def get(self): parser = reqparse.RequestParser() parser.add_argument("user-id", type=str, required=True, location='headers') args = parser.parse_args() args['user_id'] = args.pop('user-id') temp = db.get_all(table='userdata') for i in temp: if str(i['user_id']) == args['user_id']: userdata_id = str(i['userdata_id']) obj_userdata = [] results = db.get_by_id( table="zn_user_zone", field="userdata_id", value = userdata_id ) for i in results : data = { "id_user_zone" : str(i['id_user_zone']), "userdata_id" : str(i['userdata_id']), "id_zone" : str(i['id_zone']) } obj_userdata.append(data) return response(200, data = obj_userdata)
def get(self): command = utils.get_command(request.path) command = "dt_" + command try: results = model.get_all(command) obj_userdata = list() for i in results: data = { "id_vm": str(i['id_vm']), "id_company_product": str(i['id_company_product']), "spec_vcpu": i['spec_vcpu'], 'spec_clock': i['spec_clock'], "spec_ram": i['spec_ram'], "spec_os": i['spec_os'], "spec_storage_volume": i['spec_storage_volume'], 'spec_ssd_volume': i['spec_ssd_volume'], "spec_snapshot_volume": i['spec_snapshot_volume'], "spec_template_volume": i['spec_template_volume'], 'spec_iso_volume': i['spec_iso_volume'], "spec_public_ip": i['spec_public_ip'], "spec_backup_storage": i['spec_backup_storage'], 'spec_price': i['spec_price'], "spec_notes": i['spec_notes'], "date_time": i['date_time'] } obj_userdata.append(data) except Exception: results = None else: return response(200, data=obj_userdata)
def get(self): command = utils.get_command(request.path) command = "dt_" + command try: results = model.get_all(command) obj_userdata = list() for i in results: data = { "id_hosting": str(i['id_hosting']), "id_company_product": str(i['id_company_product']), 'spec_price': i['spec_price'], "spec_storage": i['spec_storage'], 'spec_database': i['spec_database'], "spec_free_domain": i['spec_free_domain'], "spec_hosting_domain": i['spec_hosting_domain'], 'spec_subdomain': i['spec_subdomain'], "spec_ftp_user": i['spec_ftp_user'], "spec_control_panel": i['spec_control_panel'], 'spec_email_account': i['spec_email_account'], "spec_spam_filter": i['spec_spam_filter'], "date_time": i['date_time'] } obj_userdata.append(data) except Exception: results = None else: return response(200, data=obj_userdata)
def post(self): parser = reqparse.RequestParser() parser.add_argument('id_zone', type=str, required=True) parser.add_argument("user-id", type=str, required=True, location='headers') args = parser.parse_args() args['user_id'] = args.pop('user-id') temp = db.get_all(table='userdata') for i in temp: if str(i['user_id']) == args['user_id']: userdata_id = str(i['userdata_id']) data_insert = { "id_zone" : args['id_zone'], "userdata_id" : userdata_id } try : result = db.insert(table='zn_user_zone', data=data_insert) except Exception as e: message = { "status" : False, "error" : str(e) } else: message = { "status" : True, "data" : data_insert, "id" : result } finally: return response(200, message=message)
def clean_users(): # removing users will remove everything # since all data linked into it users = model.get_all("user") for user in users: user_id = user["id"] model.delete(table="user", field="id", value=user_id)
def get(self): try: types = model.get_all("type") if not types: return response(404) return response(200, data=types) except Exception: return response(500)
def get(self): try: ttls = model.get_all("ttl") if not ttls: return response(404) return response(200, data=ttls) except Exception as e: return response(500, message=f"{e}")
def get(self): obj_userdata = list() results = db.get_all("userdata") data = { "userdata_id": "001", "email" : "*****@*****.**" } obj_userdata.append(data) return response(200, data=obj_userdata)
def get(self): try: users = model.get_all("user") if not users: return response(404) return response(200, data=users) except Exception as e: current_app.logger.error(f"{e}") return response(500)
def get(self): command = utils.get_command(request.path) command = "zn_" + command try: results = db.get_all(command) obj_userdata = list() for i in results: data = {"id_type": str(i['id_type']), "nm_type": i['nm_type']} obj_userdata.append(data) except Exception: results = None else: return response(200, data=obj_userdata)
def get(self): obj_userdata = list() results = db.get_all("tb_userdata") for i in results: data = { "id_userdata": str(i['id_userdata']), "first_name": i['first_name'], "last_name": i['last_name'], "location": i['location'], "email": i['email'], "created_at": str(i['created_at']) } obj_userdata.append(data) return response(200, data=obj_userdata)
def get(self): try: zones = model.get_all("zone") if not zones: return response(404) domains_detail = [] for zone in zones: detail = domain_model.get_other_data(zone) domains_detail.append(detail) return response(200, data=domains_detail) except Exception as e: current_app.logger.error(f"{e}") return response(500)
def get(self): try: records = model.get_all("record") if not records: return response(404) records_detail = [] for record in records: detail = record_model.get_other_data(record) records_detail.append(detail) return response(200, data=records_detail) except Exception as e: current_app.logger.error(f"{e}") return response(500)
def get(self): obj_userdata = list() try: results = db.get_all("userdata") except Exception: return response(200, message="Users Data Not Found") else: for i in results : data = { "userdata_id": str(i['userdata_id']), "user_id" : i['user_id'], "project_id" : i['project_id'], "created_at": str(i['created_at']) } obj_userdata.append(data) return response(200, data=obj_userdata)
def get(self): command = utils.get_command(request.path) command = "dt_" + command try: results = model.get_all(command) obj_userdata = list() for i in results: data = { "id_worker": str(i['id_worker']), "loc_schedule_config": i["loc_schedule_config"], "loc_config": i["loc_config"] } obj_userdata.append(data) except Exception: results = None else: return response(200, data=obj_userdata)
def get(self): command = utils.get_command(request.path) command = "dt_" + command try: results = model.get_all(command) obj_userdata = list() for i in results: data = { "id_product": str(i['id_product']), "nm_product": i["nm_product"], "nm_databaseref": i["nm_databaseref"] } obj_userdata.append(data) except Exception as e: results = None else: return response(200, data=obj_userdata)
def get(self): command = utils.get_command(request.path) command = "zn_" + command try: results = model.get_all(command) except Exception: results = None else: obj_userdata = list() for i in results: data = { "id_content": str(i['id_content']), "id_ttldata": str(i['id_ttldata']), "nm_content": str(i['nm_content']) } obj_userdata.append(data) return response(200, data=obj_userdata)
def get(self): command = utils.get_command(request.path) command = "dt_" + command try: results = model.get_all(command) obj_userdata = list() for i in results: data = { "id_company": str(i['id_company']), "nm_company": i['nm_company'], 'url_company': i['url_company'], "currency_used": i['currency_used'] } obj_userdata.append(data) except Exception as e: results = None else: return response(200, data=obj_userdata)
def get(self): command = utils.get_command(request.path) command = "dt_" + command try: results = model.get_all(command) obj_userdata = list() for i in results: data = { "id_company_product": str(i['id_company_product']), "id_company": str(i['id_company']), "id_product": str(i['id_product']), "id_worker": str(i['id_worker']), "nm_company_product": str(i['nm_company_product']) } obj_userdata.append(data) except Exception: results = None else: return response(200, data=obj_userdata)
def get(self): command = utils.get_command(request.path) command = "dt_" + command try: results = model.get_all(command) obj_userdata = list() for i in results: data = { "id_additional_features": str(i['id_additional_features']), "id_company_product": i['id_company_product'], 'spec_features': i['spec_features'], 'spec_features_value': i['spec_features_value'], "spec_features_price": i['spec_features_price'] } obj_userdata.append(data) except Exception: results = None else: return response(200, data=obj_userdata)