# qa_session

started_at: 2026-03-27 16:06:29.706892
completed_at: 2026-03-27 19:29:26.544792
notes: minor bugs to be reviewed
smoke_results:
  {"route_dashboard": {"label": "GET /dashboard returns 200", "status": "pass", "detail": "route registered"}, "route_pantry": {"label": "GET /pantry returns 200", "status": "pass", "detail": "route registered"}, "route_planner": {"label": "GET /meal-planner returns 200", "status": "pass", "detail": "route registered"}, "route_shopping": {"label": "GET /shopping returns 200", "status": "pass", "detail": "route registered"}, "route_recipes": {"label": "GET /recipes returns 200", "status": "pass", "detail": "route registered"}, "route_changelog": {"label": "GET /changelog returns 200", "status": "pass", "detail": "route registered"}, "route_smoketest": {"label": "GET /smoketest returns 200", "status": "pass", "detail": "route registered"}, "db_demo_user": {"label": "Demo user exists and is active", "status": "pass", "detail": "demo id=10"}, "db_admin_user": {"label": "Admin user exists with admin role", "status": "pass", "detail": "admin exists"}, "db_recipes": {"label": "At least 1 recipe in system", "status": "pass", "detail": "19 recipes"}, "db_ingredients": {"label": "Ingredient table populated", "status": "pass", "detail": "769 ingredients"}, "db_units": {"label": "Unit table has entries", "status": "pass", "detail": "56 units"}, "db_clove_unit": {"label": "Clove unit exists in Unit table", "status": "pass", "detail": "clove found"}, "schema_is_demo": {"label": "user.is_demo column exists", "status": "pass", "detail": "is_demo found in user"}, "schema_culinary_type": {"label": "recipe.culinary_type column exists", "status": "pass", "detail": "culinary_type found in recipe"}, "schema_group_label": {"label": "recipe_ingredient_detail.group_label exists", "status": "pass", "detail": "group_label found in recipe_ingredient_detail"}, "schema_meal_type_sli": {"label": "shopping_list_item.meal_type exists", "status": "pass", "detail": "meal_type found in shopping_list_item"}, "schema_unit_sli": {"label": "shopping_list_item.unit exists", "status": "pass", "detail": "unit found in shopping_list_item"}, "schema_planned_meal": {"label": "planned_meal table exists", "status": "pass", "detail": "id found in planned_meal"}, "schema_modifier_notes": {"label": "pantry_item.modifier_notes exists (Phase 2 \u2014 expected pending)", "status": "pending", "detail": "Not yet built \u2014 Phase 2 Item 1"}, "data_no_orphan_pantry": {"label": "No orphaned pantry items", "status": "pass", "detail": "0 orphans"}, "data_recipes_typed": {"label": "All recipes have culinary_type", "status": "pass", "detail": "0 untyped"}, "data_no_bad_units": {"label": "No invalid units in pantry (cup/gallon raw)", "status": "pass", "detail": "all units normalised"}, "data_planned_meal_integrity": {"label": "All PlannedMealRecipe entries have valid recipe", "status": "pass", "detail": "all valid"}, "bp_social": {"label": "Social blueprint registered (26 routes)", "status": "pass", "detail": "23 social routes"}, "bp_admin": {"label": "Admin blueprint registered", "status": "pass", "detail": "66 admin routes"}}


