search for: clone_structure_to_test

...O tobyhouse; ERROR: syntax error at or near "OWNER" at character 23 th-db_test=> ALTER SCHEMA public OWNER TO tobyhouse; ERROR: syntax error at or near "OWNER" at character 21 # rpm -q postgresql-server postgresql-server-7.4.8-1.RHEL4.1 My problem is with rake... $ rake clone_structure_to_test --trace (in /home/craig/ruby-db/th-db) ** Invoke clone_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_tes...

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/developm...

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/.

...property contains a list of schema name. And table names are looking for thought all this schemas. I am wonder, is anybody need it (i mean multiply schemas)? Well, after configuring I tried to run rake test but it is failed with log printed below. How to solve it and make it running?? ** Invoke clone_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 dropdb: database removal failed: ERROR: database "darkthr...

...running the db/schema.rb file. 2. However this file will NOT include any "execute" actions, thus resulting in a different database structure in development and test environments. In my case the above behaviour causes some of my unit tests to fail. But if I explicitly do a "rake clone_structure_to_test" and then explicitly run individual unit tests, the tests all pass with flying colours. I think the test database also needs to be generated by applying all the migration steps, and that the current behaviour is buggy. Of course there might be a really good reason for the behaviour which I...

...re, but I''m new to TDD and am still trying to get the hang of it. Suggestions, pointers and inspirational messages would all be appreciated. Also, what''s the best practice for getting my _test database to track my _development database? I''ve been using "rake clone_structure_to_test" but I''m not sure that''s the best way to accomplish this. I am using migrations for creating my data model... can/should I rerun them against the _test db? cr

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?

...st thing I noticed, upon looking into the cause, is that my test database was not being cloned correctly from development. So, I tried to run the tasks by hand: $ rake clone_schema_to_test (in /Users/jkh/Development/assetstream) rake aborted! database configuration does not specify adapter $ rake clone_structure_to_test (in /Users/jkh/Development/assetstream) rake aborted! 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.[] Strangely, db_schema_export and db_schema_import work just fine. And my application runs fine. I a...

I''ve got a very peculiar problem with unit tests. First, I clone my development database with "rake clone_structure_to_test", then I run my test with "ruby investment_product_score_override_test.rb". It fails on line 68. Then, every test run after this, fails consistently on line 34. How is this possible? I don''t use fixtures and I don''t use hardcoded id''s or whatever. Unit...

I''m new to ROR, and am working my way through the Agile Web Development Book. In the test application, the authors tell me to test my database connection by performing "rake db:migrate". When I do, I get the error "Don''t know how to build task ''db:migrate''" I''ve been looking around at the files, and I see a reference to a

...^ ./db/schema.rb:170: syntax error, 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...

...; > (i.e. no tables, so fixtures don''t load). > > > > > > What''s the solution here? > > > > > > 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...

I recently ran into the following problem: when running ''rake clone_structure_to_test'', the task would spit out the following error twice: This program requires Microsoft SQLDMO 7.0 or later After many attempts to download this library, I reinstalled the SQL Server Client Tools. Still nothing. I tracked down the program that rake was having problems with: scptxfr....

...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 unit tests. It can be recreated with the following command: "rake clone_structure_to_test" The strange thing is that when I tried to test the postgresql db using the same commands and settings from the RakeFile but through the command prompt the damn thing worked! By this I mean I issued the following commands against my tt_dev db and a clean tt_test db: pg_dump -U ttuser -s -...

Does anyone know how to extend the buit-in rake tasks like test:unit. I want to custom load some fixtures in a particular order. Thanks, Zack

Hi, is this the best forum to answer this question? Is there any better source for information or another mailinglist to address this question to? Cheers, Mariano ---------- Forwarded message ---------- From: Mariano Kamp <mariano.kamp@gmail.com> Date: Jan 8, 2006 6:24 PM Subject: Migration doesn''t seem to preserve create_table options in schema To: rails@lists.rubyonrails.org

...n it''s not copying the structure? $ rake test_units --trace (in /Users/deirdre/Desktop/datadomain/docmanager) ** Invoke test_units (first_time) ** Invoke prepare_test_database (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute prepare_test_database ** Invoke clone_structure_to_test (first_time) ** Invoke db_structure_dump (first_time) ** Invoke environment ** Execute db_structure_dump rake aborted! 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.+ /Users/deirdre/Desktop/datadomain/d...

I left ":memory:" in database.yml for testing and the most simple tests in the Agile book do not work (see trace below for test_truth). Since that''s what comes with the distributed database.yml I suppose it''s me doing something wrong. Did someone get SQLite ":memory:" working? How does it grab the schema? -- fxn % rake test_units (in

...few days and just doesnt work.Hope you guys can give me some enlightenment. Problem: The functional test doesnt seems to be able to recognise one of my model, and when i run the test, it keeps giving me the error of"You have nil object when you don''t expect it". I tried rake clone_structure_to_test but it still dont work. Checked my controllers code but it has a code that says : @countryinfo = Country.find(:first,:conditions=>["name = ?",@params[''country'']]) I dunno why the functional test just couldn''t seems to recognise this statement and so i gi...

...getting spit out while you run the test? It can be very informative. > > -Nick > > On 3/25/06, Wiebe Cazemier <halfgaar@gmail.com> wrote: > > > > I''ve got a very peculiar problem with unit tests. First, I clone my > > development database with "rake clone_structure_to_test", then I run my > > test with "ruby investment_product_score_override_test.rb". It fails on > > line 68. Then, every test run after this, fails consistently on line 34. > > > > How is this possible? I don''t use fixtures and I don''t use hardco...