def get_by_lower_email(workspace_id, email): query = """SELECT * FROM "user" WHERE workspace_id = %i AND lower(email) = lower(%s) LIMIT 1""" % (workspace_id, escape_pg_string(email)) r = Session.execute(query) rr = r.fetchone() Session.rollback() return rr
def get_by_lower_email(workspace_id, email): query = """SELECT * FROM "user" WHERE workspace_id = %i AND lower(email) = lower(%s) LIMIT 1""" % ( workspace_id, escape_pg_string(email), ) r = Session.execute(query) rr = r.fetchone() Session.rollback() return rr
def requested_in_last_seconds(workspace_id, user_id, max_seconds): query = """SELECT * FROM wsrequest WHERE workspace_id=%i AND user_id=%i AND (date_part('epoch', now()) - req_date) < %i ORDER BY req_date DESC LIMIT 1""" \ % ( workspace_id, user_id, max_seconds) log.debug("requested_in_last_seconds(): query='%s'." % ( query ) ) r = Session.execute(query) rr = r.fetchone() Session.rollback() if rr: return True return False
def requested_in_last_seconds(workspace_id, user_id, max_seconds): query = """SELECT * FROM wsrequest WHERE workspace_id=%i AND user_id=%i AND (date_part('epoch', now()) - req_date) < %i ORDER BY req_date DESC LIMIT 1""" \ % ( workspace_id, user_id, max_seconds) log.debug("requested_in_last_seconds(): query='%s'." % (query)) r = Session.execute(query) rr = r.fetchone() Session.rollback() if rr: return True return False
def accepted_lately(workspace_id, user_id): max_seconds = 600 query = """SELECT * FROM chatrequest WHERE workspace_id=%i AND user_id=%i AND accepted=True AND (date_part('epoch', now()) - accepted_date) < %i ORDER BY accepted_date DESC LIMIT 1""" \ % ( workspace_id, user_id, max_seconds) log.debug("accepted_in_last_seconds(): query='%s'." % ( query ) ) r = Session.execute(query) rr = r.fetchone() Session.rollback() if rr: return True return False