model.py 4.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168
  1. import datetime
  2. from passlib.apps import custom_app_context as pwd
  3. import peewee
  4. import playhouse.shortcuts
  5. import typing
  6. import lc.config as c
  7. import lc.error as e
  8. import lc.request as r
  9. class Model(peewee.Model):
  10. class Meta:
  11. database = c.DB
  12. def to_dict(self) -> dict:
  13. return playhouse.shortcuts.model_to_dict(self)
  14. # TODO: figure out authorization for users (oauth? passwd?)
  15. class User(Model):
  16. """
  17. A user! you know tf this is about
  18. """
  19. name = peewee.TextField(unique=True)
  20. passhash = peewee.TextField()
  21. is_admin = peewee.BooleanField(default=False)
  22. @staticmethod
  23. def from_request(user: r.User) -> "User":
  24. passhash = pwd.hash(user.password)
  25. try:
  26. return User.create(name=user.name, passhash=passhash,)
  27. except peewee.IntegrityError:
  28. raise e.UserExists(name=user.name)
  29. def authenticate(self, password: str) -> bool:
  30. return pwd.verify(password, self.passhash)
  31. def set_as_admin(self):
  32. self.is_admin = True
  33. self.save()
  34. @staticmethod
  35. def login(user: r.User) -> "User":
  36. u = User.by_slug(user.name)
  37. if not u.authenticate(user.password):
  38. raise e.BadPassword(name=user.name)
  39. return u, c.SERIALIZER.dumps(user.to_dict())
  40. @staticmethod
  41. def by_slug(slug: str) -> "User":
  42. u = User.get_or_none(name=slug)
  43. if u is None:
  44. raise e.NoSuchUser(name=slug)
  45. return u
  46. def base_url(self) -> str:
  47. return f"/u/{self.name}"
  48. def get_links(self, page: int) -> typing.List["Link"]:
  49. return Link.select().where(Link.user == self).order_by(-Link.created).paginate(page, c.PER_PAGE)
  50. def get_link(self, link_id: int) -> "Link":
  51. return Link.get((Link.user == self) & (Link.id == link_id))
  52. def get_tag(self, tag_name: str) -> "Tag":
  53. return Tag.get((Tag.user == self) & (Tag.name == tag_name))
  54. def to_dict(self) -> dict:
  55. return {"id": self.id, "name": self.name}
  56. class Link(Model):
  57. """
  58. A link as stored in the database
  59. """
  60. url = peewee.TextField()
  61. name = peewee.TextField()
  62. description = peewee.TextField()
  63. # TODO: do we need to track modified time?
  64. created = peewee.DateTimeField()
  65. # is the field entirely private?
  66. private = peewee.BooleanField()
  67. # owned by
  68. user = peewee.ForeignKeyField(User, backref="links")
  69. def link_url(self) -> str:
  70. return f"/u/{self.user.name}/l/{self.id}"
  71. @staticmethod
  72. def from_request(user: User, link: r.Link) -> "Link":
  73. l = Link.create(
  74. url=link.url,
  75. name=link.name,
  76. description=link.description,
  77. private=link.private,
  78. created=link.created or datetime.datetime.now(),
  79. user=user,
  80. )
  81. for tag_name in link.tags:
  82. t = Tag.get_or_create_tag(user, tag_name)
  83. HasTag.create(
  84. link=l, tag=t,
  85. )
  86. return l
  87. class Tag(Model):
  88. """
  89. A tag. This just indicates that a user has used this tag at some point.
  90. """
  91. name = peewee.TextField()
  92. parent = peewee.ForeignKeyField("self", null=True, backref="children")
  93. user = peewee.ForeignKeyField(User, backref="tags")
  94. def url(self) -> str:
  95. return f"/u/{self.user.name}/t/{self.name}"
  96. def get_links(self, page: int) -> typing.List[Link]:
  97. return [
  98. ht.link
  99. for ht in HasTag.select()
  100. .join(Link)
  101. .where((HasTag.tag == self))
  102. .order_by(-Link.created)
  103. .paginate(page, c.PER_PAGE)
  104. ]
  105. @staticmethod
  106. def get_or_create_tag(user: User, tag_name: str):
  107. if (t := Tag.get_or_none(name=tag_name, user=user)) :
  108. return t
  109. parent = None
  110. if "/" in tag_name:
  111. parent_name = tag_name[: tag_name.rindex("/")]
  112. parent = Tag.get_or_create_tag(user, parent_name)
  113. return Tag.create(name=tag_name, parent=parent, user=user)
  114. class HasTag(Model):
  115. """
  116. Establishes that a link is tagged with a given tag.
  117. """
  118. link = peewee.ForeignKeyField(Link, backref="tags")
  119. tag = peewee.ForeignKeyField(Tag, backref="models")
  120. class UserInvite(Model):
  121. token: str
  122. MODELS = [
  123. User,
  124. Link,
  125. Tag,
  126. HasTag,
  127. ]
  128. def create_tables():
  129. c.DB.create_tables(MODELS, safe=True)