def search_videos(self, query): self.cursor.execute(''' SELECT * FROM videos WHERE title LIKE ? OR year LIKE ? OR rating LIKE ? OR type LIKE ? OR resolution LIKE ? OR source LIKE ? ''', (f'%{query}%', f'%{query}%', f'%{query}%', f'%{query}%', f'%{query}%', f'%{query}%')) return self.cursor.fetchall()
import re
def add_video(self, metadata): self.cursor.execute(''' INSERT INTO videos VALUES (?, ?, ?, ?, ?, ?) ''', ( metadata['title'], metadata['year'], metadata['rating'], metadata['type'], metadata['resolution'], metadata['source'] )) self.conn.commit() def search_videos(self, query): self
class VideoCatalog: def __init__(self, db_name): self.conn = sqlite3.connect(db_name) self.cursor = self.conn.cursor() self.cursor.execute(''' CREATE TABLE IF NOT EXISTS videos (title TEXT, year TEXT, rating TEXT, type TEXT, resolution TEXT, source TEXT) ''') source TEXT) ''')