Ejemplo n.º 1
0
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()
Ejemplo n.º 2
0
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()
Ejemplo n.º 3
0
 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)
Ejemplo n.º 4
0
 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)
Ejemplo n.º 5
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)
Ejemplo n.º 6
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)