similar to: db:migrate question

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

Hi all, (I''m new with RoR) I''m using a migratio to import data into a database but nothing is being happens. I''m importing strings from a parsed file. this is what I have: controller: class UploadController < ApplicationController def create table = { } params[:localized_string][:data].each_line do |line| if line =~ /^\s* " (.*?) "

Hi, I have two models: category and subcategory. (one to many relationship), and a controller ''home'' I''d like to display all the categories and their sub categories in the view: home\index.rhtml. I have a method in the ''home'' controller'' like this: def list_categories @categories = Category.find(:all) end This list all the categories

Hi, I''m quite new to this language and I''m having trouble finding out simple things like a dropdown menu in rhtml. I know I have to use <% select_tag %> but I''ve read lots of different ways to put in the options so I''m a bit confused. Options are hard-coded for the menu I''m trying to create so no database is involved! Thanks v much! Bex --

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:

am in a bit of a quandry... I have asked postgresql-users list and haven''t gotten anything to work with... > > How do I change the owner of a schema? > > > > ALTER SCHEMA "public" OWNER to "some_user"; #? > > http://www.postgresql.org/docs/current/interactive/sql-alterschema.html > > The docs explain this very situation. HTML

I haven''t seen anyone mention this yet. The tail end of the migration process is a call to schema.dump. Our primary keys are uuids and these choke schema.dump on both oracle and postgres. The latter fails silently (skips three tables) while the former complains about the RAW(16) in each of the three tables. Anyone had a similar experience? -- Posted via http://www.ruby-forum.com/.

Hi. I''ve not seen anything on this so thought I''d put forward the idea and see if it has any merit, or is already in practice. When using migrations with config.active_record.schema_format = :ruby (ruby as the canonical DB definition) it seems there would be no need to query the database itself to determine its structure; it would already be known. This might have some good

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

Hello, I have tried to install the salted hash login generator by following the quick start guide at: http://wiki.rubyonrails.com/rails/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

I have a many-to-one relationship between a model named Category(one) and a model named Brands (one). How can I get ActiveRecord to order the brands by the "name" attribute? This seems like a simple question and I can think of long ways around it but there has go to be a way to do this by accessing @category.brands . Can anyone help? I tried the code below in the controller but it

Is the REST Controller (for calling APIs through the REST interface) already built-in ?? Or, I have to generate one -- generate controller rest ?? MSN id: ICEMANyears@netscape.net -- Posted via http://www.ruby-forum.com/.

Hi all, I wander if it is possible to force reload of all ActiveRecord object''s of some class that are already loaded, something like Book.reload_all? I know that I am able to reload specific objects with reload method but I would like to reload all that are currently in memory. thanks in advance, Bojan -- Bojan Mihelac Informatika Mihelac, Bojan Mihelac s.p. |

Does anyone know where I can find good documentation on how to use RJS template. I know I can do various things with the page object: page.visual_effect :shake, ''some_id'' Is there a list of method I can run on the page onject and what parameters they are expecting? I can''t find this anywhere. Thanks for your help. Thank You, Ben Johnson E: bjohnson@contuitive.com

Is there a simple way to get the original url which spawned a controller action, including any query parameters? Thanks in advance, Don Mc -- Posted via http://www.ruby-forum.com/.

Is there something similar for rails that is like $_SERVER in PHP? Something that gives you the hostname, etc. I tried using just host in my controller, because the documentation says there is a host method, and got an undefined method error. -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to

I just got a new PC at work. My project files were copied from my old drive. Just to be sure, though, I have erased them and pulled them back down from source control. My development database server is MySQL My test database server is sqlite3 I am having a confusing issue: tests are failing and errors are happening that weren''t happening before. Furthermore, they aren''t

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:

Is there any particular distro that seems to be most used among RoR developers on Linux? Any that might provide better support somehow for development of RoR apps? -- Posted via http://www.ruby-forum.com/.

On 2/5/06, Joe Van Dyk <joevandyk@gmail.com> wrote: > On 2/4/06, Jonathan Weiss <jw@innerewut.de> wrote: > > Joe Van Dyk wrote: > > > 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