92df1c671a
* fix(chalice): fixed Math-operators validation refactor(chalice): search for sessions that have events for heatmaps * refactor(chalice): search for sessions that have at least 1 location event for heatmaps * fix(chalice): fixed Math-operators validation refactor(chalice): search for sessions that have events for heatmaps * refactor(chalice): search for sessions that have at least 1 location event for heatmaps * feat(chalice): autocomplete return top 10 with stats * fix(chalice): fixed autocomplete top 10 meta-filters * fix(chalice): fixed update scope for EE
25 lines
756 B
Python
25 lines
756 B
Python
from cachetools import cached, TTLCache
|
|
|
|
from chalicelib.utils import pg_client
|
|
|
|
cache = TTLCache(maxsize=1, ttl=60)
|
|
|
|
|
|
@cached(cache)
|
|
def get_scope(tenant_id) -> int:
|
|
with pg_client.PostgresClient() as cur:
|
|
query = cur.mogrify(f"""SELECT scope_state
|
|
FROM public.tenants;""")
|
|
cur.execute(query)
|
|
return cur.fetchone()["scope_state"]
|
|
|
|
|
|
def update_scope(tenant_id, scope: int):
|
|
with pg_client.PostgresClient() as cur:
|
|
query = cur.mogrify(f"""UPDATE public.tenants
|
|
SET scope_state = %(scope_state)s;""",
|
|
{"scope_state": scope})
|
|
cur.execute(query)
|
|
if tenant_id in cache:
|
|
cache.pop(tenant_id)
|
|
return scope
|