def get_messages(): c = get_conn() query = c.execute("select * from messages;") return_value = jsonify( {'messages': [dict(row) for row in query.fetchall()]}) c.close() return return_value.json["messages"]
def get_pages(): conn = get_conn() papers = conn.get_nums if papers and papers >= 10: page = papers // 10 return page + 1 return 1
def new_paper(): """ 拿到最新壁纸 """ conn = get_conn() paper = conn.get_new() return render_template('paper.html', paper=paper, title='今日壁纸')
def create_all(): c = get_conn() c.execute("CREATE TABLE `messages` ( " "`message_id` INTEGER PRIMARY KEY AUTOINCREMENT, " "`message` TEXT NOT NULL, " "`palindrome` INTEGER DEFAULT -1 );") c.commit() c.close()
def all_papers(): page = request.args.get('page', 1, type=int) pages = get_pages() next = True if pages > page else False prev = False if page == 1 else True conn = get_conn() papers = conn.get_page(page, 10)[0] return render_template('papers.html', papers=papers, pages=pages, page=page, next=next, prev=prev)
def delete(): c = get_conn() message_id = request.json["message_id"] m = (message_id, ) try: c.execute("DELETE FROM messages WHERE message_id=?", m) c.commit() c.close() return_value = { "status": "Your message has been deleted", "message_id": message_id } return make_response(jsonify(return_value), 200) except Exception as e: headers = {'Content-Type': 'text/html'} make_response(render_template("500.html", code=500), 500, headers)
def post(): c = get_conn() message_id = request.json["message_id"] id = (message_id, ) query = c.execute("SELECT message FROM messages WHERE message_id = ?", id) message = query.fetchone()["message"] palindrome = int(checkPalindrome(message)) try: m = (palindrome, message_id) c.execute("UPDATE messages SET palindrome=? WHERE message_id=?", m) c.commit() c.close() return_value = {"palindrome": palindrome, "message_id": message_id} return make_response(jsonify(return_value), 200) except Exception as e: headers = {'Content-Type': 'text/html'} return make_response(render_template("500.html", code=500), 500, headers)
def add_word(): c = get_conn() message = request.json["value"] if checkMessage(message): m = (message, ) query = c.execute("INSERT INTO messages (message) VALUES (?);", m) m_id = query.lastrowid c.commit() c.close() return_value = { "status": "Your message has been added", "message": message, "message_id": m_id } return make_response(jsonify(return_value), 201) else: headers = {'Content-Type': 'text/html'} return make_response(render_template("400.html", code=400), 400, headers)
def drop_all(): c = get_conn() c.execute("DROP TABLE `messages`") c.commit() c.close()
def paper(num): conn = get_conn() paper = conn.get_data(num) return render_template('paper.html', paper=paper)