Hindimovieslink Link

CREATE TABLE movie_links ( id BIGSERIAL PRIMARY KEY, movie_id BIGINT REFERENCES movies(id) ON DELETE CASCADE, platform_id BIGINT REFERENCES platforms(id), url TEXT NOT NULL, price_usd NUMERIC(5,2), price_local NUMERIC(5,2), currency TEXT, is_free BOOLEAN DEFAULT FALSE, last_checked TIMESTAMP, UNIQUE(movie_id, platform_id) );

CREATE EXTENSION IF NOT EXISTS pg_trgm; CREATE INDEX idx_movies_title_trgm ON movies USING gin (title gin_trgm_ops); from fastapi import FastAPI, Depends, HTTPException, Query from pydantic import BaseModel from typing import List, Optional from sqlalchemy.orm import Session import models, crud, schemas, auth hindimovieslink

def get_movie_with_links(db: Session, movie_id: int): return ( db.query(models.Movie) .filter(models.Movie.id == movie_id) .options( sqlalchemy.orm.joinedload(models.Movie.links) .joinedload(models.MovieLink.platform) ) .first() ) CREATE TABLE movie_links ( id BIGSERIAL PRIMARY KEY,

class AlertOut(BaseModel): id: int created_at: datetime.datetime is_active: bool from sqlalchemy import func, or_ from sqlalchemy.orm import Session from . import models, schemas platform_id BIGINT REFERENCES platforms(id)