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;" }
%> 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