def login(username, password):
connection = get_connection('default')
cursor = connection.cursor()
token = generate_token(username, password)
user_id = cursor.callfunc('login', cx_Oracle.NUMBER, [username, password, token])
cursor.close()
return user_id, token
def create_rent_contract(rent_contract_id, area_id, tenant_id, landlord_id, form_data):
data = [
rent_contract_id,
tenant_id,
landlord_id,
area_id,
form_data.get('code'),
form_data.get('start_date'),
form_data.get('end_date'),
form_data.get('price'),
form_data.get('additional_payment'),
form_data.get('discount'),
form_data.get('checking_account'),
form_data.get('requirements'),
]
connection = get_connection('landlords')
cursor = connection.cursor()
try:
cursor.callfunc('meow.create_or_update_contract', cx_Oracle.NUMBER, data)
cursor.close()
connection.commit()
return True
except cx_Oracle.DatabaseError as e:
print e
return False
def register_landlord(data):
fields = [
None,
None,
data.get('username', None),
data.get('password', None),
data.get('first_name', None),
data.get('middle_name', None),
data.get('last_name', None),
data.get('email', None),
data.get('phone', None),
data.get('organization_name', None),
data.get('description', None),
]
connection = get_connection('default')
cursor = connection.cursor()
try:
cursor.callfunc('create_or_update_landlord', cx_Oracle.NUMBER, fields)
cursor.close()
return True
except cx_Oracle.DatabaseError as e:
return False
finally:
connection.commit()
def get_shopping_malls():
connection = get_connection('default')
cursor = connection.cursor()
data = cursor.callfunc('get_shopping_malls', cx_Oracle.CURSOR, [])
data = [list(obj[:5]) + get_location(obj[5]) for obj in data]
print list(data)
cursor.close()
return list(data)
def get_rent_contract(landlord_id, contract_id):
connection = get_connection('landlords')
cursor = connection.cursor()
data = list(cursor.callfunc('meow.get_rent_contract', cx_Oracle.CURSOR, [landlord_id, contract_id]))
cursor.close()
if len(data) == 0:
return None
else:
return data[0]
def get_shopping_area(area_id):
connection = get_connection('default')
cursor = connection.cursor()
data = list(
cursor.callfunc('get_shopping_area', cx_Oracle.CURSOR, [area_id]))
if len(data) == 0:
return None
cursor.close()
return list(data)[0]
def create_rent_request(tenant_id, area_id, description=''):
connection = get_connection('tenants')
cursor = connection.cursor()
try:
cursor.callproc('meow.create_rent_request', [tenant_id, area_id, description])
cursor.close()
connection.commit()
return True
except cx_Oracle.DatabaseError:
return False
def get_shopping_mall(mall_id):
connection = get_connection('default')
cursor = connection.cursor()
data = list(
cursor.callfunc('get_shopping_mall', cx_Oracle.CURSOR, [mall_id]))
if len(data) == 0:
return None
data = list(data[0][:5]) + get_location(data[0][5])
cursor.close()
return data
def get_shopping_areas(mall_id):
connection = get_connection('default')
cursor = connection.cursor()
data = cursor.callfunc('get_shopping_areas', cx_Oracle.CURSOR, [mall_id])
data = [
list(obj[:4]) + [get_landlord(obj[4])] + [get_price(obj[5])]
for obj in data
]
cursor.close()
return list(data)
def _get_user_group_name(self):
token = self.request.COOKIES.get('token', None)
connection = get_connection('default')
cursor = connection.cursor()
group_id = cursor.callfunc('authenticate', cx_Oracle.NUMBER, [token])
print group_id
if group_id < 0:
group_name = None
else:
group_name = cursor.callfunc('get_group_name', cx_Oracle.STRING, [group_id])
cursor.close()
return group_name
def delete_shopping_mall(group_name, mall_id):
connection = get_connection(group_name)
if connection is None:
return False
cursor = connection.cursor()
try:
cursor.callproc('meow.delete_shopping_mall', [mall_id])
cursor.close()
connection.commit()
return True
except cx_Oracle.DatabaseError:
return False
def create_shopping_mall(group_name, mall_id, data):
data = [
mall_id,
data.get('location_id'),
data.get('name'),
data.get('description'),
data.get('floors_number'),
data.get('parking_size'),
]
connection = get_connection(group_name)
cursor = connection.cursor()
try:
cursor.callfunc('meow.create_or_update_shopping_mall',
cx_Oracle.NUMBER, data)
cursor.close()
connection.commit()
return True
except cx_Oracle.DatabaseError:
return False
def create_shopping_area(group_name, area_id, mall_id, data):
data = [
area_id,
data.get('landlord_id'),
mall_id,
data.get('price_id'),
data.get('area'),
data.get('description'),
]
connection = get_connection(group_name)
cursor = connection.cursor()
try:
cursor.callfunc('meow.create_or_update_shopping_area',
cx_Oracle.NUMBER, data)
cursor.close()
connection.commit()
return True
except cx_Oracle.DatabaseError as e:
return False
def logout(token):
connection = get_connection('default')
cursor = connection.cursor()
cursor.callproc('logout', [token])
cursor.close()
def get_tenant_rent_contracts(tenant_id):
connection = get_connection('tenants')
cursor = connection.cursor()
data = list(cursor.callfunc('meow.get_tenant_rent_contracts', cx_Oracle.CURSOR, [tenant_id]))
cursor.close()
return data
def get_price(price_id):
connection = get_connection('default')
cursor = connection.cursor()
data = cursor.callfunc('get_price', cx_Oracle.CURSOR, [price_id])
cursor.close()
return list(data)[0]
def get_landlord_rent_contracts(landlord_id):
connection = get_connection('landlords')
cursor = connection.cursor()
data = list(cursor.callfunc('meow.get_landlord_rent_contracts', cx_Oracle.CURSOR, [landlord_id]))
cursor.close()
return data
def get_location(location_id):
connection = get_connection('default')
cursor = connection.cursor()
data = cursor.callfunc('get_location', cx_Oracle.CURSOR, [location_id])
cursor.close()
return list(data)
def delete_rent_contract(landlord_id, contract_id):
connection = get_connection('landlords')
cursor = connection.cursor()
result = cursor.callfunc('meow.delete_rent_contract', cx_Oracle.NUMBER, [landlord_id, contract_id])
cursor.close()
return result
def get_landlords():
connection = get_connection('default')
cursor = connection.cursor()
data = cursor.callfunc('get_landlords', cx_Oracle.CURSOR, [])
cursor.close()
return list(data)
def delete_rent_request(tenant_id, area_id):
connection = get_connection('landlords')
cursor = connection.cursor()
result = cursor.callfunc('meow.delete_rent_request', cx_Oracle.NUMBER, [tenant_id, area_id])
cursor.close()
return result
def get_landlord_id(token):
connection = get_connection('default')
cursor = connection.cursor()
id = cursor.callfunc('get_landlord_id', cx_Oracle.NUMBER, [token])
cursor.close()
return id
def is_active_rent_contract(contract_id):
connection = get_connection('landlords')
cursor = connection.cursor()
result = cursor.callfunc('meow.is_active_rent_contract', cx_Oracle.BOOLEAN, [contract_id])
cursor.close()
return result
