index.py

import json
import sqlite3
from flask import Flask, request, make_response, render_template
from sendpuls_api import SendPulseApi

app = Flask(__name__)


def remove_space_and_CS(string):
    # Удаление пробелов
    string = ''.join(string.split(' '))
    # Перевод в нижний регистр
    string = string.casefold()
    return string


# подключение к базе данных
def dict_factory(cursor, row):
    d = {}
    for idx, col in enumerate(cursor.description):
        d[col[0]] = row[idx]
    return d


conn = sqlite3.connect('products.db')
conn.row_factory = dict_factory
cursor = conn.cursor()
cursor.execute('SELECT * FROM product')
all_product = cursor.fetchall()


# Инициализация обекта для взаимодействия с апи
pulse_api = SendPulseApi()


@app.route('/')
def index():
    return render_template('index.html')


@app.route('/giveResult', methods=['POST'])
def give_result():
    def clear_text(text_list): return text_list.replace(
        "\n", ' ').replace('\xa0', ' ').split(';')
    products_names = request.json['productsNames']
    products_list = []
    for product in all_product:
        if remove_space_and_CS(product['name']) in products_names:
            products_list.append(
                {
                    'name': product['name'],
                    'imgUrl': product['imgUrl'],
                    'description': clear_text(product['description']),
                    'howToUse': clear_text(product['howToUse']),
                    'moreLink': product['moreLink']
                }
            )
    product_dict_json = json.dumps({'products': products_list})

    response = make_response(product_dict_json, 200)
    response.headers['Access-Control-Allow-Origin'] = '*'
    return response


@app.route('/sendData', methods=['POST'])
def send_data():
    data = request.json
    status = pulse_api.send_form_data(data)

    print(status)
    if status['result']:
        response = make_response(json.dumps('ok'), 200)
    else:
        response = make_response(json.dumps(
            'Данные через апи не отправлены'), 500)
    response.headers['Access-Control-Allow-Origin'] = '*'
    return response


if __name__ == '__main__':
    app.run(debug=True, host='0.0.0.0')