started_at: 2026-03-27 19:29:26.621395
smoke_results:
  {"route_root": {"label": "GET / registered", "status": "pass", "detail": "registered: /"}, "route_dashboard": {"label": "GET /dashboard registered", "status": "pass", "detail": "registered: /dashboard"}, "route_recipes": {"label": "GET /recipes registered", "status": "pass", "detail": "registered: /recipes"}, "route_recipe_view": {"label": "GET /recipe/<id> registered", "status": "pass", "detail": "registered: /recipe/<int:recipe_id>"}, "route_upload": {"label": "GET /recipe/upload registered", "status": "pass", "detail": "registered: /recipe/upload"}, "route_edit": {"label": "GET /recipe/edit registered", "status": "pass", "detail": "registered: /recipe/edit/<int:recipe_id>"}, "route_pantry": {"label": "GET /pantry registered", "status": "pass", "detail": "registered: /pantry"}, "route_shopping": {"label": "GET /shopping registered", "status": "pass", "detail": "registered: /shopping"}, "route_planner": {"label": "GET /meal-planner registered", "status": "pass", "detail": "registered: /meal-planner"}, "route_changelog": {"label": "GET /changelog registered", "status": "pass", "detail": "registered: /changelog"}, "route_login": {"label": "GET /login registered", "status": "pass", "detail": "registered: /login"}, "route_register": {"label": "GET /register registered", "status": "pass", "detail": "registered: /register"}, "route_profile": {"label": "GET /profile registered", "status": "pass", "detail": "registered: /profile"}, "route_smoketest": {"label": "GET /smoketest registered", "status": "pass", "detail": "registered: /smoketest"}, "route_demo_login": {"label": "POST /demo-login registered", "status": "pass", "detail": "registered: /demo-login"}, "route_demo_logout": {"label": "GET /demo-logout registered", "status": "pass", "detail": "registered: /demo-logout"}, "db_admin_exists": {"label": "Admin user exists", "status": "pass", "detail": "1 admin(s)"}, "db_demo_exists": {"label": "Demo user exists and is_demo=True", "status": "pass", "detail": "demo user found"}, "db_no_pending_users": {"label": "No stuck pending registrations", "status": "pass", "detail": "0 pending"}, "db_recipes_exist": {"label": "Recipe table accessible", "status": "pass", "detail": "0 visible, 0 total"}, "db_recipes_unflagged": {"label": "No unexpected flagged recipes", "status": "pass", "detail": "0 flagged"}, "db_flagged_count": {"label": "Flagged recipe count", "status": "pass", "detail": "0 flagged"}, "db_recipes_typed": {"label": "All recipes have culinary_type_id set", "status": "pass", "detail": "0 untyped"}, "db_ingredients": {"label": "Ingredients table has 1000+ entries (CulinaryDB)", "status": "pass", "detail": "1050 ingredients"}, "db_units": {"label": "Units table has 50+ entries", "status": "pass", "detail": "56 units"}, "db_modifiers": {"label": "Modifiers table populated", "status": "pass", "detail": "143 modifiers"}, "db_modifier_cats": {"label": "Modifier categories exist", "status": "pass", "detail": "12 categories"}, "db_tags": {"label": "Tags table populated", "status": "pass", "detail": "42 tags"}, "db_culinary_types": {"label": "Recipes have culinary types assigned", "status": "pass", "detail": "0 recipes with culinary type"}, "db_no_orphan_pantry": {"label": "No orphaned pantry items (missing ingredient)", "status": "pass", "detail": "0 orphans"}, "db_no_orphan_planned": {"label": "No orphaned PlannedMealRecipe records", "status": "pass", "detail": "11 planned meals"}, "db_shopping_lists": {"label": "ShoppingList table accessible", "status": "pass", "detail": "1 shopping lists"}, "schema_user_is_demo": {"label": "user.is_demo exists", "status": "pass", "detail": "is_demo found in user"}, "schema_user_is_staff": {"label": "user.is_staff or role exists", "status": "pass", "detail": "role found in user"}, "schema_recipe_culinary_type": {"label": "recipe.culinary_type exists", "status": "pass", "detail": "culinary_type found in recipe"}, "schema_cuisine_is_active": {"label": "cuisine.is_active exists (Ph0.1)", "status": "pass", "detail": "is_active found in cuisine"}, "schema_cuisine_no_subcat": {"label": "cuisine.subcategory dropped (Ph0.1)", "status": "pass", "detail": "subcategory still exists"}, "schema_cooklog_no_rating": {"label": "cook_log.rating dropped (Ph0.1)", "status": "pass", "detail": "rating still exists"}, "schema_photo_no_is_cover": {"label": "recipe_photo.is_cover dropped (Ph0.1)", "status": "pass", "detail": "is_cover still exists"}, "schema_recipe_is_flagged": {"label": "recipe.is_flagged exists", "status": "pass", "detail": "is_flagged found in recipe"}, "schema_rid_group_label": {"label": "recipe_ingredient_detail.group_label exists", "status": "pass", "detail": "group_label found in recipe_ingredient_detail"}, "schema_rid_group_order": {"label": "recipe_ingredient_detail.group_order exists", "status": "pass", "detail": "group_order found in recipe_ingredient_detail"}, "schema_sli_meal_type": {"label": "shopping_list_item.meal_type exists", "status": "pass", "detail": "meal_type found in shopping_list_item"}, "schema_sli_unit": {"label": "shopping_list_item.unit exists", "status": "pass", "detail": "unit found in shopping_list_item"}, "schema_planned_meal": {"label": "planned_meal table exists", "status": "pass", "detail": "planned_meal exists"}, "schema_planned_meal_recipe": {"label": "planned_meal_recipe table exists", "status": "pass", "detail": "planned_meal_recipe exists"}, "schema_site_setting": {"label": "site_setting table exists", "status": "pass", "detail": "site_setting exists"}, "schema_tag": {"label": "tag table exists", "status": "pass", "detail": "tag exists"}, "schema_recipe_tag": {"label": "recipe_tag table exists", "status": "pass", "detail": "recipe_tag exists"}, "schema_qa_session": {"label": "qa_session table exists", "status": "pass", "detail": "qa_session exists"}, "schema_product": {"label": "product table exists (Ph0.2)", "status": "pass", "detail": "product exists"}, "schema_recipe_product": {"label": "recipe_product_detail exists (Ph0.2)", "status": "pass", "detail": "recipe_product_detail exists"}, "schema_pantry_product": {"label": "pantry_product table exists (Ph0.2)", "status": "pass", "detail": "pantry_product exists"}, "schema_rid_item_type": {"label": "recipe_ingredient_detail.item_type exists (Ph0.3)", "status": "pass", "detail": "item_type found in recipe_ingredient_detail"}, "schema_rid_product_id": {"label": "recipe_ingredient_detail.product_id exists (Ph0.3)", "status": "pass", "detail": "product_id found in recipe_ingredient_detail"}, "schema_product_off_id": {"label": "product.off_id exists (Ph0.3)", "status": "pass", "detail": "off_id found in product"}, "schema_product_off_barcode": {"label": "product.off_barcode exists (Ph0.3)", "status": "pass", "detail": "off_barcode found in product"}, "schema_ingredient_parent_id": {"label": "ingredient.parent_id exists (Chapter 2 \u2014 pending)", "status": "pass", "detail": "parent_id found in ingredient"}, "schema_pantry_modifier_notes": {"label": "pantry_item.modifier_notes exists (Chapter 2 \u2014 pending)", "status": "pass", "detail": "modifier_notes found in pantry_item"}, "toggle_db_count": {"label": "SiteSetting has 30+ entries", "status": "pass", "detail": "55 settings"}, "toggle_no_dupes": {"label": "No duplicate SiteSetting keys", "status": "pass", "detail": "55 rows / 55 unique"}, "toggle_recipes_on": {"label": "feature_recipe_view ON", "status": "pass", "detail": "feature_recipe_view=true (expected true)"}, "toggle_upload_on": {"label": "feature_upload ON", "status": "pass", "detail": "feature_upload=true (expected true)"}, "toggle_edit_on": {"label": "feature_recipe_edit ON", "status": "pass", "detail": "feature_recipe_edit=true (expected true)"}, "toggle_ai_import_on": {"label": "feature_ai_import ON", "status": "pass", "detail": "feature_ai_import=true (expected true)"}, "toggle_ratings_on": {"label": "feature_ratings ON", "status": "pass", "detail": "feature_ratings=true (expected true)"}, "toggle_changelog_on": {"label": "feature_changelog ON", "status": "pass", "detail": "feature_changelog=true (expected true)"}, "toggle_registration_on": {"label": "feature_registration ON", "status": "pass", "detail": "feature_registration=true (expected true)"}, "toggle_mealplan_on": {"label": "feature_mealplan ON", "status": "pass", "detail": "feature_mealplan=true (expected true)"}, "toggle_shopping_on": {"label": "feature_shopping_list ON", "status": "pass", "detail": "feature_shopping_list=true (expected true)"}, "toggle_shop_generate_on": {"label": "feature_shop_generate ON", "status": "pass", "detail": "feature_shop_generate=true (expected true)"}, "toggle_pantry_on": {"label": "feature_pantry ON", "status": "pass", "detail": "feature_pantry=true (expected true)"}, "toggle_pantry_add_on": {"label": "feature_pantry_add ON", "status": "pass", "detail": "feature_pantry_add=true (expected true)"}, "toggle_profile_on": {"label": "feature_profile_edit ON", "status": "pass", "detail": "feature_profile_edit=true (expected true)"}, "toggle_demo_on": {"label": "feature_demo ON", "status": "pass", "detail": "feature_demo=true (expected true)"}, "toggle_mod_bypass_on": {"label": "mod_bypass_features ON", "status": "pass", "detail": "mod_bypass_features=true (expected true)"}, "toggle_deduct_on": {"label": "feature_pantry_deduct ON (Ch.2.1 complete)", "status": "pass", "detail": "feature_pantry_deduct=true (expected true)"}, "toggle_shop_pantry_on": {"label": "feature_shop_pantry_link ON (Ch.2.1 complete)", "status": "pass", "detail": "feature_shop_pantry_link=true (expected true)"}, "toggle_discover_off": {"label": "discover_enabled OFF (placeholder)", "status": "pass", "detail": "discover_enabled=false (expected false)"}, "toggle_community_off": {"label": "community_enabled OFF (placeholder)", "status": "pass", "detail": "community_enabled=false (expected false)"}, "toggle_cook_mode_on": {"label": "feature_cook_mode ON (Chapter 2.3)", "status": "pass", "detail": "feature_cook_mode=true (expected true)"}, "toggle_alert_off": {"label": "alert_enabled OFF by default", "status": "pass", "detail": "alert_enabled=false (expected false)"}, "toggle_ai_claude": {"label": "ai_provider_claude configured", "status": "pass", "detail": "ai_provider_claude=true (expected true)"}, "infra_version_file": {"label": "VERSION file exists", "status": "pass", "detail": "0.9.3-alpha"}, "infra_changelog": {"label": "CHANGELOG.md exists", "status": "pass", "detail": "found"}, "infra_roadmap": {"label": "ROADMAP_v4.md exists", "status": "pass", "detail": "found"}, "infra_restore_doc": {"label": "RESTORE.md exists", "status": "pass", "detail": "found"}, "infra_backup_dir": {"label": "instance/backups/ directory exists", "status": "pass", "detail": "found"}, "infra_backup_exists": {"label": "At least 1 DB backup exists", "status": "pass", "detail": "22 backups"}, "infra_backup_script": {"label": "backup_db.sh exists", "status": "pass", "detail": "found"}, "infra_secret_key": {"label": "SECRET_KEY configured", "status": "pass", "detail": "env var set"}, "infra_version_format": {"label": "VERSION matches expected format", "status": "pass", "detail": "0.9.3-alpha"}, "data_planned_meal_integrity": {"label": "All PlannedMealRecipe entries have valid recipe", "status": "pass", "detail": "all valid"}, "bp_social": {"label": "Social blueprint registered (26 routes)", "status": "pass", "detail": "23 social routes"}, "bp_admin": {"label": "Admin blueprint registered", "status": "pass", "detail": "68 admin routes"}}


