aspose file tools*
The moose likes Ruby and the fly likes RoR: Composite Primary Keys? Stored Procedures? ListGrid? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Languages » Ruby
Bookmark "RoR: Composite Primary Keys? Stored Procedures? ListGrid?" Watch "RoR: Composite Primary Keys? Stored Procedures? ListGrid?" New topic
Author

RoR: Composite Primary Keys? Stored Procedures? ListGrid?

Bill Mietelski
Greenhorn

Joined: Aug 18, 2004
Posts: 25
Greetings,

I actually picked up the book last week. I'm only four chapters in, but it's the best intro material I've read so far, and I'm looking forward to getting through the middle of the book and creating the Depot application.

After the Depot app, I have a "real" application I want to try, but I'm still very new to Rails, and I keep hearing about the "greenfield" vs legacy thing. I have three specific features in mind; maybe you can tell me if they're do-able in Rails.

My legacy app uses a back-end DB2 database. So far, no problem. But the tables have composite primary keys. Most of the examples of Rails apps I see use surrogate auto-generated integer primary keys. Are composite primary keys possible using Rails?

This legacy app I have in mind also uses Stored Procedures. I haven't seen any examples of this in Rails, at least from what I've seen so far. Can I call DB2 Stored Procedures in Rails?

Finally, this legacy app displays a grid, similar to DomAPI's Listgrid. Is something like this possible in Rails?

Thanks for a great book!
Aitor Imaz
Greenhorn

Joined: Jan 30, 2005
Posts: 8
You might find interesting information on how to use Rails with legacy databases on this article on the Rails Wiki:

http://wiki.rubyonrails.com/rails/pages/HowToUseLegacySchemas

Composite keys are not supported by plain Rails. However, there is a plugin that seems to support them, but I haven't tried it:

http://compositekeys.rubyforge.org/

Hope that helps.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: RoR: Composite Primary Keys? Stored Procedures? ListGrid?