def pload():
if 'user' in session:
connect = MySQLdb.connect(db=config.DB_NAME, host=config.DB_HOST, port=config.DB_PORT, user=config.DB_USER, passwd=config.DB_PASSWD)
result = ProjectService.loadProject(session['user'], request.form['pid'])
connect.close()
for joinInfo in session['user']['joinInfos']:
if joinInfo['id'] == result['group_id']:
result['group'] = joinInfo
return json.dumps(result)
return 'false'
def editor(pid):
if 'user' in session:
connect = MySQLdb.connect(db=config.DB_NAME, host=config.DB_HOST, port=config.DB_PORT, user=config.DB_USER, passwd=config.DB_PASSWD)
result = ProjectService.loadProject(connect, session['user'], pid)
connect.close()
if not result == None:
return render_template('editorjs.html', userinfo=json.dumps(session['user']), project=json.dumps(result))
else:
return redirect(url_for('login_view'))
return render_template('request_deny.html')
def editorjs(pid):
if 'user' in session:
connect = MySQLdb.connect(db=config.DB_NAME, host=config.DB_HOST, port=config.DB_PORT, user=config.DB_USER, passwd=config.DB_PASSWD)
result = ProjectService.loadProject(session['user'], pid, connect)
if not result == None:
gid = int(result['group_id'])
cur = connect.cursor()
cur.execute('SELECT GroupInfo.id AS id1,role,name,service FROM GroupInfo INNER JOIN JoinInfo ON GroupInfo.id = JoinInfo.group_id AND JoinInfo.user_id=%s AND group_id=%s;',(session['user']['id'], gid))
rows = cur.fetchall()
cur.close()
connect.close()
if not len(rows) == 0:
joinInfo = {}
joinInfo['id'] = int(rows[0][0])
joinInfo['role'] = int(rows[0][1])
joinInfo['name'] = rows[0][2]
joinInfo['service'] = rows[0][3]
result['group'] = joinInfo
return render_template('editorjs.html', pid = pid, project = json.dumps(result))
else:
return redirect(url_for('login_view'))
return render_template('request_deny.html')
