创作灵感：Flask+Beeware制作局域网小学生认字游戏-优快云博客
里面的千纬数学app参考我博客里面的文章，可能后来有了比较大的改动，还有番茄时间。
一、主程序：
from functools import partial
import toga
from toga.style.pack import COLUMN, LEFT, RIGHT, ROW, Pack
import sqlite3
import random
from time import time,sleep
from pathlib import Path
import datetime
import shutil
import miniaudio
import threading
from threading import Timer
import requests
#导入必要的库
resources_folder = Path(__file__).joinpath("../resources/").resolve()
db_filepath = resources_folder.joinpath("qwsx.db")
db_filepath0 = resources_folder.joinpath("qwrznew.db")
#测试参数1为手机，0为电脑，2为boox平板
sjcs = 1
if sjcs == 1:
sj_file = '/data/data/com.qwsxvs.qwsxvs/qwsx.db'
if Path(sj_file).exists():
db_filepath = sj_file
else:
shutil.copy(db_filepath, sj_file)
db_filepath = sj_file
sj_file0 = '/data/data/com.qwsxvs.qwsxvs/qwrznew.db'
if Path(sj_file0).exists():
db_filepath0 = sj_file0
else:
shutil.copy(db_filepath0, sj_file0)
db_filepath0 = sj_file0
elif sjcs == 2:
db_filepath = '/storage/emulated/0/Pictures/qwsx.db'
db_filepath0 = '/storage/emulated/0/Pictures/qwrznew.db'
#服务器ip地址获取
fwqip = '' #服务器ip地址，下面是在原有数据库中setupme表中新建1列，用于储存服务器ip地址
conn = sqlite3.connect(db_filepath0, timeout=10, check_same_thread=False)
c = conn.cursor()
cursor = c.execute("SELECT fwqip FROM setupme;")
row = cursor.fetchone()
if row:
fwqip = row[0]
c.close()
conn.close()
#服务器ip地址获取结束
#判断是星期四，星期四就把数据库拷贝到pictures目录
today = datetime.datetime.today()
weekday = today.isoweekday()
if weekday == 4 and sjcs == 2:
current_date = datetime.date.today()
date_string = current_date.strftime("%Y%m%d") + 'sx.db'
mbdb_filepath = '/storage/emulated/0/Pictures/' + date_string
if Path(mbdb_filepath).exists():
pass
else:
shutil.copy(db_filepath, mbdb_filepath)
conn0 = sqlite3.connect(db_filepath0, timeout=10, check_same_thread=False)
c = conn0.cursor()
cursor = c.execute("SELECT count(*) FROM sqlite_master WHERE type='table' AND name='fq'")
row = cursor.fetchone()
have_fq = row[0]
if have_fq ==0:
c.execute('''CREATE TABLE fq (
fid INTEGER PRIMARY KEY AUTOINCREMENT,
fs INTEGER,
sj TEXT,
ts INTEGER,
cuo INTEGER,
ys INTEGER,
zt INTEGER,
nr TEXT);
''')
conn0.commit()
c.close()
conn0.close()
conn = sqlite3.connect(db_filepath, timeout=10, check_same_thread=False)
c = conn.cursor()
current_date = datetime.datetime.now()
formatted_date = current_date.strftime("%Y-%m-%d")
cursor = c.execute("SELECT count(*) FROM sqlite_master WHERE type='table' AND name='jfen'")
row = cursor.fetchone()
have_jfena = row[0]
if have_jfena == 0:
c.execute('''CREATE TABLE jfen (
jid INTEGER PRIMARY KEY AUTOINCREMENT,
rq TEXT,
jf INTEGER);
''')
conn.commit()
cursor = c.execute("SELECT count(*) FROM jfen WHERE rq='"+ formatted_date +"'")
row = cursor.fetchone()
if row[0] == 0:
query_sql = "INSERT INTO jfen (rq,jf) VALUES (?,?);"
c.execute(query_sql, (formatted_date,0,))
conn.commit()
c.close()
conn.close()
#建积分表，并插入一行今日积分
names = globals()
nd = 0
hd = 0 #回答为0为出题，回答为1为1位数答题，2为2位数答题，3为3位数答题,4为符号答题
dan = 101 #初始答案
dan1 = 0
dan2 = 0
dan3 = 0
tjcs = ''
maxidc = 0
stop = 0 #番茄时间为0表示能运行
fqqk=''
timec=0
arid=0
djms = 1 # 单机模式，默认为1，联网后为0
rid = 0 # rid为次数，一轮游戏为50次正确的计算
def is_number(s):
try:
float(s)
return True
except ValueError:
pass
try:
import unicodedata
unicodedata.numeric(s)
return True
except (TypeError, ValueError):
pass
return False
#判断是不是数字
def stopyy():
stream = miniaudio.stream_file(str(resources_folder.joinpath('4480.mp3')))
with miniaudio.PlaybackDevice() as device:
device.start(stream)
sleep(300)
def fq_qk():
if globals()['hd'] == 4 or globals()['tjcs'] =='':
conn = sqlite3.connect(db_filepath0, timeout=10, check_same_thread=False)
c = conn.cursor()
query_str = 'select fs,sj,ts,cuo,nr from fq where zt = 1 order by fid desc limit 0,28;'
cursor = c.execute(query_str)
rows = cursor.fetchall()
stext3 = ""
for row in rows:
sj0=datetime.datetime.strptime(row[1], "%Y-%m-%d %H:%M:%S")
sj=str(sj0.hour).zfill(2)+":"+str(sj0.minute).zfill(2)
if row[0]==1:
fs='无声'
elif row[0]==2:
fs='有声'
elif row[0]==3:
fs='听写'
elif row[0]==4:
fs='口算'
elif row[0]==5:
fs='成语'
elif row[0]==6:
fs='英语'
stext3 = stext3 + f'{sj} {row[4]}{fs}{row[2]}({row[3]})题\n'
c.close()
conn.close()
globals()['fqqk']=stext3
else:
stext3 = globals()['fqqk']
return stext3
def get_fqbsj(fs):
fsb = 0
conn = sqlite3.connect(db_filepath0, timeout=10, check_same_thread=False)
c = conn.cursor()
query_str = 'select fs,sj,zt from fq order by fid desc;'
cursor = c.execute(query_str,)
row = cursor.fetchone()
if row:
fqbsj = row[1]
fsb = row[0]
zt = row[2]
else:
dqsj = datetime.datetime.now() #当前时间
dqsjc = dqsj.strftime("%Y-%m-%d %H:%M:%S")
query_str = 'INSERT INTO fq (fs,sj,ts,cuo,ys,zt) VALUES (?,?,0,0,0,0);'
c.execute(query_str,(fs,dqsjc,))
conn.commit()
fqbsj = dqsjc
zt = 0
if fsb != fs:
query_str = 'INSERT INTO fq (fs,sj,ts,cuo,ys,zt) VALUES (?,?,0,0,0,0);'
c.execute(query_str,(fs,fqbsj,))
conn.commit()
zt = 0
c.close()
conn.close()
return fqbsj,zt
def get_newfqbsj(fs):
conn = sqlite3.connect(db_filepath0, timeout=10, check_same_thread=False)
c = conn.cursor()
dqsj = datetime.datetime.now() #当前时间
dqsjc = dqsj.strftime("%Y-%m-%d %H:%M:%S")
query_str = 'INSERT INTO fq (fs,sj,ts,cuo,ys,zt) VALUES (?,?,0,0,0,0);'
c.execute(query_str,(fs,dqsjc,))
conn.commit()
fqbsj = dqsjc
zt = 0
c.close()
conn.close()
return fqbsj,zt
def upt_fqbsj(fqbsj,fs,njt):
conn = sqlite3.connect(db_filepath0, timeout=10, check_same_thread=False)
c = conn.cursor()
query_sql = "update fq set zt = 1 ,nr = ? where fs = ? and sj = ?"
c.execute(query_sql, (njt,fs,fqbsj,))
conn.commit()
c.close()
conn.close()
def up_fqbsj(fqbsj,fs,ts,cuo):
conn = sqlite3.connect(db_filepath0, timeout=10, check_same_thread=False)
c = conn.cursor()
query_sql = "update fq set ts = ts + ?, cuo = cuo + ? where fs = ? and sj = ?"
c.execute(query_sql, (ts,cuo,fs,fqbsj,))
conn.commit()
c.close()
conn.close()
def u_jfen(jf):
if jf > 0 or (jf < 0 and globals()['cuo'] <= 1):
conn = sqlite3.connect(db_filepath, timeout=10, check_same_thread=False)
c = conn.cursor()
current_date = datetime.datetime.now()
formatted_date = current_date.strftime("%Y-%m-%d")
cursor = c.execute("SELECT count(*) FROM jfen WHERE rq='"+ formatted_date +"'")
row = cursor.fetchone()
if row[0] ==0:
query_sql = "INSERT INTO jfen (rq,jf) VALUES (?,?);"
c.execute(query_sql, (formatted_date,0,))
conn.commit()
query_sql = "update jfen set jf = jf + ? where rq= ?"
c.execute(query_sql, (jf,formatted_date,))
conn.commit()
else:
query_sql = "update jfen set jf = jf + ? where rq= ?"
c.execute(query_sql, (jf,formatted_date,))
conn.commit()
c.close()
conn.close()
#更新积分，增加积分，中间再次判断今日的数据行是否存在是为了跨日做题不出错
def bfnum(number):
conn = sqlite3.connect(db_filepath, timeout=10, check_same_thread=False)
c = conn.cursor()
cursor = c.execute("SELECT sc from voice where number = ?;",(number,))
row = cursor.fetchone()
sc = row[0]
c.close()
conn.close()
stream = miniaudio.stream_file(str(resources_folder.joinpath(str(number) + '.wav')))
with miniaudio.PlaybackDevice() as device:
device.start(stream)
sleep(sc)
def bffh(fh):
if fh == '+':
stream = miniaudio.stream_file(str(resources_folder.joinpath('jia.wav')))
with miniaudio.PlaybackDevice() as device:
device.start(stream)
sleep(0.92)
if fh == '-':
stream = miniaudio.stream_file(str(resources_folder.joinpath('jian.wav')))
with miniaudio.PlaybackDevice() as device:
device.start(stream)
sleep(0.948)
if fh == '*':
stream = miniaudio.stream_file(str(resources_folder.joinpath('sheng.wav')))
with miniaudio.PlaybackDevice() as device:
device.start(stream)
sleep(0.975)
if fh == '/':
stream = miniaudio.stream_file(str(resources_folder.joinpath('chu.wav')))
with miniaudio.PlaybackDevice() as device:
device.start(stream)
sleep(0.975)
if fh == '□':
stream = miniaudio.stream_file(str(resources_folder.joinpath('duo.wav')))
with miniaudio.PlaybackDevice() as device:
device.start(stream)
sleep(1.066)
if fh == '=':
stream = miniaudio.stream_file(str(resources_folder.joinpath('deng.wav')))
with miniaudio.PlaybackDevice() as device:
device.start(stream)
sleep(0.975)
if fh == 'fh':
stream = miniaudio.stream_file(str(resources_folder.joinpath('tian.wav')))
with miniaudio.PlaybackDevice() as device:
device.start(stream)
sleep(0.975)
def bfsz(t1,tfh1,t2,tfh2,tdan):
if is_number(t1):
pnum(t1)
sleep(0.65)
elif t1 == '□':
pfh('□')
sleep(0.6)
pfh(tfh1)
sleep(0.6)
if is_number(t2):
pnum(t2)
sleep(0.65)
elif t2 == '□':
pfh('□')
sleep(0.6)
pfh(tfh2)
sleep(0.5)
if is_number(tdan):
pnum(tdan)
sleep(0.5)
elif tdan == '□':
pfh('□')
sleep(0.5)
#上面用sleep调节播放数字和运算符号的速度，可以再修改
def settm(nd):
conn = sqlite3.connect(db_filepath, timeout=10, check_same_thread=False)
c = conn.cursor()
if nd == 1:
cursor = c.execute("SELECT count(tid) from ys where (fh = 0 or fh = 1) and cuo < 50;")
row = cursor.fetchone()
if row[0] > 50:
maxid = row[0]
else:
maxid = 50
globals()['maxidc'] = maxid
rant = random.randint(0, maxid)
cursor = c.execute(f"SELECT * from ys where fh = 0 or fh = 1 ORDER BY cuo ASC LIMIT {rant},1;")
row = cursor.fetchone()
tid = row[0]
s1 = row[1]
jj = row[2]
s2 = row[3]
dan = row[4]
elif nd == 2:
#按数据库乘法除法只有600题，加减法各5151题，如果随机经常是加减法，按25%概率强制出现乘法除法题
if random.randint(0,3) == 3:
cursor = c.execute("SELECT count(tid) from ys where (fh = 2 or fh = 3) and cuo < 50;")
row = cursor.fetchone()
if row[0] > 50:
maxid = row[0]
else:
maxid = 50
globals()['maxidc'] = maxid
rant = random.randint(0, maxid)
cursor = c.execute(f"SELECT * from ys where fh = 2 or fh = 3 ORDER BY cuo ASC LIMIT {rant},1;")
else:
cursor = c.execute("SELECT count(tid) from ys where cuo < 50;")
row = cursor.fetchone()
if row[0] > 50:
maxid = row[0]
else:
maxid = 50
globals()['maxidc'] = maxid
rant = random.randint(0, maxid)
cursor = c.execute(f"SELECT * from ys ORDER BY cuo ASC LIMIT {rant},1;")
row = cursor.fetchone()
tid = row[0]
s1 = row[1]
jj = row[2]
s2 = row[3]
dan = row[4]
elif nd == 3:
#按数据库乘法除法只有600题，加减法各5151题，如果随机经常是加减法，按25%概率强制出现乘法题
if random.randint(0,3) == 3:
cursor = c.execute("SELECT count(tid) from ys where fh = 2 and cuo < 50;")
row = cursor.fetchone()
if row[0] > 50:
maxid = row[0]
else:
maxid = 50
globals()['maxidc'] = maxid
rant = random.randint(0, maxid)
cursor = c.execute(f"SELECT * from ys where fh = 2 ORDER BY cuo ASC LIMIT {rant},1;")
else:
cursor = c.execute("SELECT count(tid) from ys where fh < 3 and cuo < 50;")
row = cursor.fetchone()
if row[0] > 50:
maxid = row[0]
else:
maxid = 50
globals()['maxidc'] = maxid
rant = random.randint(0, maxid)
cursor = c.execute(f"SELECT * from ys where fh < 3 ORDER BY cuo ASC LIMIT {rant},1;")
row = cursor.fetchone()
tid = row[0]
s1 = row[1]
jj = row[2]
s2 = row[3]
dan = row[4]
c.close()
conn.close()
# print(maxid)
if jj == 0:
#为加法
cvalue = str(s1) + "+" + str(s2) + "="
hd = 1
ii = random.randint(0,4) #0为提交答案
if ii == 2:
cvalue = "□+" + str(s2) + "=" + str(dan) + ",□为"
plays('□','+',s2,'=',dan)
dan = s1
elif ii == 3:
cvalue = str(s1) + "+□=" + str(dan) + ",□为"
plays(s1,'+','□','=',dan)
dan = s2
elif ii ==4 and s2 > 0:#a+0=a,a-0=a,可以是+-
cvalue = str(s1) + "□" + str(s2) + "=" + str(dan) + ",□为"
pfh('fh')
dan = jj
hd = 4 #hd4为符号
else:
plays(s1,'+',s2,'=','□')
elif jj ==1:
cvalue = str(s1) + "-" + str(s2) + "="
hd = 1
ii = random.randint(0,4) #0为提交答案
if ii == 2:
cvalue = "□-" + str(s2) + "=" + str(dan) + ",□为"
plays('□','-',s2,'=',dan)
dan = s1
elif ii == 3:
cvalue = str(s1) + "-□=" + str(dan) + ",□为"
plays(s1,'-','□','=',dan)
dan = s2
elif ii ==4 and s2 > 0:#a+0=a,a-0=a,可以是+-
cvalue = str(s1) + "□" + str(s2) + "=" + str(dan) + ",□为"
pfh('fh')
dan = jj
hd = 4 #hd4为符号
else:
plays(s1,'-',s2,'=','□')
elif jj ==2:
#乘法
cvalue = str(s1) + "×" + str(s2) + "="
hd = 1
ii = random.randint(0,4) #0为提交答案
if ii == 2 and s2 !=0:#a*0=0 上次程序这个没有限制s2不等于0，bug！
cvalue = "□×" + str(s2) + "=" + str(dan) + ",□为"
plays('□','*',s2,'=',dan)
dan = s1
elif ii == 3 and s1 != 0:#a*0=0,b*0=0
cvalue = str(s1) + "×□=" + str(dan) + ",□为"
plays(s1,'*','□','=',dan)
dan = s2
elif ii ==4 and s2 !=1 and s1 != 0:#a*1=a,a/1=a;0*a=0,0/a=0
cvalue = str(s1) + "□" + str(s2) + "=" + str(dan) + ",□为"
pfh('fh')
dan = jj
hd = 4 #hd4为符号
else:
plays(s1,'*',s2,'=','□')
elif jj ==3:
cvalue = str(s1) + "÷" + str(s2) + "="
hd = 1
ii = random.randint(0,4) #0为提交答案
if ii == 2:
cvalue = "□÷" + str(s2) + "=" + str(dan) + ",□为"
plays('□','/',s2,'=',dan)
dan = s1
elif ii == 3 and s1 > 0:#0/a=0
cvalue = str(s1) + "÷□=" + str(dan) + ",□为"
plays(s1,'/','□','=',dan)
dan = s2
elif ii ==4 and s2 !=1 and s1 !=0:#a*1=a,a/1=a;0*a=0,0/a=0
cvalue = str(s1) + "□" + str(s2) + "=" + str(dan) + ",□为"
pfh('fh')
dan = jj
hd = 4 #hd4为符号
else:
plays(s1,'/',s2,'=','□')
current_date = datetime.datetime.now()
formatted_date = current_date.strftime("%Y-%m-%d")
formatted_time = current_date.strftime("%H:%M:%S")
conn = sqlite3.connect(db_filepath, timeout=10, check_same_thread=False)
c = conn.cursor()
c.execute("INSERT INTO record (rq,sj,tid,cuo,yt) VALUES (?,?,?,?,?);", (formatted_date,formatted_time,0,0,0))
conn.commit()
cursor = c.execute("SELECT cid from record order by cid desc")
row = cursor.fetchone()
cid = row[0]
c.close()
conn.close()
return(jj,dan,hd,cid,tid,cvalue)
#设置题目，并生成记录，用于记录错误，答题用时
def u_record(yt,cid,tid):
if yt > 0 and cid > 0 and tid >0:
cuoyt = 20000 - yt #20秒减去做题时间，如果做题时间大于20秒，即为负，负数变为0
if cuoyt < 0:
cuoyt = 0
conn = sqlite3.connect(db_filepath, timeout=10, check_same_thread=False)
c = conn.cursor()
cursor = c.execute("SELECT cuo from ys WHERE tid = ?;", (tid,))
row = cursor.fetchone()
cuo0 = row[0] #获取原做题速度，如做题5秒，那么原错为15秒，按最快做题速度更新
if cuo0 >= cuoyt:
pass
else:
c.execute("UPDATE ys SET cuo = ? WHERE tid = ?;", (cuoyt,tid,))
conn.commit()
c.execute("UPDATE record SET tid = ?, yt = ? WHERE cid = ?;", (tid,yt,cid))
conn.commit()
c.execute("UPDATE ys SET cs = cs + 1 WHERE tid = ?;", (tid,))
conn.commit()
c.close()
conn.close()
#记录答题用时，题目答对次数
def jf_ytime(ytime):
if ytime < 1000:
jfen = 10
elif ytime >=1000 and ytime <2000:
jfen = 9
elif ytime >=2000 and ytime <3000:
jfen = 8
elif ytime >=3000 and ytime <4000:
jfen = 7
elif ytime >=4000 and ytime <5000:
jfen = 6
elif ytime >=5000 and ytime <6000:
jfen = 4
elif ytime >=6000 and ytime <7000:
jfen = 3
elif ytime >=7000 and ytime <8000:
jfen = 2
elif ytime >=8000 and ytime <20000:
jfen = 1
else:
jfen = 0
return(jfen)
#用时转化为积分的表，大于20秒不给积分，反应越快积分越高
def u_cuo(cid,tid):
if cid > 0 and tid > 0 and globals()['cuo'] <= 1:
conn = sqlite3.connect(db_filepath, timeout=10, check_same_thread=False)
c = conn.cursor()
c.execute("UPDATE record SET cuo = cuo + 1 WHERE cid = ?;", (cid,))
conn.commit()
# c.execute("UPDATE ys SET cuo = cuo + 1 WHERE tid = ?;", (tid,))
# conn.commit()
# ys表的cuo用于记录用时，在这里不再更新
c.execute("UPDATE ys SET cuo = 0 WHERE tid = ?;", (tid,))
conn.commit()
# ys表的cuo用于记录用时，出现错误，就把用时清理为0
c.close()
conn.close()
#记录错误记录
def tj_cs():
if globals()['hd'] == 4 or globals()['tjcs'] =='':
conn = sqlite3.connect(db_filepath, timeout=10, check_same_thread=False)
c = conn.cursor()
cursor = c.execute("SELECT sum(jf) from jfen")
row = cursor.fetchone()
zjf = row[0]
current_date = datetime.datetime.now()
formatted_date = current_date.strftime("%Y-%m-%d")
cursor = c.execute("SELECT jf from jfen where rq = '" + formatted_date + "' limit 0,1")
row = cursor.fetchone()
if row:
jtjf = row[0]
else:
jtjf = 0
stext3 = "总积分：%d，今日积分：%d \n" % (zjf,jtjf)
query_str = 'select rq,count(cid),sum(cuo),round(avg(yt),0),sum(yt) from record where yt > 0 and yt < 240000 group by rq order by rq desc limit 0,3;'
cursor = c.execute(query_str)
rows = cursor.fetchall()
for row in rows:
stext3 += "%s:做%d题,错%d次,平均用%d毫秒,学习%d分钟\n" % (row[0],row[1],row[2],row[3],int(row[4]/60000))
c.close()
conn.close()
globals()['tjcs'] = stext3
stext4 = stext3 + "(已更新)"
else:
stext3 = globals()['tjcs']
stext4 = stext3 + "(待更新)"
return(stext4)
#显示做题记录
globals()['syt'] = 0
globals()['stopyyt'] = 0
def build(app):
# 定义组件
c_box0 = toga.Box()
c_box = toga.Box()
b1_box = toga.Box()
b2_box = toga.Box()
b3_box = toga.Box()
b4_box = toga.Box()
box = toga.Box()
abox = toga.Box()
bigbox = toga.Box()
c_input0 = toga.TextInput(style=Pack(font_size=14),value=fwqip)
c_input = toga.TextInput(readonly=True,style=Pack(font_size=22))
c_label = toga.Label("请选择难、中、易开始学习...", style=Pack(text_align=LEFT))
c_labela = toga.Label("", style=Pack(text_align=LEFT, font_size=9))
c_label1 = toga.Label("", style=Pack(text_align=LEFT, font_size=12))
c_label2 = toga.Label("", style=Pack(text_align=LEFT))
c_label3 = toga.Label("", style=Pack(text_align=LEFT))
#界面设置
#联网设置
def submit_button_pressed(widget):
# 获取输入框的值，如果值跟数据库里面的ip相同不操作，否则更新到数据库
global fwqip,djms
global cid,yshen,testcs,cou_cs,stime,begintime,rid,cout,njt,nd
if fwqip != c_input0.value:
conn = sqlite3.connect(db_filepath0, timeout=10, check_same_thread=False)
c = conn.cursor()
fwqip = c_input0.value
c.execute(f"UPDATE setupme SET fwqip = '{fwqip}';")
conn.commit()
c.close()
conn.close()
fwqip = c_input0.value
#另外一个功能，发送zt=-1到服务器，将zt更新为0，以结束游戏，重新可以在建
try:
response = requests.get(f'http://{fwqip}:5000/vsdata')
response.raise_for_status() # 检查请求是否成功
data = response.json()
message = data.get('message')
c_input.value = message
params = {
'zt': -1,
}
response = requests.get(f'http://{fwqip}:5000/sxdatas', params=params)
if response.status_code == 200:
# 处理成功的响应
data = response.json()
message = data.get('message')
c_input.value = message
globals()['rid'] = 0
globals()['nd'] = 0
globals()['arid'] = 0
globals()['hd'] = 0
globals()['djms'] = 1
aaa = '7 8 9 + 4 5 6 - 1 2 3 × 中 易 难 ÷'.split()
for i in range(1,17):
setattr(names['button_' + str(i)],"text",aaa[i-1])
setattr(names['button_' + str(i)],"on_press",partial(bt1,aaa[i-1]))
# 打开难易按钮
setattr(names['button_14'],"enabled",True)
setattr(names['button_15'],"enabled",True)
submit_button.text = '连接或重新开始'
else:
# 处理错误的响应
print(f"Failed to fetch data0: {response.status_code}")
except requests.RequestException as e:
print(f'Error: {e}')
submit_button = toga.Button('连接或重新开始', on_press=submit_button_pressed)
#按键反应
def bt1(bb, widget):
#选择难易，然后出题，答题，再出题
#获取3种状态
global djms,arid,hd
fs=4
fqbsj,zt = get_fqbsj(fs) #获取这个fs下的番茄时间
fqbsj0 = datetime.datetime.strptime(fqbsj, "%Y-%m-%d %H:%M:%S")
dqsj = datetime.datetime.now() #当前时间
globals()['timec'] = (dqsj - fqbsj0).total_seconds()
# print(globals()['timec'])
if globals()['timec'] >= 1800:
fqbsj,zt=get_newfqbsj(fs) #时间超过30分钟，插入新的番茄时间
globals()['stop'] = 0
globals()['stopyyt'] = 1500
names['ts_' + str(globals()['syt'])] = Timer(1500, stopyy)#25分钟后播放音乐，提示休息
names['ts_' + str(globals()['syt'])].setDaemon(True)
names['ts_' + str(globals()['syt'])].start()
elif globals()['timec'] < 1800 and globals()['timec'] >=1500:
#休息时间
globals()['stop'] = 1
else:
#工作时间
if 'ts_' + str(globals()['syt']) in names and int(globals()['stopyyt']-(1500-globals()['timec'])) > 60 and globals()['stopyyt'] > 60:
names['ts_' + str(globals()['syt'])].cancel()
globals()['syt'] = globals()['syt'] + 1
names['ts_' + str(globals()['syt'])] = Timer(int(1500-globals()['timec']), stopyy)#X分钟后播放音乐，提示休息
names['ts_' + str(globals()['syt'])].setDaemon(True)
names['ts_' + str(globals()['syt'])].start()
globals()['stopyyt'] = int(1500-globals()['timec'])
if 'ts_' + str(globals()['syt']) not in names:
names['ts_' + str(globals()['syt'])] = Timer(int(1500-globals()['timec']), stopyy)#25分钟后播放音乐，提示休息
names['ts_' + str(globals()['syt'])].setDaemon(True)
names['ts_' + str(globals()['syt'])].start()
globals()['stopyyt'] = int(1500-globals()['timec'])
globals()['stop'] = 0
# print(globals()['stopyyt'],globals()['syt'])
#*******番茄时间到*******
if globals()['stop'] == 1:
c_input.value = '休息！' + c_input.value
c_label.text=c_label.text+'\n'+'休息5分钟时间到\n等音乐结束即5分钟后可以继续或换其他学习'
# for i in range(1,17):
# setattr(names['button_' + str(i)],"enabled",False)
# sleep(1)
# for i in range(1,17):
# setattr(names['button_' + str(i)],"enabled",True)
#*******番茄时间到*******
#******************************番茄时间控制程序段**************************************
c_label3.text = tj_cs()
if nd == 0:
setattr(names['button_13'],"text",'中')
setattr(names['button_13'],"on_press",partial(bt1,'中'))
#点击难、中、易是开始游戏，这时nd必大于0
if bb == '难':
globals()['nd'] = 2
elif bb == '易':
globals()['nd'] = 1
elif bb == '中':
globals()['nd'] = 3
if bb in ('难','中','易'):
setattr(names['button_13'],"text",'0')
setattr(names['button_13'],"on_press",partial(bt1,'0'))
# 点击一次按钮，可以进行5次连接
linki = 0
while linki < 5:
bssj = ''
aip = ''
params = {
'rid': 0,
'xzng': globals()['nd'],
}
response = requests.get(f'http://{fwqip}:5000/sxdatas', params=params)
# 检查响应状态码
if response.status_code == 200:
data = response.json()
bssj = data.get('bssj')
aip = data.get('aip')
now = datetime.datetime.now()
sj = now.strftime("%Y-%m-%d %H:%M:%S")
if bssj and aip:
#比赛需要有比赛时间，对方ip
miaocha = (datetime.datetime.strptime(bssj, "%Y-%m-%d %H:%M:%S") - datetime.datetime.strptime(sj, "%Y-%m-%d %H:%M:%S")).total_seconds()
# print(miaocha)
#如果秒差在6秒内，那么中断秒差时间，确保能够同时比赛
if miaocha > 0 and miaocha <= 6:
sleep(miaocha)
globals()['djms'] = 0
hd = 0
# 锁住难易按钮
setattr(names['button_14'],"enabled",False)
setattr(names['button_15'],"enabled",False)
#连接成功，上面这个按钮会写成功
submit_button.text = '成功联网|重启'
linki = 5
else:
#秒差不对，要求结束这个在建
params = {
'zt': 0,
'xzng': nd,
}
response = requests.get(f'http://{fwqip}:5000/sxdatas', params=params)
if response.status_code == 200:
# 处理成功的响应
data = response.json()
message = data.get('message')
c_input.value = message
else:
# 处理错误的响应
print(f"Failed to fetch data0: {response.status_code}")
else:
pass
else:
# 处理错误的响应
print(f"Failed to fetch data2: {response.status_code}")
print(linki,djms)
linki = linki + 1
sleep(0.75) #间隔0.5秒
#进行第二次连接，直至linki=5
if globals()['maxidc'] > 0:
if globals()['nd'] == 2:
c_label.text = '100以内加减乘除，共' + str(globals()['maxidc']) + '题。'
elif globals()['nd'] == 1:
c_label.text = '100以内加减，共' + str(globals()['maxidc']) + '题。'
elif globals()['nd'] == 3:
c_label.text = '100以内加减乘，共' + str(globals()['maxidc']) + '题。'
else:
conn = sqlite3.connect(db_filepath, timeout=10, check_same_thread=False)
c = conn.cursor()
cursor = c.execute('select avg(cuo) from ys where cuo > 100;')
row = cursor.fetchone()
avgsd = 20000 - int(row[0])
c.close()
conn.close()
c_label.text = f'之前累计练习的平均速度为每题{avgsd}毫秒，加油！'
print(nd,f'hd={hd}')
if nd >= 1 and hd == 0:
globals()['jj'],globals()['dan'],globals()['hd'],globals()['cid'],globals()['tid'],cvalue=settm(nd)
c_input.value = cvalue
globals()['cuo'] = 0
globals()['begintime'] = time()
if bb in '+-×÷' and hd == 4:
ytime = int((time() - begintime) * 1000)
if bb == '+' and jj == 0:
jf = jf_ytime(ytime)
c_label1.text = '你答对了' + ',本题取得' + str(jf) + '积分'
globals()['rid'] += 1
u_record(ytime,cid,tid)
u_jfen(jf)
#*******番茄时间对*******
if globals()['stop'] != 1:
if zt == 0:
upt_fqbsj(fqbsj,fs,'数学')#更新状态t和学习内容,有回答正确的题才更新状态
up_fqbsj(fqbsj,fs,1,0)#更新番茄表，1为题数，0为答错题数
#*******番茄时间对*******
c_input.value = c_input.value + bb
c_label2.text = '复习：' + c_input.value
globals()['jj'],globals()['dan'],globals()['hd'],globals()['cid'],globals()['tid'],cvalue=settm(nd)
bb = ''
globals()['cuo'] = 0
c_input.value = cvalue
globals()['begintime'] = time()
elif bb == '-' and jj == 1:
jf = jf_ytime(ytime)
c_label1.text = '你答对了' + ',本题取得' + str(jf) + '积分'
globals()['rid'] += 1
u_record(ytime,cid,tid)
u_jfen(jf)
#*******番茄时间对*******
if globals()['stop'] != 1:
if zt == 0:
upt_fqbsj(fqbsj,fs,'数学')#更新状态t和学习内容,有回答正确的题才更新状态
up_fqbsj(fqbsj,fs,1,0)#更新番茄表，1为题数，0为答错题数
#*******番茄时间对*******
c_input.value = c_input.value + bb
c_label2.text = '复习：' + c_input.value
globals()['jj'],globals()['dan'],globals()['hd'],globals()['cid'],globals()['tid'],cvalue=settm(nd)
bb = ''
globals()['cuo'] = 0
c_input.value = cvalue
globals()['begintime'] = time()
elif bb == '×' and jj == 2:
jf = jf_ytime(ytime)
c_label1.text = '你答对了' + ',本题取得' + str(jf) + '积分'
globals()['rid'] += 1
u_record(ytime,cid,tid)
u_jfen(jf)
#*******番茄时间对*******
if globals()['stop'] != 1:
if zt == 0:
upt_fqbsj(fqbsj,fs,'数学')#更新状态t和学习内容,有回答正确的题才更新状态
up_fqbsj(fqbsj,fs,1,0)#更新番茄表，1为题数，0为答错题数
#*******番茄时间对*******
c_input.value = c_input.value + bb
c_label2.text = '复习：' + c_input.value
globals()['jj'],globals()['dan'],globals()['hd'],globals()['cid'],globals()['tid'],cvalue=settm(nd)
bb = ''
globals()['cuo'] = 0
c_input.value = cvalue
globals()['begintime'] = time()
elif bb == '÷' and jj == 3:
jf = jf_ytime(ytime)
c_label1.text = '你答对了' + ',本题取得' + str(jf) + '积分'
globals()['rid'] += 1
u_record(ytime,cid,tid)
u_jfen(jf)
#*******番茄时间对*******
if globals()['stop'] != 1:
if zt == 0:
upt_fqbsj(fqbsj,fs,'数学')#更新状态t和学习内容,有回答正确的题才更新状态
up_fqbsj(fqbsj,fs,1,0)#更新番茄表，1为题数，0为答错题数
#*******番茄时间对*******
c_input.value = c_input.value + bb
c_label2.text = '复习：' + c_input.value
globals()['jj'],globals()['dan'],globals()['hd'],globals()['cid'],globals()['tid'],cvalue=settm(nd)
bb = ''
globals()['cuo'] = 0
c_input.value = cvalue
globals()['begintime'] = time()
else:
c_label1.text = '答错了，重新回答，本次扣2分'
globals()['cuo'] += 1
u_cuo(cid,tid)
#*******番茄时间错*******
if globals()['stop'] != 1 and globals()['cuo']<=1:
up_fqbsj(fqbsj,fs,1,1)#更新番茄表，1为题数，1为答错题数
#*******番茄时间错*******
jf = -2
u_jfen(jf)
globals()['hd'] = 4
if is_number(bb) and hd == 3:
ytime = int((time() - begintime) * 1000)
dan3 = 0
if str(dan3) == bb:
jf = jf_ytime(ytime)
c_label1.text = '你答对了' + ',本题取得' + str(jf) + '积分'
globals()['rid'] += 1
u_record(ytime,cid,tid)
u_jfen(jf)
#*******番茄时间对*******
if globals()['stop'] != 1:
if zt == 0:
upt_fqbsj(fqbsj,fs,'数学')#更新状态t和学习内容,有回答正确的题才更新状态
up_fqbsj(fqbsj,fs,1,0)#更新番茄表，1为题数，0为答错题数
#*******番茄时间对*******
c_input.value = c_input.value + bb
c_label2.text = '复习：' + c_input.value
globals()['jj'],globals()['dan'],globals()['hd'],globals()['cid'],globals()['tid'],cvalue=settm(nd)
bb = ''
globals()['cuo'] = 0
c_input.value = cvalue
globals()['begintime'] = time()
else:
c_label1.text = '答错了，本次扣2分，答对了2个数字，请输入下一个'
globals()['cuo'] += 1
u_cuo(cid,tid)
#*******番茄时间错*******
if globals()['stop'] != 1 and globals()['cuo']<=1:
up_fqbsj(fqbsj,fs,1,1)#更新番茄表，1为题数，1为答错题数
#*******番茄时间错*******
jf = -2
u_jfen(jf)
globals()['hd'] = 3
if is_number(bb) and hd == 2:
ytime = int((time() - begintime) * 1000)
if dan >= 10 and dan < 100:
dan2 = int(str(dan)[-1:])
if dan2 == int(bb):
jf = jf_ytime(ytime)
c_label1.text = '你答对了' + ',本题取得' + str(jf) + '积分'
globals()['rid'] += 1
u_record(ytime,cid,tid)
u_jfen(jf)
#*******番茄时间对*******
if globals()['stop'] != 1:
if zt == 0:
upt_fqbsj(fqbsj,fs,'数学')#更新状态t和学习内容,有回答正确的题才更新状态
up_fqbsj(fqbsj,fs,1,0)#更新番茄表，1为题数，0为答错题数
#*******番茄时间对*******
c_input.value = c_input.value + bb
globals()['hd'] = 0 #答对重新出题
c_label2.text = '复习：' + c_input.value
globals()['jj'],globals()['dan'],globals()['hd'],globals()['cid'],globals()['tid'],cvalue=settm(nd)
bb = ''
globals()['cuo'] = 0
c_input.value = cvalue
globals()['begintime'] = time()
else:
c_label1.text = '答错了，本次扣2分，你只答对了1个数字，请输入下一个数字'
globals()['cuo'] += 1
u_cuo(cid,tid)
#*******番茄时间错*******
if globals()['stop'] != 1 and globals()['cuo']<=1:
up_fqbsj(fqbsj,fs,1,1)#更新番茄表，1为题数，1为答错题数
#*******番茄时间错*******
jf = -2
u_jfen(jf)
#globals()['hd'] = 2
elif dan ==100:
dan2 = 0
if str(dan2) == bb:
c_input.value = c_input.value + bb
c_label1.text = '你又答对了1个数字，请输入下一个数字'
globals()['hd'] = 3
else:
c_label1.text = '你答错了，继续答题，本次扣2分'
globals()['cuo'] += 1
u_cuo(cid,tid)
#*******番茄时间错*******
if globals()['stop'] != 1 and globals()['cuo']<=1:
up_fqbsj(fqbsj,fs,1,1)#更新番茄表，1为题数，1为答错题数
#*******番茄时间错*******
jf = -2
u_jfen(jf)
if is_number(bb) and hd == 1:
if dan < 10:
ytime = int((time() - begintime) * 1000)
if dan == int(bb):
jf = jf_ytime(ytime)
c_label1.text = '你答对了' + ',本题取得' + str(jf) + '积分'
globals()['rid'] += 1
u_record(ytime,cid,tid)
u_jfen(jf)
#*******番茄时间对*******
if globals()['stop'] != 1:
if zt == 0:
upt_fqbsj(fqbsj,fs,'数学')#更新状态t和学习内容,有回答正确的题才更新状态
up_fqbsj(fqbsj,fs,1,0)#更新番茄表，1为题数，0为答错题数
#*******番茄时间对*******
c_input.value = c_input.value + bb
c_label2.text = '复习：' + c_input.value
globals()['jj'],globals()['dan'],globals()['hd'],globals()['cid'],globals()['tid'],cvalue=settm(nd)
bb = ''
globals()['cuo'] = 0
c_input.value = cvalue
globals()['begintime'] = time()
else:
c_label1.text = '你答错了，继续答题，本次扣2分'
globals()['cuo'] += 1
u_cuo(cid,tid)
#*******番茄时间错*******
if globals()['stop'] != 1 and globals()['cuo']<=1:
up_fqbsj(fqbsj,fs,1,1)#更新番茄表，1为题数，1为答错题数
#*******番茄时间错*******
jf = -2
u_jfen(jf)
elif dan >= 10 and dan < 100:
dan1 = int(str(dan)[:1])
#print(dan1)
if dan1 == int(bb):
c_label1.text = '你答对了1个数字，请输入下一个数字'
c_input.value = c_input.value + bb
globals()['hd'] = 2
else:
globals()['cuo'] += 1
u_cuo(cid,tid)
#*******番茄时间错*******
if globals()['stop'] != 1 and globals()['cuo']<=1:
up_fqbsj(fqbsj,fs,1,1)#更新番茄表，1为题数，1为答错题数
#*******番茄时间错*******
jf = -2
u_jfen(jf)
# c_label1.text = '你答错了，继续答题'
elif dan == 100:
dan1 = 1
if dan1 == int(bb):
c_input.value = c_input.value + bb
c_label1.text = '你答对了1个数字，请输入下一个数字'
globals()['hd'] = 2
else:
globals()['cuo'] += 1
u_cuo(cid,tid)
#*******番茄时间错*******
if globals()['stop'] != 1 and globals()['cuo']<=1:
up_fqbsj(fqbsj,fs,1,1)#更新番茄表，1为题数，1为答错题数
#*******番茄时间错*******
jf = -2
u_jfen(jf)
#联网模式下的联网操作
if globals()['djms'] == 0:
# submit_button.text = '成功联网|重启'
#rid在下面9种情况下才发送更新rid到服务器，以减少服务器负担
if globals()['rid'] in (1,2,10,20,30,40,48,49,50,51):
params = {
'rid': rid,
}
response = requests.get(f'http://{fwqip}:5000/sxdatas', params=params)
# 检查响应状态码
if response.status_code == 200:
data = response.json()
arid = int(data.get('rid'))
submit_button.text = f'对方{arid}个|重启'
else:
# 处理错误的响应
print(f"Failed to fetch data1: {response.status_code}")
if rid == 51:
if arid < 50 and arid >= 0:
c_input.value = '你赢了！'
else:
c_input.value = '继续努力！'
globals()['rid'] = 0
globals()['nd'] = 0
globals()['hd'] = 0
globals()['arid'] = 0
globals()['djms'] = 1
aaa = '7 8 9 + 4 5 6 - 1 2 3 × 中 易 难 ÷'.split()
submit_button.text = '连接或重新开始'
# 打开难易按钮
setattr(names['button_14'],"enabled",True)
setattr(names['button_15'],"enabled",True)
for i in range(1,17):
setattr(names['button_' + str(i)],"text",aaa[i-1])
setattr(names['button_' + str(i)],"on_press",partial(bt1,aaa[i-1]))
else:
submit_button.text = '连接或重新开始'
#*******番茄时间*******
fqt = '番茄时间情况：\n'
c_labela.text = fqt + fq_qk()
if globals()['stop'] == 1:
c_input.value='休息！'+c_input.value
c_label.text=c_label.text+'\n'+'休息5分钟时间到!\n等音乐结束即5分钟后可以继续或换其他学习。'
# for i in range(1,17):
# setattr(names['button_' + str(i)],"enabled",False)
# sleep(1)
# for i in range(1,17):
# setattr(names['button_' + str(i)],"enabled",True)
#*******番茄时间*******
aaa = '7 8 9 + 4 5 6 - 1 2 3 × 中 易 难 ÷'.split()
#print(aaa) 用字符串变为数组，这样代码比较简
for i in range(1,17):
names['button_' + str(i)] = toga.Button(aaa[i-1], on_press=partial(bt1, aaa[i-1]),style=Pack(font_size=25))
#初始界面
# 设置组件样式和布局
c_box0.add(c_input0)
c_box0.add(submit_button)
box.add(c_box0)
c_box.add(c_input)
box.add(c_box)
for i in range(1,5):
b1_box.add(names['button_' + str(i)])
for i in range(5,9):
b2_box.add(names['button_' + str(i)])
for i in range(9,13):
b3_box.add(names['button_' + str(i)])
for i in range(13,17):
b4_box.add(names['button_' + str(i)])
fqt = '番茄时间情况：\n'
c_labela.text = fqt + fq_qk()
abox.add(c_labela)
box.add(b1_box)
box.add(b2_box)
box.add(b3_box)
box.add(b4_box)
box.add(c_label)
box.add(c_label1)
box.add(c_label2)
box.add(c_label3)
bigbox.add(box)
bigbox.add(abox)
# 设置 outer box 和 inner box 的样式
box.style.update(direction=COLUMN, padding=5)
abox.style.update(direction=COLUMN, padding=1)
bigbox.style.update(direction=ROW, padding=1)
b1_box.style.update(direction=ROW, padding=1)
b2_box.style.update(direction=ROW, padding=1)
b3_box.style.update(direction=ROW, padding=1)
b4_box.style.update(direction=ROW, padding=1)
c_box.style.update(direction=ROW, padding=5)
c_box0.style.update(direction=ROW, padding=5)
# 设置单个组件的样式
c_input0.style.update(width=240, flex=1)
c_input.style.update(width=345, flex=1)
# button.style.update(padding=15)
c_label.style.update(width=345, padding_left=4)
c_label1.style.update(width=345, padding_left=4)
c_label2.style.update(width=345, padding_left=4)
c_label3.style.update(width=345, padding_left=4)
submit_button.style.update(height=40, padding=1)
for i in range(1,17):
names['button_' + str(i)].style.update(width=85, height=85, padding=1)
return bigbox
def plays(t1,tfh1,t2,tfh2,tdan):
thread = threading.Thread(target=bfsz, args=(t1,tfh1,t2,tfh2,tdan,))
thread.daemon = True
thread.start()
#播放算式
def pfh(fh):
thread = threading.Thread(target=bffh, args=(fh,))
thread.daemon = True
thread.start()
#播放符号
def pnum(num):
thread = threading.Thread(target=bfnum, args=(num,))
thread.daemon = True
thread.start()
#播放数字
def main():
return toga.App("千纬数学（网络版）", "org.qwsxvs", startup=build)
if __name__ == "__main__":
main().main_loop()这个代码真的很长，一千行。
二、Flask服务器端代码（把认字游戏也加上去，平时都是一起用）
这里有一些改进，就是考虑用Qpython，把数据库的创建也写在代码里面，要用的时候直接复制就行，不用复制数据库。
# -*- coding: utf-8 -*-
"""
Created on Wed Jan 15 22:39:02 2025
@author: Ybk
"""
from flask import Flask, jsonify, request
from pathlib import Path
import sqlite3
import datetime
import os
db_filepath_vs = Path(__file__).joinpath("../vs.db").resolve()
if not os.path.exists(db_filepath_vs):
conn = sqlite3.connect('vs.db')
# 创建一个游标对象
cursor = conn.cursor()
# 创建表
now = datetime.datetime.now()
sj = now.strftime("%Y-%m-%d %H:%M:%S")
#这里设置比赛时间为当前时间加6秒，即6秒的匹配时间
bssj = now + datetime.timedelta(seconds=6)
bssjstr = bssj.strftime("%Y-%m-%d %H:%M:%S")
xzng = 0
cursor.execute('''
CREATE TABLE vs (
id INTEGER PRIMARY KEY AUTOINCREMENT,
zt INTEGER,
sj TEXT,
ip1 TEXT,
ip2 TEXT,
rid1 INTEGER,
rid2 INTEGER,
xzng1 INTEGER,
xzng2 INTEGER,
bssj TEXT
);
''')
# 插入一行数据
cursor.execute('''
INSERT INTO vs(zt,sj,ip1,ip2,rid1,rid2,xzng1,xzng2,bssj) VALUES(0,?,?,'',0,0,?,0,?);
''', (sj,'0.0.0.0',xzng,bssjstr))
# 提交事务
conn.commit()
cursor.execute('''
CREATE TABLE sx (
id INTEGER PRIMARY KEY AUTOINCREMENT,
zt INTEGER,
sj TEXT,
ip1 TEXT,
ip2 TEXT,
rid1 INTEGER,
rid2 INTEGER,
xzng1 INTEGER,
xzng2 INTEGER,
bssj TEXT
);
''')
# 插入一行数据
cursor.execute('''
INSERT INTO sx(zt,sj,ip1,ip2,rid1,rid2,xzng1,xzng2,bssj) VALUES(0,?,?,'',0,0,?,0,?);
''', (sj,'0.0.0.0',xzng,bssjstr))
# 提交事务
conn.commit()
conn.close()
print(f"文件 '{db_filepath_vs}' 创建成功。")
else:
print(f"文件 '{db_filepath_vs}' 已存在。")
app = Flask(__name__)
#千纬数学比赛的服务器端
@app.route('/vsdata', methods=['GET'])
def getvs_data():
response_data = {
'message': '连接成功'
}
return jsonify(response_data)
@app.route('/vsdatas', methods=['GET'])
def getvs_datas():
#连接数据库的代码，因为一直都用所以不关闭，等这个函数结束时关闭
conn = sqlite3.connect(db_filepath_vs, timeout=10, check_same_thread=False)
c = conn.cursor()
#默认反馈对手ip为空
xzng = 0
response_data = {
'aip': ''
}
#获取状态信息，初始zt为None，如果zt为0，那么设置为0，如果zt为-1，那么强制设置为0
zt = None
if request.args.get('zt') is None:
pass
else:
if request.args.get('zt') == '0':
cursor = c.execute("SELECT id FROM vs order by id desc limit 0,1")
row = cursor.fetchone()
vsid = row[0]
c.execute(f"update vs set zt = 0 where id ={vsid}")
conn.commit()
zt = 0
response_data = {
'aip': '',
'message': '可以重新游戏'
}
elif request.args.get('zt') == '-1':
#判断现在时间是否超过比赛时间的代码段
cursor = c.execute("SELECT id,bssj FROM vs order by id desc limit 0,1")
row = cursor.fetchone()
vsid = row[0]
biaosj = row[1]
now = datetime.datetime.now()
sj = now.strftime("%Y-%m-%d %H:%M:%S")
miaocha = (datetime.datetime.strptime(sj, "%Y-%m-%d %H:%M:%S") - datetime.datetime.strptime(biaosj, "%Y-%m-%d %H:%M:%S")).total_seconds()
#如果现在时间超过比赛时间，那么就可以设置状态为0
if miaocha >= 0:
#删除匹配不成功的行,删除好像让服务器变卡，采取100次才执行一次删除
if vsid % 100 == 0:
c.execute("DELETE FROM vs where ip2 = '' and zt = 0;")
conn.commit()
#设置在建行为结束游戏状态
c.execute(f"update vs set zt = 0 where id ={vsid}")
conn.commit()
zt = -1
print(zt)
response_data = {
'aip': '',
'message': '可以重新游戏'
}
#设置zt代码结束
#获取选择年级
if request.args.get('xzng') is None:
xzng = 0
else:
xzng = int(request.args.get('xzng'))
# 尝试从 X-Forwarded-For 头部获取 IP 地址
ip_address = request.headers.get('X-Forwarded-For', None)
if ip_address:
# X-Forwarded-For 头部可能包含多个 IP 地址，用逗号分隔
ip_address = ip_address.split(',')
else:
# 如果没有 X-Forwarded-For 头部，则使用 remote_addr
ip_address = request.remote_addr
#获取ip地址结束
#如果没有反馈zt，分3种情况，从表中最后一行提取zt
if zt == None or zt == 0:
cursor = c.execute("SELECT zt FROM vs order by id desc limit 0,1")
row = cursor.fetchone()
if row:
if row[0] == 0 and xzng > 0:
#如果zt为0，那么设置在建行，即zt=2
#判断现在时间是否超过比赛时间的代码段
cursor = c.execute("SELECT id,bssj FROM vs order by id desc limit 0,1")
row = cursor.fetchone()
vsid = row[0]
biaosj = row[1]
now = datetime.datetime.now()
sj = now.strftime("%Y-%m-%d %H:%M:%S")
miaocha = (datetime.datetime.strptime(sj, "%Y-%m-%d %H:%M:%S") - datetime.datetime.strptime(biaosj, "%Y-%m-%d %H:%M:%S")).total_seconds()
#如果现在时间超过比赛时间，那么就可以插入在建
if miaocha >= 0:
insert_query = "INSERT INTO vs(zt,sj,ip1,ip2,rid1,rid2,xzng1,xzng2,bssj) VALUES(2,?,?,'',0,0,?,0,?);"
now = datetime.datetime.now()
sj = now.strftime("%Y-%m-%d %H:%M:%S")
#这里设置比赛时间为当前时间加6秒，即6秒的匹配时间
bssj = now + datetime.timedelta(seconds=6)
bssjstr = bssj.strftime("%Y-%m-%d %H:%M:%S")
insert_data = (sj,ip_address,xzng,bssjstr)
c.execute(insert_query,insert_data)
conn.commit()
response_data = {
'bssj': bssjstr,
'aip': '',
'rid': 0
}
elif row[0] == 1:
#如果zt=1，即在比赛中
if request.args.get('rid') is None:
pass
else:
rid = int(request.args.get('rid'))
if rid < 25:
cursor = c.execute("SELECT id,ip1,ip2,rid1,rid2,bssj FROM vs where zt = 1 order by id desc limit 0,1")
else:
cursor = c.execute("SELECT id,ip1,ip2,rid1,rid2,bssj FROM vs order by id desc limit 0,1")
row = cursor.fetchone()
vsid = row[0]
ip1 = row[1]
ip2 = row[2]
rid1 = row[3]
rid2 = row[4]
bssjstr = row[5]
aip = ''
if ip1 == ip_address and rid < 26:
c.execute(f"update vs set rid1 = '{rid}' where id ={vsid}")
conn.commit()
rid = rid2
aip = ip2
elif ip2 == ip_address and rid < 26:
c.execute(f"update vs set rid2 = '{rid}' where id ={vsid}")
conn.commit()
rid = rid1 #反馈对方的rid，判断是否胜利
aip = ip1
response_data = {
'rid': rid,
'zt': 1,
'bssj': bssjstr,
'aip': aip
}
# 两个rid相加为50，即全部题做好，设置这个在建为0
if (rid1 + rid2) >= 49:
c.execute(f"update vs set zt = 0 where id ={vsid}")
conn.commit()
elif row[0] == 2:
#判断时间是否过期
now = datetime.datetime.now()
sj = now.strftime("%Y-%m-%d %H:%M:%S")
#判断ip是否相同
cursor = c.execute("SELECT id,ip1,ip2,bssj FROM vs where zt = 2 order by id desc limit 0,1")
row = cursor.fetchone()
vsid = row[0]
ip1 = row[1]
ip2 = row[2]
bssjstr = row[3]
miaocha = (datetime.datetime.strptime(bssjstr, "%Y-%m-%d %H:%M:%S") - datetime.datetime.strptime(sj, "%Y-%m-%d %H:%M:%S")).total_seconds()
if miaocha > 0 and miaocha < 6:
if ip1 != ip_address and ip2 == '':
c.execute(f"update vs set zt = 1,ip2 = '{ip_address}',xzng2 = {xzng} where id ={vsid}")
conn.commit()
response_data = {
'bssj': bssjstr,
'aip': ip1,
'rid': 0
}
else:
#时间过期了，设置状态为0
c.execute(f"update vs set zt = 0 where id ={vsid}")
conn.commit()
#再重新在建
insert_query = "INSERT INTO vs(zt,sj,ip1,ip2,rid1,rid2,xzng1,xzng2,bssj) VALUES(2,?,?,'',0,0,?,0,?);"
now = datetime.datetime.now()
sj = now.strftime("%Y-%m-%d %H:%M:%S")
bssj = now + datetime.timedelta(seconds=5)
bssjstr = bssj.strftime("%Y-%m-%d %H:%M:%S")
insert_data = (sj,ip_address,xzng,bssjstr)
c.execute(insert_query,insert_data)
conn.commit()
response_data = {
'bssj': bssjstr,
'aip': '',
'rid': 0
}
else:
#判断现在时间是否超过比赛时间的代码段
cursor = c.execute("SELECT id,bssj FROM vs order by id desc limit 0,1")
row = cursor.fetchone()
vsid = row[0]
biaosj = row[1]
now = datetime.datetime.now()
sj = now.strftime("%Y-%m-%d %H:%M:%S")
miaocha = (datetime.datetime.strptime(sj, "%Y-%m-%d %H:%M:%S") - datetime.datetime.strptime(biaosj, "%Y-%m-%d %H:%M:%S")).total_seconds()
#如果现在时间超过比赛时间，那么就可以插入在建
if miaocha >= 0:
insert_query = "INSERT INTO vs(zt,sj,ip1,ip2,rid1,rid2,xzng1,xzng2,bssj) VALUES(2,?,?,'',0,0,?,0,?);"
now = datetime.datetime.now()
sj = now.strftime("%Y-%m-%d %H:%M:%S")
bssj = now + datetime.timedelta(seconds=5)
bssjstr = bssj.strftime("%Y-%m-%d %H:%M:%S")
insert_data = (sj,ip_address,xzng,bssjstr)
c.execute(insert_query,insert_data)
conn.commit()
response_data = {
'bssj': bssjstr,
'aip': '',
'rid': 0
}
# print(ip_address)
c.close()
conn.close()
return jsonify(response_data)
@app.route('/sxdatas', methods=['GET'])
def getsx_datas():
#连接数据库的代码，因为一直都用所以不关闭，等这个函数结束时关闭
conn = sqlite3.connect(db_filepath_vs, timeout=10, check_same_thread=False)
c = conn.cursor()
#默认反馈对手ip为空
xzng = 0
response_data = {
'aip': ''
}
#获取状态信息，初始zt为None，如果zt为0，那么设置为0，如果zt为-1，那么强制设置为0
zt = None
if request.args.get('zt') is None:
pass
else:
if request.args.get('zt') == '0':
cursor = c.execute("SELECT id FROM sx order by id desc limit 0,1")
row = cursor.fetchone()
vsid = row[0]
c.execute(f"update sx set zt = 0 where id ={vsid}")
conn.commit()
zt = 0
response_data = {
'aip': '',
'message': '可以重新游戏'
}
elif request.args.get('zt') == '-1':
#判断现在时间是否超过比赛时间的代码段
cursor = c.execute("SELECT id,bssj FROM sx order by id desc limit 0,1")
row = cursor.fetchone()
vsid = row[0]
biaosj = row[1]
now = datetime.datetime.now()
sj = now.strftime("%Y-%m-%d %H:%M:%S")
miaocha = (datetime.datetime.strptime(sj, "%Y-%m-%d %H:%M:%S") - datetime.datetime.strptime(biaosj, "%Y-%m-%d %H:%M:%S")).total_seconds()
#如果现在时间超过比赛时间，那么就可以设置状态为0
if miaocha >= 0:
#删除匹配不成功的行,删除好像让服务器变卡，采取100次才执行一次删除
if vsid % 100 == 0:
c.execute("DELETE FROM sx where ip2 = '' and zt = 0;")
conn.commit()
#设置在建行为结束游戏状态
c.execute(f"update sx set zt = 0 where id ={vsid}")
conn.commit()
zt = -1
print(zt)
response_data = {
'aip': '',
'message': '可以重新游戏'
}
#设置zt代码结束
#获取选择年级
if request.args.get('xzng') is None:
xzng = 0
else:
xzng = int(request.args.get('xzng'))
# 尝试从 X-Forwarded-For 头部获取 IP 地址
ip_address = request.headers.get('X-Forwarded-For', None)
if ip_address:
# X-Forwarded-For 头部可能包含多个 IP 地址，用逗号分隔
ip_address = ip_address.split(',')
else:
# 如果没有 X-Forwarded-For 头部，则使用 remote_addr
ip_address = request.remote_addr
#获取ip地址结束
#如果没有反馈zt，分3种情况，从表中最后一行提取zt
if zt == None or zt == 0:
cursor = c.execute("SELECT zt FROM sx order by id desc limit 0,1")
row = cursor.fetchone()
if row:
if row[0] == 0 and xzng > 0:
#如果zt为0，那么设置在建行，即zt=2
#判断现在时间是否超过比赛时间的代码段
cursor = c.execute("SELECT id,bssj FROM sx order by id desc limit 0,1")
row = cursor.fetchone()
vsid = row[0]
biaosj = row[1]
now = datetime.datetime.now()
sj = now.strftime("%Y-%m-%d %H:%M:%S")
miaocha = (datetime.datetime.strptime(sj, "%Y-%m-%d %H:%M:%S") - datetime.datetime.strptime(biaosj, "%Y-%m-%d %H:%M:%S")).total_seconds()
#如果现在时间超过比赛时间，那么就可以插入在建
if miaocha >= 0:
insert_query = "INSERT INTO sx(zt,sj,ip1,ip2,rid1,rid2,xzng1,xzng2,bssj) VALUES(2,?,?,'',0,0,?,0,?);"
now = datetime.datetime.now()
sj = now.strftime("%Y-%m-%d %H:%M:%S")
#这里设置比赛时间为当前时间加6秒，即6秒的匹配时间
bssj = now + datetime.timedelta(seconds=6)
bssjstr = bssj.strftime("%Y-%m-%d %H:%M:%S")
insert_data = (sj,ip_address,xzng,bssjstr)
c.execute(insert_query,insert_data)
conn.commit()
response_data = {
'bssj': bssjstr,
'aip': '',
'rid': 0
}
elif row[0] == 1:
#如果zt=1，即在比赛中
if request.args.get('rid') is None:
pass
else:
rid = int(request.args.get('rid'))
if rid < 25:
cursor = c.execute("SELECT id,ip1,ip2,rid1,rid2,bssj FROM sx where zt = 1 order by id desc limit 0,1")
else:
cursor = c.execute("SELECT id,ip1,ip2,rid1,rid2,bssj FROM sx order by id desc limit 0,1")
row = cursor.fetchone()
vsid = row[0]
ip1 = row[1]
ip2 = row[2]
rid1 = row[3]
rid2 = row[4]
bssjstr = row[5]
aip = ''
if ip1 == ip_address and rid < 51:
c.execute(f"update sx set rid1 = '{rid}' where id ={vsid}")
conn.commit()
rid = rid2
aip = ip2
elif ip2 == ip_address and rid < 51:
c.execute(f"update sx set rid2 = '{rid}' where id ={vsid}")
conn.commit()
rid = rid1 #反馈对方的rid，判断是否胜利
aip = ip1
response_data = {
'rid': rid,
'zt': 1,
'bssj': bssjstr,
'aip': aip
}
# 两个rid相加为50，即全部题做好，设置这个在建为0
if (rid1 + rid2) >= 100:
c.execute(f"update sx set zt = 0 where id ={vsid}")
conn.commit()
elif row[0] == 2:
#判断时间是否过期
now = datetime.datetime.now()
sj = now.strftime("%Y-%m-%d %H:%M:%S")
#判断ip是否相同
cursor = c.execute("SELECT id,ip1,ip2,bssj FROM sx where zt = 2 order by id desc limit 0,1")
row = cursor.fetchone()
vsid = row[0]
ip1 = row[1]
ip2 = row[2]
bssjstr = row[3]
miaocha = (datetime.datetime.strptime(bssjstr, "%Y-%m-%d %H:%M:%S") - datetime.datetime.strptime(sj, "%Y-%m-%d %H:%M:%S")).total_seconds()
if miaocha > 0 and miaocha < 6:
if ip1 != ip_address and ip2 == '':
c.execute(f"update sx set zt = 1,ip2 = '{ip_address}',xzng2 = {xzng} where id ={vsid}")
conn.commit()
response_data = {
'bssj': bssjstr,
'aip': ip1,
'rid': 0
}
else:
#时间过期了，设置状态为0
c.execute(f"update sx set zt = 0 where id ={vsid}")
conn.commit()
#再重新在建
insert_query = "INSERT INTO sx(zt,sj,ip1,ip2,rid1,rid2,xzng1,xzng2,bssj) VALUES(2,?,?,'',0,0,?,0,?);"
now = datetime.datetime.now()
sj = now.strftime("%Y-%m-%d %H:%M:%S")
bssj = now + datetime.timedelta(seconds=5)
bssjstr = bssj.strftime("%Y-%m-%d %H:%M:%S")
insert_data = (sj,ip_address,xzng,bssjstr)
c.execute(insert_query,insert_data)
conn.commit()
response_data = {
'bssj': bssjstr,
'aip': '',
'rid': 0
}
else:
#判断现在时间是否超过比赛时间的代码段
cursor = c.execute("SELECT id,bssj FROM sx order by id desc limit 0,1")
row = cursor.fetchone()
vsid = row[0]
biaosj = row[1]
now = datetime.datetime.now()
sj = now.strftime("%Y-%m-%d %H:%M:%S")
miaocha = (datetime.datetime.strptime(sj, "%Y-%m-%d %H:%M:%S") - datetime.datetime.strptime(biaosj, "%Y-%m-%d %H:%M:%S")).total_seconds()
#如果现在时间超过比赛时间，那么就可以插入在建
if miaocha >= 0:
insert_query = "INSERT INTO sx(zt,sj,ip1,ip2,rid1,rid2,xzng1,xzng2,bssj) VALUES(2,?,?,'',0,0,?,0,?);"
now = datetime.datetime.now()
sj = now.strftime("%Y-%m-%d %H:%M:%S")
bssj = now + datetime.timedelta(seconds=5)
bssjstr = bssj.strftime("%Y-%m-%d %H:%M:%S")
insert_data = (sj,ip_address,xzng,bssjstr)
c.execute(insert_query,insert_data)
conn.commit()
response_data = {
'bssj': bssjstr,
'aip': '',
'rid': 0
}
# print(ip_address)
c.close()
conn.close()
return jsonify(response_data)
if __name__ == '__main__':
app.run(host='192.168.1.140')
三：关于怎么用，参考我上一篇文章。源代码我也不发布了，反正没几个人看，如果感兴趣，可以发邮件给我 索要：eybk@qq.com
也不上图。
PS：因为我开发的app是用boox平板用，用的boox平板只有Android 9/10 ，这次装在Android上，发现不能读手机里面图片文件夹的数据库，后来才发现是AndroidManifest.xml没有加上android:requestLegacyExternalStorage="true"这一行。
<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android" >
<uses-permission android:name="android.permission.INTERNET" />
<uses-permission android:name="android.permission.ACCESS_NETWORK_STATE" />
<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE"/>
<uses-permission android:name="android.permission.READ_EXTERNAL_STORAGE"/>
<application
android:allowBackup="true"
android:icon="@mipmap/ic_launcher"
android:label="@string/formal_name"
android:networkSecurityConfig="@xml/network_security_config"
android:roundIcon="@mipmap/ic_launcher_round"
android:supportsRtl="true"
android:requestLegacyExternalStorage="true"
android:theme="@style/AppTheme.Launcher" >
<!-- https://developer.android.com/guide/topics/resources/runtime-changes#HandlingTheChange -->
<activity
android:configChanges="orientation|screenSize|screenLayout|keyboardHidden"
android:name="org.beeware.android.MainActivity"
android:exported="true" >
<intent-filter>
<action android:name="android.intent.action.MAIN" />
<category android:name="android.intent.category.LAUNCHER" />
</intent-filter>
</activity>
<provider
android:name="androidx.core.content.FileProvider"
android:authorities="com.qwsxvs.qwsxvs.fileprovider"
android:exported="false"
android:grantUriPermissions="true">
<meta-data
android:name="android.support.FILE_PROVIDER_PATHS"
android:resource="@xml/file_paths">
</meta-data>
</provider>
</application>
</manifest>
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