# qa_checklist_item

block: shopping
item_key: shp_06
status: fail
updated_at: 2026-03-27 19:11:34.891009
notes:
  is not bound to a Session; attribute refresh operation cannot proceed (Background on this error at: https://sqlalche.me/e/20/bhk3)


block: shopping
item_key: shp_08
status: fail
updated_at: 2026-03-27 19:12:52.482457
notes:
  various issues, here is one error... is not bound to a Session; attribute refresh operation cannot proceed (Background on this error at: https://sqlalche.me/e/20/bhk3)


# user

username: admin
role: admin
status: active
created_at: 2026-02-06 06:25:44.501937
last_login: 2026-03-30 15:29:29.947553
last_seen: 2026-03-31 23:26:11.647460
timezone: America/Los_Angeles
zip_code: 92626
preferred_ai_provider: claude
password_hash:
  scrypt:32768:8:1$L8YaqXAzLPBYmxm8$488d7ca4c61161c0c5f008071d3a0aad0d8c3b365e84f3c913770b8caeac6b7a18c40280c4dfa5d242b3eff3ba5bf276ba07a54716aec52ca64c8dbd059ef225

api_key_claude:
  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


username: mod
role: moderator
status: active
created_at: 2026-02-12 20:14:42.612040
last_login: 2026-03-27 20:54:12.366131
last_seen: 2026-03-27 20:54:53.473368
timezone: America/Los_Angeles
preferred_ai_provider: claude
password_hash:
  scrypt:32768:8:1$C2HkN8iwtFIIOprd$a2e7ee2e3f2bff22ee12bda64d6865ea432218d467f9e11239917a9311de98ad3c8e8dc5393463960fafffadf5681ca08a2aed09c66dd3ff7d305eb00cab420c


username: Spazz
email: josh@bardin.one
role: user
status: active
created_at: 2026-02-14 07:07:56.798185
last_login: 2026-02-13 23:07:56.898137
timezone: America/Los_Angeles
preferred_ai_provider: claude
password_hash:
  scrypt:32768:8:1$hzXmHgvENlB73MQV$9291c5d3f37834e9f76b318f5a8b13be2bf4153be370456c8293a02517ac105eac3abe8c95305a07cb297d477860464e47fc71ef93cb7d662b5964cc152d3589


username: ChefBeezy
email: joshua.v.bardin@me.com
role: user
status: active
created_at: 2026-02-19 00:21:43.074875
last_login: 2026-03-27 19:25:28.485665
last_seen: 2026-03-27 19:25:39.744980
timezone: America/Los_Angeles
preferred_ai_provider: claude
password_hash:
  scrypt:32768:8:1$3r8jiGJrfOSBXrKI$bc81978a9e0009841dcb63bd3a8d1f40e2dfda2bb52abdcb9c454f460ba39dd78a0c95e1120ec8fceba6dba38d08e7e528f1cab5dc6ecf6f7fcaf6ee6917bf5b


username: Aimkas
email: aim76@hotmail.com
role: user
status: active
created_at: 2026-02-19 00:27:32.679761
last_login: 2026-02-19 00:29:06.268293
timezone: America/Chicago
preferred_ai_provider: claude
password_hash:
  scrypt:32768:8:1$3p76Cl2nkycUYru1$00c48bb95e66824c8bfd523d62b220e55b711dffcad4414b000d3f86b70de76656b406e3841e19bf35bff78b668ce64b719ebbe13cb84c8315f097df7038d8da


username: Phaba
email: syncope.punchy.3q@icloud.com
role: user
status: active
created_at: 2026-02-19 01:36:22.538172
last_login: 2026-02-19 01:40:34.098165
timezone: America/Chicago
preferred_ai_provider: claude
password_hash:
  scrypt:32768:8:1$uKjpUtFGyPuSOq0g$41e57c455138b911f8c25da204af0fd8d52bc16c8b52397b902d160c38731c61ce79ebc1edb16fde949f0fab593de9d2a37f4879ba0fd1fc3e894cf2f6428f39


username: demo
email: demo@kitchencrate.local
role: user
status: active
created_at: 2026-03-26 19:57:17.662314
last_login: 2026-03-29 20:55:01.394888
last_seen: 2026-03-30 15:05:38.622069
timezone: America/Los_Angeles
preferred_ai_provider: claude
password_hash:
  scrypt:32768:8:1$oNiC51Mye1nXBl2E$1c5e6c3585471c360b248d98dbcf101fef475ef7fcadf5d25dfea5d930a1ba1e6eae753a7d40da68dddbbb4a7ee6dd87a24ea9ecac24e802d66e25b74528dede


