if calltest: return 'dpdeletetest_fk' else: return "delete from tb_testfk where fktest = {}".format( key_values) else: if calltest: return 'dpdeletetest_ckeys' else: return "delete from tb_maintable_ckeys where main_code = '{}' and main_number = {}".format( key_values[0], key_values[1]) daoDelegate = DAODelegateTest() dao = DatabasePersistence(trx, daoDelegate) constraints = None if calltest: constraints = Constraints() # usamos la transacion para informar que el control es extrerno. # IMPORTANTE: # Si usa sp para eliminar y verified_delete_check es true el parametro # key_values deben ser iguales a lo de los caller params en los constraints. if test == 'normal': key = 15 if calltest: constraints.add_caller_parameter(Constraints.CallerOperation.DEL, key, 0)
if calltest_execute: return "dpupdatetest" elif calltest: return "select dpupdatetest({},'{}');".format( record_model.id_key, record_model.anytext) else: return "update tb_maintable set anytext = '{}' where id_key = {}".format( record_model.anytext, record_model.id_key) model = MainTableModel() model.anytext = 'testchang4' model.id_key = 5 model.xmin = 128951 constraints = None if calltest_execute: constraints = Constraints() constraints.add_caller_parameter(Constraints.CallerOperation.UPD, 'id_key', 0) constraints.add_caller_parameter(Constraints.CallerOperation.UPD, 'anytext', 0) daoDelegate = DAODelegateTest() dao = DatabasePersistence(trx, daoDelegate) # usamos la transacion para informar que el control es extrerno. ret = dao.update_record(model, c_constraints=constraints) print(ret) print(model.__dict__)
return lastrowid def get_read_record_query(self, record_model, key_values, c_constraints=None, sub_operation=None): return "select * from tb_maintable where id_key={}".format( key_values) def get_add_record_query(self, record_model, c_constraints=None, sub_operation=None): return "withOutParamInsertTest" daoDelegate = DAODelegateTest() constraints = Constraints() constraints.add_caller_parameter(Constraints.CallerOperation.ADD, 'anytext', 0) dao = DatabasePersistence(trx, daoDelegate) # usamos la transacion para informar que el control es extrerno. ret = dao.add_record(model, reread_record=fl_reread, c_constraints=constraints) print(ret) print(model.__dict__)
key_values, c_constraints=None, sub_operation=None): return "select * from tb_maintable where id_key={}".format( key_values) def get_add_record_query(self, record_model, c_constraints=None, sub_operation=None): return "select * from withOutParamInsertTest('{}');".format( record_model.anytext) daoDelegate = DAODelegateTest() dao = DatabasePersistence(trx, daoDelegate) # usamos la transacion para informar que el control es extrerno. if verify_dup: trx.start_transaction() ret = dao.add_record(model, reread_record=fl_reread) print(ret) print(model.__dict__) if verify_dup and ret == PersistenceErrors.DB_ERR_ALLOK: model.nondup = 'El segundo 25' ret = dao.add_record(model, reread_record=fl_reread) print(ret) print(model.__dict__) # cerreamos la transacion global
'user': '******', 'password': '******', 'database': 'py_dbtest' }) else: trx = TransactionManager( driver, { 'dsn': 'MSSQLServer', 'host': '192.168.0.9', 'port': '1433', 'user': '******', 'password': '******', 'database': 'veritrade' }) daoDelegate = DAODelegateTest() dao = DatabasePersistence(trx, daoDelegate) memb = mem_profile.memory_usage_psutil() print('Memory (Before): {}Mb'.format(memb)) t1 = time.clock() constraint = Constraints() constraint.offset = 0 constraint.limit = 50 if driver == 'pgsql': constraint.add_filter_field('issotrx', True, Constraints.FilterType.EQUAL) constraint.add_filter_field('c_bpartner_id', 1009790, Constraints.FilterType.NO_EQUAL) constraint.add_filter_field('c_groupdoc_id', None, Constraints.FilterType.NO_EQUAL)
return "select * from tb_testfk where fktest={}".format(key_values) else: return "select * from tb_maintable_ckeys where main_code = '{}' and main_number = {}".format( key_values[0], key_values[1]) def get_delete_record_query(self, key_values, c_constraints=None, sub_operation=None): if test == 'normal': return "delete from tb_maintable where pk_id = {}".format( key_values) elif test == 'del_fk': return "delete from tb_testfk where fktest = {}".format(key_values) else: return "delete from tb_maintable_ckeys where main_code = '{}' and main_number = {}".format( key_values[0], key_values[1]) daoDelegate = DAODelegateTest() dao = DatabasePersistence(trx, daoDelegate) # usamos la transacion para informar que el control es extrerno. if test == 'normal': ret = dao.delete_record(4) elif test == 'del_fk': ret = dao.delete_record(1) else: ret = dao.delete_record(('008', 7)) print(ret)