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": "Ошибка запроса к базе данных" } }