thr3ads.net - Rails - Ruby existing database [Apr 2010]

If this information is useful, please help other people find it:
Share via:

Will Raffaele

2010-Apr-20 17:50 UTC

Ruby existing database

Hello all from Ruby newbie,

I''m sure this has been asked many times, but I can''t find the
answer.

I would like to use Ruby for an existing database.

It does not use id for the primary key, and the table name are not
plural.

The tables are already loaded and filled with data.

How can I get CRUD modules for the existing tables without changing the
database structure in any way?
-- 
Posted via http://www.ruby-forum.com/.

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

Craig White

2010-Apr-20 18:03 UTC

head link

Re: Ruby existing database

On Tue, 2010-04-20 at 19:50 +0200, Will Raffaele wrote:> Hello all from Ruby newbie,
> 
> I''m sure this has been asked many times, but I can''t find
the answer.
> 
> I would like to use Ruby for an existing database.
> 
> It does not use id for the primary key, and the table name are not
> plural.
> 
> The tables are already loaded and filled with data.
> 
> How can I get CRUD modules for the existing tables without changing the
> database structure in any way?----
inside the model class...

set_table_name :some_table_in_your_db

set_primary_key "some_primary_key_other_than_id"

Anyone else notice that http://api.rubyonrails.org has been hijacked?

Craig


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

Marnen Laibow-Koser

2010-Apr-20 22:09 UTC

head link

Re: Ruby existing database

Will Raffaele wrote:> Hello all from Ruby newbie,
> 
> I''m sure this has been asked many times, but I can''t find
the answer.
> 
> I would like to use Ruby for an existing database.
> 
> It does not use id for the primary key, and the table name are not
> plural.
> 
> The tables are already loaded and filled with data.
> 
> How can I get CRUD modules for the existing tables without changing the
> database structure in any way?
That depends.  Are you using Rails?  You specified Ruby without 
mentioning any other libraries...

Best,
--
Marnen Laibow-Koser
http://www.marnen.org
marnen-sbuyVjPbboAdnm+yROfE0A@public.gmane.org
-- 
Posted via http://www.ruby-forum.com/.

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

Will Raffaele

2010-Apr-21 19:06 UTC

head link

Re: Ruby existing database

Yes, I have installed Rails, as well as oracle_enhanced adapter and oci8 
installed.

I found an interesting link about using legacy databases:

  http://www.slideshare.net/napcs/rails-and-legacy-databases-railsconf-2009

I did:  rails --database=oracle ora_t1

I took the advice of Craig White and set the primary key and sequence as 
suggested in ctkagency.rb

ruby script\generate scaffold CTK_AGENCY   AGENCY_SEQUENCE:number 
AGENCY_NAME:text

I got to the localhost/3000 page ok, showing:

About your application’s environment
  Ruby version 1.8.6 (i386-mswin32)
  RubyGems version 1.3.6
  Rack version 1.0
  Rails version 2.3.5
  Active Record version 2.3.5
  Active Resource version 2.3.5
  Action Mailer version 2.3.5
  Active Support version 2.3.5
  Application root C:/Ruby/rails_apps/ora_t1
  Environment development
  Database adapter oracle_enhanced
  Database schema version 0

The next page bombed.

I think it''s because my table names have underscores, like
"CTK_AGENCY".

Processing Rails::InfoController#properties (for 127.0.0.1 at 2010-04-21 
14:49:21) [GET]
   [4;36;1mSQL (328.0ms) [0m    [0;1mselect 
decode(table_name,upper(table_name),lower(table_name),table_name) name 
from all_tables where owner =
sys_context(''userenv'',''session_user'') [0m
Completed in 421ms (View: 0, DB: 328) | 200 OK 
[http://localhost/rails/info/properties]
/!\ FAILSAFE /!\  Wed Apr 21 14:49:33 -0400 2010
  Status: 500 Internal Server Error
  Expected C:/Ruby/rails_apps/ora_t1/app/helpers/ctkagen_cies_helper.rb 
to define CtkagenCiesHelper
   
C:/Ruby/lib/ruby/gems/1.8/gems/activesupport-2.3.5/lib/active_support/dependencies.rb:426:in
`load_missing_constant''
   
C:/Ruby/lib/ruby/gems/1.8/gems/activesupport-2.3.5/lib/active_support/dependencies.rb:80:in
`const_missing''
   
C:/Ruby/lib/ruby/gems/1.8/gems/activesupport-2.3.5/lib/active_support/dependencies.rb:92:in
`const_missing''
   
C:/Ruby/lib/ruby/gems/1.8/gems/activesupport-2.3.5/lib/active_support/inflector.rb:361:in
`constantize''
   
C:/Ruby/lib/ruby/gems/1.8/gems/activesupport-2.3.5/lib/active_support/inflector.rb:360:in
`each''
   
C:/Ruby/lib/ruby/gems/1.8/gems/activesupport-2.3.5/lib/active_support/inflector.rb:360:in
`constantize''
   
C:/Ruby/lib/ruby/gems/1.8/gems/activesupport-2.3.5/lib/active_support/core_ext/string/inflections.rb:162:in
`constantize''
   
C:/Ruby/lib/ruby/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/helpers.rb:137:in
`helper''
   
C:/Ruby/lib/ruby/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/helpers.rb:115:in
`each''
   
C:/Ruby/lib/ruby/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/helpers.rb:115:in
`helper''
   
C:/Ruby/lib/ruby/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/helpers.rb:120:in
`helper''
   
C:/Ruby/lib/ruby/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/helpers.rb:115:in
`each''
   
C:/Ruby/lib/ruby/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/helpers.rb:115:in
`helper''
    C:/Ruby/rails_apps/ora_t1/app/controllers/application_controller.rb:5


-- 
Posted via http://www.ruby-forum.com/.

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

Rails - Apr 2010 - Ruby existing database

Ruby existing database

Re: Ruby existing database

Re: Ruby existing database

Re: Ruby existing database