search for: development_structur

...e_structure_to_test (first_time) ** Invoke db_structure_dump (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute db_structure_dump ** Invoke purge_test_database (first_time) ** Invoke environment ** Execute purge_test_database ** Execute clone_structure_to_test psql:db/development_structure.sql:28: NOTICE: CREATE TABLE will create implicit sequence "case_managers_id_seq" for "serial" column "case_managers.id" psql:db/development_structure.sql:57: NOTICE: CREATE TABLE will create implicit sequence "placements_id_seq" for "serial" col...

...st_time) ** Invoke environment ** Execute purge_test_database dropdb: database removal failed: ERROR: database "darkthrone" is being accessed by other users createdb: database creation failed: ERROR: database "darkthrone" already exists ** Execute clone_structure_to_test psql:db/development_structure.sql:13: ERROR: schema "development" already exists psql:db/development_structure.sql:27: ERROR: schema "test" already exists psql:db/development_structure.sql:34: ERROR: language "plpgsql" already exists psql:db/development_structure.sql:45: ERROR: function "gtsv...

Hello, When I try to run "rake clone_structure_to_test" on my project, I get the following errors: $ rake clone_structure_to_test (in /home/www/cedscreening) psql:db/development_structure.sql:8: ERROR: permission denied to set session authorization psql:db/development_structure.sql:16: ERROR: permission denied for schema public psql:db/development_structure.sql:34: NOTICE: CREATE TABLE will create implicit sequence "pages_id_seq" for "serial" column "pag...

Hi, I noticed that db/development_structure.sql file somehow appeared in my project... Why is it generated? what is it good for? I see it has my db schema. but I already have my db schema in another file I created. thanks! -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this...

...s/pages/SaltedLoginGeneratorQuickstart. Everything seems to work fine until I try to run the unit tests by doing ''rake test_units'', then I get the following error message: <error-message> [brasse@keso login-test]$ rake test_units (in /home/brasse/RAILS/login-test) psql:db/development_structure.sql:29: NOTICE: CREATE TABLE will create implicit sequence "users_id_seq" for "serial" column "users.id" psql:db/development_structure.sql:38: NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "users_pkey" for table "users" psql:...

When the unit test harness creates a test database from the development database, the ON DELETE CASCADE constraints I have on my foreign keys are not copied into the test database. (I can tell by looking at db/development_structure.sql.) That means the fixtures can''t load/unload from the test database properly. In other words, all my tests fail with the same error message: ActiveRecord::StatementInvalid: PGError: ERROR: update or delete on "orders" violates foreign key constraint "redeemed_coupons_...

...; > > rake clone_schema_to_test > > # Recreate the test database from the current environment''s database schema. > > > > rake clone_structure_to_test > > # Recreate the test databases from the development structure > > So, I have to have a schema.rb or a development_structure.sql file > available? I don''t have any, it''s all based on migrations now. > > And, if I want to change how CIA works with regards to migrations, I > have to dive into the source to change the default rake tasks? Oops, I''m referring to the continuous_integr...

In development and production, I''ve got postgresql constraints that prevent deleting a CaseManager if there is a Client that belongs to that CaseManager. In unit tests...and obviously in my testing db, those restrictions don''t get added. Is it wrong to test for deleting dependent records in unit tests? Craig --~--~---------~--~----~------------~-------~--~----~ You received

