I have been performing some testing between my development and staging
environments. I had noticed that the order.amount has been truncated.
All works fine in sqlite3 in development.
Here is the output: Amount is meant to be decimal (8,2) to support
pounds and pence (or dollars and cents).
class CreateOrders < ActiveRecord::Migration
def self.up
create_table :orders do |t|
t.integer :quote_id
t.integer :policyholder_id
t.string :ip_address
t.string :account_name
t.string :payment_type
t.string :last_digits
t.decimal :amount, :precision => 8, :scale => 2
t.string :cc_txncode
t.string :cc_securitykey
t.string :cc_card_type
t.timestamps
end
end
def self.down
drop_table :orders
end
end
If I check the table definition in sqllite (v 3.6.12) it looks
correct.
sqlite> .schema orders
CREATE TABLE “orders” (“id” INTEGER PRIMARY KEY AUTOINCREMENT NOT
NULL, “quote_id” integer, “policyholder_id” integer, “ip_address”
varchar(255), “account_name” varchar(255), “payment_type”
varchar(255), “last_digits” varchar(255), “amount” decimal(8,2),
“cc_txncode” varchar(255), “cc_securitykey” varchar(255),
“cc_card_type” varchar(255), “created_at” datetime, “updated_at”
datetime);
but the decimal amount gets changed to decimal(10,0) on the staging
mysql (Ver 5.0.67)
CREATE TABLE orders (
id int(11) NOT NULL auto_increment,
quote_id int(11) default NULL,
policyholder_id int(11) default NULL,
ip_address varchar(255) collate utf8_unicode_ci default NULL,
account_name varchar(255) collate utf8_unicode_ci default NULL,
payment_type varchar(255) collate utf8_unicode_ci default NULL,
last_digits varchar(255) collate utf8_unicode_ci default NULL
amount decimal(10,0) default NULL,
cc_txncode varchar(255) collate utf8_unicode_ci default NULL,
cc_securitykey varchar(255) collate utf8_unicode_ci default NULL,
cc_card_type varchar(255) collate utf8_unicode_ci default NULL,
created_at datetime default NULL,
updated_at datetime default NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci;
Running on rails 2.3.5
Some of my decimal declarations are ok, even on the same table, some
work and some do not:
t.decimal :annual_price, :precision => 8, :scale => 2
t.decimal :monthly_price, :precision => 8, :scale => 2
t.string :status
t.date :policy_purchased_on
t.decimal :excess, :precision => 8, :scale => 2
annual_price decimal(8,2) default NULL,
monthly_price decimal(8,2) default NULL,
status varchar(255) collate utf8_unicode_ci default NULL,
policy_purchased_on date default NULL,
excess decimal(10,0) default NULL,
Any ideas as to what I am missing? Is it Rake?
Thanks,
O.