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)