def forum_create(): cursor = db.get_cursor() try: data = request.get_json() name = data['name'] short_name = data['short_name'] user = data['user'] cursor.execute( """insert into forums (name, shortname, user) values (%s, %s, %s)""", (name, short_name, user)) db.commit() cursor.close() return jsonify(code=0, response={ 'id': cursor.lastrowid, 'name': name, 'short_name': short_name, 'user': user }) except KeyError: return jsonify(code=2, response='invalid json') except DoesNotExist: return jsonify(code=1, response='user does not exist') except IntegrityError, e: if e[0] == 1062: return jsonify(code=0, response=get_forum_info(short_name, db)) elif e[0] == 1452: return jsonify(code=1, response='user not found')
def forum_create(): cursor = db.get_cursor() try: data = request.get_json() name = data['name'] short_name = data['short_name'] user = data['user'] cursor.execute("""insert into forums (name, shortname, user) values (%s, %s, %s)""",(name, short_name, user)) db.commit() cursor.close() return jsonify(code=0, response={ 'id':cursor.lastrowid, 'name':name, 'short_name': short_name, 'user': user}) except KeyError: return jsonify(code=2, response='invalid json') except DoesNotExist: return jsonify(code=1, response='user does not exist') except IntegrityError, e: if e[0] == 1062: return jsonify(code=0, response=get_forum_info(short_name, db)) elif e[0] == 1452: return jsonify(code=1, response='user not found')
def forum_details(): try: forum = request.args['forum'] related = request.args.getlist('related') return jsonify(code=0, response=get_forum_info(forum, db, related)) except KeyError: return jsonify(code=2, response='invalid json') except DoesNotExist: return jsonify(code=1, response="not found") except: return jsonify(code=4, response='opps')
def forum_details(): try: forum = request.args['forum'] related = request.args.getlist('related') return jsonify(code=0, response=get_forum_info(forum, db, related)) except KeyError: return jsonify(code=2, response='invalid json') except DoesNotExist: return jsonify(code=1, response="not found") except: return jsonify(code=4, response='opps')
def forum_listPosts(): cursor = db.get_cursor(MySQLdb.cursors.DictCursor) try: forum = request.args['forum'] limit = request.args.get('limit', '') order = request.args.get('order', 'desc') since_date = request.args.get('since', False) related = request.args.getlist('related') query = "" query_params = () if since_date: query = "select * from posts where forum = %s and date >= %s order by date " + order query_params += ( forum, since_date, ) else: query = "select * from posts where forum = %s order by date " + order query_params += (forum, ) if limit != '': query += " limit " + limit cursor.execute(query, query_params) posts = cursor.fetchall() for post in posts: if 'user' in related: post.update({'user': get_user_info(post['user'], db)}) if 'thread' in related: post.update({'thread': get_thread_info(post['thread'], db)}) if 'forum' in related: post.update({'forum': get_forum_info(post['forum'], db)}) post.update({"date": str(post["date"])}) cursor.close() return jsonify(code=0, response=posts) except DoesNotExist: return jsonify(code=1, response='does not exist') except IntegrityError, e: return jsonify(code=1, response='something not found')
def forum_listPosts(): cursor = db.get_cursor(MySQLdb.cursors.DictCursor) try: forum = request.args['forum'] limit = request.args.get('limit', '') order = request.args.get('order', 'desc') since_date = request.args.get('since', False) related = request.args.getlist('related') query = "" query_params = () if since_date: query = "select * from posts where forum = %s and date >= %s order by date " + order query_params += (forum, since_date, ) else: query = "select * from posts where forum = %s order by date " + order query_params += (forum,) if limit != '': query += " limit " + limit cursor.execute(query, query_params) posts = cursor.fetchall() for post in posts: if 'user' in related: post.update({'user': get_user_info(post['user'], db)}) if 'thread' in related: post.update({'thread': get_thread_info(post['thread'], db)}) if 'forum' in related: post.update({'forum': get_forum_info(post['forum'], db)}) post.update({"date": str(post["date"])}) cursor.close() return jsonify(code=0, response=posts) except DoesNotExist: return jsonify(code=1, response='does not exist') except IntegrityError, e: return jsonify(code=1, response='something not found')