#!/usr/bin/python3

import sys

from rsdb.connect.db import getConnection, getExecCursor

testconn = sys.argv[1]
testdb = sys.argv[2] if len(sys.argv) == 3 else None

cxn = getConnection(testconn, testdb)
if len(sys.argv) == 3:
    sql = "SHOW TABLES"
else:
    sql = "SHOW DATABASES"
    #sql = "SELECT * FROM information_schema.session_variables WHERE VARIABLE_NAME='HOSTNAME'"

cur = getExecCursor(cxn, sql)
for row in cur:
    print (row)