#d.addConnection(dbConn, cursor)
#create test query
#q = SqliteQuery(dbConn, cursor)
#q.addQuery('select count(*) from queries', 'Mike', 3.4)
#results = q.searchQuery('queries')
#sqlite
#configDB = SqliteConnection("/home/mike/projects/python/sm3dbrowser/sm3dbrowser.sqlite")
#results = configDB.searchQuery('queries')
#results = configDB.executeQuery("SELECT * FROM connectioninfo",())
#parameters = ('%'+'con'+'%',)
#results = configDB.executeQuery("SELECT * FROM connectioninfo WHERE Name LIKE ?",parameters)
#configDB.closeConnection()
#Oracle
clientDB = OracleConnection('sm3', 'sm3', '192.168.2.115', '1521', 'sm3')
#results = clientDB.executeQuery('SELECT * FROM sha_mst',{})
parameters = {'warehouse_code': '20'}
results = clientDB.executeQuery(
'SELECT * FROM OEH_HDR WHERE warehouse_code = :warehouse_code', parameters)
clientDB.closeConnection()
xl = Excel('test.xlsx', 'first worksheet')
xl.addWorksheet('Parameters')
#headings = ('ConnectionInfoID','Name','HostName','Port','SID','Username','Password','VPN','Description')
#xl.writeRow('first worksheet', 1, 1, True, headings)
xl.writeRows('first worksheet', 2, 1, False, results)
xl.writeFile()
