similar to: about 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

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

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:

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

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

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:

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

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*

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

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,

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

Olly Betts writes: > On Mon, Apr 11, 2016 at 09:54:36AM +0200, Jean-Francois Dockes wrote: > > The question which remains for me is if I should run xapian-compact > > after an initial indexing operation. I guess that this depends on the > > amount of expected updates and that there is no easy answer ? > > I think it's not obvious whether it's a good plan

Hello, I would like to load an Hash in my init.rb plugin file ... than I would like to use this hash in my module ... in my init.rb: @anHash = load From file... in mymodule: module Amodule def myFunction #@anHash .... end end How can I access to my hash in my plugin module function ? thanks for this dummy question ;-) Arnaud

Thanks for replying to my question. However, I am still confused. Rafal Szczesniak <mimir@samba.org> wrote: >On Thu, Jul 17, 2003 at 08:58:30AM -0700, Matt Seitz wrote: >> The Samba web site contains "The Samba Team announces Samba 3.0.0 >> beta3". This document includes a section titled "Trust Relationships >> and a Samba Domain". For

Hi, I can''t list error_messages in my Form ??, and all the formfields are reset ...(I think my redirect :back clean everything, formfield and error_messages ...), only my flash[:notice] is ok.... I would like to use the "error_messages_for" tag to add a simple red * on my textfiled if a problem occurs ... thanks for help arnaud here are the basics steps to check that

Hi all, I'm wondering what about machine accounts (WinXP) by migrating from Samba 2.2.8 with authentication backend /etc/smbpasswd to Samba 3.0.4 with ldapsam. Is it possible just to take NT hash from smbpasswd and paste it to ldap record as sambaNTPassword? I'm not able to login from machine vs3 to new domain. My configuration files and log files follow. The Samba-SID is the same

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

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

I recently lost a hard drive and after successfully restoring everything, I think, I'm getting "Error opening database `current.1': DatabaseOpeningError: Couldn't detect type of database" The directory current.1 contains the following files: -rw-rw-r-- 1 jwl jwl  30064640 Aug 28 23:44 docdata.glass -rw-rw-r-- 1 jwl jwl       151 Aug 28 23:44 iamglass -rw-rw-r-- 1 jwl jwl

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: