671 lines
38 KiB
Python
671 lines
38 KiB
Python
from sqlalchemy import DateTime, ForeignKey, Index, Integer, REAL, String, Text, text
|
|
from typing import List, Optional
|
|
|
|
from sqlalchemy.orm import DeclarativeBase, Mapped, mapped_column, relationship
|
|
import datetime
|
|
|
|
class Base(DeclarativeBase):
|
|
pass
|
|
|
|
|
|
class IafdDistributors(Base):
|
|
__tablename__ = 'iafd_distributors'
|
|
|
|
id: Mapped[int] = mapped_column(Integer, primary_key=True)
|
|
name: Mapped[str] = mapped_column(String(255))
|
|
href: Mapped[Optional[str]] = mapped_column(String(255))
|
|
created_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
updated_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
details: Mapped[Optional[str]] = mapped_column(Text)
|
|
|
|
iafd_movies: Mapped[List['IafdMovies']] = relationship('IafdMovies', back_populates='distributor')
|
|
|
|
|
|
class IafdMetaEthnic(Base):
|
|
__tablename__ = 'iafd_meta_ethnic'
|
|
|
|
id: Mapped[int] = mapped_column(Integer, primary_key=True)
|
|
name: Mapped[str] = mapped_column(String(255))
|
|
href: Mapped[Optional[str]] = mapped_column(String(255))
|
|
created_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
|
|
|
|
class IafdPerformers(Base):
|
|
__tablename__ = 'iafd_performers'
|
|
|
|
name: Mapped[str] = mapped_column(Text)
|
|
is_full_data: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
birth_year: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
from_astro_list: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
from_birth_list: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
from_ethnic_list: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
from_movie_list: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
id: Mapped[Optional[int]] = mapped_column(Integer, primary_key=True)
|
|
gender: Mapped[Optional[str]] = mapped_column(Text)
|
|
birthday: Mapped[Optional[str]] = mapped_column(Text)
|
|
astrology: Mapped[Optional[str]] = mapped_column(Text)
|
|
birthplace: Mapped[Optional[str]] = mapped_column(Text)
|
|
years_active: Mapped[Optional[str]] = mapped_column(Text)
|
|
ethnicity: Mapped[Optional[str]] = mapped_column(Text)
|
|
nationality: Mapped[Optional[str]] = mapped_column(Text)
|
|
hair_colors: Mapped[Optional[str]] = mapped_column(Text)
|
|
eye_color: Mapped[Optional[str]] = mapped_column(Text)
|
|
height_str: Mapped[Optional[str]] = mapped_column(Text)
|
|
weight_str: Mapped[Optional[str]] = mapped_column(Text)
|
|
measurements: Mapped[Optional[str]] = mapped_column(Text)
|
|
tattoos: Mapped[Optional[str]] = mapped_column(Text)
|
|
piercings: Mapped[Optional[str]] = mapped_column(Text)
|
|
fake_tits: Mapped[Optional[str]] = mapped_column(Text)
|
|
href: Mapped[Optional[str]] = mapped_column(Text, unique=True)
|
|
created_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
updated_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
weight: Mapped[Optional[int]] = mapped_column(Integer)
|
|
height: Mapped[Optional[int]] = mapped_column(Integer)
|
|
rating: Mapped[Optional[int]] = mapped_column(Integer)
|
|
movies_cnt: Mapped[Optional[int]] = mapped_column(Integer)
|
|
vixen_cnt: Mapped[Optional[int]] = mapped_column(Integer)
|
|
blacked_cnt: Mapped[Optional[int]] = mapped_column(Integer)
|
|
tushy_cnt: Mapped[Optional[int]] = mapped_column(Integer)
|
|
x_art_cnt: Mapped[Optional[int]] = mapped_column(Integer)
|
|
|
|
iafd_performer_aliases: Mapped[List['IafdPerformerAliases']] = relationship('IafdPerformerAliases', back_populates='performer')
|
|
iafd_performer_urls: Mapped[List['IafdPerformerUrls']] = relationship('IafdPerformerUrls', back_populates='performer')
|
|
iafd_performers_movies: Mapped[List['IafdPerformersMovies']] = relationship('IafdPerformersMovies', back_populates='performer')
|
|
|
|
|
|
class IafdStudios(Base):
|
|
__tablename__ = 'iafd_studios'
|
|
|
|
id: Mapped[int] = mapped_column(Integer, primary_key=True)
|
|
name: Mapped[str] = mapped_column(String(255))
|
|
href: Mapped[Optional[str]] = mapped_column(String(255))
|
|
created_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
updated_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
details: Mapped[Optional[str]] = mapped_column(Text)
|
|
|
|
iafd_movies: Mapped[List['IafdMovies']] = relationship('IafdMovies', back_populates='studio')
|
|
|
|
|
|
class IafdTaskLog(Base):
|
|
__tablename__ = 'iafd_task_log'
|
|
|
|
task_id: Mapped[int] = mapped_column(Integer, primary_key=True)
|
|
full_data_performers: Mapped[Optional[int]] = mapped_column(Integer)
|
|
total_performers: Mapped[Optional[int]] = mapped_column(Integer)
|
|
full_data_movies: Mapped[Optional[int]] = mapped_column(Integer)
|
|
total_movies: Mapped[Optional[int]] = mapped_column(Integer)
|
|
total_distributors: Mapped[Optional[int]] = mapped_column(Integer)
|
|
total_studios: Mapped[Optional[int]] = mapped_column(Integer)
|
|
task_status: Mapped[Optional[str]] = mapped_column(String(255))
|
|
created_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
updated_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
|
|
|
|
class JavbusActors(Base):
|
|
__tablename__ = 'javbus_actors'
|
|
|
|
uncensored: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
is_full_data: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
from_actor_list: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
from_movie_list: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
movies_cnt: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
id: Mapped[Optional[int]] = mapped_column(Integer, primary_key=True)
|
|
ja_name: Mapped[Optional[str]] = mapped_column(Text)
|
|
zh_name: Mapped[Optional[str]] = mapped_column(Text)
|
|
en_name: Mapped[Optional[str]] = mapped_column(Text)
|
|
href: Mapped[Optional[str]] = mapped_column(Text, unique=True)
|
|
pic: Mapped[Optional[str]] = mapped_column(Text)
|
|
birth_date: Mapped[Optional[str]] = mapped_column(Text)
|
|
height: Mapped[Optional[str]] = mapped_column(Text)
|
|
breast_size: Mapped[Optional[str]] = mapped_column(Text)
|
|
measurements: Mapped[Optional[str]] = mapped_column(Text)
|
|
created_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
updated_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
|
|
javbus_actors_movies: Mapped[List['JavbusActorsMovies']] = relationship('JavbusActorsMovies', back_populates='actor')
|
|
|
|
|
|
class JavbusLabels(Base):
|
|
__tablename__ = 'javbus_labels'
|
|
|
|
id: Mapped[int] = mapped_column(Integer, primary_key=True)
|
|
name: Mapped[Optional[str]] = mapped_column(String(255))
|
|
en_name: Mapped[Optional[str]] = mapped_column(String(255))
|
|
ja_name: Mapped[Optional[str]] = mapped_column(String(255))
|
|
href: Mapped[Optional[str]] = mapped_column(String(255))
|
|
details: Mapped[Optional[str]] = mapped_column(Text)
|
|
uncensored: Mapped[Optional[int]] = mapped_column(Integer, server_default=text('0'))
|
|
from_list: Mapped[Optional[int]] = mapped_column(Integer, server_default=text('0'))
|
|
from_movie_list: Mapped[Optional[int]] = mapped_column(Integer, server_default=text('0'))
|
|
created_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
updated_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
movies_cnt: Mapped[Optional[int]] = mapped_column(Integer, server_default=text('0'))
|
|
magnet_cnt: Mapped[Optional[int]] = mapped_column(Integer, server_default=text('0'))
|
|
|
|
|
|
class JavbusMovies(Base):
|
|
__tablename__ = 'javbus_movies'
|
|
|
|
is_full_data: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
uncensored: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
from_actor_list: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
from_movie_studios: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
from_movie_labels: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
from_movie_series: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
actors_cnt: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
id: Mapped[Optional[int]] = mapped_column(Integer, primary_key=True)
|
|
href: Mapped[Optional[str]] = mapped_column(Text, unique=True)
|
|
title: Mapped[Optional[str]] = mapped_column(Text)
|
|
cover_url: Mapped[Optional[str]] = mapped_column(Text)
|
|
serial_number: Mapped[Optional[str]] = mapped_column(Text)
|
|
release_date: Mapped[Optional[str]] = mapped_column(Text)
|
|
duration: Mapped[Optional[str]] = mapped_column(Text)
|
|
studio_id: Mapped[Optional[int]] = mapped_column(Integer)
|
|
label_id: Mapped[Optional[int]] = mapped_column(Integer)
|
|
series_id: Mapped[Optional[int]] = mapped_column(Integer)
|
|
created_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
updated_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
|
|
javbus_actors_movies: Mapped[List['JavbusActorsMovies']] = relationship('JavbusActorsMovies', back_populates='movie')
|
|
javbus_movies_tags: Mapped[List['JavbusMoviesTags']] = relationship('JavbusMoviesTags', back_populates='movie')
|
|
|
|
|
|
class JavbusSeries(Base):
|
|
__tablename__ = 'javbus_series'
|
|
|
|
id: Mapped[int] = mapped_column(Integer, primary_key=True)
|
|
name: Mapped[Optional[str]] = mapped_column(String(255))
|
|
en_name: Mapped[Optional[str]] = mapped_column(String(255))
|
|
ja_name: Mapped[Optional[str]] = mapped_column(String(255))
|
|
href: Mapped[Optional[str]] = mapped_column(String(255))
|
|
details: Mapped[Optional[str]] = mapped_column(Text)
|
|
uncensored: Mapped[Optional[int]] = mapped_column(Integer, server_default=text('0'))
|
|
from_list: Mapped[Optional[int]] = mapped_column(Integer, server_default=text('0'))
|
|
from_movie_list: Mapped[Optional[int]] = mapped_column(Integer, server_default=text('0'))
|
|
created_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
updated_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
movies_cnt: Mapped[Optional[int]] = mapped_column(Integer, server_default=text('0'))
|
|
magnet_cnt: Mapped[Optional[int]] = mapped_column(Integer, server_default=text('0'))
|
|
|
|
|
|
class JavbusStudios(Base):
|
|
__tablename__ = 'javbus_studios'
|
|
|
|
id: Mapped[int] = mapped_column(Integer, primary_key=True)
|
|
name: Mapped[Optional[str]] = mapped_column(String(255))
|
|
en_name: Mapped[Optional[str]] = mapped_column(String(255))
|
|
ja_name: Mapped[Optional[str]] = mapped_column(String(255))
|
|
href: Mapped[Optional[str]] = mapped_column(String(255))
|
|
details: Mapped[Optional[str]] = mapped_column(Text)
|
|
uncensored: Mapped[Optional[int]] = mapped_column(Integer, server_default=text('0'))
|
|
from_list: Mapped[Optional[int]] = mapped_column(Integer, server_default=text('0'))
|
|
from_movie_list: Mapped[Optional[int]] = mapped_column(Integer, server_default=text('0'))
|
|
created_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
updated_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
movies_cnt: Mapped[Optional[int]] = mapped_column(Integer, server_default=text('0'))
|
|
magnet_cnt: Mapped[Optional[int]] = mapped_column(Integer, server_default=text('0'))
|
|
|
|
|
|
class JavbusTags(Base):
|
|
__tablename__ = 'javbus_tags'
|
|
|
|
id: Mapped[int] = mapped_column(Integer, primary_key=True)
|
|
name: Mapped[Optional[str]] = mapped_column(String(255))
|
|
en_name: Mapped[Optional[str]] = mapped_column(String(255))
|
|
ja_name: Mapped[Optional[str]] = mapped_column(String(255))
|
|
href: Mapped[Optional[str]] = mapped_column(String(255))
|
|
created_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
updated_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
|
|
javbus_movies_tags: Mapped[List['JavbusMoviesTags']] = relationship('JavbusMoviesTags', back_populates='tag')
|
|
|
|
|
|
class JavdbActors(Base):
|
|
__tablename__ = 'javdb_actors'
|
|
|
|
name: Mapped[str] = mapped_column(Text)
|
|
href: Mapped[str] = mapped_column(Text, unique=True)
|
|
is_full_data: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
from_actor_list: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
from_movie_list: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
movies_cnt: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
uncensored: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
id: Mapped[Optional[int]] = mapped_column(Integer, primary_key=True)
|
|
pic: Mapped[Optional[str]] = mapped_column(Text)
|
|
created_at: Mapped[Optional[datetime.datetime]] = mapped_column(DateTime, server_default=text("datetime('now', 'localtime')"))
|
|
updated_at: Mapped[Optional[datetime.datetime]] = mapped_column(DateTime, server_default=text("datetime('now', 'localtime')"))
|
|
|
|
javdb_actors_alias: Mapped[List['JavdbActorsAlias']] = relationship('JavdbActorsAlias', back_populates='actor')
|
|
javdb_actors_movies: Mapped[List['JavdbActorsMovies']] = relationship('JavdbActorsMovies', back_populates='actor')
|
|
|
|
|
|
class JavdbMakers(Base):
|
|
__tablename__ = 'javdb_makers'
|
|
|
|
id: Mapped[int] = mapped_column(Integer, primary_key=True)
|
|
name: Mapped[str] = mapped_column(String(255))
|
|
href: Mapped[Optional[str]] = mapped_column(String(255))
|
|
created_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
updated_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
details: Mapped[Optional[str]] = mapped_column(Text)
|
|
from_list: Mapped[Optional[int]] = mapped_column(Integer, server_default=text('0'))
|
|
from_movie_list: Mapped[Optional[int]] = mapped_column(Integer, server_default=text('0'))
|
|
|
|
|
|
class JavdbMovies(Base):
|
|
__tablename__ = 'javdb_movies'
|
|
|
|
is_full_data: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
from_actor_list: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
from_movie_makers: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
from_movie_series: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
from_movie_publishers: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
uncensored: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
id: Mapped[Optional[int]] = mapped_column(Integer, primary_key=True)
|
|
href: Mapped[Optional[str]] = mapped_column(Text, unique=True)
|
|
title: Mapped[Optional[str]] = mapped_column(Text)
|
|
cover_url: Mapped[Optional[str]] = mapped_column(Text)
|
|
serial_number: Mapped[Optional[str]] = mapped_column(Text)
|
|
release_date: Mapped[Optional[str]] = mapped_column(Text)
|
|
duration: Mapped[Optional[str]] = mapped_column(Text)
|
|
maker_id: Mapped[Optional[str]] = mapped_column(Text)
|
|
series_id: Mapped[Optional[str]] = mapped_column(Text)
|
|
created_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
updated_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
pub_id: Mapped[Optional[int]] = mapped_column(Integer)
|
|
|
|
javdb_actors_movies: Mapped[List['JavdbActorsMovies']] = relationship('JavdbActorsMovies', back_populates='movie')
|
|
javdb_movies_tags: Mapped[List['JavdbMoviesTags']] = relationship('JavdbMoviesTags', back_populates='movie')
|
|
|
|
|
|
class JavdbPublishers(Base):
|
|
__tablename__ = 'javdb_publishers'
|
|
|
|
id: Mapped[int] = mapped_column(Integer, primary_key=True)
|
|
name: Mapped[str] = mapped_column(String(255))
|
|
href: Mapped[Optional[str]] = mapped_column(String(255))
|
|
created_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
updated_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
details: Mapped[Optional[str]] = mapped_column(Text)
|
|
from_list: Mapped[Optional[int]] = mapped_column(Integer, server_default=text('0'))
|
|
from_movie_list: Mapped[Optional[int]] = mapped_column(Integer, server_default=text('0'))
|
|
|
|
|
|
class JavdbSeries(Base):
|
|
__tablename__ = 'javdb_series'
|
|
|
|
id: Mapped[int] = mapped_column(Integer, primary_key=True)
|
|
name: Mapped[str] = mapped_column(String(255))
|
|
href: Mapped[Optional[str]] = mapped_column(String(255))
|
|
created_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
updated_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
details: Mapped[Optional[str]] = mapped_column(Text)
|
|
from_list: Mapped[Optional[int]] = mapped_column(Integer, server_default=text('0'))
|
|
from_movie_list: Mapped[Optional[int]] = mapped_column(Integer, server_default=text('0'))
|
|
|
|
|
|
class JavdbTags(Base):
|
|
__tablename__ = 'javdb_tags'
|
|
|
|
id: Mapped[int] = mapped_column(Integer, primary_key=True)
|
|
name: Mapped[str] = mapped_column(String(255))
|
|
href: Mapped[Optional[str]] = mapped_column(String(255))
|
|
created_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
updated_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
|
|
javdb_movies_tags: Mapped[List['JavdbMoviesTags']] = relationship('JavdbMoviesTags', back_populates='tag')
|
|
|
|
|
|
class JavdbTaskLog(Base):
|
|
__tablename__ = 'javdb_task_log'
|
|
|
|
task_id: Mapped[int] = mapped_column(Integer, primary_key=True)
|
|
full_data_actors: Mapped[Optional[int]] = mapped_column(Integer)
|
|
total_actors: Mapped[Optional[int]] = mapped_column(Integer)
|
|
full_data_movies: Mapped[Optional[int]] = mapped_column(Integer)
|
|
total_movies: Mapped[Optional[int]] = mapped_column(Integer)
|
|
total_makers: Mapped[Optional[int]] = mapped_column(Integer)
|
|
total_series: Mapped[Optional[int]] = mapped_column(Integer)
|
|
task_status: Mapped[Optional[str]] = mapped_column(String(255))
|
|
created_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
updated_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
|
|
|
|
class JavhdModels(Base):
|
|
__tablename__ = 'javhd_models'
|
|
|
|
is_full_data: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
id: Mapped[Optional[int]] = mapped_column(Integer, primary_key=True)
|
|
rank: Mapped[Optional[int]] = mapped_column(Integer)
|
|
ja_name: Mapped[Optional[str]] = mapped_column(Text)
|
|
zh_name: Mapped[Optional[str]] = mapped_column(Text)
|
|
en_name: Mapped[Optional[str]] = mapped_column(Text)
|
|
url: Mapped[Optional[str]] = mapped_column(Text, unique=True)
|
|
pic: Mapped[Optional[str]] = mapped_column(Text)
|
|
height: Mapped[Optional[str]] = mapped_column(Text)
|
|
weight: Mapped[Optional[str]] = mapped_column(Text)
|
|
breast_size: Mapped[Optional[str]] = mapped_column(Text)
|
|
breast_factor: Mapped[Optional[str]] = mapped_column(Text)
|
|
hair_color: Mapped[Optional[str]] = mapped_column(Text)
|
|
eye_color: Mapped[Optional[str]] = mapped_column(Text)
|
|
birth_date: Mapped[Optional[str]] = mapped_column(Text)
|
|
ethnicity: Mapped[Optional[str]] = mapped_column(Text)
|
|
birth_place: Mapped[Optional[str]] = mapped_column(Text)
|
|
created_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
updated_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
|
|
|
|
class PboxActors(Base):
|
|
__tablename__ = 'pbox_actors'
|
|
|
|
name: Mapped[str] = mapped_column(Text)
|
|
movies_cnt: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
is_full_data: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
id: Mapped[Optional[int]] = mapped_column(Integer, primary_key=True)
|
|
href: Mapped[Optional[str]] = mapped_column(Text, unique=True)
|
|
gender: Mapped[Optional[str]] = mapped_column(Text)
|
|
age: Mapped[Optional[int]] = mapped_column(Integer)
|
|
nationality: Mapped[Optional[str]] = mapped_column(Text)
|
|
country: Mapped[Optional[str]] = mapped_column(Text)
|
|
created_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
updated_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
|
|
pbox_actor_aliases: Mapped[List['PboxActorAliases']] = relationship('PboxActorAliases', back_populates='actor')
|
|
pbox_actors_movies: Mapped[List['PboxActorsMovies']] = relationship('PboxActorsMovies', back_populates='actor')
|
|
|
|
|
|
class PboxStudios(Base):
|
|
__tablename__ = 'pbox_studios'
|
|
|
|
id: Mapped[int] = mapped_column(Integer, primary_key=True)
|
|
name: Mapped[str] = mapped_column(String(255))
|
|
label_id: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
scene_count: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
href: Mapped[Optional[str]] = mapped_column(String(255))
|
|
created_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
updated_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
description: Mapped[Optional[str]] = mapped_column(Text)
|
|
|
|
pbox_movies: Mapped[List['PboxMovies']] = relationship('PboxMovies', back_populates='studio')
|
|
|
|
|
|
class PboxTags(Base):
|
|
__tablename__ = 'pbox_tags'
|
|
|
|
id: Mapped[int] = mapped_column(Integer, primary_key=True)
|
|
name: Mapped[str] = mapped_column(String(255))
|
|
href: Mapped[Optional[str]] = mapped_column(String(255))
|
|
tag_id: Mapped[Optional[int]] = mapped_column(Integer)
|
|
created_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
updated_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
|
|
pbox_movies_tags: Mapped[List['PboxMoviesTags']] = relationship('PboxMoviesTags', back_populates='tag')
|
|
|
|
|
|
class ThelordofpornActress(Base):
|
|
__tablename__ = 'thelordofporn_actress'
|
|
|
|
is_full_data: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
id: Mapped[Optional[int]] = mapped_column(Integer, primary_key=True)
|
|
pornstar: Mapped[Optional[str]] = mapped_column(Text)
|
|
rating: Mapped[Optional[float]] = mapped_column(REAL)
|
|
rank: Mapped[Optional[int]] = mapped_column(Integer)
|
|
votes: Mapped[Optional[int]] = mapped_column(Integer)
|
|
href: Mapped[Optional[str]] = mapped_column(Text, unique=True)
|
|
career_start: Mapped[Optional[str]] = mapped_column(Text)
|
|
measurements: Mapped[Optional[str]] = mapped_column(Text)
|
|
born: Mapped[Optional[str]] = mapped_column(Text)
|
|
height: Mapped[Optional[str]] = mapped_column(Text)
|
|
weight: Mapped[Optional[str]] = mapped_column(Text)
|
|
date_modified: Mapped[Optional[str]] = mapped_column(Text)
|
|
global_rank: Mapped[Optional[int]] = mapped_column(Integer)
|
|
weekly_rank: Mapped[Optional[int]] = mapped_column(Integer)
|
|
last_month_rating: Mapped[Optional[float]] = mapped_column(REAL)
|
|
current_rating: Mapped[Optional[float]] = mapped_column(REAL)
|
|
total_votes: Mapped[Optional[int]] = mapped_column(Integer)
|
|
birth_date: Mapped[Optional[str]] = mapped_column(Text)
|
|
birth_year: Mapped[Optional[str]] = mapped_column(Text)
|
|
birth_place: Mapped[Optional[str]] = mapped_column(Text)
|
|
height_ft: Mapped[Optional[str]] = mapped_column(Text)
|
|
height_cm: Mapped[Optional[str]] = mapped_column(Text)
|
|
weight_lbs: Mapped[Optional[str]] = mapped_column(Text)
|
|
weight_kg: Mapped[Optional[str]] = mapped_column(Text)
|
|
created_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
updated_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
|
|
thelordofporn_alias: Mapped[List['ThelordofpornAlias']] = relationship('ThelordofpornAlias', back_populates='actress')
|
|
|
|
|
|
class IafdMovies(Base):
|
|
__tablename__ = 'iafd_movies'
|
|
|
|
id: Mapped[int] = mapped_column(Integer, primary_key=True)
|
|
is_full_data: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
release_year: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
from_performer_list: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
from_dist_list: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
from_stu_list: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
title: Mapped[Optional[str]] = mapped_column(String(255))
|
|
minutes: Mapped[Optional[str]] = mapped_column(String(255))
|
|
distributor_id: Mapped[Optional[int]] = mapped_column(ForeignKey('iafd_distributors.id'))
|
|
studio_id: Mapped[Optional[int]] = mapped_column(ForeignKey('iafd_studios.id'))
|
|
release_date: Mapped[Optional[str]] = mapped_column(String(255))
|
|
added_to_IAFD_date: Mapped[Optional[str]] = mapped_column(String(255))
|
|
all_girl: Mapped[Optional[str]] = mapped_column(String(255))
|
|
all_male: Mapped[Optional[str]] = mapped_column(String(255))
|
|
compilation: Mapped[Optional[str]] = mapped_column(String(255))
|
|
webscene: Mapped[Optional[str]] = mapped_column(String(255))
|
|
director_id: Mapped[Optional[int]] = mapped_column(Integer)
|
|
href: Mapped[Optional[str]] = mapped_column(String(255))
|
|
created_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
updated_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
|
|
distributor: Mapped[Optional['IafdDistributors']] = relationship('IafdDistributors', back_populates='iafd_movies')
|
|
studio: Mapped[Optional['IafdStudios']] = relationship('IafdStudios', back_populates='iafd_movies')
|
|
iafd_movies_appers_in: Mapped[List['IafdMoviesAppersIn']] = relationship('IafdMoviesAppersIn', foreign_keys='[IafdMoviesAppersIn.appears_in_id]', back_populates='appears_in')
|
|
iafd_movies_appers_in_: Mapped[List['IafdMoviesAppersIn']] = relationship('IafdMoviesAppersIn', foreign_keys='[IafdMoviesAppersIn.movie_id]', back_populates='movie')
|
|
iafd_performers_movies: Mapped[List['IafdPerformersMovies']] = relationship('IafdPerformersMovies', back_populates='movie')
|
|
|
|
|
|
class IafdPerformerAliases(Base):
|
|
__tablename__ = 'iafd_performer_aliases'
|
|
|
|
performer_id: Mapped[int] = mapped_column(ForeignKey('iafd_performers.id'), primary_key=True)
|
|
alias: Mapped[str] = mapped_column(String(255), primary_key=True)
|
|
|
|
performer: Mapped['IafdPerformers'] = relationship('IafdPerformers', back_populates='iafd_performer_aliases')
|
|
|
|
|
|
class IafdPerformerUrls(Base):
|
|
__tablename__ = 'iafd_performer_urls'
|
|
|
|
performer_id: Mapped[int] = mapped_column(ForeignKey('iafd_performers.id'), primary_key=True)
|
|
position: Mapped[str] = mapped_column(String(255), primary_key=True)
|
|
url: Mapped[str] = mapped_column(String(255), primary_key=True)
|
|
|
|
performer: Mapped['IafdPerformers'] = relationship('IafdPerformers', back_populates='iafd_performer_urls')
|
|
|
|
|
|
class JavbusActorsMovies(Base):
|
|
__tablename__ = 'javbus_actors_movies'
|
|
__table_args__ = (
|
|
Index('idx_actor_movie_actor_id', 'actor_id'),
|
|
)
|
|
|
|
actor_id: Mapped[Optional[int]] = mapped_column(ForeignKey('javbus_actors.id'), primary_key=True)
|
|
movie_id: Mapped[Optional[int]] = mapped_column(ForeignKey('javbus_movies.id'), primary_key=True)
|
|
tags: Mapped[Optional[str]] = mapped_column(Text)
|
|
created_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
updated_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
|
|
actor: Mapped[Optional['JavbusActors']] = relationship('JavbusActors', back_populates='javbus_actors_movies')
|
|
movie: Mapped[Optional['JavbusMovies']] = relationship('JavbusMovies', back_populates='javbus_actors_movies')
|
|
|
|
|
|
class JavbusMoviesTags(Base):
|
|
__tablename__ = 'javbus_movies_tags'
|
|
|
|
movie_id: Mapped[Optional[int]] = mapped_column(ForeignKey('javbus_movies.id'), primary_key=True)
|
|
tag_id: Mapped[Optional[int]] = mapped_column(ForeignKey('javbus_tags.id'), primary_key=True)
|
|
tags: Mapped[Optional[str]] = mapped_column(Text)
|
|
created_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
updated_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
|
|
movie: Mapped[Optional['JavbusMovies']] = relationship('JavbusMovies', back_populates='javbus_movies_tags')
|
|
tag: Mapped[Optional['JavbusTags']] = relationship('JavbusTags', back_populates='javbus_movies_tags')
|
|
|
|
|
|
class JavdbActorsAlias(Base):
|
|
__tablename__ = 'javdb_actors_alias'
|
|
|
|
actor_id: Mapped[int] = mapped_column(ForeignKey('javdb_actors.id', ondelete='CASCADE'), primary_key=True)
|
|
alias: Mapped[str] = mapped_column(Text, primary_key=True)
|
|
created_at: Mapped[Optional[datetime.datetime]] = mapped_column(DateTime, server_default=text("datetime('now', 'localtime')"))
|
|
updated_at: Mapped[Optional[datetime.datetime]] = mapped_column(DateTime, server_default=text("datetime('now', 'localtime')"))
|
|
|
|
actor: Mapped['JavdbActors'] = relationship('JavdbActors', back_populates='javdb_actors_alias')
|
|
|
|
|
|
class JavdbActorsMovies(Base):
|
|
__tablename__ = 'javdb_actors_movies'
|
|
|
|
actor_id: Mapped[Optional[int]] = mapped_column(ForeignKey('javdb_actors.id'), primary_key=True)
|
|
movie_id: Mapped[Optional[int]] = mapped_column(ForeignKey('javdb_movies.id'), primary_key=True)
|
|
tags: Mapped[Optional[str]] = mapped_column(Text)
|
|
created_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
updated_at: Mapped[Optional[str]] = mapped_column(Text)
|
|
|
|
actor: Mapped[Optional['JavdbActors']] = relationship('JavdbActors', back_populates='javdb_actors_movies')
|
|
movie: Mapped[Optional['JavdbMovies']] = relationship('JavdbMovies', back_populates='javdb_actors_movies')
|
|
|
|
|
|
class JavdbMoviesTags(Base):
|
|
__tablename__ = 'javdb_movies_tags'
|
|
|
|
movie_id: Mapped[Optional[int]] = mapped_column(ForeignKey('javdb_movies.id'), primary_key=True)
|
|
tag_id: Mapped[Optional[int]] = mapped_column(ForeignKey('javdb_tags.id'), primary_key=True)
|
|
tags: Mapped[Optional[str]] = mapped_column(Text)
|
|
created_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
updated_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
|
|
movie: Mapped[Optional['JavdbMovies']] = relationship('JavdbMovies', back_populates='javdb_movies_tags')
|
|
tag: Mapped[Optional['JavdbTags']] = relationship('JavdbTags', back_populates='javdb_movies_tags')
|
|
|
|
|
|
class PboxActorAliases(Base):
|
|
__tablename__ = 'pbox_actor_aliases'
|
|
|
|
id: Mapped[int] = mapped_column(Integer, primary_key=True)
|
|
actor_id: Mapped[int] = mapped_column(ForeignKey('pbox_actors.id'))
|
|
alias: Mapped[str] = mapped_column(String(255))
|
|
actor_alias: Mapped[Optional[str]] = mapped_column(String(255))
|
|
created_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
updated_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
|
|
actor: Mapped['PboxActors'] = relationship('PboxActors', back_populates='pbox_actor_aliases')
|
|
|
|
|
|
class PboxMovies(Base):
|
|
__tablename__ = 'pbox_movies'
|
|
|
|
id: Mapped[int] = mapped_column(Integer, primary_key=True)
|
|
is_full_data: Mapped[int] = mapped_column(Integer, server_default=text('0'))
|
|
href: Mapped[Optional[str]] = mapped_column(String(255))
|
|
title: Mapped[Optional[str]] = mapped_column(String(255))
|
|
movie_id: Mapped[Optional[int]] = mapped_column(Integer)
|
|
content_id: Mapped[Optional[int]] = mapped_column(Integer)
|
|
duration: Mapped[Optional[str]] = mapped_column(String(255))
|
|
publish_date: Mapped[Optional[str]] = mapped_column(String(255))
|
|
release_date: Mapped[Optional[str]] = mapped_column(String(255))
|
|
studio_id: Mapped[Optional[int]] = mapped_column(ForeignKey('pbox_studios.id'))
|
|
created_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
updated_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
|
|
studio: Mapped[Optional['PboxStudios']] = relationship('PboxStudios', back_populates='pbox_movies')
|
|
pbox_actors_movies: Mapped[List['PboxActorsMovies']] = relationship('PboxActorsMovies', back_populates='movie')
|
|
pbox_movies_alts: Mapped[List['PboxMoviesAlts']] = relationship('PboxMoviesAlts', foreign_keys='[PboxMoviesAlts.max_mov_id]', back_populates='max_mov')
|
|
pbox_movies_alts_: Mapped[List['PboxMoviesAlts']] = relationship('PboxMoviesAlts', foreign_keys='[PboxMoviesAlts.min_mov_id]', back_populates='min_mov')
|
|
pbox_movies_tags: Mapped[List['PboxMoviesTags']] = relationship('PboxMoviesTags', back_populates='movie')
|
|
|
|
|
|
class ThelordofpornAlias(Base):
|
|
__tablename__ = 'thelordofporn_alias'
|
|
|
|
actress_id: Mapped[int] = mapped_column(ForeignKey('thelordofporn_actress.id', ondelete='CASCADE'), primary_key=True)
|
|
alias: Mapped[str] = mapped_column(Text, primary_key=True)
|
|
updated_at: Mapped[Optional[str]] = mapped_column(Text)
|
|
|
|
actress: Mapped['ThelordofpornActress'] = relationship('ThelordofpornActress', back_populates='thelordofporn_alias')
|
|
|
|
|
|
class IafdMoviesAppersIn(Base):
|
|
__tablename__ = 'iafd_movies_appers_in'
|
|
|
|
movie_id: Mapped[Optional[int]] = mapped_column(ForeignKey('iafd_movies.id'), primary_key=True)
|
|
appears_in_id: Mapped[Optional[int]] = mapped_column(ForeignKey('iafd_movies.id'), primary_key=True)
|
|
gradation: Mapped[Optional[int]] = mapped_column(Integer)
|
|
notes: Mapped[Optional[str]] = mapped_column(String(255))
|
|
|
|
appears_in: Mapped[Optional['IafdMovies']] = relationship('IafdMovies', foreign_keys=[appears_in_id], back_populates='iafd_movies_appers_in')
|
|
movie: Mapped[Optional['IafdMovies']] = relationship('IafdMovies', foreign_keys=[movie_id], back_populates='iafd_movies_appers_in_')
|
|
|
|
|
|
class IafdPerformersMovies(Base):
|
|
__tablename__ = 'iafd_performers_movies'
|
|
__table_args__ = (
|
|
Index('idx_iafd_performers_movies_performer_id', 'performer_id'),
|
|
)
|
|
|
|
performer_id: Mapped[Optional[int]] = mapped_column(ForeignKey('iafd_performers.id'), primary_key=True)
|
|
movie_id: Mapped[Optional[int]] = mapped_column(ForeignKey('iafd_movies.id'), primary_key=True)
|
|
role: Mapped[Optional[str]] = mapped_column(String(255))
|
|
notes: Mapped[Optional[str]] = mapped_column(String(255))
|
|
created_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
|
|
movie: Mapped[Optional['IafdMovies']] = relationship('IafdMovies', back_populates='iafd_performers_movies')
|
|
performer: Mapped[Optional['IafdPerformers']] = relationship('IafdPerformers', back_populates='iafd_performers_movies')
|
|
|
|
|
|
class PboxActorsMovies(Base):
|
|
__tablename__ = 'pbox_actors_movies'
|
|
|
|
id: Mapped[int] = mapped_column(Integer, primary_key=True)
|
|
actor_id: Mapped[Optional[int]] = mapped_column(ForeignKey('pbox_actors.id'))
|
|
movie_id: Mapped[Optional[int]] = mapped_column(ForeignKey('pbox_movies.id'))
|
|
actor_mov: Mapped[Optional[str]] = mapped_column(String(255))
|
|
created_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
updated_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
tags: Mapped[Optional[str]] = mapped_column(Text)
|
|
|
|
actor: Mapped[Optional['PboxActors']] = relationship('PboxActors', back_populates='pbox_actors_movies')
|
|
movie: Mapped[Optional['PboxMovies']] = relationship('PboxMovies', back_populates='pbox_actors_movies')
|
|
|
|
|
|
class PboxMoviesAlts(Base):
|
|
__tablename__ = 'pbox_movies_alts'
|
|
|
|
id: Mapped[int] = mapped_column(Integer, primary_key=True)
|
|
min_mov_id: Mapped[Optional[int]] = mapped_column(ForeignKey('pbox_movies.id'))
|
|
max_mov_id: Mapped[Optional[int]] = mapped_column(ForeignKey('pbox_movies.id'))
|
|
min_max: Mapped[Optional[str]] = mapped_column(String(255))
|
|
created_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
updated_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
|
|
max_mov: Mapped[Optional['PboxMovies']] = relationship('PboxMovies', foreign_keys=[max_mov_id], back_populates='pbox_movies_alts')
|
|
min_mov: Mapped[Optional['PboxMovies']] = relationship('PboxMovies', foreign_keys=[min_mov_id], back_populates='pbox_movies_alts_')
|
|
|
|
|
|
class PboxMoviesTags(Base):
|
|
__tablename__ = 'pbox_movies_tags'
|
|
|
|
id: Mapped[int] = mapped_column(Integer, primary_key=True)
|
|
movie_id: Mapped[Optional[int]] = mapped_column(ForeignKey('pbox_movies.id'))
|
|
tag_id: Mapped[Optional[int]] = mapped_column(ForeignKey('pbox_tags.id'))
|
|
movid_tagid: Mapped[Optional[str]] = mapped_column(String(255))
|
|
tags: Mapped[Optional[str]] = mapped_column(Text)
|
|
created_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
updated_at: Mapped[Optional[str]] = mapped_column(Text, server_default=text("datetime('now', 'localtime')"))
|
|
|
|
movie: Mapped[Optional['PboxMovies']] = relationship('PboxMovies', back_populates='pbox_movies_tags')
|
|
tag: Mapped[Optional['PboxTags']] = relationship('PboxTags', back_populates='pbox_movies_tags')
|