model.py 3.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127
  1. import datetime
  2. import peewee
  3. import typing
  4. import lc.config as c
  5. import lc.request as r
  6. class Model(peewee.Model):
  7. class Meta:
  8. database = c.DB
  9. # TODO: figure out authorization for users (oauth? passwd?)
  10. class User(Model):
  11. """
  12. A user! you know tf this is about
  13. """
  14. name = peewee.TextField()
  15. @staticmethod
  16. def from_request(user: r.User) -> "User":
  17. return User.create(name=user.name)
  18. @staticmethod
  19. def by_slug(slug: str) -> "User":
  20. return User.get(name=slug)
  21. def base_url(self) -> str:
  22. return f"/u/{self.name}"
  23. def get_links(self, page: int) -> typing.List["Link"]:
  24. return Link.select().where(Link.user == self).paginate(page, c.PER_PAGE)
  25. def get_tag(self, tag_name: str) -> "Tag":
  26. return Tag.get((Tag.user == self) & (Tag.name == tag_name))
  27. class Link(Model):
  28. """
  29. A link as stored in the database
  30. """
  31. url = peewee.TextField()
  32. name = peewee.TextField()
  33. description = peewee.TextField()
  34. # TODO: do we need to track modified time?
  35. created = peewee.DateTimeField()
  36. # is the field entirely private?
  37. private = peewee.BooleanField()
  38. # owned by
  39. user = peewee.ForeignKeyField(User, backref="links")
  40. def link_url(self) -> str:
  41. return f"/u/{self.user.name}/l/{self.id}"
  42. @staticmethod
  43. def from_request(user: User, link: r.Link) -> "Link":
  44. l = Link.create(
  45. url=link.url,
  46. name=link.name,
  47. description=link.description,
  48. private=link.private,
  49. created=datetime.datetime.now(),
  50. user=user,
  51. )
  52. for tag_name in link.tags:
  53. t = Tag.get_or_create_tag(user, tag_name)
  54. HasTag.create(
  55. link=l, tag=t,
  56. )
  57. return l
  58. class Tag(Model):
  59. """
  60. A tag. This just indicates that a user has used this tag at some point.
  61. """
  62. name = peewee.TextField()
  63. parent = peewee.ForeignKeyField("self", null=True, backref="children")
  64. user = peewee.ForeignKeyField(User, backref="tags")
  65. def url(self) -> str:
  66. return f"/u/{self.user.name}/t/{self.name}"
  67. def get_links(self, page: int) -> typing.List[Link]:
  68. return [
  69. ht.link
  70. for ht in HasTag.select()
  71. .where((HasTag.tag == self))
  72. .paginate(page, c.PER_PAGE)
  73. ]
  74. @staticmethod
  75. def get_or_create_tag(user: User, tag_name: str):
  76. if (t := Tag.get_or_none(name=tag_name, user=user)) :
  77. return t
  78. parent = None
  79. if "/" in tag_name:
  80. parent_name = tag_name[: tag_name.rindex("/")]
  81. parent = Tag.get_or_create_tag(user, parent_name)
  82. return Tag.create(name=tag_name, parent=parent, user=user,)
  83. class HasTag(Model):
  84. """
  85. Establishes that a link is tagged with a given tag.
  86. """
  87. link = peewee.ForeignKeyField(Link, backref="tags")
  88. tag = peewee.ForeignKeyField(Tag, backref="models")
  89. MODELS = [
  90. User,
  91. Link,
  92. Tag,
  93. HasTag,
  94. ]
  95. def create_tables():
  96. c.DB.create_tables(MODELS, safe=True)