-
Notifications
You must be signed in to change notification settings - Fork 0
/
models.py
50 lines (37 loc) · 1.82 KB
/
models.py
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
42
43
44
45
46
47
48
49
50
from datetime import datetime
from sqlalchemy import Column, Integer, String, DateTime, ForeignKey
from sqlalchemy.orm import relationship, declarative_base, DeclarativeMeta
Base: DeclarativeMeta = declarative_base()
class User(Base):
__tablename__ = "users"
id = Column(Integer, primary_key=True)
email = Column(String, nullable=False)
username = Column(String, nullable=False)
password = Column(String, nullable=False)
created_at = Column(DateTime, default=datetime.utcnow)
accounts = relationship("Account", back_populates="user")
master_key = relationship("Master_Key", back_populates="user", uselist=False)
def __repr__(self):
return f"<User(username='{self.username}', email='{self.email}')>"
class Account(Base):
__tablename__ = "accounts"
id = Column(Integer, primary_key=True)
user_id = Column(Integer, ForeignKey("users.id"))
account_order = Column(Integer, nullable=False)
service = Column(String, nullable=False)
account_username = Column(String, nullable=False)
account_password = Column(String, nullable=False)
encryption_key = Column(String, nullable=False)
created_at = Column(DateTime, default=datetime.utcnow)
user = relationship("User", back_populates="accounts")
def __repr__(self):
return f"<Account(service='{self.service}', account_username='{self.account_username}', account_password='{self.account_password}')>"
class Master_Key(Base):
__tablename__ = "master_key"
id = Column(Integer, primary_key=True)
user_id = Column(Integer, ForeignKey("users.id"))
master_key = Column(String, nullable=False)
created_at = Column(DateTime, default=datetime.utcnow)
user = relationship("User", back_populates="master_key")
def __repr__(self) -> str:
return f"<Master_Key(master_key='{self.master_key}')>"