similar to: Does rake db:schema:load need the whole environment?

Hey there, I''ve adjusted some of my many to many join tables recently to use a composite primary key based on the id''s in the two columns - instead of using a surrogate key. I just did a db:schema:dump, and it looks something like this: create_table "class_members", :id => false, :force => true do |t| t.integer "user_id", :default => 0,

Hey, I am new to this and I thought I had finally set up everything perfectly after three days of trying to configure it. However I run this command: rake db:schema:load and I get an error "syntax error on line 23, col 11: `''". The error however is now with the schema it''s with the ruby install itself as you can see with the trace I ran:

anyone able to explain logic behind "rake spec" startup? i.e. the below steps & why things occur when they do Macintosh-2:myequity greg$ rake spec --trace (in /Users/greg/source/myequity) ** Invoke spec (first_time) ** Invoke db:test:prepare (first_time) ** Invoke db:abort_if_pending_migrations (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute

My ruby version is 1.8.7 I have installed mysql-essential-5.0.90-win32 and using Fedena 2.3.5 List of all gems installed:* columnize (0.3.6) declarative_authorization (0.5.1) fattr (2.2.1) ffi (1.9.0) gem_plugin (0.2.3) highline (1.6.19) i18n (0.4.2) metaclass (0.0.1) mime-types (1.23) mocha (0.14.0) mongrel (1.1.5) mysql (2.8.1) net-ping (1.6.0) prawn (0.6.3) prawn-core (0.6.3) prawn-format

Hi there - I''m a ruby newbie and am stuck on the Getting Started with Rails app. See output below. Problem arose when I ran the rake db:migrate command. I also tried the ''rake db:migrate RAILS_ENV=development'' command which may be obvious. Any ideas on how to fix this? Many thanks!! $ ruby -v ruby 1.9.3p392 (2013-02-22 revision 39386) [x86_64-darwin10.8.0]

Hi all, I dumped my schema from SQLServer 2000 without any problems. I then tried to "rake db_schema_import" on MySQL 4. To do this i changed my database.yml settings to use the mysql adapter (as it was set to use sqlsever before) and attempted the import. I haven''t changed a thing in the schema.rb script and, even though I do have generated a migration, I think I

Is there a way to specify not not use schema.rb but instead using a native sql file to clone structure to the test db? Schema.rb doesn''t really work that well for mediumblobs ... Thanks. -- Posted via http://www.ruby-forum.com/.

Posted this message on Core, but maybe it belongs here. The subject pretty much says it all. I''m getting ready to set up an environment for working on my first patch, and I discovered that the activerecord/test/schema files have changed, but the Rakefile hasn''t yet been updated. Is there a simple way to set up the test databases with the new system?

Hey all, I''m trying to create a task that prepare the environment to start programming. To do so, I created a task like this *task :setup_env => [''db:reset'', ''db:migrate'', ''db:test:prepare'']* and observed that after execute * rake setup_env*, it never execute db:test:prepare properly. In order to get the schema cloned to test db,

Dear all, task ''test'' do Rake::Task[''db:create:all''].invoke Rake::Task[''db:migrate''].invoke end Did I miss something or what? Turns out that this simple task would have migration done in the test db. I''ve tried to "puts RAILS_ENV" inbetween and it shows "development", but migration''s still done in

As many of you know, rake db:reset changed behavior just before Rails 2.0 got released. db:reset used to drop the database, re create it and migrate it up. The core team after integrating this feature, realized that it was not used as intended and instead db:create now uses the schema.rb file instead of the migrations. Check the many discussions we had about this topic, you will quickly notice

I have just migrated to use Rail 1.1 from 1.0. In the progress of fixing and cleaning up the unit tests. I found the following problem. I am not sure if this is a bug or it is my environment. When I run "rake test_units, some of the index in association tables is not created, this leads to failures for some unit test cases. Thinking that may be because I didn''t setup the

Hi, I am writing scripts for deployment of our software and I am also using MCollective on linux. I hope to use MCollective in order to reduce the requirement of opening a putty session to each VM and running the puppet agent manually the first time (when its registers/ creates keys etc). The problem I see with this is that I need to log in to each machine and install/configure mcollective

Hi, I''m going through the Depot tutorial in the book "Agile Web Development with Rails" and I can''t even get past the very first step. I''m getting the following error: "Before updating scaffolding from new DB schema, try creating a table for your model (Product)" when I try to run "ruby script/generate scaffold Product Admin. I have a table

Hi I''ve discovered the following error messages in my db/schema.rb: # Could not dump table "pg_ts_dict" because of following StandardError # Unknown type ''regprocedure'' for column ''dict_init'' # Could not dump table "pg_ts_parser" because of following StandardError # Unknown type ''regprocedure'' for column

I''ve got a bunch of table creations in the schema.rb file and all is well. However, I have to manually go and create the db first. Is there a way (something like a create_database method) to get this to work? (execute "create database ..." didn''t seem to cut it either.) _______________________ Brad Eck Sr. Software Engineer Pelco 3500 Pelco Way Clovis, CA 93612

Hello. I''m working the "proper way" with creating the initial db schema via migrations and db/schema.rb. However, I have a bit of a special need, and need to know if anyone knows the solution to this; I need a sequence that is common to several tables - a "data id" that gives a sort of unique object number to every row in every table. Some associated tables (a

I am struggling here a bit.... can someone please clarify? When installing puppetdb from source, how do I create the tables/schema? I have created puppetdb as instructed in the install docs but, how/when does the schema and tables get created. Thanks! -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email

Hello, I''ve extracted from the Sportbook (formerly Wettpool)[1] the football fixtures for easy reuse. The open sports database[2] also includes a little command line tool (Ruby gem), that is, sportdb and a sample web admin tool[3] in Ruby on Rails. Events in the sport.db include - the Champions League 2012/13, - Euro 2012, - World Cup Quali and others. Add yours.

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