Displaying 20 results from an estimated 1000 matches similar to: "FK constraints overrated?"
2006 Apr 28
5
Migrations - use them or not?
Hello,
As a rails newbie, i have stumbled upon some tutorials promoting
migratons. I have thought, wow, cool and started using them right away.
However, now that i am reading the RoR list on a daily basis, i have
seen also mails ranging from ''migrations are not always the best'' to
''migrations are evil'' and even ''i would not use migrations even
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?
2006 Nov 10
2
Testing with foreign keys
I''m looking for a plugin/whatever for preloading fixtures, to run
tests with FKs defined.
Specifying load order just doesn''t work for me, I need to purge the
test db, load all fixtures, and only then create the FK constraints.
Any suggestions?
Isak
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
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 May 25
24
Make these a prt of Ruby on Rails!
3 things that should be part of the main Rails tree:
http://www.redhillconsulting.com.au/rails_plugins.html
Views?
--
Posted via http://www.ruby-forum.com/.
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
2011 Nov 28
29
Lack of foreign-key constraints support in ActiveRecord
Is there any reason why AR has never supported foreign-key constraints?
I can understand the lack of support for triggers and stored procedures
since they are highly dependent on the database to create a wrap API
around them. But this is not the case for foreign keys.
This is specially important for open-source projects like
Redmine/Chiliproject and Gitorious where you shouldn''t be
2006 Feb 13
5
ActiveRecord with Legacy Database
Hiya RoR gurus,
I work at a .NET shop, but I enjoy learning Ruby. So, I wanna
prototype some of our product''s screens using Rails (and hopefullly
AJAX). One thing I''m not sure about, since I''m a Rails noob, is
whether ActiveRecord will get along with our database...
So I have two questions:
* Can I have ActiveRecord get along with our PascalCase naming conventions?
2005 Sep 06
9
acts_as_taggable v4 - Tag Counting Anyone?
There´s already a new version of the acts_as_taggable mixin available
and look what it is capable of now:
# Gets the top 10 tags for all photos
Photo.tags_count :limit => 10 # => { ''beer'' => 68, ''wine'' => 37, ''vodka''
=> ''22'', ... }
# Gets the tags count that are greater than 30
Photo.tags_count :count =>
2005 Sep 06
6
strange behavior of acts_as_taggable
I was testing my models with this new library and I got:
>> s.tag "warp"
ActiveRecord::StatementInvalid: ERROR: inserción o actualización en la tabla
«tags_stories» viola la llave foránea «tags_stories_story_id_fkey»
DETAIL: La llave (story_id)=(8) no está presente en la tabla «stories».
: INSERT INTO tags_stories ("tag_id", "story_id") VALUES
2004 Dec 15
4
AR db adapter for a RDF database (ATT: DHH)
Hi people,
As I stated in a earlier message, I am using Rails on my masters degree
and soon I will have to port my application from a relational database
(MySql) to a RDF semantic database called Sesame.
At first, I thought that I could get away with most of the porting only
by writing a decent database adapter, but then, examining AR closer, I
could see that it has some strong dependencies
2005 May 01
5
Example using Builder::XmlMarkup and .rxml files?
Greetings,
I''m a newby to both "R"s in RoR. I would like to use Builder::XmlMarkup
to generate my pages. If there is a working downloadable example
somewhere, that would probably be enough. Otherwise, here''s what
I want to do:
With the following controller:
class AccountsController < ApplicationController
layout ''accounts''
model :account
2005 Sep 03
13
acts_as_taggable v2 - Tagging on Steroids
Hi folks,
Thanks to the community feedback on the 1st version, I''ve come up with a
much improved version of the acts_as_taggable mixin.
There´s some piece of the action here:
http://dema.ruby.com.br/articles/2005/09/03/tagging-on-steroids-with-rails
Cheers
Dema
--
http://dema.ruby.com.br - Rails from a .NET perspective
1997 Jul 24
4
Samba and ClearCase
We're trying to use samba to let our PC's mount view extended pathnames used
by clearcase but they show up as empty. If anyone's used samba and Clear
Case (by Pure Atria) and gotten it to work I'd love to hear how.
thanks,
Bill
--
---------------------------------------------------------------------
William H. Schwartz email: whschwartz@mmm.com
System
2005 Aug 16
3
Rails Docs in CHM format
Hi Folks,
For the Windows Railers, I''ve made the Rails docs available as a CHM file:
http://dema.ruby.com.br/articles/2005/08/16/rails-docs-in-chm-format
Cheers,
Dema
--
http://dema.ruby.com.br - Rails from a .NET perspective
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 <
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 May 26
0
has_and_belongs_to_many with fk constraints?
Hi folks,
I''m wondering if it''s possible to use foreign key constraints on the join
tables of a has_and_belongs_to_many relation. Specifically, I get this
error when I try and delete a model I''m using, named saved_search, which is
many-to-many with neighborhoods. Any ideas? Thanks for any help. :-)
-Eric
Code:
@saved_search.destroy
Error:
Mupdate or delete on
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 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