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