|
from cs50 import sql
|
|
|
|
db = sql.SQL("sqlite:///shows.db")
|
|
title = input("Title?: ")
|
|
rows = db.execute("SELECT * FROM shows WHERE title = ? LIMIT 10", title)
|
|
|
|
print("title | year | episodes")
|
|
for row in rows:
|
|
print(f"{row['title']} | {row['year']} | {row['episodes']}") |