model.py 6.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238
  1. from dataclasses import dataclass
  2. import datetime
  3. from passlib.apps import custom_app_context as pwd
  4. import peewee
  5. import playhouse.shortcuts
  6. from typing import List, Optional, Tuple
  7. import lc.config as c
  8. import lc.error as e
  9. import lc.request as r
  10. class Model(peewee.Model):
  11. class Meta:
  12. database = c.db
  13. def to_dict(self) -> dict:
  14. return playhouse.shortcuts.model_to_dict(self)
  15. @dataclass
  16. class Pagination:
  17. current: int
  18. last: int
  19. def previous(self) -> Optional[dict]:
  20. if self.current > 1:
  21. return {"page": self.current - 1}
  22. return None
  23. def next(self) -> Optional[dict]:
  24. if self.current < self.last:
  25. return {"page": self.current + 1}
  26. return None
  27. @classmethod
  28. def from_total(cls, current, total) -> "Pagination":
  29. return cls(current=current, last=((total - 1) // c.per_page) + 1,)
  30. # TODO: figure out authorization for users (oauth? passwd?)
  31. class User(Model):
  32. """
  33. A user! you know tf this is about
  34. """
  35. name = peewee.TextField(unique=True)
  36. passhash = peewee.TextField()
  37. is_admin = peewee.BooleanField(default=False)
  38. @staticmethod
  39. def from_request(user: r.User) -> "User":
  40. passhash = pwd.hash(user.password)
  41. try:
  42. return User.create(name=user.name, passhash=passhash,)
  43. except peewee.IntegrityError:
  44. raise e.UserExists(name=user.name)
  45. @staticmethod
  46. def from_invite(user: r.User, token: str) -> "User":
  47. invite = UserInvite.by_code(token)
  48. if invite.claimed_by is not None or invite.claimed_at is not None:
  49. raise e.AlreadyUsedInvite(invite=token)
  50. u = User.from_request(user)
  51. invite.claimed_at = datetime.datetime.now()
  52. invite.claimed_by = u
  53. invite.save()
  54. return u
  55. def authenticate(self, password: str) -> bool:
  56. return pwd.verify(password, self.passhash)
  57. def set_as_admin(self):
  58. self.is_admin = True
  59. self.save()
  60. @staticmethod
  61. def login(user: r.User) -> Tuple["User", str]:
  62. u = User.by_slug(user.name)
  63. if not u.authenticate(user.password):
  64. raise e.BadPassword(name=user.name)
  65. return u, user.to_token()
  66. @staticmethod
  67. def by_slug(slug: str) -> "User":
  68. u = User.get_or_none(name=slug)
  69. if u is None:
  70. raise e.NoSuchUser(name=slug)
  71. return u
  72. def base_url(self) -> str:
  73. return f"/u/{self.name}"
  74. def get_links(self, page: int) -> Tuple[List["Link"], Pagination]:
  75. links = (
  76. Link.select()
  77. .where(Link.user == self)
  78. .order_by(-Link.created)
  79. .paginate(page, c.per_page)
  80. )
  81. pagination = Pagination.from_total(page, Link.select().count())
  82. return links, pagination
  83. def get_link(self, link_id: int) -> "Link":
  84. return Link.get((Link.user == self) & (Link.id == link_id))
  85. def get_tag(self, tag_name: str) -> "Tag":
  86. return Tag.get((Tag.user == self) & (Tag.name == tag_name))
  87. def to_dict(self) -> dict:
  88. return {"id": self.id, "name": self.name}
  89. class Link(Model):
  90. """
  91. A link as stored in the database
  92. """
  93. url = peewee.TextField()
  94. name = peewee.TextField()
  95. description = peewee.TextField()
  96. # TODO: do we need to track modified time?
  97. created = peewee.DateTimeField()
  98. # is the field entirely private?
  99. private = peewee.BooleanField()
  100. # owned by
  101. user = peewee.ForeignKeyField(User, backref="links")
  102. def link_url(self) -> str:
  103. return f"/u/{self.user.name}/l/{self.id}"
  104. @staticmethod
  105. def from_request(user: User, link: r.Link) -> "Link":
  106. l = Link.create(
  107. url=link.url,
  108. name=link.name,
  109. description=link.description,
  110. private=link.private,
  111. created=link.created or datetime.datetime.now(),
  112. user=user,
  113. )
  114. for tag_name in link.tags:
  115. t = Tag.get_or_create_tag(user, tag_name)
  116. HasTag.create(
  117. link=l, tag=t,
  118. )
  119. return l
  120. class Tag(Model):
  121. """
  122. A tag. This just indicates that a user has used this tag at some point.
  123. """
  124. name = peewee.TextField()
  125. parent = peewee.ForeignKeyField("self", null=True, backref="children")
  126. user = peewee.ForeignKeyField(User, backref="tags")
  127. def url(self) -> str:
  128. return f"/u/{self.user.name}/t/{self.name}"
  129. def get_links(self, page: int) -> Tuple[List[Link], Pagination]:
  130. links = [
  131. ht.link
  132. for ht in HasTag.select()
  133. .join(Link)
  134. .where((HasTag.tag == self))
  135. .order_by(-Link.created)
  136. .paginate(page, c.per_page)
  137. ]
  138. pagination = Pagination.from_total(
  139. page, HasTag.select().where((HasTag.tag == self)).count(),
  140. )
  141. return links, pagination
  142. @staticmethod
  143. def get_or_create_tag(user: User, tag_name: str):
  144. if (t := Tag.get_or_none(name=tag_name, user=user)) :
  145. return t
  146. parent = None
  147. if "/" in tag_name:
  148. parent_name = tag_name[: tag_name.rindex("/")]
  149. parent = Tag.get_or_create_tag(user, parent_name)
  150. return Tag.create(name=tag_name, parent=parent, user=user)
  151. class HasTag(Model):
  152. """
  153. Establishes that a link is tagged with a given tag.
  154. """
  155. link = peewee.ForeignKeyField(Link, backref="tags")
  156. tag = peewee.ForeignKeyField(Tag, backref="models")
  157. class UserInvite(Model):
  158. token = peewee.TextField(unique=True)
  159. created_by = peewee.ForeignKeyField(User, backref="invites")
  160. created_at = peewee.DateTimeField()
  161. claimed_by = peewee.ForeignKeyField(User, null=True)
  162. claimed_at = peewee.DateTimeField(null=True)
  163. @staticmethod
  164. def by_code(token: str) -> "UserInvite":
  165. if (u := UserInvite.get_or_none(token=token)) :
  166. return u
  167. raise e.NoSuchInvite(invite=token)
  168. @staticmethod
  169. def manufacture(creator: User) -> "UserInvite":
  170. now = datetime.datetime.now()
  171. token = c.serializer.dumps(
  172. {"created_at": now.timestamp(), "created_by": creator.name,}
  173. )
  174. return UserInvite.create(
  175. token=token,
  176. created_by=creator,
  177. created_at=now,
  178. claimed_by=None,
  179. claimed_at=None,
  180. )
  181. MODELS = [
  182. User,
  183. Link,
  184. Tag,
  185. HasTag,
  186. UserInvite,
  187. ]
  188. def create_tables():
  189. c.db.create_tables(MODELS, safe=True)