thr3ads.net - Rails core - Legacy databases [Nov 2010]

If this information is useful, please help other people find it:
Share via:
Gustavo de Sá Carvalho Honorato
2010-Nov-25 16:10 UTC
Legacy databases

Hi,

I''m experiencing problems with Rails when using a database with users
table
and columns names different from default. When I try to register an new user
using the register form, I got the following error:
*
*
*   ActiveRecord::RecordNotFound in UsersController#create

Couldn''t find Role without an ID

RAILS_ROOT: /home/gustavo/CAS/cas-web
 Application Trace <http://localhost:3000/users#> | Framework
Trace<http://localhost:3000/users#>| Full
Trace <http://localhost:3000/users#>

/home/gustavo/.rvm/gems/jruby-1.5.2/gems/activerecord-2.3.8/lib/active_record/base.rb:1597:in
`find_from_ids''
/home/gustavo/.rvm/gems/jruby-1.5.2/gems/activerecord-2.3.8/lib/active_record/base.rb:619:in
`find''
/home/gustavo/CAS/cas-web/app/controllers/users_controller.rb:41:in
`create''


My user.rb file:


class User < ActiveRecord::Base
  #=============================  #   Petro DB Convention Mapping
  #=============================  TABLE_NAME = ''USUARIO''
  set_table_name TABLE_NAME

  FIRST_NAME_COLUMN = ''USUA_NM_NOME''
  LAST_NAME_COLUMN = ''USUA_NM_SOBRENOME''
  USERNAME_COLUMN = ''USUA_NM_USUARIO''
  CRYPT_PASSWORD_COLUMN = ''USUA_VL_CRYPT_PASSWORD''

  PASSWORD_SALT_COLUMN = ''USUA_VL_PASSWORD_SALT''
  PERSISTENCE_TOKEN_COLUMN = ''USUA_VL_TOKEN''
  LAST_LOGIN_AT_COLUMN = ''USUA_DT_ULTIMO_LOGIN''
  LAST_LOGIN_IP_COLUMN = ''USUA_VL_IP_ULTIMO_LOGIN''
  EMAIL_COLUMN = ''USUA_VL_EMAIL''
  CURRENT_LOGIN_AT_COLUMN = ''USUA_DT_ATUAL_LOGIN''
  CURRENT_LOGIN_IP_COLUMN = ''USUA_VL_IP_ATUAL_LOGIN''
  DEPARTMENT_ID_COLUMN = ''USUA_CD_DPTO''

  CREATED_AT_COLUMN = ''EVT_DT_CRIACAO''
  UPDATED_AT_COLUMN = ''EVT_DT_ATUALIZACAO''

  alias_attribute :first_name, FIRST_NAME_COLUMN
  alias_attribute :last_name, LAST_NAME_COLUMN
  alias_attribute :username, USERNAME_COLUMN
  alias_attribute :crypted_password, CRYPT_PASSWORD_COLUMN

  alias_attribute :password_salt, PASSWORD_SALT_COLUMN
  alias_attribute :persistence_token, PERSISTENCE_TOKEN_COLUMN
  alias_attribute :last_login_at, LAST_LOGIN_AT_COLUMN
  alias_attribute :last_login_ip, LAST_LOGIN_IP_COLUMN
  alias_attribute :email, EMAIL_COLUMN
  alias_attribute :current_login_at, CURRENT_LOGIN_AT_COLUMN
  alias_attribute :current_login_ip, CURRENT_LOGIN_IP_COLUMN
  alias_attribute :department_id, DEPARTMENT_ID_COLUMN

  alias_attribute :created_at, CREATED_AT_COLUMN
  alias_attribute :updated_at, UPDATED_AT_COLUMN


  acts_as_authentic do |config|
    config.login_field USERNAME_COLUMN
    config.crypted_password_field CRYPT_PASSWORD_COLUMN
  end

  acts_as_tagger

  #=============================  #   Associations
  #=============================
  has_many :events
  has_many :assignments, :dependent => :destroy
  has_many :roles, :through => :assignments
  has_many :event_approval_requests

  belongs_to :department, :foreign_key => DEPARTMENT_ID_COLUMN

  #=============================  #   Validations
  #=============================
  accepts_nested_attributes_for :assignments

  validates_associated :roles, :assignments

  validates_presence_of :first_name, :last_name, :email, :username

  validates_presence_of :department_id, :unless => :admin?

  def admin?
    roles.first.title == Role::ADMIN_TITLE
  end

  def to_param
    "#{id}-#{username}"
  end

  def role_symbols
    roles.map do |role|
      role.title.underscore.to_sym
    end
  end
end


Register Form:

<% simple_form_for @user do |f| %>
    <%= f.error_messages %>

    <%= f.input :username %>
    <%= f.input :first_name %>
    <%= f.input :last_name %>
    <%= f.input :email %>
    <%= f.association :roles, :as => :radio %>
    <%= f.association :department %>

    <%= f.button :submit %>
<% end  %>

 Migration snippet:

    change_table :users do |t|
      t.rename :first_name, User::FIRST_NAME_COLUMN
      t.rename :last_name, User::LAST_NAME_COLUMN
      t.rename :username, User::USERNAME_COLUMN
      t.rename :crypted_password, User::CRYPT_PASSWORD_COLUMN

      t.rename :password_salt, User::PASSWORD_SALT_COLUMN
      t.rename :persistence_token, User::PERSISTENCE_TOKEN_COLUMN
      t.rename :last_login_at, User::LAST_LOGIN_AT_COLUMN
      t.rename :last_login_ip, User::LAST_LOGIN_IP_COLUMN
      t.rename :email, User::EMAIL_COLUMN
      t.rename :current_login_at, User::CURRENT_LOGIN_AT_COLUMN
      t.rename :current_login_ip, User::CURRENT_LOGIN_IP_COLUMN
      t.rename :department_id, User::DEPARTMENT_ID_COLUMN

      t.rename :created_at, User::CREATED_AT_COLUMN
      t.rename :updated_at, User::UPDATED_AT_COLUMN
    end

    rename_table :users, User::TABLE_NAME

Roles table:

    create_table :roles do |t|
      t.string :title

      t.timestamps
    end

Assignment table:

    create_table :assignments do |t|
      t.integer :user_id
      t.integer :role_id
      t.timestamps
    end

*
Thanks in advance,
Gustavo

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Core" group.
To post to this group, send email to rubyonrails-core@googlegroups.com.
To unsubscribe from this group, send email to
rubyonrails-core+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-core?hl=en.
Rails core - Nov 2010 - Legacy databases

Legacy databases
