I created a new Expense item. In particular, the value I entered in
the Amount field was 14.99. In the scaffold invocation for this
field, I declared its type to be Decimal.
The log for the creation of this expense record shows
"amount"=>"14.99"
But log for the SQL statement shows:
Create (16.0ms) [0m [0mINSERT INTO `expenses` (`purpose`, `by`,
`updated_at`, `date`, `type`, `amount`, `vendor`, `created_at`)
VALUES('fun', 'RLM', '2010-03-12 22:11:24', '2010-03-12', NULL, 14,
'Ringling Bros', '2010-03-12 22:11:24')
So the amount has been converted to an integer with the decimal
portion of the input truncated.
I created a new Expense item. In particular, the value I entered in
the Amount field was 14.99. In the scaffold invocation for this
field, I declared its type to be Decimal.
The log for the creation of this expense record shows
"amount"=>"14.99"
But log for the SQL statement shows:
Create (16.0ms) [0m [0mINSERT INTO `expenses` (`purpose`, `by`,
`updated_at`, `date`, `type`, `amount`, `vendor`, `created_at`)
VALUES('fun', 'RLM', '2010-03-12 22:11:24', '2010-03-12', NULL, 14,
'Ringling Bros', '2010-03-12 22:11:24')
So the amount has been converted to an integer with the decimal
portion of the input truncated.
But just before I logged in right now, the fundamental cause of my
problem struck me:
When I declared expense:decimal in the scaffold, I didn't
declare :scale=>10, :precision=>2, which is what I want. So there's a
new question, I think:
- Can I declare successive migrations where I drop column and then add
column, or
- can I just add those attributes to the column?
I don't care about the any data in there at the moment: it's all toy
data for testing.
But just before I logged in right now, the fundamental cause of my
problem struck me:
When I declared expense:decimal in the scaffold, I didn't
declare :scale=>10, :precision=>2, which is what I want. So there's a
new question, I think:
- Can I declare successive migrations where I drop column and then add
column, or
- can I just add those attributes to the column?
I don't care about the any data in there at the moment: it's all toy
data for testing.