search for: understandingmigr

when i run rake create_sessions_table, I get following output. tables donot get created and my application doesnot start. (in G:/rubysrc/blog) create db/migrate create db/migrate/001_add_sessions.rb info: the first time ran take everyting was fine, but now i have reinstalled ruby and rails and created the database, but i am unable to create session table with rake, please help.

Hi, On the wiki http://wiki.rubyonrails.com/rails/pages/UnderstandingMigrations it says: Valid column options are: - limit - offset - null (i.e. ? :null => false? implies NOT NULL) - default (to specify default values) I was wondering what the purpose of the "offset" option is. And after looking at the API at http://api.rubyonrails.com/classes/ActiveRecor...

Hallo -- could anyone tell me how I use Migrations (which my existing development schema is implemented with) to create the production database for deployment? The target DB is a SQL Server database -- I don''t know if that''s an issue -- I seem to remember reading that SQL Server is supported now. Oh, yeah -- SQL Server was *not* my choice! But what I seem totally unable to

I am familiar with using RoR in a pure development environment, that is to say that I can create a local project, access it via a web browser, update the database, etc. However, I''m having trouble figuring out how to best set up things with actual deployment in mind. Forgive me if this has been asked before, I couldn''t find it easily. Right now I have a subversion repository

On the wiki it says to migrate your DB to production, you can run: rake migrate RAILS_ENV="production" This is taken from: http://wiki.rubyonrails.com/rails/pages/UnderstandingMigrations My database is set up with correct MySQL permissions granted and the database.yml is pointing at it. I get no errors when I run it, but equally my production database does not change at all. When I run the comment I just get this: dave$ rake migrate RAILS_ENV="production"...

In Rolling with Ruby on Rails tutorial - http://www.onlamp.com/pub/a/onlamp/2005/01/20/rails.html - I saw that to introduce a new element to my domain, I needed to define it in a table, generate a model element with a similar name and the class would autoamtically take the attributes from the table definition. Is it possible to do this in the other direction... i.e to take the class diagram

Hello, I''m just taking a look at migrations, seems like a fantastic way to maintain the database. I am wonder if there is a way to maintain what I''ll call "reference data" along with the migrations. A lot of times in apps your have tables that have pretty static data, often used to generate select lists. Is there a way to insert the reference data into these tables

...atabase without going through all the migrations: 1. checkout from SVN 2. rake db_schema_import Now here come the questions: a. Any comments on the procedure described above? b. Where do I define the initial data? E.g. the statusses in a status table. In http://wiki.rubyonrails.org/rails/pages/UnderstandingMigrations it is suggested to put these in a migration script. But these lines are NOT carried over to schema.rb. So if I create a fresh database using the procedure described above, it would not contain this initial data. Thanks, Mike. -- Posted via http://www.ruby-forum.com/.

I think I am pissing into the wind to make migrations work at this point. Looking at http://wiki.rubyonrails.org/rails/pages/UnderstandingMigrations it appears that the problem that I am having is that postgresql can''t do the drop_table part because of the foreign_key keys (constraints) which requires ''cascade'' as an option to drop some of the tables that have other tables which include a column from the table...

I just posed this question to #subversion, with no reply. Any thoughts here? I''m trying to decide how to manage database changes w/ subversion. I''ve got a large number of production checkouts of a branch (actually, multiple branches). Of course I have a base script to create the schema, and this is updated of course when new fields are added to the system. When a new field

Everytime a new record object is created i.e. Record.new, i want certain fields to be the same. Any idea how to do this? Thanks Chris -- Posted via http://www.ruby-forum.com/.

Hi, Im using locomotive and running SQLight. Im confused about making tables with sqlight. Im following the depot example from ''agile web development with rails''. When trying to make the table ''products'' is there a difference when using SQLight rather than MySQL? Here is the DDL for MySQL, how do I make this table with SQLight? - drop table if exists

I am a total RoR virgin, and took my first steps this weekend into the Ruby world. A lot of sites I create need to be as SEO friendly as possible, particularly for google. Before I delve any further, can anyone tell me how friendly the dynamic URLs or if there is the usual rewrite mod for rugby? Thanks Mike -- Posted via http://www.ruby-forum.com/.

Hi everybody, I know this is an easy question but I don''t seem to see the solution. I''m trying to have a user select a file so that my code can parse it and populate the database with corresponding values. So far it seems like uploads but nothing shows in my db. Can anybody give me a hand? thanks view: h1>Importing Strings<h1>

I''ve spent the last several months learning RoR and building my first app. I''ve not used migrations yet and honestly don''t understand them much, and have not had my app under version control. I''ve decided it''s time (I know, some will say way past time ;-) ) to put the app under version control. I''ll be using Subversion and have begun working