similar to: Migration commands -- create a SQL Server production DB?

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

Hi again :), I''m playing with migrations. I''ve created some migrations classes and with rake db:migrate the tables are created and altered fine, but then I dropped some of the tables and when I run db:migrate command again I don''t get tables being re-created. What am I doing wrong? Is there a way to run db:migration in order to drop the tables? -- Posted via

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.

Hallo -- I''ve just installed the latest stable version of rails, and am following the rails recipies book''s first recipie -- using in_place_editor_field. My problem is that the code throws no error, but the resulting fields are not editable -- the values just come up as text, rather than clickable-then-editable fields. Can anyone help shed any light on why this might be the

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 there ! I am currently investingation ROR. I really like the idea of specifying my database schema via Migrations, but one questions came to my mind. How does one specify Table relations in the migration ? 1. There is a fancy way of doing it with Active Records. 2. I just add manually some Integer ID columns etc... and lateron add the Foreign Key semantic via SQL.. Which one of the above

Hallo -- is there a way anyone know of that I can add a :confirm clause to a form submit? Something like: <%= submit_tag ''commit'', :confirm=>"are you certain?" %> Does anyone know how to achieve this? Cheers, doug. -- Posted via http://www.ruby-forum.com/.

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

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

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

Hi can any1 guide me ,How can i use foreign Key concept in rails, I m using Migrations to create tables, Also i want to know diffrent fields we can use while creating tables. I mean like String,Date time, timestamp,,,,Plz tell me various fields so that i can Make proper use of them as per requirement. Thank u in advance -- Posted via http://www.ruby-forum.com/.

> There is no place for beginner to get a clue and still worse when they ask His email was unreadable, I gave him this link that is what he really needs http://www.bbc.co.uk/worldservice/learningenglish/ Ivan. ____________________________________________________________ Libero ADSL: navighi gratis a 1.2 Mega, senza canone e costi di attivazione. Abbonati subito su http://www.libero.it

Bad rails day for Matt- In a migration, for a habtm: create_table :teams_users do |t| t.column :team_id, :integer t.column :user_id, :integer end Ok, fine. In a controller (well really a migration script): @user.teams << Team.find( 3 ) And the SQL pumped at my server is: INSERT INTO teams_users (`team_id`, `id`, `user_id`) VALUES (3, 3, 34) Which

Hi -- all the docs I can seem to find are related to running puppet with passenger, but not installing it. Does anyone know of any recipes I can use to actually install passenger with my server''s Ruby and Apache installs? Thanks, Doug. -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to

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

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

Hi, What is the normal mechanism for creating the tables in the (a) test and (b) production databases. For example the following didn''t work for creating the production tables: a) change environment.rb to include "ENV[''RAILS_ENV''] ||= ''production''" b) run "rake db:migrate" However this seemed to still work against DEV not

Hello ! Can you please share your experiences with ZFS deployment for Oracle databases for production usage ? Why did you choose to deploy the database on ZFS ? What features of ZFS are you using ? What tuning was done during ZFS setup ? How big are the databases ? Thank you, Jay

I have a separate DB for one model in my application and in development mode the connection is working properly, in production however it isn''t. production: adapter: mysql host: myhost username: root password: database: production_db users_production: adapter: mysql host: myhost username: root password: database: other_db The model that connects to the other

I''m having hard time convincing my boss that a Rails app would be better than a php one, but the fact that in php changes you make at the code are seen as soon as you modify the code is pushing him towards php. In Rails (in production mode) you have to restart the server somehow if your model has changed (am I wrong?). Hot deploy is important in our app. What I don''t understand