Python get_thread_entityの例

コード例 #1

def vote_thread():
    cur = mysql.connection.cursor()
    try:
        json_obj = json.loads(json.dumps(request.json))
        thread_id = json_obj["thread"]
        vote = str(json_obj["vote"])
    except Exception:
        return json.dumps(responses_codes[2])
    if not thread_id or not vote:
        return json.dumps(responses_codes[1])
    if vote not in {'1', '-1'}:
        return json.dumps(responses_codes[2])
    try:
        if vote == '1':
            cur.execute('''UPDATE Thread SET points = points + 1, likes = likes + 1 WHERE id = '%s' ''' % thread_id)
        else:
            cur.execute('''UPDATE Thread SET points = points - 1, dislikes = dislikes + 1 WHERE id = '%s' ''' % thread_id)
    except Exception:
        return json.dumps(responses_codes[5])
    response = get_thread_entity([], thread_id)
    if response in responses_codes:
        return json.dumps(response, sort_keys=True)
    result = {
        "code": 0,
        "response": response
    }
    return json.dumps(result, sort_keys=True)

コード例 #2

def update_thread():
    cur = mysql.connection.cursor()
    try:
        json_obj = json.loads(json.dumps(request.json))
        thread_id = json_obj["thread"]
        message = json_obj["message"]
        slug = json_obj["slug"]
    except Exception:
        return json.dumps(responses_codes[2])

    if not thread_id or not message or not slug:
        return json.dumps(responses_codes[1])

    try:
        cur.execute('''UPDATE Thread SET message='%s', slug='%s' WHERE id = '%s' ''' % (message, slug, thread_id,))
    except Exception:
        return json.dumps(responses_codes[5])
    response = get_thread_entity([], thread_id)
    if response in responses_codes:
        return json.dumps(response, sort_keys=True)
    result = {
        "code": 0,
        "response": response
    }
    return json.dumps(result, sort_keys=True)

コード例 #3

ファイル: thread.py プロジェクト: nickshch/Forum_database

def vote_thread():
    cur = mysql.connection.cursor()
    try:
        json_obj = json.loads(json.dumps(request.json))
        thread_id = json_obj["thread"]
        vote = str(json_obj["vote"])
    except Exception:
        return json.dumps(responses_codes[2])
    if not thread_id or not vote:
        return json.dumps(responses_codes[1])
    if vote not in {'1', '-1'}:
        return json.dumps(responses_codes[2])
    try:
        if vote == '1':
            cur.execute('''UPDATE Thread SET points = points + 1, likes = likes + 1 WHERE id = '%s' ''' % thread_id)
        else:
            cur.execute('''UPDATE Thread SET points = points - 1, dislikes = dislikes + 1 WHERE id = '%s' ''' % thread_id)
    except Exception:
        return json.dumps(responses_codes[5])
    response = get_thread_entity([], thread_id)
    if response in responses_codes:
        return json.dumps(response, sort_keys=True)
    result = {
        "code": 0,
        "response": response
    }
    return json.dumps(result, sort_keys=True)

コード例 #4

ファイル: thread.py プロジェクト: nickshch/Forum_database

def update_thread():
    cur = mysql.connection.cursor()
    try:
        json_obj = json.loads(json.dumps(request.json))
        thread_id = json_obj["thread"]
        message = json_obj["message"]
        slug = json_obj["slug"]
    except Exception:
        return json.dumps(responses_codes[2])

    if not thread_id or not message or not slug:
        return json.dumps(responses_codes[1])

    try:
        cur.execute('''UPDATE Thread SET message='%s', slug='%s' WHERE id = '%s' ''' % (message, slug, thread_id,))
    except Exception:
        return json.dumps(responses_codes[5])
    response = get_thread_entity([], thread_id)
    if response in responses_codes:
        return json.dumps(response, sort_keys=True)
    result = {
        "code": 0,
        "response": response
    }
    return json.dumps(result, sort_keys=True)

コード例 #5

def detail_thread():
    related = request.args.getlist("related")
    thread_id = int(request.args.get("thread"))
    if not thread_id:
        return json.dumps(responses_codes[2], sort_keys=True)
    for x in related:
        if x not in ["forum", "user"]:
            return json.dumps(responses_codes[3], sort_keys=True)

    response = get_thread_entity(related, thread_id)
    if response in responses_codes:
        return json.dumps(response, sort_keys=True)
    result = {"code": 0, "response": response}
    return json.dumps(result, sort_keys=True)

コード例 #6

ファイル: thread.py プロジェクト: nickshch/Forum_database

def detail_thread():
    related = request.args.getlist("related")
    thread_id = int(request.args.get("thread"))
    if not thread_id:
        return json.dumps(responses_codes[2], sort_keys=True)
    for x in related:
        if x not in ["forum", "user"]:
            return json.dumps(responses_codes[3], sort_keys=True)

    response = get_thread_entity(related, thread_id)
    if response in responses_codes:
        return json.dumps(response, sort_keys=True)
    result = {
        "code": 0,
        "response": response
    }
    return json.dumps(result, sort_keys=True)