Losing Decimal scale from sqlite3 to mysql going from development to staging.

6 views
Skip to first unread message

Owain

unread,
Mar 16, 2010, 11:35:52 AM3/16/10
to Ruby on Rails: Talk
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.

Reply all
Reply to author
Forward
0 new messages