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)
