def edit_addon_price():
connection = connect.connect_db()
cursor = connection.cursor()
data_from_api = flask.request.data.decode()
values = json.loads(data_from_api)
db.edit_addon_price(cursor, connection, values["price"], values["addon"])
connection.close()
return flask.jsonify(values["price"])
def delete_booking():
connection = connect.connect_db()
cursor = connection.cursor()
data_from_api = flask.request.data.decode()
values = json.loads(data_from_api)
db.delete_booking_and_unblock_hour(cursor, connection, values)
connection.close()
return "ok"
def get_note_for_service():
connection = connect.connect_db()
cursor = connection.cursor()
data_from_api = flask.request.data.decode()
values = json.loads(data_from_api)
note = db.get_note(cursor, connection, values["service"])
connection.close()
return flask.jsonify(note)
def get_service_price():
connection = connect.connect_db()
cursor = connection.cursor()
data_from_api = flask.request.data.decode()
values = json.loads(data_from_api)
price = db.get_service_price(cursor, connection, values["prices"])
connection.close()
return flask.jsonify(price)
def addons_title():
connection = connect.connect_db()
cursor = connection.cursor()
data_from_api = flask.request.data.decode()
values = json.loads(data_from_api)
addons = db.get_all_addons_by_service(cursor, connection, values['add'])
connection.close()
return flask.jsonify(addons)
def get_service_by_category():
connection = connect.connect_db()
cursor = connection.cursor()
data_from_api = flask.request.data.decode() # getting the body request
values = json.loads(data_from_api)
services = db.get_service_by_category(cursor, connection, values['title'])
connection.close()
return flask.jsonify(services)
def get_latest_history_date():
conn = connect_db()
cur = conn.cursor()
cur.execute('SELECT date FROM history WHERE id = 2330 ORDER BY date DESC LIMIT 1 ;')
latest_date = cur.fetchall()[0][0]
cur.close()
print(latest_date)
return latest_date
def add_new_service():
connection = connect.connect_db()
cursor = connection.cursor()
data_from_api = flask.request.data.decode() # getting the body request
values = json.loads(data_from_api)
db.add_new_service(cursor, connection, values)
connection.close()
return "ok"
def delete_city():
connection = connect.connect_db()
cursor = connection.cursor()
data_from_api = flask.request.data.decode()
values = json.loads(data_from_api)
db.delete_city(cursor, connection, values["city"])
connection.close()
return "ok"
def delete_addon():
connection = connect.connect_db()
cursor = connection.cursor()
data_from_api = flask.request.data.decode() # getting the body request
values = json.loads(data_from_api)
db.delete_addon(cursor, connection, values["addon_name"])
connection.close()
return "ok"
def get_disabled_dates_and_by_region():
connection = connect.connect_db()
cursor = connection.cursor()
data_from_api = flask.request.data.decode()
values = json.loads(data_from_api)
disabled_days = db.get_all_disabled_dates(cursor, connection,
values["city"])
connection.close()
return flask.jsonify(disabled_days)
def price_and_details():
connection = connect.connect_db()
cursor = connection.cursor()
data_from_api = flask.request.data.decode()
values = json.loads(data_from_api)
price, dits, images = db.get_service_price_and_description(
cursor, connection, values["service"])
connection.close()
return flask.jsonify(price, dits, images)
def get_description_for_service():
connection = connect.connect_db()
cursor = connection.cursor()
data_from_api = flask.request.data.decode()
values = json.loads(data_from_api)
description = db.get_description_for_service(cursor, connection,
values["service"])
connection.close()
return description
def send_feedback():
connection = connect.connect_db()
# cursor = connection.cursor()
data_from_api = flask.request.data.decode()
values = json.loads(data_from_api)
email.handle_feedback(values)
# db.delete_booking_only(cursor, connection, values["id"])
connection.close()
return 'ok'
def update_time():
connection = connect.connect_db()
cursor = connection.cursor()
data_from_api = flask.request.data.decode()
values = json.loads(data_from_api)
db.change_hours_for_day(cursor, connection, values["start"], values["end"],
values["interval"])
connection.close()
return "ok"
def edit_service_name():
connection = connect.connect_db()
cursor = connection.cursor()
data_from_api = flask.request.data.decode()
values = json.loads(data_from_api)
db.edit_service_name(cursor, connection, values["service"],
values["newName"])
connection.close()
return 'ok'
def block_hour():
connection = connect.connect_db()
cursor = connection.cursor()
data_from_api = flask.request.data.decode()
values = json.loads(data_from_api)
day = values["date"].split("T")
new_day = db.day_plus_one(day[0])
hours = db.block_hour(cursor, connection, new_day, values["hour"])
connection.close()
return flask.jsonify(hours)
def activate_date():
connection = connect.connect_db()
cursor = connection.cursor()
data_from_api = flask.request.data.decode()
values = json.loads(data_from_api)
day = values["date"].split("T")
new_day = db.day_plus_one(day[0])
db.delete_disabled_date(cursor, connection, new_day)
connection.close()
return "ok"
def Update_All_Analysis():
"""Update analysis info of all stocks"""
conn = connect_db()
cur = conn.cursor()
cur.execute('SELECT * FROM stock;')
stocks = cur.fetchall()
for stock in stocks:
Add_Analysis(conn, cur, stock[0])
cur.close()
print('Update all analysis success')
def get_stock_name(stock_id):
""" Get stock name """
conn = connect_db()
cur = conn.cursor()
cur.execute(f"select name from stock where id = {stock_id};")
data = cur.fetchall()
cur.close()
stock_name = str(data[0])
stock_name = stock_name[2:-3]
return stock_name
def add_main_image_to_service():
connection = connect.connect_db()
cursor = connection.cursor()
try:
data_from_api = flask.request.data.decode()
values = json.loads(data_from_api)
db.add_main_img_to_service(cursor, connection, values["service"],
values["image"])
connection.close()
return 'OK'
except Exception as e:
return e
def Update_All_Stock():
"""Update history info of all stocks"""
conn = connect_db()
cur = conn.cursor()
cur.execute('SELECT id FROM stock;')
stocks = cur.fetchall()
today = datetime.date.today()
tomorrow = today + datetime.timedelta(days = 1)
# three_years_ago = today - relativedelta(years = 3)
latest_date = get_latest_history_date() + datetime.timedelta(days = 1)
for stock in stocks:
Add_History(conn, cur, stock[0], latest_date.strftime('%Y%m%d'), tomorrow.strftime('%Y%m%d'))
cur.close()
print('Update all stock history success')
def get_stock_info(stock_id, start_date):
""" Get stock information """
conn = connect_db()
cur = conn.cursor()
cur.execute(
f"select * from history where id = {stock_id} and date >= '{start_date}' ;"
)
data = cur.fetchall()
cur.close()
stock_df = pd.DataFrame(data,
columns=[
'id', 'date', 'high', 'low', 'close', 'volume',
'open', 'change'
])
stock_df = stock_df.sort_values(by=['date'])
# stock_id = stock_df['id'].iloc[0]
return stock_df
def booking():
connection = connect.connect_db()
cursor = connection.cursor()
data_from_api = flask.request.data.decode() # get the body of the request
values = json.loads(
data_from_api) # convert to jason in order to get the fields
db.add_new_booking(cursor, connection, values)
new_day = db.day_plus_one(values["date"].split("T")[0])
values["day"] = db.findDay(values["date"]) + ": " + new_day
email.email_handle(
values) # email handler sends emails to customer and manager
values["date"] = db.handle_time(
cursor, connection, values["date"],
values["hour"]) # handle time changes the date
# service = sync.syncalendar_and_service()
event.create_event_and_insert(values) # create event in the calendar
connection.close()
return 'OK'
def Get_Cluster_Stocks():
"""Get cluster of different risk stocks, 5 stocks each risk cluster """
conn = connect_db()
cur = conn.cursor()
stocks = clustering(conn, cur)
# cur.close()
print(stocks)
for risk_list in stocks:
for idx, stock_id in enumerate(risk_list):
cur.execute(f"select name from stock where id = {stock_id};")
data = cur.fetchall()
stock_name = str(data[0])
stock_name = stock_name[2:-3]
# stock_name = get_stock_name(stock_id)
risk_list[idx] = stock_name + '(' + str(stock_id) + ')'
cur.close()
low_risk_list = stocks[0]
mid_risk_list = stocks[1]
high_risk_list = stocks[2]
return low_risk_list, mid_risk_list, high_risk_list
def get_customers_address():
connection = connect.connect_db()
cursor = connection.cursor()
address, details = db.get_customers_address(cursor, connection)
connection.close()
return flask.jsonify(address, details)
def get_all_addons():
connection = connect.connect_db()
cursor = connection.cursor()
addons = db.get_all_addons(cursor, connection)
connection.close()
return flask.jsonify(addons)
def get_all_categories():
connection = connect.connect_db()
cursor = connection.cursor()
categories = db.get_all_categories(cursor, connection)
connection.close()
return flask.jsonify(categories)
def get_past_customers():
connection = connect.connect_db()
cursor = connection.cursor()
customers = db.get_past_customers(cursor, connection)
connection.close()
return flask.jsonify(customers)
def get_time():
connection = connect.connect_db()
cursor = connection.cursor()
time = db.get_time_for_display(cursor, connection)
connection.close()
return flask.jsonify(time)
