Ruby Rails: wont save as decimal in postgresql

Question

Im using Ruby 2.4.1 with rails 5.0.2

Here is my code:

total_price = 600.0
o = client.bills.new(client_id: client, total_price: total_price.to_f)
#<Bill id: nil, client_id: 21, created_at: nil, updated_at: nil, total_price: 0.6e3, bill_id: nil, discount_price: nil>
o.save

it will save as 0.00 instead of 600.0 or 0.6e3 in my PostgreSQL. Oh, im using Numeric(8,2) as its datatypes which is decimal, :precision => 8, :scale => 2

My migration:

add_column :bills, :total_price, :decimal, :precision => 8, :scale => 2

Any clues?

could you please add your migration and schema/structure file? — marmeladze
– marmeladze, Commented Apr 7, 2017 at 5:34
show me the output of o.update_column(total_price: 123.45). If that works it means you have some validation or something else preventing the correct number to be saved — Andrey Deineko
– Andrey Deineko, Commented Apr 7, 2017 at 5:48
@AndreyDeineko it return 0.12345e3 but still save it as 0.00 — Amirol Ahmad
– Amirol Ahmad, Commented Apr 7, 2017 at 6:18

Andrey Deineko · Accepted Answer · 2017-04-07 06:37:32Z

1

I think you have some validation/callback preventing the correct value to be written to database. Double check validations/callbacks in Bill model.

answered Apr 7, 2017 at 6:37

Andrey Deineko

52.5k11 gold badges119 silver badges151 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Amirol Ahmad Over a year ago

you are right.. i forgot that i have callback after_create.. thanks for your hint!

Collectives™ on Stack Overflow

Ruby Rails: wont save as decimal in postgresql

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest