def insertar(self, obj=None):
stmt = BaseModel.get_query("tipo_dato_insert")
list_data = list(obj.__dict__.values())
list_data.pop(0)
insert_data = tuple(list_data)
obj.tipo_dato_id = self.execute_insert(stmt, insert_data)
def get_object(self, params):
query_str = BaseModel.get_query("tabla_get_object")
result_set = BaseModel.execute_query(query_str, params)
obj = DomainTabla()
if len(result_set) == 1:
for element_dict in result_set:
BaseModel.dict_to_object(obj, element_dict)
return obj
def insertar(self, obj=None):
stmt = BaseModel.get_query("proveedor_bd_insert")
"""now = datetime.datetime.now()
obj.fch_creacion = now
fch_creacion = str(now.strftime("%Y-%m-%d"))"""
insert_data = (
obj.nombre,
obj.icono
)
obj.proveedor_bd_id = self.execute_insert(stmt, insert_data)
def insertar(self, obj=None):
stmt = BaseModel.get_query("tabla_insert")
now = datetime.datetime.now()
#Convert to iso format to insert
#obj.fch_registro = str(now.strftime("%Y-%m-%d"))
obj.fch_creacion = now
fch_creacion = str(now.strftime("%Y-%m-%d"))
insert_data = (obj.nombre, obj.descripcion, fch_creacion, obj.dbms_id)
obj.tabla_id = self.execute_insert(stmt, insert_data)
def insertar(self, obj=None):
stmt = BaseModel.get_query("campo_insert")
now = datetime.datetime.now()
obj.fch_creacion = now
fch_creacion = str(now.strftime("%Y-%m-%d"))
insert_data = (obj.tabla_id, obj.nombre, obj.descripcion,
obj.flg_obligatorio, obj.flg_pk, fch_creacion,
obj.tipo_dato_id, obj.tipo_dato_data,
obj.tipo_dato_text, obj.tipo_dato_syntax)
obj.campo_id = self.execute_insert(stmt, insert_data)
def actualizar(self, obj=None):
stmt = BaseModel.get_query("tabla_actualizar")
self.execute_update(stmt, obj.__dict__)