Gecko [ tsuru-no-tsurugi.tokyo ]

Name	Size	Permission	Date
.vscode	[ DIR ]	drwxr-xr-x	2024-08-27 23:20
.well-known	[ DIR ]	drwxrwxr-x	2024-08-29 11:22
DirectEdit-master	[ DIR ]	drwxrwxr-x	2024-08-29 23:14
admin	[ DIR ]	drwxr-xr-x	2024-08-27 23:20
answer	[ DIR ]	drwxr-xr-x	2024-08-28 22:37
api	[ DIR ]	drwxrwxr-x	2025-04-07 13:23
article	[ DIR ]	drwxr-xr-x	2024-08-27 23:20
auth	[ DIR ]	drwxr-xr-x	2024-08-28 00:03
discord	[ DIR ]	drwxr-xr-x	2024-08-27 23:20
discord-bot	[ DIR ]	drwxr-xr-x	2024-08-27 23:20
example	[ DIR ]	drwxr-xr-x	2024-08-27 23:20
img	[ DIR ]	drwxr-xr-x	2024-08-27 23:20
judge	[ DIR ]	drwxr-xr-x	2024-08-27 23:20
problems	[ DIR ]	drwxr-xr-x	2024-08-27 23:20
programming_practice	[ DIR ]	drwxrwxrwx	2026-06-18 21:35
s2	[ DIR ]	drwxr-xr-x	2024-08-27 23:20
submit	[ DIR ]	drwxr-xr-x	2024-08-27 23:20
testimonial	[ DIR ]	drwxr-xr-x	2024-08-27 23:20
MathJax.js	62.04 KB	-rwxr-xr-x	2024-08-27 23:20
answer.html	4.06 KB	-rwxr-xr-x	2024-08-28 00:23
answer.php	4.47 KB	-rwxr-xr-x	2024-08-28 22:38
code.css	475 B	-rwxr-xr-x	2024-08-27 23:20
css.css	2.75 KB	-rwxr-xr-x	2024-08-27 23:20
database.py	4.16 KB	-rwxr-xr-x	2024-08-27 23:20
database2.py	731 B	-rwxr-xr-x	2024-08-27 23:20
default.html	3.3 KB	-rwxr-xr-x	2024-08-28 00:23
default.php	3.82 KB	-rwxr-xr-x	2024-08-28 00:23
detail.php	5.75 KB	-rwxr-xr-x	2024-08-28 00:23
detail2.php	5.79 KB	-rwxr-xr-x	2024-08-28 00:23
fuck.txt	488.29 KB	-rw-r--r--	2024-08-27 23:20
icon.jpg	285.53 KB	-rwxr-xr-x	2024-08-27 23:20
icon.png	285.53 KB	-rwxr-xr-x	2024-08-27 23:20
index.php	9.17 KB	-rwxr-xr-x	2024-08-28 00:22
index2.html	5.91 KB	-rwxr-xr-x	2024-08-28 00:23
judge.php	3.8 KB	-rwxr-xr-x	2024-08-28 00:23
judge.php.save	3.74 KB	-rwxr-xr-x	2024-08-28 00:23
judge.py	4.76 KB	-rwxr-xr-x	2024-08-27 23:20
output.html	1.16 KB	-rwxr-xr-x	2024-08-27 23:20
prism.css	6.22 KB	-rwxr-xr-x	2024-08-27 23:20
prism.js	49.16 KB	-rwxr-xr-x	2024-08-27 23:20
problems.html	4.56 KB	-rwxr-xr-x	2024-08-28 00:23
problems.php	5.6 KB	-rwxr-xr-x	2024-08-28 00:23
rank.php	3.93 KB	-rwxr-xr-x	2024-08-28 00:23
submit.html	4.35 KB	-rwxr-xr-x	2024-08-28 00:23
submit2.php	5.03 KB	-rwxr-xr-x	2024-08-27 23:20
t.php	3.22 KB	-rw-r--r--	2024-08-27 23:20
test-1.php	1.29 KB	-rwxr-xr-x	2024-08-29 23:28
test.php	171 B	-rwxr-xr-x	2024-08-28 00:19
test2.html	445 B	-rwxr-xr-x	2024-08-27 23:20
testimonial.php	4.34 KB	-rwxr-xr-x	2024-08-28 00:23
testimonial_gene.php	18.02 KB	-rwxr-xr-x	2024-08-29 23:28
typescript	2.09 KB	-rwxr-xr-x	2024-08-27 23:20

Rename

import mysql.connector
import datetime

start_time = datetime.datetime.strptime('2023-10-24 07:00:00', '%Y-%m-%d %H:%M:%S')
#print(start_time)

