python import shorten_tv import sqlite3 conn = sqlite3.connect('shorten_tv.db') c = conn.cursor() c.execute('''CREATE TABLE IF NOT EXISTS urls (long_url text, short_url text)''') def shorten_url(long_url): short_url = shorten_tv.shorten(long_url) c.execute("INSERT INTO urls VALUES (?, ?)", (long_url, short_url)) conn.commit() return short_url def get_long_url(short_url): c.execute("SELECT long_url FROM urls WHERE short_url=?", (short_url,)) long_url = c.fetchone()[0] return long_url original_url = "https://example.com/very/long/url/to/be/shortened" shortened_url = shorten_url(original_url) print("Shortened url:", shortened_url) retrieved_url = get_long_url(shortened_url) print("Retrieved url:", retrieved_url) conn.close()


上一篇:
下一篇:
切换中文