profile.py 3.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384
  1. # Copyright 2014-2016 OpenMarket Ltd
  2. #
  3. # Licensed under the Apache License, Version 2.0 (the "License");
  4. # you may not use this file except in compliance with the License.
  5. # You may obtain a copy of the License at
  6. #
  7. # http://www.apache.org/licenses/LICENSE-2.0
  8. #
  9. # Unless required by applicable law or agreed to in writing, software
  10. # distributed under the License is distributed on an "AS IS" BASIS,
  11. # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  12. # See the License for the specific language governing permissions and
  13. # limitations under the License.
  14. from typing import Optional
  15. from synapse.api.errors import StoreError
  16. from synapse.storage._base import SQLBaseStore
  17. from synapse.storage.databases.main.roommember import ProfileInfo
  18. class ProfileWorkerStore(SQLBaseStore):
  19. async def get_profileinfo(self, user_localpart: str) -> ProfileInfo:
  20. try:
  21. profile = await self.db_pool.simple_select_one(
  22. table="profiles",
  23. keyvalues={"user_id": user_localpart},
  24. retcols=("displayname", "avatar_url"),
  25. desc="get_profileinfo",
  26. )
  27. except StoreError as e:
  28. if e.code == 404:
  29. # no match
  30. return ProfileInfo(None, None)
  31. else:
  32. raise
  33. return ProfileInfo(
  34. avatar_url=profile["avatar_url"], display_name=profile["displayname"]
  35. )
  36. async def get_profile_displayname(self, user_localpart: str) -> Optional[str]:
  37. return await self.db_pool.simple_select_one_onecol(
  38. table="profiles",
  39. keyvalues={"user_id": user_localpart},
  40. retcol="displayname",
  41. desc="get_profile_displayname",
  42. )
  43. async def get_profile_avatar_url(self, user_localpart: str) -> Optional[str]:
  44. return await self.db_pool.simple_select_one_onecol(
  45. table="profiles",
  46. keyvalues={"user_id": user_localpart},
  47. retcol="avatar_url",
  48. desc="get_profile_avatar_url",
  49. )
  50. async def create_profile(self, user_localpart: str) -> None:
  51. await self.db_pool.simple_insert(
  52. table="profiles", values={"user_id": user_localpart}, desc="create_profile"
  53. )
  54. async def set_profile_displayname(
  55. self, user_localpart: str, new_displayname: Optional[str]
  56. ) -> None:
  57. await self.db_pool.simple_upsert(
  58. table="profiles",
  59. keyvalues={"user_id": user_localpart},
  60. values={"displayname": new_displayname},
  61. desc="set_profile_displayname",
  62. )
  63. async def set_profile_avatar_url(
  64. self, user_localpart: str, new_avatar_url: Optional[str]
  65. ) -> None:
  66. await self.db_pool.simple_upsert(
  67. table="profiles",
  68. keyvalues={"user_id": user_localpart},
  69. values={"avatar_url": new_avatar_url},
  70. desc="set_profile_avatar_url",
  71. )
  72. class ProfileStore(ProfileWorkerStore):
  73. pass