获取原始URL
def get_original_url(short_id):
conn = sqlite3.connect(DB_NAME)
c = conn.cursor()
c.execute(SELECT long_url FROM urls WHERE short_id=?, (short_id,))
result = c.fetchone()
conn.close()
return result[0] if result else None
@app.route('/shorten', methods=['POST'])
def shorten():
long_url = request.json.get('url')
if not long_url:
return {'error': 'Missing URL'}, 400