@app.route('/<short_code')
def redirect_to_original(short_code):
conn = sqlite3.connect('urls.db')
c = conn.cursor()
c.execute(SELECT original_url FROM urls WHERE short_code=?, (short_code,))
result = c.fetchone()
conn.close()
if result:
return redirect(result[0])
else:
return 短网址不存在, 404
if __name__ == '__main__':
init_db()
app.run(debug=True)