similar to: Is there a rake task to extract data from a database/table

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

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,

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

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

I read somewhere that the correct naming of bridge tables is in alpha order. For example. I have two tables: houses, and colors. If I want to create a bridge table to associate colors with houses, I would name the table: colors_houses The associations work fine. But, if I have a table named: track_houses. Building a bridge table called: colors_track_houses, gives me model associaton errors.

I need to process some text files quickly. I''ve not been able to find the answer in the archive. The Ruby Standard Library site times out. Can someone tell me where to find info on how to: 1. Get a list of filenames in a directory. 2. How to open a file. 3. How to read it a line at a time. -- Thanks in advance for the help, -Larry "Work, work, work...there is no satisfactory

Filed a ticket for bogus Ruby produced via: rake db_schema_dump http://dev.rubyonrails.org/ticket/3232 I''d appreciate it if someone could verify against PostgreSQL 8.0.x -- -- Tom Mornini

Ruby script/console takes 30-secs to start on the Windows 2003 servers in our shop. Has anyone found a way to speed that up? ( I know Linux is much faster, but that''s not an option, in this case). -- Best Regards, -Larry "Work, work, work...there is no satisfactory alternative." --- E.Taft Benson -------------- next part -------------- An HTML attachment was

Anyone know why "rake db_schema_dump" would produce the following error: rake aborted! Don''t know how to build task ''db_schema_dump'' (See full trace by running task with --trace) Otherwise, my migrations work fine. -- Posted via http://www.ruby-forum.com/.

Evaluating session variables inside a markaby paragraph tag always returns false. For example welcome.mab -- p "Good morning Mr. #{session[:user]}." -- displays: Good mornig Mr. How can I access session variables in maraby? -- Best Regards, -Larry "Work, work, work...there is no satisfactory alternative." --- E.Taft Benson -------------- next part

Recently discovered Markaby. Before I use it on a production system, I''d like to know if it is still being maintained? According to the change log, the last change was in February of 2006. Does this mean that the project has been abandoned? Or, at version 0.3 it was considered production stable and complete? -- Best Regards, -Larry "Work, work, work...there is no satisfactory

Installed Fedora5. Installed Ruby 1.8.4. Installed rubygems. Installed rails. Created test app to verify that ruby and rails were working. When I attempted to install mongrel via: sudo gem install mongrel I get this error: Install required dependency daemons? [Yn] y Install required dependency gem_plugin? [Yn] y Building native extensions. This could take a while... can''t find

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

Hi all I''d like to dump also my data with rake db_schema_dump. Is there a way to do this? Thanks Josh -- Posted via http://www.ruby-forum.com/.

What''s the best way to handle a find that doesn''t find anything? For example. Model Foo @result = Foo.find(:first, :condition => "some condtion string").name if the condition is not met Foo.find stops the application with ''unexpected nil''. What is the best way to gracefully trap this error and return something meaningfull to the calling

I''ve been using tables to get my forms to line up. ( I have usually one column for labels, and a column for values ). Should I be using divs instead? I''ve been reading some CSS design books lately. They tend to recommend divs over tables for general page layout stuff. But, what about the forms elements? What''s the ''best practice'' in this regard?

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

Does anyone have any experience getting ODBC to work? I could really use some help here. I''m having trouble accessing a db2 database via odbc using rails. It''s an external database, that I import data from. I have placed the connection code in my model : unless connected? establish_connection( :adapter => "odbc", :dsn => "<dsn

My migrations were working fine until today. I dropped and re-created the database.But, when I go to apply my migrations, rake migrate aborts with this error. You have a nil object when you didn''t expect it! You might have expected an instance of Array. The error occured while evaluating nil.first Any idea what might be wrong? The migrations look right. It''s talking to the

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