def insert_data(cls, dataJson):
query = LogsEnviame(
name = dataJson['name'],
status = dataJson['status'] if "status" in dataJson else 0,
payload = dataJson['payload'],
response = dataJson['response'] if "response" in dataJson else None
)
LogsEnviame.save(query)
if query.id:
return Utilities.get_structure(query)
return None
def insert_data(cls, dataJson):
query = Company(
identification=dataJson['identification'],
name=dataJson['name'],
address=dataJson['address'],
status=dataJson['status'] if "status" in dataJson else 1,
phone=dataJson['phone'] if "phone" in dataJson else None,
mail=dataJson['mail'] if "mail" in dataJson else None)
Company.save(query)
if query.id:
return Utilities.get_structure(query)
return None
def update_data(cls, _id, dataJson):
query = cls.query.filter_by(id=_id).first()
if query:
if 'name' in dataJson:
query.name = dataJson['name']
if 'status' in dataJson:
query.status = dataJson['status']
if 'payload' in dataJson:
query.payload = dataJson['payload']
if 'response' in dataJson:
query.response = dataJson['response']
db.session.commit()
if query.id:
return Utilities.get_structure(query)
return None
def update_data(cls, _id, dataJson):
query = cls.query.filter_by(id=_id).first()
if query:
if 'identification' in dataJson:
query.identification = dataJson['identification']
if 'name' in dataJson:
query.name = dataJson['name']
if 'address' in dataJson:
query.address = dataJson['address']
if 'status' in dataJson:
query.status = dataJson['status']
if 'phone' in dataJson:
query.phone = dataJson['phone']
if 'mail' in dataJson:
query.mail = dataJson['mail']
db.session.commit()
if query.id:
return Utilities.get_structure(query)
return None
def get_all(cls):
query = cls.query.all()
return Utilities.get_structure(query) if query is not None else None
def get_data(cls, _id):
query = cls.query.filter_by(id=_id).first()
return Utilities.get_structure(query) if query is not None else None
def get_data_by_identification(cls, _identification):
query = cls.query.filter_by(identification=_identification).first()
return Utilities.get_structure(query) if query is not None else None