connection w/ a non-standard mysql db using active-record and retrieving tables

ar_mysql_connect.rb

#! /usr/bin/env ruby
#
# Establishes connection with a MySQL db and access its tables
# which have non-standard names, such as user, accounts.
#

require 'active_support/inflector'
require 'active_record'
require 'mysql2'

ActiveRecord::Base.establish_connection({
  adapter: 'mysql2',
  host: 'localhost',
  username: 'root',
  password: 'mysecret',
  database: 'blah_db'
})

models = []

ActiveRecord::Base.connection.tables.each do |t|
  model = Class.new(ActiveRecord::Base) do
    self.table_name = t
  end
  Object.const_set(t.singularize.camelize, model)
  models << model     
end

puts models.map(&:name).join(", ") + "\n"
models.map{|m| puts m.inspect }.join("\n")



# OUTPUT

# Account, User
# Account(id: integer, user_id: integer, cc_number: string)
# User(id: integer, name: string, email: string, mobileno: string)