similar to: Migrations bug with Rails 1.0, PostgreSQL 8.1?

Just starting a new thread so that it''s easy to follow. I just submitted a patch at trac to add a new class method called "set_default_values" ( not a great name I think ), which lets you do all kinds of crazy stuff with setting default values. This ticket is at http://dev.rubyonrails.org/ticket/9093 and example pastie is at http://pastie.caboo.se/81925 It also lets you make

I''m somewhat of a newbie - played with recent versions of rails a few mths ago, but have decided to start from scratch with 1.0. I want to build my new db as much as possible with migrations, so I watched DHH''s migrations movie from rubyonrails.org. A few things confuse me: 1. He generates the model ("post") before running rake db_schema_dump. Is that necessary or

Hello all, I''ve spent a while looking for a sniff of this on the wiki or google at large.. Does migrations work for SQL Server on 1.0 ? -- ------------------------------ Joyeux Noël ------------------------------ Peter Fitzgibbons _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org

Is anyone using migrations with a SQL Server database who might be able to lend me a hand? I''ve used migrations with MySql in the past and haven''t run into any issues so forgive When I run rake migrate nothing is actually getting updated in my database. I created a migration using ./script/generate migration AddFooTable and updated the migration to look as follows: class

I''ve poked around a bit with Google and I can''t find a way to generate a base set of migrations from a given SQL schema. Is there an easy way to do this? thanks John

Hi, I dumped the schema using rake db_schema_dump. Now how do I create a migration containing all the data I have in my dev db ? -- Jean-Christophe Michel

rake migrate bug with datetime: > rake db_schema_dump produced a bad schema.rb that isn''t valid ruby, it has an invalid default, unless ruby takes bare words: t.column "date_available", :datetime, :default => Sun Jan 01 00:00:00 Arabic Standard Time 2006, :null => false I don''t think the Baghdad time zone should matter. ruby 1.8.4, rails 1.1.2,

Hello all. I''m new to Rails and working on replacing an existing Perl based app. Everything has been smooth, and I''m beginning to get the hang of things. I just implemented DB based photo handling, with code directly from the Pragmatic Rails book. Here''s a fresh server log of my app, with a logged in user (by cookie and session) getting a list of his photos. The

Hi, I''d like to use migrations to build my initial database. Is there a gem or plugin that will generate the migration code for initial db if I point it at a live database or sql file? If yes, then can you automatically generate the incremental migrations as well? Thanks, Jason

Hi, I have a mysql schema with some decimal(20,20) fields. Now, I made a rake db_schema_dump for deployment of my applications on other machines. Rails created a schema.rb with the decimal fields as float. After a rake db_schema_import the fields are just float not decimal. How can I force rails to create decimal(20,20) columns instead of float? Thx. Marc -- Posted via

I am attempting to start my new application using the migrations feature of rails. I''m not new to databases but new to SQLite. My question is that starting with noting it appears I have to create a table in the SQLite console and then use migrations to delete that table and add more tables. Surely it should be possible to create a blank SQLite database that I can then use migrations

Oh noes! What do I do? Just installed RoR and SQLite3 yesterday, watched a screencast that said the db_schema_dump will slaughter my enemies and make my poop smell like rainbows. Now I get rake telling me that it doesn''t know how to. Any help? -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are

As far as I can tell "numericality" is not a word. Maybe this method should be renamed. -- R. Mark Volkmann Partner, Object Computing, Inc.

I tried to use ''rake db_schema_dump'' from old MySQL database and then use ''rake db_schema_import'' to rebuild the database in PostgreSQL. The issue here is that only some of tables can be imported successfully. For example, in the dumped schema.rb: create_table "profiles", :force => true do |t| t.column "ticker", :string, :limit

Just wondering if there''s a way to use migrations to generate join tables (where the table columns comprise only of foreign keys to other tables, and where the primary key is all the foreign keys taken together). I made the changes manually in MySQL, then did rake db_schema_dump and it gave something like this: create_table "apples_oranges", :id => false, :force

One thing I found annoying about Migrations, besides that you have a very limited ways to define your data, is that it will overwrite EVERYTHING in your schema file. So if you spend hours customizing your initial schema file, to get it work, exactly like you''ll need it, that work immediately becomes for nothing once you run a migration. Your entire schema will get rewritten, not appended

I currently have 3 tables/models: 1) Clients, 2) Charges, and 3) Court_Dates. Clients 1..n Charges 1..n Court_Dates I am trying to find all clients that have a court_date on a certain day: something along the lines of (@client.charge.court_date.date == Date.today). I have had success preloading child rows using the :include parameter, but that only works with a parent and a child, or a

I'm using Centos 4.5 right now, and I had a RAID 5 array stop because two drives became unavailable. After adjusting the cables on several occasions and shutting down and restarting, I was able to see the drives again. This is when I snatched defeat from the jaws of victory. Please, someone with vast knowledge of how RAID 5 with mdadm works, tell me if I have any chance at all

Hi, I''m using the ''rake db_schema_dump'' command to clone the structure of the developement database into the test database. Unfortunatelly, the schema.rb file doesn''t contain any information about the foreign keys of the tables. For this reason all the test that concern about the relations are not working has suposed. Is this a limitation of Rails or am I

I know I can get the schema by running rake db_schema_dump but, is there a way to ge the data from a table or a database into a format that can be quickly converted to a migration. What I''m really trying to do is synch my local development database (schema and data) with the db on my hosting service. -- Best Regards, -Larry "Work, work, work...there is no satisfactory