#!/bin/env jruby
# Licensed under the terms of http://www.apache.org/licenses/LICENSE-2.0

require 'java'
#include_class 'java.lang.Class'

include_class 'java.sql.DriverManager' 
include_class 'com.mysql.jdbc.jdbc2.optional.MysqlDataSource'

require 'jdbc'
require 'format'

## ds = MysqlDataSource.new()
## ds.setUser(ENV['SDB_USER'])
## ds.setPassword(ENV['SDB_PASSWORD'])
## ds.setURL("jdbc:mysql://localhost/information_schema")
## ds.getConnection()
## 
## c = JDBC::DB.new(ds.getConnection())

c = JDBC::DB.connect("jdbc:mysql://localhost/information_schema",
                     "com.mysql.jdbc.Driver",
                     ENV['SDB_USER'],
                     ENV['SDB_PASSWORD'])

q = <<EOQ
   SELECT DISTINCT table_schema, engine
   FROM TABLES
   WHERE table_schema != 'information_schema' 
   AND table_schema != 'mysql'
EOQ
c.query_print(q)
c.close