class Insert_t(unittest.TestCase): @DaoConfig("DBSWriter") def __init__(self, methodName='runTest'): super(Insert_t, self).__init__(methodName) data_location = os.path.join(os.path.dirname(os.path.abspath(__file__)), 'test_data.pkl') self.data_provider = create_dbs_data_provider(data_type='transient', data_location=data_location) self.data = self.data_provider.get_acquisition_era_data(regenerate=True)[0] def setUp(self): """setup all necessary parameters""" self.conn = self.dbi.connection() self.acquisition_era_insert = AcquisitionEraInsert(self.logger, self.dbi, self.dbowner) self.sequence_manager = SequenceManager(self.logger, self.dbi, self.dbowner) def tearDown(self): """Clean-up all necessary parameters""" self.conn.close() def test01(self): """dao.Oracle.AcquisitionEra.Insert: Basic""" tran = self.conn.begin() try: self.data["acquisition_era_id"] = self.sequence_manager.increment(self.conn, "SEQ_AQE", tran) self.data["acquisition_era_name"] = self.data["acquisition_era_name"].upper() self.acquisition_era_insert.execute(self.conn, self.data, tran) except Exception as ex: tran.rollback() raise ex else: tran.commit() finally: if tran: tran.close()
class Insert_t(unittest.TestCase): @DaoConfig("DBSWriter") def __init__(self, methodName='runTest'): super(Insert_t,self).__init__(methodName) data_location = os.path.join(os.path.dirname(os.path.abspath(__file__)),'test_data.pkl') self.data_provider = create_dbs_data_provider(data_type='transient',data_location=data_location) self.data = self.data_provider.get_acquisition_era_data(regenerate=True)[0] def setUp(self): """setup all necessary parameters""" self.conn = self.dbi.connection() self.acquisition_era_insert = AcquisitionEraInsert(self.logger, self.dbi, self.dbowner) self.sequence_manager = SequenceManager(self.logger, self.dbi, self.dbowner) def tearDown(self): """Clean-up all necessary parameters""" self.conn.close() def test01(self): """dao.Oracle.AcquisitionEra.Insert: Basic""" tran = self.conn.begin() try: self.data["acquisition_era_id"] = self.sequence_manager.increment(self.conn, "SEQ_AQE", tran) self.data["acquisition_era_name"] = self.data["acquisition_era_name"].upper() self.acquisition_era_insert.execute(self.conn, self.data, tran) except Exception as ex: tran.rollback() raise ex else: tran.commit() finally: if tran: tran.close()
def test07(self): """AcquisitionEra.Insert""" from dbs.dao.Oracle.AcquisitionEra.Insert import Insert as AcqusitionEraInsert dao = AcqusitionEraInsert(self.logger, self.dbi) dinput = {"acquisitioneraid":int(INSERTCOUNT), "acquisitioneraname":"Ihavenoideahowitshouldlooklike" + INSERTCOUNT, "creationdate":1234, "createby":"me", "description":"nodescription" } dao.execute(dinput)
def setUp(self): """setup all necessary parameters""" self.conn = self.dbi.connection() self.acquisition_era_insert = AcquisitionEraInsert( self.logger, self.dbi, self.dbowner) self.sequence_manager = SequenceManager(self.logger, self.dbi, self.dbowner)
def setUp(self): """setup all necessary parameters""" self.conn = self.dbi.connection() self.acquisition_era_insert = AcquisitionEraInsert(self.logger, self.dbi, self.dbowner) self.sequence_manager = SequenceManager(self.logger, self.dbi, self.dbowner)