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()