I have a role based access control system with models Right, Role and
User and there are 2 join tables... rights_roles and roles_users
I have been maintaining the Right & Role data via migrations which has
created a few duplications over time and a few omissions and I''m
finding
that there is a variation between my testing_db and my development_db in
the rights and rights_roles tables as well.
So I''m thinking that I can maintain just one set of fixtures for rights
and rights_users and load them into whichever db I need.
So my first questions...
1. How do I delete records from join table without id column?
from script/console test
RightsRoles.destroy_all
ActiveRecord::StatementInvalid: PGError: ERROR: column "id" does not
exist
: DELETE FROM rights_roles
WHERE "id" = NULL
2. If I have new fixtures to load for just these 2 tables (rights.yml
and rights_roles.yml), how can I load them in the console?
Craig
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
On Mon, 2008-06-02 at 13:16 -0700, Craig White wrote:> I have a role based access control system with models Right, Role and > User and there are 2 join tables... rights_roles and roles_users > > I have been maintaining the Right & Role data via migrations which has > created a few duplications over time and a few omissions and I''m finding > that there is a variation between my testing_db and my development_db in > the rights and rights_roles tables as well. > > So I''m thinking that I can maintain just one set of fixtures for rights > and rights_users and load them into whichever db I need. > > So my first questions... > > 1. How do I delete records from join table without id column? > > from script/console test > > RightsRoles.destroy_all > ActiveRecord::StatementInvalid: PGError: ERROR: column "id" does not > exist > : DELETE FROM rights_roles > WHERE "id" = NULL > > 2. If I have new fixtures to load for just these 2 tables (rights.yml > and rights_roles.yml), how can I load them in the console?---- OK...I guess I can drop and recreate the table for the first question but the second one puzzles me...how do I load a fixtures file from the console? Craig --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On Mon, 2008-06-02 at 13:16 -0700, Craig White wrote:> I have a role based access control system with models Right, Role and > User and there are 2 join tables... rights_roles and roles_users > > I have been maintaining the Right & Role data via migrations which has > created a few duplications over time and a few omissions and I''m finding > that there is a variation between my testing_db and my development_db in > the rights and rights_roles tables as well. > > So I''m thinking that I can maintain just one set of fixtures for rights > and rights_users and load them into whichever db I need. > > So my first questions... > > 1. How do I delete records from join table without id column? > > from script/console test > > RightsRoles.destroy_all > ActiveRecord::StatementInvalid: PGError: ERROR: column "id" does not > exist > : DELETE FROM rights_roles > WHERE "id" = NULL > > 2. If I have new fixtures to load for just these 2 tables (rights.yml > and rights_roles.yml), how can I load them in the console?---- since I asked, I might as well provide the answers to my question... 1. @rights = Right.find(:all) for right in @rights RightsRoles.destroy_all( "right_id" == right.id ) right.destroy end 2. require ''active_record/fixtures'' directory = File.join(File.dirname(__FILE__), "test/fixtures") Fixtures.create_fixtures(directory, "rights") Fixtures.create_fixtures(directory, "rights_roles") Craig --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---