def get():
query = """
SELECT *
FROM users
WHERE id = %(id)s
LIMIT 1;
"""
result = get_row(db_conn, query, params)
return result
def test_get_row(db_conn, session):
query = """
SELECT *
FROM users
WHERE id = %(id)s
LIMIT 1;
"""
params = {
'id': convert_slug_to_uuid(user_id),
}
result = get_row(db_conn, query, params)
assert result['id'] == convert_slug_to_uuid(user_id)
def get_subject_version(db_conn, version_id):
"""
Get a subject version.
"""
query = """
SELECT *
FROM subjects
WHERE version_id = %(version_id)s
ORDER BY created DESC;
/* TODO LIMIT OFFSET */
"""
params = {'version_id': convert_slug_to_uuid(version_id)}
return get_row(db_conn, query, params)
def get_card_parameters(db_conn, params):
"""
Get Card Parameters
"""
query = """
SELECT *
FROM cards_parameters
WHERE entity_id = %(entity_id)s
LIMIT 1;
"""
params = {
'entity_id': convert_slug_to_uuid(params['entity_id']),
}
return get_row(db_conn, query, params)
def get_notice(db_conn, params):
"""
Get the user matching the parameters.
"""
query = """
SELECT *
FROM notices
WHERE id = %(id)s
LIMIT 1;
"""
params = {
'id': convert_slug_to_uuid(params['id']),
}
return get_row(db_conn, query, params)
def does_subject_exist(db_conn, entity_id):
"""
Just... is this a valid subject entity_id.
"""
query = """
SELECT entity_id
FROM subjects_entity_id
WHERE entity_id = %(entity_id)s
LIMIT 1;
"""
params = {
'entity_id': convert_slug_to_uuid(entity_id),
}
return get_row(db_conn, query, params)
def get_user_by_name(db_conn, params):
"""
Get the user by name.
"""
query = """
SELECT *
FROM users
WHERE name = %(name)s
LIMIT 1;
"""
params = {
'name': params['name'],
}
return get_row(db_conn, query, params)
def get_user_by_email(db_conn, params):
"""
Get the user by email.
"""
query = """
SELECT *
FROM users
WHERE email = %(email)s
LIMIT 1;
"""
params = {
'email': params['email'],
}
return get_row(db_conn, query, params)
def get_user_by_id(db_conn, params):
"""
Get the user by ID.
"""
query = """
SELECT *
FROM users
WHERE id = %(id)s
LIMIT 1;
"""
params = {
'id': convert_slug_to_uuid(params['id']),
}
return get_row(db_conn, query, params)
def get_follow_by_id(db_conn, follow_id):
"""
Find a specific follow (entity <-> user).
"""
query = """
SELECT *
FROM follows
WHERE id = %(id)s
LIMIT 1;
"""
params = {
'id': convert_slug_to_uuid(follow_id),
}
return get_row(db_conn, query, params)
def get_latest_accepted_subject(db_conn, entity_id):
"""
Get Latest Accepted Subject Version by EID
"""
query = """
SELECT DISTINCT ON (entity_id) *
FROM subjects
WHERE status = 'accepted' AND entity_id = %(entity_id)s
ORDER BY entity_id, created DESC;
/* TODO LIMIT */
"""
params = {
'entity_id': convert_slug_to_uuid(entity_id),
}
return get_row(db_conn, query, params)
def get_follow(db_conn, user_id, entity_id):
"""
Find a specific follow (entity <-> user).
"""
query = """
SELECT *
FROM follows
WHERE user_id = %(user_id)s AND entity_id = %(entity_id)s
LIMIT 1;
"""
params = {
'user_id': convert_slug_to_uuid(user_id),
'entity_id': convert_slug_to_uuid(entity_id),
}
return get_row(db_conn, query, params)
def get_latest_response(db_conn, user_id, unit_id):
"""
Get the latest response given a user ID and a unit ID.
"""
query = """
SELECT *
FROM responses
WHERE user_id = %(user_id)s AND unit_id = %(unit_id)s
ORDER BY created DESC
LIMIT 1;
"""
params = {
'user_id': convert_slug_to_uuid(user_id),
'unit_id': convert_slug_to_uuid(unit_id),
}
return get_row(db_conn, query, params)
def test_get_row_error(db_conn):
query = "a;"
params = {}
result = get_row(db_conn, query, params)
assert result is None
