def delroot():
rid = request.args.get("rid")
cur.execute("delete from role where rid=%s",(rid))
db.commit()
cur.execute("select * from role")
result = cur.fetchall()
return json.dumps(result)
def dele():
id = request.args.get('id')
cur.execute("delete from questiontype where id=%s", (id))
db.commit()
cur.execute("select * from questiontype")
result = cur.fetchall()
return json.dumps(result)
def del1():
id = request.args.get("id")
cur.execute("delete from users where uid=%s", (id))
db.commit()
cur.execute("select * from users,role where users.rid=role.rid")
data = cur.fetchall()
return json.dumps(data)
def updaterole():
rid = request.args.get("rid")
rname = request.args.get("rname")
power = request.args.get("power")
cur.execute("update role set rname=%s,power=%s where rid=%s",(rname,power,rid))
db.commit()
return "ok"
def del1():
data = json.loads(request.args.get('datas'))
cid = request.args.get('cid')
print(data)
cur.execute("delete from dircursor where cid=%s and step=%s",
(cid, data['step']))
db.commit()
return 'ok'
def add():
# nid=request.args.get('nid')
name = request.args.get('name')
cur.execute("insert into questiontype (name) values (%s)", (name))
db.commit()
cur.execute("select * from questiontype")
result = cur.fetchall()
return json.dumps(result)
def get(self, id):
db, cursor = self.db_init()
sql = "Select * From api.users Where id = '{}' and deleted is not True".format(id)
cursor.execute(sql)
db.commit()
user = cursor.fetchone()
db.close()
return jsonify({"data": user})
def addjudge():
con=request.args.get('con')
answer=request.args.get('answer')
nid = 3
point = request.args.get('point') or 3
cname = request.args.get('cname')
cur.execute("select cid from `cursor` where cname=%s", (cname))
fid = cur.fetchone()['cid']
cur.execute("insert into question (fid,con,answer,point,nid) values (%s,%s,%s,%s,%s)",(fid, con, answer, point, nid))
db.commit()
return 'ok'
def filedata(con):
cur.execute("insert into `cursor` (cname) values (%s)", (con[0]))
cid = db.insert_id()
step = con[1].split("\n")
part = con[2].split("\n")
for index in range(len(step)):
arr = []
arr.append((step[index], part[index], cid))
cur.executemany(
"insert into `dircursor` (step,part,cid) values (%s,%s,%s)", (arr))
db.commit()
def edit():
id = request.args.get('id')
nid = request.args.get('nid')
name = request.args.get('name')
print(id, nid, name)
cur.execute("update questiontype set nid=%s,name=%s where id=%s",
(nid, name, id))
db.commit()
cur.execute("select * from questiontype")
result = cur.fetchall()
return json.dumps(result)
def addone():
name = request.args.get('name')
f = request.args.get('f')
start = request.args.get('start')
end = request.args.get('end')
cur.execute("select cid from `cursor` where cname=%s", (f))
cid = cur.fetchone()['cid']
cur.execute(
"insert into classes (name,start,end,fid) values (%s,%s,%s,%s)",
(name, start, end, cid))
db.commit()
return "ok"
def __init__(self, name, email, password, surname=None, is_admin=False):
self.name = name
self.email = email
self.password = generate_password_hash(password,
method='pbkdf2:sha256',
salt_length=8)
if surname:
self.surname = surname
if is_admin:
self.is_admin = True
db.add(self)
db.commit()
def add():
name = request.form['name']
upass = request.form['pass']
phone = request.form['phone']
rid = request.form['rid']
md5 = hashlib.md5()
md5.update(upass.encode())
upass = md5.hexdigest()
cur.execute(
"insert into users(name,uname,upass,phone,rid)values (%s,%s,%s,%s,%s)",
(name, phone, upass, phone, rid))
db.commit()
return 'ok'
def upload1():
UPLOAD_FOLDER = 'upload/teacher/'
current_app.config['UPLOAD_FOLDER'] = UPLOAD_FOLDER
if request.method == 'POST':
db1 = pymysql.connect(host="localhost",
user="******",
password="******",
db="lzm",
charset="utf8")
cur1 = db1.cursor()
cur1.execute("select cname,cid from `cursor`")
c = dict(cur1.fetchall())
db1.close()
f = request.files['file'] # 从表单的file字段获取文件，myfile为该表单的name值
if f and allowed_file(f.filename): # 判断是否是允许上传的文件类型
fname = secure_filename(f.filename)
suf = fname.rsplit('.', 1)[1] #截取文件后缀名
now = int(time.time())
newfile = str(now) + '.' + suf
f.save(os.path.join(current_app.config['UPLOAD_FOLDER'], newfile))
book = xlrd.open_workbook('upload/teacher/' + newfile)
sheet = book.sheet_by_index(0) #定义一个对象
arr = []
user = []
for i in range(1, sheet.nrows):
con = sheet.row_values(i)
if isinstance(con[1], float):
con[1] = str(int(con[1]))
if isinstance(con[3], float):
con[3] = int(con[3])
con[2] = c[con[2]]
arr.append(con)
name = con[0]
phone = con[1]
md5 = hashlib.md5()
md5.update(b'111111')
up = md5.hexdigest()
arr1 = [name, phone, up, phone, 2]
user.append(arr1)
cur.executemany(
"insert into teacher (name,phone,fid,class) values (%s,%s,%s,%s)",
(arr))
cur.executemany(
"insert into users (name,uname,upass,phone,rid) values (%s,%s,%s,%s,%s)",
(user))
db.commit()
return 'ok'
else:
return "error"
def __init__(self, original_url, url_identifier_length=4):
self.original_url = original_url
# Identifiers need to start with B to ensure nginx can catch the request
# and proxy it to the backend
url_identifier = 'B'
url_identifier += ''.join(
random.choices(string.ascii_uppercase + string.digits,
k=url_identifier_length))
self.follow_url = f'{HOST}/{url_identifier}'
self.identifier = url_identifier
db.add(self)
db.commit()
def editonecursor():
data = request.args.get('data')
data = json.loads(data)
print(data)
cid = request.args.get('id')
cur.execute("update `cursor` set cname=%s where cid=%s", (data[0], cid))
cur.execute("delete from dircursor where cid=%s", (cid))
step = data[1].split("\n")
part = data[2].split("\n")
for index in range(len(step)):
arr = []
arr.append((step[index], part[index], cid))
cur.executemany(
"insert into `dircursor` (step,part,cid) values (%s,%s,%s)", (arr))
db.commit()
return 'ok'
def addstudaily():
uid = session.get('uid')
# classid=session.get('classid')
cur.execute("select phone from users where uid=%s", (uid))
phone = cur.fetchone()['phone']
name = session.get('name')
motto = request.args.get('motto')
con = request.args.get('con')
heart = request.args.get('heart')
suggest = request.args.get('suggest')
date = request.args.get('date')
cur.execute(
"insert into studaily (uid,name,motto,con,heart,suggest,date,phone) values (%s,%s,%s,%s,%s,%s,%s,%s)",
(uid, name, motto, con, heart, suggest, date, phone))
db.commit()
return 'ok'
def upload():
UPLOAD_FOLDER = 'upload/exam/'
current_app.config['UPLOAD_FOLDER'] = UPLOAD_FOLDER
if request.method == 'POST':
f = request.files['file'] # 从表单的file字段获取文件，myfile为该表单的name值
if f and allowed_file(f.filename): # 判断是否是允许上传的文件类型
fname = secure_filename(f.filename)
suf = fname.rsplit('.', 1)[1] #截取文件后缀名
now = int(time.time())
newfile = str(now)+'.'+suf
f.save(os.path.join(current_app.config['UPLOAD_FOLDER'],newfile))
book=xlrd.open_workbook('upload/exam/'+newfile)
sheet = book.sheet_by_index(0) #定义一个对象
question=[]
for i in range(1,sheet.nrows):
arr=[]
con = sheet.row_values(i)
cur.execute("select cid from `cursor` where cname=%s",(con[0]))
fid=cur.fetchone()['cid']
cur.execute("select nid from questiontype where name=%s", (con[1]))
nid=cur.fetchone()['nid']
sel=con[3].split('|')
if nid==1:
answer=sel.index(str(int(con[4])))
elif nid==2:
answer=''
ans = con[4].split('|')
for i in range(len(sel)):
for j in range(len(ans)):
if sel[i] == ans[j]:
a=str(i)+'|'
answer+=a
answer=answer[0:-1]
elif nid==3:
con[3]=None
if con[4]=='错':
answer=0
elif con[4]=='对':
answer=1
arr+=[fid]+[con[2]]+[con[3]]+[answer]+[int(con[5])]+[nid]
question.append(tuple(arr))
cur.executemany("insert into question (fid,con,`option`,answer,point,nid) values (%s,%s,%s,%s,%s,%s)",(question))
db.commit()
return 'ok'
else:
return "error"
def addone():
name = request.args.get('name')
school = request.args.get('school')
phone = request.args.get('phone')
classes = request.args.get('classes')
md5 = hashlib.md5()
md5.update(b'111111')
up = md5.hexdigest()
cur.execute("select id from classes where name=%s", (classes))
classid = cur.fetchone()['id']
cur.execute(
"insert into studentes (name,phone,school,classid) values (%s,%s,%s,%s)",
(name, phone, school, classid))
cur.execute(
"insert into users (name,uname,upass,phone,rid) values (%s,%s,%s,%s,%s)",
(name, phone, up, phone, 1))
db.commit()
return "ok"
def addone():
name = request.args.get('name')
f = request.args.get('f')
phone = request.args.get('phone')
classes = request.args.get('classes')
md5 = hashlib.md5()
md5.update(b'111111')
up = md5.hexdigest()
cur.execute("select cid from `cursor` where cname=%s", (f))
fid = cur.fetchone()['cid']
cur.execute(
"insert into teacher (name,phone,class,fid) values (%s,%s,%s,%s)",
(name, phone, classes, fid))
cur.execute(
"insert into users (name,uname,upass,phone,rid) values (%s,%s,%s,%s,%s)",
(name, phone, up, phone, 2))
db.commit()
return "ok"
def upload1():
UPLOAD_FOLDER = 'upload/classes/'
current_app.config['UPLOAD_FOLDER'] = UPLOAD_FOLDER
if request.method == 'POST':
db1 = pymysql.connect(host="localhost",
user="******",
password="******",
db="lzm",
charset="utf8")
cur1 = db1.cursor()
cur1.execute("select cname,cid from `cursor`")
c = dict(cur1.fetchall())
db1.close()
f = request.files['file'] # 从表单的file字段获取文件，myfile为该表单的name值
if f and allowed_file(f.filename): # 判断是否是允许上传的文件类型
fname = secure_filename(f.filename)
suf = fname.rsplit('.', 1)[1] #截取文件后缀名
now = int(time.time())
newfile = str(now) + '.' + suf
f.save(os.path.join(current_app.config['UPLOAD_FOLDER'], newfile))
book = xlrd.open_workbook('upload/classes/' + newfile)
sheet = book.sheet_by_index(0) #定义一个对象
arr = []
for i in range(1, sheet.nrows):
con = sheet.row_values(i)
if isinstance(con[0], float):
con[0] = int(con[0])
con[2] = xlrd.xldate_as_datetime(
con[2], 0).strftime("%Y-%m-%d %H:%M:%S")
con[3] = xlrd.xldate_as_datetime(
con[3], 0).strftime("%Y-%m-%d %H:%M:%S")
con[1] = c[con[1]]
arr.append(con)
cur.executemany(
"insert into classes (name,fid,start,end) values (%s,%s,%s,%s)",
(arr))
db.commit()
return 'ok'
else:
return "error"
def addPoint():
id = session.get('uid') or 10
data = request.args.get('data')
data = json.loads(data)
myanswer = ''
aid = ''
for item in data:
if isinstance(item['myanswer'], list):
a = ''
for i in item['myanswer']:
a += str(i) + '|'
a = a[:-1]
item['myanswer'] = a
myanswer += str(item['myanswer']) + '/n'
aid += str(item['id']) + '/n'
myanswer = myanswer[:-2]
aid = aid[:-2]
point = data[len(data) - 1]['point']
nowdate = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime())
cur.execute(
"insert into point (stuid,point,myanswer,aid,nowdate) values (%s,%s,%s,%s,%s)",
(id, point, myanswer, aid, nowdate))
db.commit()
return 'ok'
def __init__(self, text, p_id):
self.pawn_id = p_id
self.text = text
db.add(self)
db.commit()
def delete(self):
db.delete(self)
db.commit()
def addrole():
rname = request.args.get("rname")
power = request.args.get("power")
cur.execute("insert into role (rname,power)values (%s,%s)",(rname,power))
db.commit()
return "ok"
def __init__(self, name):
self.name = name
db.add(self)
db.commit()
def del1():
name = request.args.get('name')
cur.execute("delete from classes where name=%s", (name))
db.commit()
return 'ok'
def del1():
phone = request.args.get('phone')
cur.execute("delete from teacher where phone=%s", (phone))
cur.execute("delete from users where phone=%s", (phone))
db.commit()
return 'ok'
def addarrange():
cid=request.args.get('cid')
alltime=request.args.get('alltime')
cur.execute("insert into exam1 (fid,alltime) values (%s,%s)",(cid,alltime))
db.commit()
return 'ok'
