def get_credentials(sid): credentials = mc.get(mc_cred_key(sid)) if not credentials: credentials = {} if sid: conn, cur=get_cursor('default') cur.execute("select id as user_id, " "(select COALESCE(array_agg(role_id), ARRAY[]::integer[]) from user_roles where user_id=users.id) as roles " "from users where id=(select user_id from session where id=%s and expires>%s)", (sid, datetime.now())) credentials=cur.fetchone() if not credentials: credentials={} release_cursor('default', cur, conn) mc.set(mc_cred_key(sid), credentials) return credentials
def __del__(self): try: self.conn.commit() except:pass release_cursor(self.db_name, self.db, self.conn)