# DBへ接続
conn = mysql.connector.connect(
    user='akisai',
    password='manko',
    host='localhost',
    database='akisai_backup'
)

AC_database = [[False for i in range(10)] for j in range(2)]
AC_db = [False for i in range(10)]
AC_user =[['' for i in range(10)] for j in range(2)]
AC_usr = ['' for i in range(10)]
AC_time =[['' for i in range(10)] for j in range(2)]
AC_tm = ['' for i in range(10)]

# DBの接続確認
if not conn.is_connected():
    raise Exception("MySQLサーバへの接続に失敗しました")

cur = conn.cursor(dictionary=True)
query__for_fetching = "SELECT submittion_id,submittion_time,problem,language,user_name,judge_status FROM akisai_backup.submit;"
cur.execute(query__for_fetching)
#print(cur.fetchall())
for submit_info in cur.fetchall():
    problem_num = ord(submit_info['problem'])-ord('A')
    if submit_info['judge_status']=='AC' and AC_database[0 if submit_info['language']=='cpp' else 1][problem_num]==False:
        AC_database[0 if submit_info['language']=='cpp' else 1][problem_num]=True
        AC_user[0 if submit_info['language']=='cpp' else 1][problem_num] = submit_info['user_name']
        AC_time[0 if submit_info['language']=='cpp' else 1][problem_num] = submit_info['submittion_time'] - start_time

cur2=conn.cursor(dictionary=True)
        query__for_fetching = "SELECT first_AC_$language$ FROM akisai_backup.rank WHERE user_name = '$user_name$';".replace('$language$',submit_info['language']).replace('$user_name$',submit_info['user_name'])
        cur2.execute(query__for_fetching)
        first_AC_status = cur2.fetchall()[0]['first_AC_$language$'.replace('$language$',submit_info['language'])]
        first_AC_status = first_AC_status[:problem_num] + "o" + first_AC_status[problem_num+1:]
        query__for_fetching = "UPDATE akisai_backup.rank SET first_AC_$language$ = '$first_AC_status$' WHERE user_name = '$user_name$'".replace('$language$',submit_info['language']).replace('$first_AC_status$',first_AC_status).replace('$user_name$',submit_info['user_name'])
        cur3=conn.cursor()
        cur3.execute(query__for_fetching)
        conn.commit()
    if submit_info['judge_status']=='AC' and AC_db[problem_num]==False:
        AC_db[problem_num]=True
        AC_usr[problem_num]=submit_info['user_name']
        AC_tm[problem_num]=submit_info['submittion_time'] - start_time

cur4=conn.cursor(dictionary=True)
        query__for_fetching = "SELECT first_AC FROM akisai_backup.rank WHERE user_name = '$user_name$';".replace('$language$',submit_info['language']).replace('$user_name$',submit_info['user_name'])
        cur4.execute(query__for_fetching)
        first_AC_status = cur2.fetchall()[0]['first_AC_$language$'.replace('$language$',submit_info['language'])]
        first_AC_status = first_AC_status[:problem_num] + "o" + first_AC_status[problem_num+1:]
        query__for_fetching = "UPDATE akisai_backup.rank SET first_AC = '$first_AC_status$' WHERE user_name = '$user_name$'".replace('$language$',submit_info['language']).replace('$first_AC_status$',first_AC_status).replace('$user_name$',submit_info['user_name'])
        cur5=conn.cursor()
        cur5.execute(query__for_fetching)
        conn.commit()

for i in range(10):
    sql = "INSERT INTO akisai_backup.first_AC (user_name,submittion_time,problem) VALUES ('$user_name$','$submittion_time$','$problem$');".replace('$user_name$',AC_usr[i]).replace('$submittion_time$',str(AC_tm[i])).replace('$problem$',chr(65+i))
    sql_cpp = "INSERT INTO akisai_backup.first_AC_cpp (user_name,submittion_time,problem) VALUES ('$user_name$','$submittion_time$','$problem$');".replace('$user_name$',AC_user[0][i]).replace('$submittion_time$',str(AC_time[0][i])).replace('$problem$',chr(65+i))
    sql_python = "INSERT INTO akisai_backup.first_AC_python (user_name,submittion_time,problem) VALUES ('$user_name$','$submittion_time$','$problem$');".replace('$user_name$',AC_user[1][i]).replace('$submittion_time$',str(AC_time[1][i])).replace('$problem$',chr(65+i))

cur6=conn.cursor()
    cur6.execute(sql);cur6.execute(sql_cpp);cur6.execute(sql_python)
    conn.commit()