similar to: has_and_belongs_to_many with fk constraints?

Displaying 15 results from an estimated 15 matches similar to: "has_and_belongs_to_many with fk constraints?"

2006 May 09
0
Passing params between actions?
I am wondering what are the rules for the availability of params in controller actions? If I redirect, are the params still available? How about when I render a different action? It doesn''t seem so... What are the best ways to pass them? I''m trying to use an ajax scaffold component with 2 actions which load different data for the component. I have an ajax scaffold component
2016 Dec 31
2
Baffling regress/forwarding.sh failure, new in 7.4p1
I have the OpenSSH regression tests hooked up to run in Debian and Ubuntu's "autopkgtest" system, so that they're automatically run on uploads of OpenSSH itself or any of its dependencies. This is especially good for enforcing interoperability between it and other SSH implementations, but it's also pretty good for throwing up occasional extremely-hard-to-debug failures since
2010 Nov 16
2
IMAP aggregation and MUPDATE protocolo
Hi. I'm just having a look about aggregating several IMAP sources and a IMAP aggregator proxy would come very handy. I just read: http://www.cyrusimap.org/mediawiki/index.php/Cyrus_Murder_Design and found it very interesting. Anyone did something similar based on: http://tools.ietf.org/html/rfc3656 Thanx. Erny -- Ernesto Revilla Yaco Sistemas +34 954 500 057
2006 May 28
1
ActiveRecord: FK constraints problem
Hi all. I have has_and_belongs_to_many association between models: Section and Content. class Section < ActiveRecord::Base acts_as_tree has_and_belongs_to_many :contents belongs_to :default_content, :class_name => ''Content'', :foreign_key => ''default_content_id'', :dependent => :nullify end class Content < ActiveRecord::Base belongs_to
2006 Jan 10
0
bug? : STI and :include => fk and class_name MUST be specified
I suspect this is a bug. Or a limitation. Problem: ---------------- When you include a STI class in a ''find'' : @results = Result.find :all, :include => :event , you are forced to specify the fk and the class name : belongs_to :event , :class_name => "Event", :foreign_key => "event_id" . Full code: ----------- class Event <
2006 Oct 20
0
FK references in DBDesigner4?
I seem to have trouble getting DBD4 to create ActiveRecord-compatible DDL statements. I have a database with a series of 1:n relationships which should be easy to model. But, depending on the relationship type I use, when I connect them in the ERD it either: 1) starts cascading foreign keys like an avalanche, or 2) fails to add ''contraint fk_xxx foreign key (yyy) references
2006 Aug 23
1
problems with Oracle: FK, triggers
Hi All! Is anyone working with Oracle on Rails? What about testing? I will be very happy if you can help me: 1) When I run rake test:unit it removes all my sequences in test enviroment. And I get an error like "OCIError: ORA-02289: sequence does not exist" But when I run rake db:test:clone_structure I can see all sequences again. Where is a problem? 2) How I can take proper
2007 Jan 31
0
radio buttons => What if the value is a FK?
Hi: I have radio buttons like this in my view: <%= radio_button :goals, :goaltype_id, ''Recurring'', { :onclick => "new Effect.SlideDown(''recurring''); return false;" } %>&nbsp;&nbsp;Recurring<br /> <%= radio_button :goals, :goaltype_id, ''One-time'', { :onclick => "new
2006 Mar 11
2
assignment of parent ID in child''s fk field
When I create a child record I''m not automagically getting the parent ID put into the fk field. Does object.new take parameters that allows me to do that as part of the AR record creation? Or do I need to do it separately? Or am I missing the boat altogether ;-) Thanks, Bill -------------- next part -------------- An HTML attachment was scrubbed... URL:
2006 Mar 15
4
[NQ] How to set an initial FK for a new item of something?
Hi all, running into a little problem here. I''ve a list of things with a "New thing" link beneath it. When you click that link, obviously, a new thing shall be created. Now, that works pretty fine for things that don''t have foreign keys, but for things that do it crashes, since there is not yet a thing.other_thing.name available. I suspect you can somewhere in
2010 Jan 27
2
RMySQL - Bulk loading data and creating FK links
I have a table (contact) with several fields and it's PK is an auto increment field. I'm bulk loading data to this table from files which if successful will be about 3.5million rows (approx 16000 rows per file). However, I have a linking table (an_contact) to resolve a m:m relationship between the an and contact tables. How can I retrieve the PK's for the data bulk loaded into
2009 Oct 08
6
Eager Loading a Relationship That Has No PK/FK
I''m attempting to wrestle an old DB into Rails. This relationship is giving me trouble: class Show < AR::Base has_many :segments end class Segment < AR::Base belongs_to :show has_one :media #this has no PK/FK relation end A Segment is "linked" to Media by Media.name, which is the result of concatenating Segment.name and Segment.part. As I said there are is no
2007 Jun 09
7
create 2 fk referencing the same table
Hi everyone! I have a problem with defining 2 fk referencing the same table. I have a Program table and a Team table. The Program should have an away team and a home team fk. From my understanding, "the fk column should be named after the class of the target table, converted to lowercase, with _id appended". But, in my case, I have 2 fk referencing the same table. How can I do this?
2009 Oct 19
2
how to get rid of 2 for-loops and optimize runtime
Short: get rid of the loops I use and optimize runtime Dear all, I want to calculate for each row the amount of the month ago. I use a matrix with 2100 rows and 22 colums (which is still a very small matrix. nrows of other matrixes can easily be more then 100000) Table before Year month quarter yearmonth Service ... Amount 2009 9 Q3 092009 A ...
2005 Jun 27
9
FK constraints overrated?
Hello folks, I use to think that a relational databases without foreign keys constraints enforced strictly by the RDBMS were no good, piece of crap, data junk. However, I''ve also learned the hard way that FKs constraints imposes serious difficulties when moving data around, specially between different DBs, or for loading test data or for upgrading DBs schemas, or for porting DBs