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__)
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
trx.end_transaction()
else:
class MainTableModel(Model):