class SelectQueryTestCase(unittest.TestCase): def setUp(self): self.host = dbhost self.dbName = dbname self.username = dbuser self.password = dbpassword self.conn = Connection(self.host, self.dbName, self.username, self.password, 3306, 10) def tearDown(self): if self.conn: self.conn.close() def testSelectStatementWithNoRowsReturned(self): result = self.conn.executeSQL("select * from channel where chanid = 999") if result: log.debug(self.conn.getFormattedSQLResultsFromIterator()) else: log.debug(str(result)) log.debug("Result = %s" % result) self.assertEquals(1, result, "successfull sql select should return 1") self.assertTrue(self.conn.getErrorCode() is None, "expected None error code") self.assertEquals("", self.conn.getErrorMsg(), "expected empty error msg") itr = self.conn.dictRowIterator() self.assertTrue(itr is None, "expected null iterator") def testSelectStatementWithOneRowReturned(self): if self.conn.executeSQL( "select chanid, visible, xmltvid, freqid, sourceid, callsign, name, channum from channel where chanid=1021" ): log.debug("\n" + self.conn.getFormattedSQLResultsFromIterator()) else: log.debug("ERROR " + str(self.conn.getErrorCode()) + ": " + self.conn.getErrorMsg()) def testSelectStatementWithManyRowsReturned(self): if self.conn.executeSQL( "select chanid, visible, xmltvid, freqid, sourceid, callsign, name, channum from channel order by chanid" ): log.debug("\n" + self.conn.getFormattedSQLResultsFromIterator()) else: log.debug("ERROR " + str(self.conn.getErrorCode()) + ": " + self.conn.getErrorMsg())
class SelectQueryTestCase(unittest.TestCase): def setUp(self): self.host = dbhost self.dbName = dbname self.username = dbuser self.password = dbpassword self.conn = Connection(self.host, self.dbName, self.username, self.password, 3306, 10) def tearDown(self): if self.conn: self.conn.close() def testSelectStatementWithNoRowsReturned(self): result = self.conn.executeSQL('select * from channel where chanid = 999') if result: log.debug(self.conn.getFormattedSQLResultsFromIterator()) else: log.debug(str(result)) log.debug('Result = %s' % result) self.assertEquals(1, result, 'successfull sql select should return 1') self.assertTrue(self.conn.getErrorCode() is None, 'expected None error code') self.assertEquals('', self.conn.getErrorMsg(), 'expected empty error msg') itr = self.conn.dictRowIterator() self.assertTrue(itr is None, 'expected null iterator') def testSelectStatementWithOneRowReturned(self): if self.conn.executeSQL( "select chanid, visible, xmltvid, freqid, sourceid, callsign, name, channum from channel where chanid=1021" ): log.debug('\n' + self.conn.getFormattedSQLResultsFromIterator()) else: log.debug('ERROR ' + str(self.conn.getErrorCode()) + ': ' + self.conn.getErrorMsg()) def testSelectStatementWithManyRowsReturned(self): if self.conn.executeSQL( "select chanid, visible, xmltvid, freqid, sourceid, callsign, name, channum from channel order by chanid" ): log.debug('\n' + self.conn.getFormattedSQLResultsFromIterator()) else: log.debug("ERROR " + str(self.conn.getErrorCode()) + ": " + self.conn.getErrorMsg())
def testGetErrorMessageIsEmptyWhenNothingDone(self): conn = Connection(dbhost, dbname, dbuser, dbpassword, 3306, 60.0) errorMessage = conn.getErrorMsg() self.assertEquals(0, len(errorMessage))