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')