Spaces:
Sleeping
Sleeping
File size: 4,073 Bytes
1af2162 6421d95 642d630 1af2162 642d630 1af2162 642d630 6421d95 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 |
import sqlite3
from flask import request, jsonify
import globs
import os
api_variable = os.getenv('api_key_s')
def create_database_and_table():
# Создание подключения к базе данных SQLite
conn = sqlite3.connect('mydatabase.db')
cur = conn.cursor()
# Создание таблицы с автоинкрементным столбцом
cur.execute('''
CREATE TABLE IF NOT EXISTS my_table (
id INTEGER PRIMARY KEY AUTOINCREMENT,
column1 TEXT,
column2 TEXT,
column3 TEXT,
column4 TEXT,
column5 TEXT,
column6 TEXT,
column7 TEXT,
column8 TEXT,
column9 TEXT,
column10 TEXT
)
''')
# Применение изменений и закрытие соединения
conn.commit()
cur.close()
conn.close()
globs.eep_set = 0
globs.ph_set = "5.55"
globs.ph_on_set = "2.5"
globs.ec_set = "1.00"
globs.ec_A_set = "2.5"
globs.ec_B_set = "2.5"
globs.ec_C_set = "2.5"
globs.l_ON_h_set = "10"
globs.l_ON_m_set = "30"
globs.l_OFF_h_set = "22"
globs.l_OFF_m_set = "30"
globs.ec_t_Voz_set = "27"
def sql_save():
err = 0
# Проверяем условие и выполняем кусок кода, если условие истинно
if api_variable == request.args.get('api'):
# Вставьте сюда ваш кусок кода, который должен выполняться, если условие истинно
# Читаем значение параметра и заносим в глобальную переменную
globs.dey = request.args.get('dey')
globs.wek = request.args.get('wek')
globs.v_hid = request.args.get('v_hid')
globs.v_min = request.args.get('v_min')
globs.ph = request.args.get('ph')
globs.ec = request.args.get('ec')
globs.tS = request.args.get('tS')
globs.tA = request.args.get('tA')
globs.hDm = request.args.get('hDm')
globs.sVen = request.args.get('sVen')
globs.rFul = request.args.get('rFul')
globs.rLi = request.args.get('rLi')
globs.rWat = request.args.get('rWat')
globs.rRas = request.args.get('rRas')
globs.rPH = request.args.get('rPH')
globs.rEC = request.args.get('rEC')
globs.rSl = request.args.get('rSl')
globs.rLe = request.args.get('rLe')
globs.alW = request.args.get('alW')
globs.ph_eep = request.args.get('ph_eep')
globs.ph_on_eep = request.args.get('ph_on_eep')
globs.ec_eep = request.args.get('ec_eep')
globs.ec_A_eep = request.args.get('ec_A_eep')
globs.ec_B_eep = request.args.get('ec_B_eep')
globs.ec_C_eep = request.args.get('ec_C_eep')
globs.l_ON_h_eep = request.args.get('l_ON_h_eep')
globs.l_ON_m_eep = request.args.get('l_ON_m_eep')
globs.l_OFF_h_eep = request.args.get('l_OFF_h_eep')
globs.l_OFF_m_eep = request.args.get('l_OFF_m_eep')
globs.t_Voz_eep = request.args.get('t_Voz_eep')
err = 1
pass
else:
# Вставьте сюда ваш кусок кода, который должен выполняться, если условие ложно
err = 0
pass
# Создаем JSON-объект
response = {
"1_ph_set": globs.ph_set,
"2_ph_on_set": globs.ph_on_set,
"3_ec_set": globs.ec_set,
"4_ec_A_set": globs.ec_A_set,
"5_ec_B_set": globs.ec_B_set,
"6_ec_C_set": globs.ec_C_set,
"7_l_ON_h_set": globs.l_ON_h_set,
"7_l_ON_m_set": globs.l_ON_m_set,
"8_l_OFF_h_set": globs.l_OFF_h_set,
"8_l_OFF_m_set": globs.l_OFF_m_set,
"9_ec_t_Voz_set": globs.ec_t_Voz_set,
"eep_set": globs.eep_set,
"err": err
}
# Возвращаем JSON-объект
return jsonify(response)
|