Repository navigation
Expand file tree
/
Copy pathdatabase.py
More file actions
41 lines (32 loc) · 1.63 KB
/
Copy pathdatabase.py
File metadata and controls
41 lines (32 loc) · 1.63 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
#database.py
from status import ArtworkScanStatus, SimilarArtworkStatus
from sqlalchemy import create_engine, Column, ForeignKey, Integer, String, DateTime, LargeBinary, Boolean, UniqueConstraint
from sqlalchemy.orm import declarative_base, sessionmaker
from datetime import datetime, timezone
from load_env import DATABASE_URL
engine = create_engine(DATABASE_URL)
SessionLocal = sessionmaker(bind=engine)
Base = declarative_base()
class Artwork(Base):
__tablename__ = "artworks"
id = Column(Integer, primary_key=True, index=True)
user_id = Column(String, nullable=False)
filename = Column(String, nullable=False)
filepath = Column(String, nullable=True)
embedding = Column(LargeBinary, nullable=False)
time_uploaded = Column(DateTime(timezone=True), default=lambda: datetime.now(timezone.utc))
scan_status = Column(String, nullable=False, server_default=ArtworkScanStatus.IDLE)
scan_started_at = Column(DateTime(timezone=True), nullable=True)
last_scanned_at = Column(DateTime(timezone=True), nullable=True)
class SimilarArtwork(Base):
__tablename__ = "similar_artworks"
__table_args__ = (
UniqueConstraint("artwork_id", "url", name="uq_artwork_url"),
)
id = Column(Integer, primary_key=True, index=True)
artwork_id = Column(Integer, ForeignKey("artworks.id"), nullable=False)
url = Column(String, nullable=False)
similarity_score = Column(Integer, nullable=False)
is_similar = Column(Boolean, nullable=False)
time_scanned = Column(DateTime(timezone=True), default=lambda: datetime.now(timezone.utc))
status = Column(String, nullable=False, default=SimilarArtworkStatus.NEW)