def in_state(call):
with AdoptBranch() as bd:
sign = True
if not bd.execute(AdoptBranch.in_state(call)):
sign = False
print("SSS")
return sign
def in_country(call):
with AdoptBranch() as bd:
sign = True
if not bd.execute(AdoptBranch.in_country(call)):
sign = False
return sign
def update_status_product(file_name, sign):
with AdoptBranch() as bd:
bd.execute(AdoptBranch.update_status_product(file_name, sign))
def our_choice(city):
with AdoptBranch() as bd:
bd.execute(AdoptBranch.our_choice(city))
return bd.fetchall()
def city(state):
with AdoptBranch() as bd:
bd.execute(AdoptBranch.select_city(state))
return bd.fetchall()
def add_user(user_id):
with AdoptBranch() as cur:
cur.execute(AdoptBranch.add_user(user_id))
def add_pay(token, user_id, file_name, data_req, status):
with AdoptBranch() as bd:
bd.execute(
AdoptBranch.add_pay(token, user_id, file_name, data_req, status))
def in_city(call):
with AdoptBranch() as bd:
if not bd.execute(AdoptBranch.in_city(call)):
return 0
else:
return 1
def select_user_state(user_id):
with AdoptBranch() as bd:
bd.execute(AdoptBranch.select_user_state(user_id))
return bd.fetchone()[0]
def delete_payment(data_req, token):
with AdoptBranch() as bd:
bd.execute(AdoptBranch.delete_payment(data_req, token))
def change_user_state(user_id, state):
with AdoptBranch() as bd:
bd.execute(AdoptBranch.update_user_state(user_id, state))
def get_all():
with AdoptBranch() as bd:
bd.execute(AdoptBranch.get_all())
return bd.fetchall()
def get_zip(zip_code):
with AdoptBranch() as bd:
bd.execute(AdoptBranch.get_zip(zip_code))
return bd.fetchall()
def cmp_token(token):
with AdoptBranch() as bd:
bd.execute(AdoptBranch.cmp_token(token))
return bd.fetchall()
def get_login_pass(filename):
with AdoptBranch() as bd:
bd.execute(AdoptBranch.get_login_pass(filename))
return bd.fetchall()
def exist(call):
with AdoptBranch() as bd:
if len(bd.exist(call)) == 0:
return False
else:
return True
def get_token(user_id):
with AdoptBranch() as bd:
bd.execute(AdoptBranch.get_token(user_id))
return bd.fetchall()
def country():
with AdoptBranch() as bd:
bd.execute(AdoptBranch.select_country())
return bd.fetchall()
def autorisation(user_id):
with AdoptBranch() as bd:
if not bd.execute(AdoptBranch.select_user(user_id)):
return 0
return 1
def state(country):
with AdoptBranch() as bd:
bd.execute(AdoptBranch.select_state(country))
print("ASD)")
return bd.fetchall()
def add_payment(call):
with AdoptBranch() as bd:
bd.execute(AdoptBranch.in_zip(call))
def get_filename(val):
with AdoptBranch() as bd:
bd.execute(AdoptBranch.get_filename(val))
return bd.fetchone()[0]