require 'rubygems'
require 'yaml'
require 'active_record'
 
CONFIG_DATABASE_YML = <<END
development:
  adapter: mysql
  database: prosol_development
  host: localhost
  username: root
  password:
 
test:
  adapter: mysql
  database: prosol_test
  host: localhost
  username: root
  password:
 
demo:
  adapter: sqlite3
  dbfile: db/demo.db
 
END
 
def connect(environment)
  conf = YAML::load(CONFIG_DATABASE_YML)
  ActiveRecord::Base.establish_connection(conf[environment])
end
 
# Open ActiveRecord connection
connect('development')
 
['tables.sql', 'data.sql', 'keys.sql'].each do |script|
  File.read("/Users/Etapeta/Sorgenti/PPMS_ERD/#{script}").split("-- GO\n").each do |sql| 
    sql = sql.sub(/^\s*/, '')
    unless sql.empty?
      puts sql; puts "....." 
      ActiveRecord::Base.connection.execute(sql)
    end
  end
end