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)
