def sql_biometric_add(bio_vals):
"""Insert biometric log item"""
con = nt_sqlite_connect()
cur = con.cursor()
# TODO: finish up
query1 = "INSERT INTO biometric_log(profile_id, tags, notes) VALUES (?, ?, ?)"
_sql(query1, (PROFILE_ID, "", ""))
log_id = cur.lastrowid
print(log_id)
query2 = "INSERT INTO bio_log_entry(log_id, biometric_id, value) VALUES (?, ?, ?)"
records = [(log_id, biometric_id, value)
for biometric_id, value in bio_vals.items()]
cur.executemany(query2, records)
return log_id
def sql_analyze_recipe(recipe_id):
"""Output (nutrient) analysis columns for a given recipe_id"""
query = """
SELECT
id,
name,
food_id,
grams
FROM
recipes
INNER JOIN recipe_dat ON recipe_id = id
AND id = ?;
"""
return _sql(query, values=(recipe_id, ))
def sql_recipes():
"""Show recipes with selected details"""
query = """
SELECT
id,
tagname,
name,
COUNT(recipe_id) AS n_foods,
SUM(grams) AS grams,
created
FROM
recipes
LEFT JOIN recipe_dat ON recipe_id = id
GROUP BY
id;
"""
return _sql(query, headers=True)
def sql_recipe(recipe_id):
"""Selects columns for recipe_id"""
query = "SELECT * FROM recipes WHERE id=?;"
return _sql(query, values=(recipe_id, ))
def sql_biometric_logs(profile_id):
"""Selects biometric logs"""
query = "SELECT * FROM biometric_log WHERE profile_id=?"
return _sql(query, values=(profile_id, ), headers=True)
def sql_biometrics():
"""Selects biometrics"""
query = "SELECT * FROM biometrics;"
return _sql(query, headers=True)
def sql_recipe_add():
"""TODO: method for adding recipe"""
query = """
"""
return _sql(query)