def actor_fire(sql_data):
data = Sql.exec(file="api/sql/select_fire.sql", args=sql_data)
_list = []
g = 0
fire = 0
for i in range(len(data) - 1, len(data) - 6, -1):
fire += int(data[i]['count'])
count_fire = Sql.exec(file="api/sql/select_count_fire.sql", args=sql_data)
return {'count_fire': count_fire[0]['sum'], names.DATA: {'fire': fire}}
def select_fire(sql_data):
data = Sql.exec(file="api/sql/select_fire.sql", args=sql_data)
_dict = dict()
_list = []
for i in range(0, len(data), 3):
_list.append([i, data[i]['count']])
_dict[i] = data[i]['count']
count_fire = Sql.exec(file="api/sql/select_count_fire.sql", args=sql_data)
return {'count_fire': count_fire[0]['sum'], names.DATA: _list}
def selectUser(user_data):
try:
auth_data = Sql.exec(file="api/sql/select_user_auth.sql",
args=user_data)
except:
return {
names.ANSWER: errors.SQL_EXEC,
names.DATA: {
"error_info": "Ошибка запроса к базе данных"
}
}
auth = Sql.exec(file="api/sql/select_auth.sql", args=user_data)
return {names.ANSWER: errors.OK, names.DATA: auth[0]}
def fire(sql_data):
try:
sql_data['time_int'] = 1
datas = Sql.exec(file="api/sql/insert_fire.sql", args=sql_data)
except:
return {
names.ANSWER: errors.SQL_EXEC,
names.DATA: {
"error_info": "Ошибка запроса к базе данных"
}
}
data = Sql.exec(file="api/sql/update_fire.sql", args=sql_data)
all_count = Sql.exec(file="api/sql/select_count_fire.sql", args=sql_data)
data[0]['progress'] = (all_count[0]['sum'] * 100) / 1000
data[0]['allCount'] = all_count[0]['sum']
return {names.ANSWER: errors.OK, names.DATA: data[0]}
def insert_quest(user_data):
try:
auth_data = Sql.exec(file="api/sql/insert_quest.sql", args=user_data)
except:
return {
names.ANSWER: errors.SQL_EXEC,
names.DATA: {
"error_info": "Ошибка запроса к базе данных"
}
}
return {names.ANSWER: errors.OK, names.DATA: auth_data[0]}
def select_quest():
try:
auth_data = Sql.exec(query="select * from questions")
except:
return {
names.ANSWER: errors.SQL_EXEC,
names.DATA: {
"error_info": "Ошибка запроса к базе данных"
}
}
return {names.ANSWER: errors.OK, names.DATA: auth_data}
def get_time(data):
try:
auth_data = Sql.exec(file="api/sql/select_time.sql", args=data)
except:
return {
names.ANSWER: errors.SQL_EXEC,
names.DATA: {
"error_info": "Ошибка запроса к базе данных"
}
}
return {names.ANSWER: errors.OK, names.DATA: auth_data[0]}
def list_concerts():
try:
data = Sql.exec(file="api/sql/select_concerts.sql")
except:
return {
names.ANSWER: errors.SQL_EXEC,
names.DATA: {
"error_info": "Ошибка запроса к базе данных"
}
}
post_process_data(data)
return {names.ANSWER: errors.OK, names.DATA: data}
def fire():
sql_data = dict()
sql_data[names.ID_USER] = 1
sql_data[names.ID_CONCERT] = 1
try:
sql_data['time_int'] = Sql.exec(query="""
select
max(time) as time
, sum(time_int)
from fire
where id_concert = 1
group by to_char(time, 'HH:MI:SS')
order by time desc limit 1
""")[0]['sum'] - 1
if sql_data['time_int'] < 0:
sql_data['time_int'] = 0
datas = Sql.exec(
file="D:/artist_and_people/backend/api/sql/insert_fire.sql",
args=sql_data)
except:
print('alarm')
return
def insert_user(user_data):
try:
auth_data = Sql.exec(file="api/sql/inserst_auth.sql", args=user_data)
except:
return {
names.ANSWER: errors.SQL_EXEC,
names.DATA: {
"error_info": "Ошибка запроса к базе данных"
}
}
if auth_data is not None:
answer = auth(user_data)
return answer
else:
return {
names.ANSWER: errors.SQL_EXEC,
names.DATA: {
"error_info": "Ошибка запроса к базе данных"
}
}