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)