def get_positions_models():
pg = get_pg()
return [
PositionModel(pg["id"]) for pg in pg.select("""SELECT id FROM position
ORDER BY view_order ASC""",
auto_one=False)
]
def auth_by_token(token):
pg = get_pg()
e = pg.select("""SELECT employer_id FROM token WHERE token = %s""",
(token, ))
if e != []:
return EmployerModel(e["employer_id"])
return None
def get_employers():
pg = get_pg()
return [
EmployerModel(e["id"]) for e in pg.select("""
SELECT id FROM employer
WHERE title_id != 3
""",
auto_one=False)
]
def __init__(self, year=None, month=None, day=None, day_id=None):
self.pg = get_pg()
self.date = None
if year is not None and month is not None and day is not None:
self.date = date(year, month, day)
self.day_id = day_id
if not self.exists():
self.init_day()
def generate_token(self):
pg = get_pg()
user_data = pg.select(
"""
SELECT * FROM users WHERE id = %(user_id)s
""", {"user_id": self.id})
token = str(uuid.uuid4())
return token
def auth_employer(email, password):
if len(email) > 3 and len(password) > 2:
pg = get_pg()
e = pg.select(
"""SELECT id FROM employer
WHERE email = %s
AND password = %s
LIMIT 1""", (
email.lower(),
hashlib.sha256(password.encode()).hexdigest(),
))
if e != []:
return EmployerModel(e["id"])
return None
def collect_single(path=""):
if not (request.is_json
or request.content_type == "application/csp_report"):
return "this isn't json", 415
pg = get_pg()
cur = pg.cursor()
body = request.get_json(force=True)
body['beacon_type'] = path
authed, purpose = authenticate(request, pg)
try:
insert_beacons([body], authed, purpose, pg)
pg.commit()
except Exception as e:
return str(e), 400
return 'OK', 200
def collect():
if not request.is_json:
return "this isn't json", 415
beacons = request.get_json()
if not isinstance(beacons, list):
return '400', 400
pg = get_pg()
authenticated, purpose = authenticate(request, pg)
if not authenticated:
return '403', 403
try:
insert_beacons(beacons, authenticated, purpose, pg)
except Exception as e:
return str(e), 400
pg.commit()
return 'OK', 200
def __init__(self, id):
self.pg = get_pg()
self.id = id
self.permissions = None
def __init__(self, id):
self.pg = get_pg()
self.id = id
def __init__(self, id):
self.pg = get_pg()
self.id = id
self.settings = None
