blob: b8026310fb99b2398b2eaa2143a0848df136e1c2 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
from database import *
from sqlalchemy.sql import select
database_url = "sqlite:///jlm.db"
engine, Session = init_db_stuff(database_url)
from sqlalchemy import func
movie_name = "Forrest Gump"
with engine.connect() as conn:
movie_deets = select(movies_table).filter(
func.lower(movies_table.columns.title) == func.lower(movie_name)
)
result = conn.execute(movie_deets)
for row in result:
print(row)
|