...ted to be able to take the data I''ve painstakingly defined in my fixture files and slurp it up into my development database so I can play with my website (locally, in development mode) with the same data I use in my tests. In a similar vein, I want to take the table definitions in the development_structure.sql file and use it to re-define my development database schema. Unless I''m missing something obvious, when someone changes the db schema commits it into our subversion repository, I always have to hand-update my development db to match the new schema (if I don''t want to toa...

Hi, In my environment.rb, I have set: config.active_record.schema_format = :ruby Whenever I do a rake db:migrate, both db/development_structure.sql and db/schema.rb get generated. This shouldn''t happen should it? I thought I should only get db/schema.rb? Thanks, Jordan

Hi, Using rake with Postgresql gives the following error: psql:db/development_structure.sql:13: ERROR: must be owner of schema public I''m using the latest version of rails and postgresql 8.0 on ruby 1.8.3 (2005-06-23) [i486-linux]. The above error occurs when rake clones my dev database to test - it first came to my attention when I ran "rake" for my first uni...

...t tests I have followed the quick start guide for the salted hash login generator (http://wiki.rubyonrails.com/rails/pages/SaltedLoginGeneratorQuickstart), my version of rake is 0.7.0. This is my error message [brasse@keso login-test]$ rake test_units (in /home/brasse/RAILS/login-test) psql:db/development_structure.sql:37: NOTICE: CREATE TABLE will create implicit sequence "users_id_seq" for "serial" column "users.id" psql:db/development_structure.sql:46: NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "users_pkey" for table "users" /usr/...

...unexpected tCONSTANT, expecting kDO or ''{'' or ''('' t.column "added", :datetime, :default => Sun Mar 05 03:19:40 MST 2006, :null => false And when I do ''rake clone_structure_to_test'' I get this: (in /var/www/rails1) psql:db/development_structure.sql:13: ERROR: must be owner of schema public Looking at the first, shouldn''t Rails be putting quotes around the default datetime values? The second appears to be a permission problem with schema public, but I''ve made sure its owner is the same as the one set in database.y...

Hi, I''d like to set up CIA. So I added the plugin to my app, went to my subversion server, added the post commit, added a build directory. I checked out the code in the build directory on the svn server. However, running rake on it fails, because the test database is empty (i.e. no tables, so fixtures don''t load). What''s the solution here?

As of some recent version of Postgres, plpgsql is created for new databases by default, but the sql schema export (config.active_record.schema_format = :sql) expots a create command in development_structure.sql, resulting in an error. CREATE PROCEDURAL LANGUAGE plpgsql; I could not find the version this changed in, however it is noted here: http://www.postgresql.org/about/featuredetail/feature.185 I believe this is a bug at least in Rails 2.3.5? My solution was to switch off the sql schema form...

...b:test:clone_structure (first_time) ** Invoke db:structure:dump (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute db:structure:dump ** Invoke db:test:purge (first_time) ** Invoke environment ** Execute db:test:purge ** Execute db:test:clone_structure psql:db/development_structure.sql:15: ERROR: language "plpgsql" already exists This doesn''t seem to be a common configuration problem. I did try "dropping: the language on the command line, but no help. any ideas would be appreciated... --~--~---------~--~----~------------~-------~--~----~ You recei...

This is a question regarding ActiveRecord outside of Rails. I have several databases that have absolutely identical table structure. I have a ActiveRecord::Base.establish_connection( :adapter => "mysql", :host => "localhost", :username => "user", :password => "password", :database

All, It looks like rake db:schema:dump does not dump primary keys. I have some legacy table that don''t follow the convention ie pk = id and none of the primary keys for these tables are getting dumped... Seems strange as this should be readily available from the db. I am using MySQL. Is anybody else seeing that ? Incidentally how does one specify a primary key using

I am pleased to announce that Radiant CMS is now publically available from the Subversion repository at: http://radiantcms.org/ What is Radiant? ---------------- Radiant is a no-fluff, open source content management system designed for small teams. It is similar to Textpattern or MovableType, but is a general purpose content management system (not a blogging engine). Radiant features:

Hi there, So I have an odd error at the moment that only occurs when I run tests via rake. It''s happening with two tests now. Under a simple ruby run, the tests are fine, e.g.: D:\User\Code\ruby\prometheus>ruby test\functional\story_comments_controller_test .rb Loaded suite test/functional/story_comments_controller_test Started ......... Finished in 2.37 seconds. 9 tests, 65