Contents

print "Using PostgreSQL\n"

puts "Resetting database"
conn = ETL::Engine.connection(:data_warehouse)

lines = open(File.join(File.dirname(__FILE__), 'schema.sql')).readlines
lines.join.split(';').each_with_index do |line, index|
  begin
    conn.execute(line)
  rescue => e
    puts "failed to load line #{index}: #{e}"
  end
end

Version data entries

4 entries across 4 versions & 4 rubygems

Version	Path
etl-0.9.5.rc1	test/connection/postgresql/connection.rb
activewarehouse-etl-sgonyea-0.9.6	test/connection/postgresql/connection.rb
activewarehouse-etl-0.9.5.rc1	test/connection/postgresql/connection.rb
balinterdi-activewarehouse-etl-0.9.2	test/connection/postgresql/connection.rb