class TestMECODBRead(unittest.TestCase): def setUp(self): self.reader = MECODBReader() self.connector = MSGDBConnector(True) self.conn = self.connector.connectDB() self.inserter = MECODBInserter() self.util = MSGDBUtil() self.lastSeqVal = None self.tableName = 'MeterData' self.colName = 'meter_data_id' self.deleter = MECODBDeleter() def testMECODBReadCanBeInited(self): self.assertIsNotNone(self.reader) def testSelectRecord(self): """ Insert and retrieve a record to test the ability to select a record. """ print "testSelectRecord:" print "self.conn = %s" % self.conn sampleDict = { 'MeterName': '100001', 'UtilDeviceID': '100001', 'MacID': '00:00:00:00:00:00:00:00' } self.inserter.insertData(self.conn, self.tableName, sampleDict) self.lastSeqVal = self.util.getLastSequenceID(self.conn, self.tableName, self.colName) print "lastSeqVal = %s" % self.lastSeqVal row = self.reader.selectRecord(self.conn, self.tableName, self.colName, self.lastSeqVal) self.assertEqual(row[self.colName], self.lastSeqVal) def tearDown(self): # Delete the record that was inserted. if self.lastSeqVal != None: self.deleter.deleteRecord(self.conn, self.tableName, self.colName, self.lastSeqVal) self.connector.closeDB(self.conn)
class TestMECODBRead(unittest.TestCase): def setUp(self): self.reader = MECODBReader() self.connector = MSGDBConnector(True) self.conn = self.connector.connectDB() self.inserter = MECODBInserter() self.util = MSGDBUtil() self.lastSeqVal = None self.tableName = 'MeterData' self.colName = 'meter_data_id' self.deleter = MECODBDeleter() def testMECODBReadCanBeInited(self): self.assertIsNotNone(self.reader) def testSelectRecord(self): """ Insert and retrieve a record to test the ability to select a record. """ print "testSelectRecord:" print "self.conn = %s" % self.conn sampleDict = {'MeterName': '100001', 'UtilDeviceID': '100001', 'MacID': '00:00:00:00:00:00:00:00'} self.inserter.insertData(self.conn, self.tableName, sampleDict) self.lastSeqVal = self.util.getLastSequenceID(self.conn, self.tableName, self.colName) print "lastSeqVal = %s" % self.lastSeqVal row = self.reader.selectRecord(self.conn, self.tableName, self.colName, self.lastSeqVal) self.assertEqual(row[self.colName], self.lastSeqVal) def tearDown(self): # Delete the record that was inserted. if self.lastSeqVal != None: self.deleter.deleteRecord(self.conn, self.tableName, self.colName, self.lastSeqVal) self.connector.closeDB(self.conn)
class TestMECODBInserter(unittest.TestCase): """ Unit tests for the MECO XML Parser. """ def setUp(self): self.i = MECODBInserter() self.util = MSGDBUtil() self.connector = MSGDBConnector(True) self.deleter = MECODBDeleter() self.reader = MECODBReader() self.lastSeqVal = None self.conn = self.connector.connectDB() self.sampleTableName = 'MeterData' self.sampleDict = {'MeterName': '100001', 'UtilDeviceID': '100001', 'MacID': '00:00:00:00:00:00:00:00'} self.keyName = 'meter_data_id' def testMECODBInserterCanBeInited(self): localInserter = MECODBInserter() self.assertIsInstance(self.i, type(localInserter)) def testInsertionToMeterDataTable(self): """ Data can be written to the Meter Data table. """ # Insert some values. self.i.insertData(self.conn, self.sampleTableName, self.sampleDict) # Retrieve the last fetched value. self.lastSeqVal = self.util.getLastSequenceID(self.conn, self.sampleTableName, self.keyName) print "lastSeqVal = %s" % self.lastSeqVal row = self.reader.selectRecord(self.conn, self.sampleTableName, self.keyName, self.lastSeqVal) self.assertEqual(row[self.keyName], self.lastSeqVal) def test_fkey_value_is_correct(self): """ Verify that the fkey value used during insertion is correct. """ def testInsertionsSums(self): """ """ pass def tearDown(self): # Delete the record that was inserted. if self.lastSeqVal != None: self.deleter.deleteRecord(self.conn, self.sampleTableName, self.keyName, self.lastSeqVal) self.connector.closeDB(self.conn)