Displaying 20 results from an estimated 10000 matches similar to: "Composite Primary Keys support for Associations"
2006 Aug 14
0
Composite Primary Keys - now works with Rails 1.1.6
Due to the foolish implied assumption that there''d never be a revision
to activerecord library, the Composite Primary Key code promptly broke
for anyone who updated their apps to Rails 1.1.6 (with its
activerecord-1.14.4)
Now the gem dependencies are fixed and your legacy databases are free to
wield composite primary keys without fear again.
Description:
Composite Primary Keys
2010 Aug 19
1
Composite primary keys and :joins=>
I have a legacy db with the following simplified structure:
Table-A:
type_key, code_key, name, ... # PKs are type_key and code_key,
there is no id col and I cannot alter this db
Table-B: # each row has only the code as a foreign_key, the type_key
is hard-coded to "FOOKEY"
an_id, code, ...
Models:
class TableB < AR::Base
set_table_name ''table_b''
2006 Jul 30
0
Composite Keys 0.3.3
Composite Primary Keys for ActiveRecords
Bug fix release - 0.3.3
Notes:
Fixed errors with id= and create.
Note, the create method does not use sequences to generate ids for you.
If anyone has any use cases where their DBs generate ids for their
composite keys, pls let me know - we may need to add some syntax to the
set_primary_keys command.
Url:
http://compositekeys.rubyforge.org
Summary:
2012 Jan 05
3
composite keys and association
i have two table, comment and post, both have composite keys, and no id
column, comment belongs to post, i follow the instruction of
http://compositekeys.rubyforge.org/, and it seems successfully,
(But i still cant confirm to put require ''rubygems'' and
require ''composite_primary_keys'' on which file ).
I can do the CRUD operation for post,then i want to create
2007 Mar 08
2
Composite Primary Keys
Have been looking into using rails but am finding the "Composite
Primary Keys are Bad" thing a tad disturbing (to put it mildly). I
have been working with RDBMS systems for over fifteen years and this
is the first time I have herd the idea questioned. I have cone across
using surrogate keys which mirror the composite key for performance
reasons in VERY big databases but I have never
2005 Dec 09
1
composite primary keys
Hello,
Is it true that Rails doesn''t support composite primary keys? I have a
legacy system and was pondering adding a new interface to it. This whole
Rails thing (and yes, Ruby too) seems pretty interesting but I''d feel
ashamed of myself adding an additional column called ''id'' when there''s
already a perfectly good composite key.
Assuming the rumors
2006 Jul 23
0
Composite Primary Keys 0.3.2
ActiveRecords with composite primary keys now seem to happily support
find/create/update/destroy options.
Url: http://compositekeys.rubyforge.org
Background:
Rails/ActiveRecords has long been critised for not supporting legacy
databases, especially composite primary keys. This gem extends ARs with
this support.
Cheers
Nic
--
Posted via http://www.ruby-forum.com/.
2006 Jul 27
0
CRUD, REST and associations
Let''s say I have the model class Reader and Magazine, connected by join
model Subscription. It looks something like this
class Reader < ActiveRecord::Base
has_many :subscriptions, :dependent => :delete_all
has_many :magazines, :through => :subscriptions
validates_presence_of :name
end
class Magazine < ActiveRecord::Base
has_many :subscriptions, :dependent =>
2006 Apr 03
4
How to fake composite primary keys?
I know ActiveRecord doesn''t support composite primary keys, but I need to use
one, and I need it ASAP. I don''t need any composite foreign keys, luckily;
what I have is a table that stores old versions of rows in another table, so
the composite key is an id + date stamp. Would someone tell me a hack I can
use to support this?
--
View this message in context:
2006 Jun 21
1
about composite primary keys
hello,
what is the strategy you use for composite primary keys ?
I saw the solution proposed by Graham Glass ( ticket 3201) using a
set_composite_key..., but it seems it is not in AR ....(why ?)
thanks for feedback
arnaud
2014 May 15
0
composite primary key - Rails 4.1
Hi,
I am facing issue with composite primary key
In my gem file I have the below entries -
gem 'rails', '>= 4.1.0.rc2'
gem 'mysql2'
gem 'rb-readline', "~> 0.5.1"
gem 'sdoc', '~> 0.4.0', group: :doc
gem 'spring', group: :development
gem 'bcrypt', '~> 3.1.7'
gem
2006 Jan 11
1
Composite primary key
Hi All,
How do I specify a composite primary key for a table in ActiveRecord?
For example the table Recipe which has the primary key [cookie id, version
number] where cookie id is also a foreign key referencing Cookie.
Also: Thanks to Nic and Adam for helping with the Cookie -> Cooky problem.
/Hugo
--SQL
*
CREATE* *TABLE* `Raw_Materials`*
(*
id *INT*
2009 May 26
0
rake db:schema:dump doesn't produce composite primary key instructions
Hey there,
I''ve adjusted some of my many to many join tables recently to use a
composite primary key based on the id''s in the two columns - instead
of using a surrogate key.
I just did a db:schema:dump, and it looks something like this:
create_table "class_members", :id => false, :force => true do |t|
t.integer "user_id", :default => 0,
2007 Oct 26
0
Composite Keys on RESTful Routes
I am building an app with existing controllers/actions, using
traditional rails routes. I recently started moving over to RESTful
routes and have hit a snag. Now I am reconsidering my whole effort
and may go back to the original, more flexible, map.connect method.
My problem is, one of the resources has composite keys. The keys are
both strings as well, and can include dots. Here''s
2006 Mar 22
0
validating composite model keys
I know that I should be able to figure this out by looking at the
source, but this "ruby newbie" can''t:
I have a model for a table with a 3-column composite key. Is there a way
to tell the stock validates_uniqueness_of() helper to validate such a
key or do I have to write my own?
Thanks,
Larry
--
Posted via http://www.ruby-forum.com/.
2006 Feb 18
14
Composite primary key support in ActiveRecord?
Hi,
As I understand, composite primary keys aren''t supported in
ActiveRecord yet. May I ask if there are plans for this feature?
Better yet, if this feature is under development, how''s the progress
going?
I''m not trying to use legacy databases. I tend to think that using
multiple integer column id''s (composite primary key) are often
natural way to
2006 Jul 26
15
Rails without a primary key
I''ve been trying to use Rails on a database where the biggest
datawarehouse-style table doesn''t have a primary key. It really
doesn''t make sense and just adds extra unnecessary space. I do have,
however, a column that I normally use to search on (IP) that returns
many rows. The table also references several other tables through
rails-friendly foreign keys.
Simple AR
2006 Feb 28
3
Composite Key Support
Right now rails doesn''t support composite keys, that is id1, id2, and
id3 are in the primary key of the table. Does anyone know if this is
being discussed for future versions, or is it pretty much out of scope?
--
Posted via http://www.ruby-forum.com/.
2006 Aug 07
28
Dr Nic’s Magic Models
Welcome! Welcome! Welcome! Ladies and Gentlemen, today you shall be
thrilled and dazzled by wonders of magical mystery.
Dr Nic?s Magic Models will now be unveiled to all. Mystery and magic
that you will be able to perform at home.
Within your ActiveRecord models, never again will you need to write:
* validates_presence_of validations
* has_many and belongs_to statements
* has_many
2006 Aug 16
0
Polymorphic Associations and grouping users and projects
Hi all,
In my app I would like to create user groups in my admin. Currently I
have the following models and associations that facilitate this.
class User < ActiveRecord::Base
has_many :memberships
has_many :groups, :through => :memberships
end
class Membership < ActiveRecord::Base
belongs_to :group
belongs_to :user
end
class Group < ActiveRecord::Base
has_many