#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()