def submitted_cases(submitted_by: str):
query = "select * from submitted_cases where submitted_by='{}'".format(
submitted_by)
with PostgresConnection() as conn:
cursor = conn.cursor()
cursor.execute(query)
return cursor.fetchall()
def authenticate_user(username, password, role):
query = "select * from users where username='******' and password='******'".format(username, password)
with PostgresConnection() as conn:
cursor = conn.cursor()
cursor.execute(query)
if cursor.rowcount == 1:
return True
return False
def get_training_data(submitted_by: str, status: str = None):
query = "select case_id, face_encoding from submitted_cases where submitted_by='{}'".format(
submitted_by)
if status:
query = query + "and status='NF'"
with PostgresConnection() as conn:
cursor = conn.cursor()
cursor.execute(query)
return cursor.fetchall()
def authenticate(username: str, password: str, role: Optional[str] = None):
result = False
query = "select * from users where username='******' and password='******'".format(
username, password)
with PostgresConnection() as conn:
cursor = conn.cursor()
cursor.execute(query)
if cursor.rowcount == 1:
result = True
return {"status": result}
def create():
with PostgresConnection() as conn:
cursor = conn.cursor()
table_queries = [
user_submission_table, submitted_cases_table, users_tables,
admin_user_query
]
for table_query in table_queries:
try:
cursor.execute(table_query)
except psycopg2.IntegrityError as e:
pass
def submit_user_data(user_submission):
name = user_submission.name
location = user_submission.location
mobile = user_submission.mobile
image = user_submission.image
face_encoding = user_submission.face_encoding
sub_id = user_submission.sub_id
status = 'NC'
query = f"insert into user_submissions(id, submitted_by, face_encoding,\
location, mobile, image, status) values('{sub_id}', '{name}', '{face_encoding}',\
'{location}', '{mobile}', '{image}', 'NR')"
with PostgresConnection() as conn:
cursor = conn.cursor()
cursor.execute(query)
def submit_case(user_info):
submitted_by = user_info.submitted_by
name = user_info.name
age = user_info.age
mobile = user_info.mobile
father_name = user_info.father_name
face_encoding = user_info.face_encoding
image = user_info.image
case_id = user_info.case_id
query = f"insert into submitted_cases(submitted_by, name, father_name, age,\
mobile, face_encoding, status, image, case_id) values('{submitted_by}', '{name}', '{father_name}',\
'{age}', '{mobile}', '{face_encoding}', 'NF', '{image}', '{case_id}')"
with PostgresConnection() as conn:
cursor = conn.cursor()
cursor.execute(query)
def save(self):
conn = PostgresConnection()
conn.update_game_data(self.new_rate)
pass
self.units[i].steps_to_create = unit.steps_to_create
self.seller[i] = player
self.time_exist[i] = 5
break
player.units.remove(unit)
# отправляет деньги владельцу юнита
# обнуляет все данные о юните, расположенном на i-той позиции
def send_money(self, cost, position):
self.seller[position].value[self.seller[position].id] += round(
cost * game.new_rate[self.seller[position].id])
self.seller[position] = None
# проверка на уже залежавшиеся юниты
# если таковые имеются, то они удаляются
def check(self):
for i in range(len(self.units)):
if self.time_exist[i] <= 0:
self.time_exist[i] = 1
self.units[i] = None
self.seller[i] = None
pg_conn = PostgresConnection()
mongo_conn = MongoConnection()
game = Game()
server = TcpServer()
server.run_()
def change_found_status(case_id: str):
query = f"update submitted_cases set status='F' where case_id={case_id}"
with PostgresConnection() as conn:
cursor = conn.cursor()
cursor.execute(query)
return {"status": "success"}
def get_confirmed_cases(submitted_by: str):
query = f"select * from submitted_cases where submitted_by='{submitted_by}' and status='F'"
with PostgresConnection() as conn:
cursor = conn.cursor()
cursor.execute(query)
return cursor.fetchall()
def user_details(case_id: str):
query = f"select location, submitted_at, image from user_submissions where id={case_id}"
with PostgresConnection() as conn:
cursor = conn.cursor()
cursor.execute(query)
return cursor.fetchall()
def case_details(case_id: str):
query = f"select name, father_name, image, mobile, age from submitted_cases where case_id={case_id}"
with PostgresConnection() as conn:
cursor = conn.cursor()
cursor.execute(query)
return cursor.fetchall()
def get_usr_submission():
query = f"select id, face_encoding from user_submissions"
with PostgresConnection() as conn:
cursor = conn.cursor()
cursor.execute(query)
return cursor.fetchall()