similar to: Composite Primary Keys 0.3.2

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

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:

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

Announcement: Composite Primary Keys gem now includes support for ActiveRecord Associations. Summary: Composite Primary Keys allows an ActiveRecord to support 2+ primary keys using the set_primary_keys class method. Previous versions provided full CRUD and find support. This latest release provides support for more ActiveRecord magic: associations (has_many, belongs_to, etc) Full report:

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

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

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:

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

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''

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

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*

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,

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

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/.

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

The AWDwR book has the following: add_index :categories_products, [:product_id, :category_id] add_index :categories_products, :category_id The first, composite index actually serves two purposes: it creates an index which can be searched on both foreign key columns, and with most databases it also creates an index that enables fast lookup by the product id. The second index then completes

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/.

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

I´m looking for a way to work with compose primary keys. I alredy know that plugin http://compositekeys.rubyforge.org/ but it doesn´t have examples. Please help =] -- Horus Augustus C. C. Lima Sagarana Tech Mobile +55(85)8842.4402 Desk +55(85)3304.6530 augustus-b3GZhX+fmr6XmMXjJBpWqg@public.gmane.org http://www.sagaranatech.com --~--~---------~--~----~------------~-------~--~----~ You

Hi all, I have two tables: TABLE 1 A pk - fk (referencesc TABLE 2) B pk C pk D pk E F TABLE 2 A pk G H I L I don''t use incremental field (id). I''d like don''t use find_by_sql. How can I define both models to use correctly find method (with include)? With only one column primary key I haven''t problems. I thought two solutions, but I don''t like these