Hi

\"\n});\n```\n\n## Val Town Utility Functions\n\nVal Town provides several utility functions to help with common project tasks.\n\n### Importing Utilities\nAlways import utilities with version pins to avoid breaking changes:\n```ts\nimport { parseProject, readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n```\n\n### Available Utilities\n\n1. **parseProject** - Extract information about the current project from import.meta.url:\n```ts\nconst projectVal = parseProject(import.meta.url);\nconsole.log(projectVal.username); // Owner of the project\nconsole.log(projectVal.name); // Project name\nconsole.log(projectVal.version); // Version number\nconsole.log(projectVal.branch); // Branch name\nconsole.log(projectVal.links.self.project); // URL to the project page\n```\n\n2. **readFile** - Read files from within the project:\n```ts\n// Read a file from the project\nconst fileContent = await readFile(\"/frontend/index.html\", import.meta.url);\n```\n\n3. **serveFile** - Serve project files with proper content types:\n```ts\n// Serve a file from the project with proper Content-Type header\napp.get(\"/public/style.css\", c => serveFile(\"/frontend/style.css\", import.meta.url));\n```\n\n4. **listFiles** - List all files in the project:\n```ts\nconst files = await listFiles(import.meta.url);\n```\n\n5. **fetchTranspiledJavaScript** - Fetch and transpile TypeScript to JavaScript:\n```ts\nconst jsCode = await fetchTranspiledJavaScript(\"https://esm.town/v/username/project/path/to/file.ts\");\n```\n\n6. **testServer** - Create a test server for running test suites:\n```ts\nexport default testServer([\n {\n name: \"Feature Tests\",\n tests: [\n {\n name: \"should add numbers correctly\",\n function: () => {\n expect(1 + 1).toBe(2);\n },\n }\n ],\n }\n]);\n```\n\n## Val Town Platform Specifics\n- **Redirects:** Use `return new Response(null, { status: 302, headers: { Location: \"/place/to/redirect\" }})` instead of `Response.redirect` which is broken\n- **Images:** Avoid external images or base64 images. Use emojis, unicode symbols, or icon fonts/libraries instead\n- For AI-generated images, use: `https://maxm-imggenurl.web.val.run/the-description-of-your-image`\n- **Storage:** DO NOT use the Deno KV module for storage\n- **Browser APIs:** DO NOT use the `alert()`, `prompt()`, or `confirm()` methods\n- **Weather Data:** Use open-meteo for weather data (doesn't require API keys) unless otherwise specified\n- **View Source:** Add a view source link with `import.meta.url.replace(\"esm.town\", \"val.town\")` and include `target=\"_top\"` attribute\n- **Error Debugging:** Add `` to HTML to capture client-side errors\n- **Error Handling:** Only use try...catch when there's a clear local resolution; avoid catches that merely log or return 500s - let errors bubble up with full context\n- **Environment Variables:** Use `Deno.env.get('keyname')` and minimize their use - prefer APIs without keys\n- **Imports:** Use `https://esm.sh` for npm and Deno dependencies to ensure compatibility on server and browser\n- **Storage Strategy:** Only use backend storage if explicitly required; prefer simple static client-side sites\n- For persistence, use Val Town SQLite or Blob storage with `import.meta.url` for keys/table names\n- **React Configuration:** When using React libraries, pin versions with `?deps=react@18.2.0,react-dom@18.2.0` and include the `@jsxImportSource` pragma\n- When facing client-side render issues, check if all React dependencies are pinned to the same version\n- **Styling:** Default to using TailwindCSS via `` unless otherwise specified\n\n## Project Structure and Design Patterns\n\n### Recommended Directory Structure\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Schema definitions\n│ │ ├── queries.ts # DB query functions\n│ │ └── README.md\n│ ├── index.ts # Main entry point\n│ └── README.md\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx\n│ │ └── [Component].tsx\n│ ├── favicon.svg\n│ ├── index.html # Main HTML template\n│ ├── index.tsx # JS entry point\n│ ├── README.md\n│ └── style.css\n├── README.md\n└── shared/\n ├── README.md\n └── utils.ts # Shared types and functions\n```\n\n### Backend (Hono) Best Practices\n- Hono is the recommended API framework (similar to Express, Flask, or Sinatra)\n- Main entry point should be `backend/index.ts`\n- **Static asset serving:** Use the utility functions to read and serve project files:\n ```ts\n // Use the serveFile utility to handle content types automatically\n app.get(\"/public/*\", c => serveFile(c.req.path.replace(\"/public\", \"/frontend\"), import.meta.url));\n\n // For index.html, often you'll want to bootstrap with initial data\n app.get(\"/\", async c => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n\n // Inject data to avoid extra round-trips\n const initialData = await fetchInitialData();\n const dataScript = ``;\n\n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n });\n ```\n- Create RESTful API routes for CRUD operations\n- Be careful with error handling as Hono tends to swallow errors\n- Always include this snippet at the top-level Hono app to re-throwing errors to see full stack traces:\n ```ts\n // Unwrap Hono errors to see original error details\n app.onError((err, c) => {\n throw err;\n });\n ```\n\n### Frontend Best Practices\n- Structure as a standard client-side React app\n- Use SVG for favicons (Val Town only supports text files)\n- Separate components into individual files\n- Access bootstrapped data from `window.__INITIAL_DATA__`\n- Use React 18.2.0 consistently in all imports and the `@jsxImportSource` pragma\n- Follow the React component pattern from the example project\n- Handle API calls properly with proper error catching\n\n### Database Patterns\n- Run migrations on startup or comment out for performance\n- Change table names when modifying schemas rather than altering\n- Export clear query functions with proper TypeScript typing\n- Follow the queries and migrations pattern from the example\n\n## Common Gotchas and Solutions\n\n1. **Environment Limitations:**\n - Val Town runs on Deno in a serverless context, not Node.js\n - Code in `shared/` must work in both frontend and backend environments\n - Cannot use `Deno` keyword in shared code\n - Use `https://esm.sh` for imports that work in both environments\n\n2. **SQLite Peculiarities:**\n - Limited support for ALTER TABLE operations\n - Create new tables with updated schemas and copy data when needed\n - Always run table creation before querying\n\n3. **React Configuration:**\n - All React dependencies must be pinned to 18.2.0\n - Always include `@jsxImportSource https://esm.sh/react@18.2.0` at the top of React files\n - Rendering issues often come from mismatched React versions\n\n4. **File Handling:**\n - Val Town only supports text files, not binary\n - Use the provided utilities to read files across branches and forks\n - For files in the project, use `readFile` helpers\n\n5. **API Design:**\n - `fetch` handler is the entry point for HTTP vals\n - Run the Hono app with `export default app.fetch // This is the entry point for HTTP vals`\n - Properly handle CORS if needed for external access",[],[101],["D",1748633051486],[110],[19],{"_36":62,"_13":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":73,"_38":111,"_17":32,"_75":76,"_77":78,"_79":53,"_80":-5,"_97":112,"_18":113},["D",1748633051486],[],[19,63],"aa50c2fa-3d8b-11f0-9747-76b3cceeab13","frontend","a0ec69ad-c080-47a0-ac8a-98b5fa7d9e3c",["D",1748633051486],[120],[115],{"_36":121,"_13":122,"_64":123,"_66":116,"_68":69,"_70":71,"_72":73,"_38":124,"_17":32,"_75":24,"_77":125,"_79":53,"_80":-5,"_97":126,"_18":127},"aa50b5f8-3d8b-11f0-9747-76b3cceeab13","index.html","af6584f7-e465-4aec-ae10-3cd6d0fdbe4d",["D",1748633051486],"\n\n \n \n \n Personal Shopper - Kroger Integration\n \n \n \n \n

\n\n \n \n",[],[115,122],"aa50b44a-3d8b-11f0-9747-76b3cceeab13","docs","cf60dd95-32ee-4b44-8327-a74cb62c2ca2",["D",1748633051486],[134,135,136,137,138],[129],{"_36":167,"_13":168,"_64":169,"_66":130,"_68":69,"_70":71,"_72":73,"_38":170,"_17":32,"_75":24,"_77":171,"_79":53,"_80":-5,"_97":172,"_18":173},{"_36":160,"_13":161,"_64":162,"_66":130,"_68":69,"_70":71,"_72":73,"_38":163,"_17":32,"_75":24,"_77":164,"_79":53,"_80":-5,"_97":165,"_18":166},{"_36":153,"_13":154,"_64":155,"_66":130,"_68":69,"_70":71,"_72":73,"_38":156,"_17":32,"_75":24,"_77":157,"_79":53,"_80":-5,"_97":158,"_18":159},{"_36":146,"_13":147,"_64":148,"_66":130,"_68":69,"_70":71,"_72":73,"_38":149,"_17":32,"_75":24,"_77":150,"_79":53,"_80":-5,"_97":151,"_18":152},{"_36":139,"_13":140,"_64":141,"_66":130,"_68":69,"_70":71,"_72":73,"_38":142,"_17":32,"_75":24,"_77":143,"_79":53,"_80":-5,"_97":144,"_18":145},"aa50af54-3d8b-11f0-9747-76b3cceeab13","oauth-setup.md","c43d344a-2c6b-4d59-a483-a773d22bdd5b",["D",1748633051486],"# Kroger OAuth Setup Guide\n\nThis guide walks you through setting up Kroger OAuth authentication for the Personal Shopper application.\n\n## Prerequisites\n\n1. **Kroger Developer Account**: You need to register as a developer with Kroger\n2. **Val Town Account**: Your application should be deployed on Val Town\n\n## Step 1: Register with Kroger Developer Portal\n\n1. Visit the [Kroger Developer Portal](https://developer.kroger.com/)\n2. Create an account or sign in\n3. Create a new application\n4. Note down your `Client ID` and `Client Secret`\n\n## Step 2: Configure Redirect URI\n\nIn your Kroger application settings, set the redirect URI to:\n```\nhttps://your-val-name.web.val.run/auth/callback\n```\n\nReplace `your-val-name` with your actual Val Town username and val name.\n\n## Step 3: Set Environment Variables\n\nIn your Val Town environment, set these variables:\n\n### Required Variables\n\n- **KROGER_CLIENT_ID**: Your Kroger application's client ID\n- **KROGER_CLIENT_SECRET**: Your Kroger application's client secret \n- **KROGER_REDIRECT_URI**: The redirect URI you registered (e.g., `https://your-val-name.web.val.run/auth/callback`)\n\n### How to Set Environment Variables in Val Town\n\n1. Go to your Val Town dashboard\n2. Click on your val\n3. Go to the \"Environment\" tab\n4. Add the three variables listed above\n\n## Step 4: Test the OAuth Flow\n\n1. Visit your application URL\n2. Click \"Connect with Kroger\"\n3. You should be redirected to Kroger's login page\n4. After logging in and authorizing, you'll be redirected back to your app\n\n## OAuth Flow Details\n\n### 1. Authorization Request\nWhen a user clicks \"Connect with Kroger\", they're redirected to:\n```\nhttps://api.kroger.com/v1/connect/oauth2/authorize?\n client_id=YOUR_CLIENT_ID&\n redirect_uri=YOUR_REDIRECT_URI&\n response_type=code&\n scope=profile.compact cart.basic:write product.compact&\n state=RANDOM_STATE_STRING\n```\n\n### 2. Authorization Callback\nKroger redirects back to your callback URL with:\n- `code`: Authorization code to exchange for tokens\n- `state`: The same state value you sent (for security)\n\n### 3. Token Exchange\nYour app exchanges the authorization code for:\n- `access_token`: Used to make API calls on behalf of the user\n- `refresh_token`: Used to get new access tokens when they expire\n- `expires_in`: How long the access token is valid (in seconds)\n\n### 4. Profile Retrieval\nYour app uses the access token to get the user's Kroger profile ID from:\n```\nGET https://api.kroger.com/v1/identity/profile\nAuthorization: Bearer ACCESS_TOKEN\n```\n\n### 5. User Session\nThe app creates a local user record and sets a session cookie for future requests.\n\n## Scopes Requested\n\nThe application requests these OAuth scopes:\n\n- **profile.compact**: Access to user's basic profile information\n- **cart.basic:write**: Ability to add items to the user's cart\n- **product.compact**: Access to search products in the catalog\n\n## Security Features\n\n- **State Parameter**: Prevents CSRF attacks during OAuth flow\n- **HTTP-Only Cookies**: Session cookies are not accessible via JavaScript\n- **Token Refresh**: Automatic refresh of expired access tokens\n- **Secure Storage**: Tokens are stored securely in the database\n\n## Troubleshooting\n\n### \"OAuth not configured\" Error\n- Ensure all three environment variables are set correctly\n- Check that there are no extra spaces in the variable values\n\n### \"Invalid redirect URI\" Error\n- Verify the redirect URI in Kroger's developer portal matches exactly\n- Ensure you're using HTTPS (required by Kroger)\n\n### \"Invalid client\" Error\n- Double-check your client ID and secret\n- Ensure your Kroger application is active\n\n### Token Refresh Issues\n- The app automatically handles token refresh\n- If refresh fails, users will need to re-authenticate\n\n## API Endpoints\n\nOnce OAuth is configured, these endpoints become available:\n\n### Authentication\n- `GET /auth/login` - Start OAuth flow\n- `GET /auth/callback` - Handle OAuth callback\n- `POST /auth/logout` - End user session\n\n### User Management\n- `GET /api/user` - Get current user info\n- `PUT /api/user/location` - Update preferred store location\n\n### Data Management\n- `GET /api/guidance` - Get user's shopping preferences\n- `POST /api/guidance` - Add new preference\n- `GET /api/selections` - Get user's saved product selections\n- `POST /api/selections` - Save new product selection\n\n## Next Steps\n\nAfter OAuth is working:\n\n1. **Test the full flow** with a real Kroger account\n2. **Implement product search** using the Kroger Products API\n3. **Add cart management** using the Kroger Cart API\n4. **Integrate AI/LLM** for intelligent product selection\n5. **Build the shopping list interface**\n\n## Support\n\nFor Kroger API issues:\n- [Kroger Developer Documentation](https://developer.kroger.com/documentation)\n- [Kroger Developer Support](https://developer.kroger.com/support)\n\nFor Val Town issues:\n- [Val Town Documentation](https://docs.val.town/)\n- [Val Town Discord](https://discord.gg/dHv45uN5RY)",[],[129,140],"aa50a87e-3d8b-11f0-9747-76b3cceeab13","kroger-products.md","5977f959-52d8-48f9-a549-1ba7e0a53d43",["D",1748633051486],"## Products API (1.2.4)\n\nThe Products API allows you to search the Kroger product catalog.\n\n### Rate Limit\n\nThe Public Products API has a 10,000 call per day rate limit.\n\nFor all Public APIs, we enforce the rate limit by the number of calls the client makes to the endpoint, not individual API operations. This means you can distribute the 10,000 calls across all API operations using the /products endpoint as you see fit.\n\n### Pagination\n\nThe Product Search operation supports pagination with a default value of 10 results per page. Using the following parameters, you can extend and skip results in the response:\n\n- `filter.limit` - Sets a limit on the number of products returned.\n- `filter.start` - Sets a number of results to skip in the response.\n\nNote: Since searching by a term acts as a fuzzy search, the order of the results can change with each new request.\n\n### API Operations\n\nThe Products API supports the following operations:\n\n| Name | Method | Description |\n| --------------- | ------ | ----------------------------------------------------------------------------- |\n| Product search | GET | Allows you to find products by passing in either a search term or product Id. |\n| Product details | GET | Returns product details for a specific product. |\n\n### Additional Response Data\n\nTo return the following data from the /products endpoint, you must include a locationId in the request. All operations for the products endpoint accept the filter.locationId query parameter.\n\n### Price\n\nReturns the following price objects:\n\nprice - Includes both the regular price of the item and the promo price of the item.\nnationalPrice - Includes both the regular national price of the item and the national promo price of the item.\n\nNote: Seasonal products only return a price when available. Some items may not have a national prices available.\n\n### Fulfillment Type\n\nReturns the following boolean objects to indicate an item's fulfillment availability:\n\ninstore - The item is sold in store at the given location.\nshiptohome - The item is available to be shipped to home.\ndelivery - The item is available for delivery from the given location.\ncurbside - The item is available for curbside pickup from the given location.\n\nNote: The instore fulfillment type only indicated that the item is sold by the given location, not that it is in stock.\n\n### Aisle Locations\n\nReturns the aisle locations of the item for the given location.\n\n### Inventory\n\nReturns the stockLevel of the item. This property is omitted when unavailable:\n\nHIGH - The stock level is high.\nLOW - The stock level is low.\nTEMPORARILY_OUT_OF_STOCK - The item is temporarily out of stock.\n\n## Example\n\n### /v1/products\n\n```sh\ncurl -X GET \\\n 'https://api.kroger.com/v1/products?filter.brand={{BRAND}}&filter.term={{TERM}}&filter.locationId={{LOCATION_ID}}' \\\n -H 'Accept: application/json' \\\n -H 'Authorization: Bearer {{TOKEN}}'\n```\n\n```json\n{\n \"data\": [\n {\n \"productId\": \"0001111041700\",\n \"productPageURI\": \"/p/kroger-2-reduced-fat-milk/0001111041700?cid=dis.api.tpi_products-api_20240521_b:all_c:p_t:\",\n \"aisleLocations\": [\n {\n \"bayNumber\": \"13\",\n \"description\": \"Aisle 35\",\n \"number\": \"35\",\n \"numberOfFacings\": \"5\",\n \"sequenceNumber\": \"3\",\n \"side\": \"L\",\n \"shelfNumber\": \"2\",\n \"shelfPositionInBay\": \"1\"\n }\n ],\n \"brand\": \"Kroger\",\n \"categories\": [\"Dairy\"],\n \"countryOrigin\": \"United States\",\n \"description\": \"Kroger 2% Reduced Fat Milk\",\n \"items\": [\n {\n \"itemId\": \"0001111041700\",\n \"inventory\": {\n \"stockLevel\": \"HIGH\"\n },\n \"favorite\": true,\n \"fulfillment\": {\n \"curbside\": true,\n \"delivery\": true,\n \"instore\": true,\n \"shiptohome\": true\n },\n \"price\": {\n \"regular\": 1.99,\n \"promo\": 1.59,\n \"regularPerUnitEstimate\": 1.99,\n \"promoPerUnitEstimate\": 1.59\n },\n \"nationalPrice\": {\n \"regular\": 1.99,\n \"promo\": 1.59,\n \"regularPerUnitEstimate\": 1.99,\n \"promoPerUnitEstimate\": 1.59\n },\n \"size\": \"1 gal\",\n \"soldBy\": \"unit\"\n }\n ],\n \"itemInformation\": {\n \"depth\": \"3.5\",\n \"height\": \"2.0\",\n \"width\": \"4.75\"\n },\n \"temperature\": {\n \"indicator\": \"Refrigerated\",\n \"heatSensitive\": true\n },\n \"images\": [\n {\n \"id\": \"string\",\n \"perspective\": \"front\",\n \"default\": true,\n \"sizes\": [\n {\n \"id\": \"7df2d0a3-8349-44d4-9512-1dab89e675a9\",\n \"size\": \"medium\",\n \"url\": \"https://www.kroger.com/product/images/medium/front/0001111041700\"\n }\n ]\n }\n ],\n \"upc\": \"0001111041700\"\n }\n ],\n \"meta\": {}\n}\n```\n\n### /v1/products/{productId}\n\n```sh\ncurl -X GET \\\n 'https://api.kroger.com/v1/products/{{ID}}?filter.locationId={{LOCATION_ID}}' \\\n -H 'Accept: application/json' \\\n -H 'Authorization: Bearer {{TOKEN}}'\n```\n\n```json\n{\n \"data\": {\n \"productId\": \"0001111041700\",\n \"productPageURI\": \"/p/kroger-2-reduced-fat-milk/0001111041700?cid=dis.api.tpi_products-api_20240521_b:all_c:p_t:\",\n \"aisleLocations\": [\n {\n \"bayNumber\": \"13\",\n \"description\": \"Aisle 35\",\n \"number\": \"35\",\n \"numberOfFacings\": \"5\",\n \"sequenceNumber\": \"3\",\n \"side\": \"L\",\n \"shelfNumber\": \"2\",\n \"shelfPositionInBay\": \"1\"\n }\n ],\n \"brand\": \"Kroger\",\n \"categories\": [\"Dairy\"],\n \"countryOrigin\": \"United States\",\n \"description\": \"Kroger 2% Reduced Fat Milk\",\n \"items\": [\n {\n \"itemId\": \"0001111041700\",\n \"inventory\": {\n \"stockLevel\": \"HIGH\"\n },\n \"favorite\": true,\n \"fulfillment\": {\n \"curbside\": true,\n \"delivery\": true,\n \"instore\": true,\n \"shiptohome\": true\n },\n \"price\": {\n \"regular\": 1.99,\n \"promo\": 1.59,\n \"regularPerUnitEstimate\": 1.99,\n \"promoPerUnitEstimate\": 1.59\n },\n \"nationalPrice\": {\n \"regular\": 1.99,\n \"promo\": 1.59,\n \"regularPerUnitEstimate\": 1.99,\n \"promoPerUnitEstimate\": 1.59\n },\n \"size\": \"1 gal\",\n \"soldBy\": \"unit\"\n }\n ],\n \"itemInformation\": {\n \"depth\": \"3.5\",\n \"height\": \"2.0\",\n \"width\": \"4.75\"\n },\n \"temperature\": {\n \"indicator\": \"Refrigerated\",\n \"heatSensitive\": true\n },\n \"images\": [\n {\n \"id\": \"string\",\n \"perspective\": \"front\",\n \"default\": true,\n \"sizes\": [\n {\n \"id\": \"7df2d0a3-8349-44d4-9512-1dab89e675a9\",\n \"size\": \"medium\",\n \"url\": \"https://www.kroger.com/product/images/medium/front/0001111041700\"\n }\n ]\n }\n ],\n \"upc\": \"0001111041700\"\n },\n \"meta\": {}\n}\n```",[],[129,147],"aa50a69e-3d8b-11f0-9747-76b3cceeab13","kroger-identity.md","2252c1bd-4c60-4416-93d1-6a97c41e9502",["D",1748633051486],"# Kroger Identity\n\n## GET `/v1/identity/profile`\n\nUser profile information\n\nProvides access to the profile id of an authenticated customer.\n\nNote: the customer must be authenticated using the OAuth2 Authorization Code grant type.\n\n### Parameters\n\n- None\n\n### Responses\n\n#### 200 OK\n\n#### Media type\n\napplication/json\n\n#### Example Value\n\n```json\n{\n \"data\": {\n \"id\": \"53990804-cfd1-43f3-8256-bdc9817a4fd0\"\n },\n \"meta\": {\n \"pagination\": {\n \"total\": 0,\n \"start\": 0,\n \"limit\": 0\n },\n \"warnings\": [\"string\"]\n }\n}\n```",[],[129,154],"aa50a3f6-3d8b-11f0-9747-76b3cceeab13","kroger-cart.md","aac44217-edec-4adf-85fe-3d0c3d4b35db",["D",1748633051486],"# Kroger Cart API\n\n## PUT `/v1/cart/add`\n\n### Add to cart\n\nProvides access to add items to an authenticated customer's cart.\n\nNote: the customer must be authenticated using the OAuth2 Authorization Code grant type.\n\n### Parameters\n\n- None\n\n### Request body\n\n- application/json\n- A list of items that you are adding to the cart.\n\n### Example Value\n\n```json\n{\n \"items\": [\n {\n \"quantity\": 1,\n \"upc\": \"0001111060903\",\n \"modality\": \"PICKUP\"\n }\n ]\n}\n```",[],[129,161],"aa509f14-3d8b-11f0-9747-76b3cceeab13","kroger-authorize.md","c84d240a-65f0-4e30-9643-570345e0d93c",["D",1748633051486],"# Kroger Authorize\n\n## Authorization Code\n\nGET `/v1/connect/oauth2/authorize`\n\nThis endpoint is used when the end user must approve access to a protected resource (such as a cart) before a service can act on the user's behalf. Here's how it works:\n\nYour service or application calls this endpoint and includes the redirect URL (what the end user should see after this service executes) and scopes (defines the actions your application or service can take on behalf of the user).\nThis endpoint displays a login screen, where the end user enters their email address and password.\nThe end user is then asked to give the application permission to access the resource on their behalf.\nWhen the user agrees, this service returns the redirect URL with an authorization code as a parameter.\nAfter this endpoint returns, your service or application must call the /token endpoint with the authorization_code grant type and code value to get an access token. The access token is then sent to the endpoint being called to prove that your service or application is authorized to act on a user's behalf.\n\n### Parameters\n\n- `scope` \\*\n\n - string\n - (query)\n The level of access your application is requesting.\n\n- `client_id` \\*\n\n - string\n - (query)\n Your application's client ID.\n\n- `redirect_uri` \\*\n\n - string\n - (query)\n Your registered redirect URL. The redirect URL tells this endpoint which URL to display after the user approves access to the protected resource.\n\n- `response_type` \\*\n\n - string\n - (query)\n Is always `code`.\n\n- `state`\n\n - string\n - (query)\n A random string to verify that the response belongs to the initiated request. The server should always return the same state value as the one specified in the request to protect against forgery attacks.\n\n- `banner`\n\n - string\n - (query)\n - Sets the chain specific branding displayed on the authorization consent screen presented to the end user for shopper logins. When this parameter is not supplied the default chain branding (Kroger) will be used. Only one option may be used at a time and the available options are the following:\n\n- `bakers` - Bakers' Plus\n- `citymarket` - City Market\n- `dillons` - Dillons\n- `fredmeyer` - Fred Meyer\n- `frys` - Fry's Food\n- `gerbes` - Gerbes\n- `kingsoopers` - King Soopers\n- `kroger` - Kroger (default if no banner provided)\n- `metromarket` - Metro Market\n- `picknsave` - Pick 'n Save\n- `qfc` - QFC\n- `ralphs` - Ralphs\n- `smiths` - Smiths Food and Drug\n- `food4less` - Food 4 Less\n- `foodsco` - Foods Co.\n- `harristeeter` - Harris Teeter\n- `vons` - Vons\n- `fredmeyerjewelers` - Fred Meyer\n- `jaycfoods` - Jay C\n- `marianos` - Marianos\n- `payless` - Pay Less\n- `ppsrx` - Postal Prescription Services (PPSRX)\n- `rulerfoods` - Ruler Foods\n- `copps` - Copps\n\n## Access Token\n\nPOST `/v1/connect/oauth2/token`\n\nAll Oauth2 applications are issued \"client credentials\" in the form of a unique client_id and client_secret after registration. The credentials are used to authorize the application.\n\nThere are 3 grant type flows that the token endpoint offers:\n\nauthorization_code - Uses the code returned from the /authorize endpoint to get a token, allowing your service or application to make API requests on an end user's behalf, including accessing personal data. The service is only able to perform the actions specified in the approved scopes.\nclient_credentials - Uses the client credentials to provide a token that allows your service or application to call endpoints that do not require user approval.\nrefresh_token - Allows the application to \"refresh\" an access token that has expired. Refresh tokens are only granted when using the Authorization Code grant type. Using the refresh token eliminates the need to re-authenticate the customer when the access token expires.\nThe access_token received from this step is sent to the endpoint being called to prove that your service or application is authorized to call the API. The token_type field indicates what type of token it is so that you can correctly pass it to the API.\n\n### Parameters\n\n- `Authorization` \\*\n\n - string\n - (header)\n Your client_id:client_secret base64 encoded.\n\n- `Request body`\n - application/x-www-form-urlencoded\n\n### Example Request Body\n\n```json\n{\n \"grant_type\": \"code\",\n \"code\": \"zWrT1GkdshSadIowJW0Rm4w2kKhOzv1W\",\n \"redirect_uri\": \"https://example.com/callback\"\n}\n```\n\n### Example Response\n\n```json\n{\n \"expires_in\": 1800,\n \"access_token\": \"eyJh5GciOiJSUzI1NiGsImtpZCI6Ilo0RnQzbXNrSUj4OGlydDdMQjVjNmc2PSIsInR5cCI6IkpXVmJ9.eqJzY29wZSI6InByb2T1Y3QuY29tcGFjdCBjb3Vwb24uYmFzaWMiLCJhdXRoQXQiOjE1NjUwOTk0OTUzMzIzOTIxMTIsImF1ZCI6InBlcmsvcm1hbmNlLWFnZW50LXB1YmxpYyIsImV4cCI6MTU2NTEwMTI5NSwiaWF0IjoxNTY1MDk5BDkwLCJpc3MiOiJhcGkua3JvZ2VyLmNvbSIsInN1YiI6IjBmZjdkMGIwLWVkOGItNDJmOS1hNTExLWEzMGQyYTAyZDljNSJ9.ej0mov6SGV4n4HiAvduTdYCceMlSo3T06M4Nfh3MfpIjSKzKaLWgd5S0W1EKDXrWz8IE7NTg8EIrL-WKhwdZPt-TWaS7LLjRXLJ0w5rKc44DStgBdvDiCcnKeMsnimjhBlHOiiKUV5y3GbVqJzaDVZwg0j8lP9qtwZP9EIIQ7k409nkskY1pz7l1lZrGotYRJKmnteN5vVQeZ3R8jywIwOOSEbKSgQALVA3Oj02964P7lI6h1GsZ66V5FLA9KU8QXm4ejrFHf1beAIA2zi_fQI3dmW7yj57pWoCECZIjq7Sfo3nGR5rkjEwfyXEK7aTn8oj4_14YHgKRTY-28L96cw\",\n \"token_type\": \"bearer\",\n \"refresh_token\": \"FN20LbaF2EWC6MPMWdemBwwnP4ZmX8\"\n}\n```",[],[129,168],"aa509d70-3d8b-11f0-9747-76b3cceeab13","backend","fee87468-1560-4931-af1e-7ac0a47b682e",["D",1748633051486],[180,181,182],[175],{"_36":205,"_13":206,"_64":207,"_66":176,"_68":69,"_70":71,"_72":73,"_38":208,"_17":32,"_75":84,"_77":-5,"_79":53,"_80":-5,"_97":209,"_18":210},{"_36":191,"_13":192,"_64":193,"_66":176,"_68":69,"_70":71,"_72":73,"_38":194,"_17":32,"_75":84,"_77":-5,"_79":53,"_80":-5,"_97":195,"_18":196},{"_36":183,"_13":184,"_64":185,"_66":176,"_68":69,"_70":71,"_72":73,"_38":186,"_17":32,"_75":187,"_77":188,"_79":53,"_80":-5,"_97":189,"_18":190},"aa509208-3d8b-11f0-9747-76b3cceeab13","index.ts","6b221300-76fa-4639-97ce-a86b350ea0c9",["D",1748633051486],"http","import { nanoid } from \"https://esm.sh/nanoid@5.0.5\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport { deleteCookie, getCookie, getSignedCookie, setCookie, setSignedCookie } from \"npm:hono/cookie\";\n\nimport {\n createGuidance,\n createSelection,\n createUser,\n deleteGuidance,\n deleteSelection,\n getGuidanceByUserId,\n getSelectionByUserAndItem,\n getSelectionsByUserId,\n getUserById,\n getUserByKrogerProfileId,\n searchGuidance,\n updateGuidance,\n updateSelection,\n updateUserLocation,\n updateUserTokens,\n} from \"./database/krogerQueries.ts\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport { KrogerAuthService } from \"./services/krogerAuth.ts\";\n\nconst app = new Hono();\n\n// Initialize database on startup\nawait runMigrations();\n\n// Initialize Kroger Auth Service\nconst krogerAuth = new KrogerAuthService();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n console.error(\"Error in Hono route:\", err);\n return c.json({ error: \"Internal Server Error\", details: err.message }, 500);\n});\n\n// Middleware to get current user from session\nasync function getCurrentUser(c: any) {\n const sessionId = getSignedCookie(c, Deno.env.get(\"SESSION_SECRET\"), \"session_id\");\n if (!sessionId) return null;\n\n try {\n return await getUserById(sessionId);\n } catch (error) {\n console.error(\"Error getting current user:\", error);\n return null;\n }\n}\n\nfunction cookieCtx(c) {\n // I don't know why setCookie/deleteCookie don't work, but this shim will do for now\n const fakeContext = {\n header(k: string, v: string) {\n c.res.headers.append(k, v);\n },\n req: c.req,\n };\n return fakeContext;\n}\n\n// --- OAuth Routes ---\n\n// Start OAuth flow\napp.get(\"/auth/login\", (c) => {\n if (!krogerAuth.isConfigured()) {\n return c.json({\n error: \"OAuth not configured\",\n message: \"Please set KROGER_CLIENT_ID, KROGER_CLIENT_SECRET, and KROGER_REDIRECT_URI environment variables\",\n }, 500);\n }\n\n const state = nanoid(16);\n // This is not working for some reason. Maybe because it's a 302?\n setCookie(cookieCtx(c), \"oauth_state\", state, {\n httpOnly: true,\n secure: true,\n sameSite: \"Lax\",\n maxAge: 600, // 10 minutes\n });\n\n const authUrl = krogerAuth.getAuthorizationUrl(state);\n c.res.headers.append(\"Location\", authUrl);\n\n return new Response(null, {\n status: 302,\n headers: c.res.headers,\n });\n});\n\n// OAuth callback\napp.get(\"/auth/callback\", async (c) => {\n const code = c.req.query(\"code\");\n const state = c.req.query(\"state\");\n const storedState = getCookie(c, \"oauth_state\");\n\n if (!code) {\n return c.json({ error: \"Authorization code not provided\" }, 400);\n }\n\n if (!state || state !== storedState) {\n return c.json({ error: \"Invalid state parameter\" }, 400);\n }\n\n try {\n // Exchange code for token\n const tokenResponse = await krogerAuth.exchangeCodeForToken(code);\n\n // Get user profile\n const profileResponse = await krogerAuth.getUserProfile(tokenResponse.access_token);\n const krogerProfileId = profileResponse.data.id;\n\n // Check if user exists\n let user = await getUserByKrogerProfileId(krogerProfileId);\n\n if (user) {\n // Update existing user's tokens\n await updateUserTokens(\n user.id,\n tokenResponse.access_token,\n tokenResponse.refresh_token,\n tokenResponse.expires_in,\n );\n user = await getUserById(user.id);\n } else {\n // Create new user\n user = await createUser({\n krogerProfileId,\n accessToken: tokenResponse.access_token,\n refreshToken: tokenResponse.refresh_token,\n tokenExpiresAt: Date.now() + (tokenResponse.expires_in * 1000),\n });\n }\n\n // Set session cookie\n setSignedCookie(cookieCtx(c), \"session_id\", user!.id, Deno.env.get(\"SESSION_SECRET\"), {\n httpOnly: true,\n secure: true,\n sameSite: \"Lax\",\n maxAge: 30 * 24 * 60 * 60, // 30 days\n });\n\n // Clear OAuth state\n deleteCookie(cookieCtx(c), \"oauth_state\");\n c.res.headers.append(\"Location\", \"/\");\n\n // Redirect to dashboard\n return new Response(null, {\n status: 302,\n headers: c.res.headers,\n });\n } catch (error) {\n console.error(\"OAuth callback error:\", error);\n return c.json({ error: \"Authentication failed\", details: error.message }, 500);\n }\n});\n\n// Logout\napp.post(\"/auth/logout\", (c) => {\n deleteCookie(c, \"session_id\");\n return c.json({ success: true });\n});\n\n// Get current user info\napp.get(\"/api/user\", async (c) => {\n const user = await getCurrentUser(c);\n if (!user) {\n return c.json({ error: \"Not authenticated\" }, 401);\n }\n\n // Don't return sensitive token information\n return c.json({\n id: user.id,\n krogerProfileId: user.krogerProfileId,\n preferredLocationId: user.preferredLocationId,\n createdAt: user.createdAt,\n });\n});\n\n// Update user location\napp.put(\"/api/user/location\", async (c) => {\n const user = await getCurrentUser(c);\n if (!user) {\n return c.json({ error: \"Not authenticated\" }, 401);\n }\n\n const { locationId } = await c.req.json();\n if (!locationId) {\n return c.json({ error: \"Location ID is required\" }, 400);\n }\n\n await updateUserLocation(user.id, locationId);\n return c.json({ success: true });\n});\n\n// --- Guidance Routes ---\n\n// Get all guidance for current user\napp.get(\"/api/guidance\", async (c) => {\n const user = await getCurrentUser(c);\n if (!user) {\n return c.json({ error: \"Not authenticated\" }, 401);\n }\n\n const guidance = await getGuidanceByUserId(user.id);\n return c.json(guidance);\n});\n\n// Search guidance\napp.get(\"/api/guidance/search\", async (c) => {\n const user = await getCurrentUser(c);\n if (!user) {\n return c.json({ error: \"Not authenticated\" }, 401);\n }\n\n const itemName = c.req.query(\"q\");\n if (!itemName) {\n return c.json({ error: \"Search query is required\" }, 400);\n }\n\n const guidance = await searchGuidance(user.id, itemName);\n return c.json(guidance);\n});\n\n// Create guidance\napp.post(\"/api/guidance\", async (c) => {\n const user = await getCurrentUser(c);\n if (!user) {\n return c.json({ error: \"Not authenticated\" }, 401);\n }\n\n const { itemName, guidance } = await c.req.json();\n if (!itemName || !guidance) {\n return c.json({ error: \"Item name and guidance are required\" }, 400);\n }\n\n const newGuidance = await createGuidance({\n userId: user.id,\n itemName,\n guidance,\n });\n\n return c.json(newGuidance, 201);\n});\n\n// Update guidance\napp.put(\"/api/guidance/:id\", async (c) => {\n const user = await getCurrentUser(c);\n if (!user) {\n return c.json({ error: \"Not authenticated\" }, 401);\n }\n\n const id = c.req.param(\"id\");\n const updates = await c.req.json();\n\n await updateGuidance(id, updates);\n return c.json({ success: true });\n});\n\n// Delete guidance\napp.delete(\"/api/guidance/:id\", async (c) => {\n const user = await getCurrentUser(c);\n if (!user) {\n return c.json({ error: \"Not authenticated\" }, 401);\n }\n\n const id = c.req.param(\"id\");\n await deleteGuidance(id);\n return c.json({ success: true });\n});\n\n// --- Selection Routes ---\n\n// Get all selections for current user\napp.get(\"/api/selections\", async (c) => {\n const user = await getCurrentUser(c);\n if (!user) {\n return c.json({ error: \"Not authenticated\" }, 401);\n }\n\n const selections = await getSelectionsByUserId(user.id);\n return c.json(selections);\n});\n\n// Get selection by item name\napp.get(\"/api/selections/item/:itemName\", async (c) => {\n const user = await getCurrentUser(c);\n if (!user) {\n return c.json({ error: \"Not authenticated\" }, 401);\n }\n\n const itemName = decodeURIComponent(c.req.param(\"itemName\"));\n const selection = await getSelectionByUserAndItem(user.id, itemName);\n\n if (!selection) {\n return c.json({ error: \"Selection not found\" }, 404);\n }\n\n return c.json(selection);\n});\n\n// Create or update selection\napp.post(\"/api/selections\", async (c) => {\n const user = await getCurrentUser(c);\n if (!user) {\n return c.json({ error: \"Not authenticated\" }, 401);\n }\n\n const { itemName, upc, productName } = await c.req.json();\n if (!itemName || !upc || !productName) {\n return c.json({ error: \"Item name, UPC, and product name are required\" }, 400);\n }\n\n const selection = await createSelection({\n userId: user.id,\n itemName,\n upc,\n productName,\n });\n\n return c.json(selection, 201);\n});\n\n// Update selection\napp.put(\"/api/selections/:id\", async (c) => {\n const user = await getCurrentUser(c);\n if (!user) {\n return c.json({ error: \"Not authenticated\" }, 401);\n }\n\n const id = c.req.param(\"id\");\n const updates = await c.req.json();\n\n await updateSelection(id, updates);\n return c.json({ success: true });\n});\n\n// Delete selection\napp.delete(\"/api/selections/:id\", async (c) => {\n const user = await getCurrentUser(c);\n if (!user) {\n return c.json({ error: \"Not authenticated\" }, 401);\n }\n\n const id = c.req.param(\"id\");\n await deleteSelection(id);\n return c.json({ success: true });\n});\n\n// --- Static File Serving ---\n\n// Serve index.html at the root\napp.get(\"/\", async (c) => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n\n // Check if user is authenticated and inject user data\n const user = await getCurrentUser(c);\n if (user) {\n const userData = {\n id: user.id,\n krogerProfileId: user.krogerProfileId,\n preferredLocationId: user.preferredLocationId,\n createdAt: user.createdAt,\n };\n\n const dataScript = ``;\n\n html = html.replace(\"\", `${dataScript}`);\n }\n\n return c.html(html);\n});\n\n// Serve frontend files\napp.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", (c) => serveFile(c.req.path, import.meta.url));\n\nexport default app.fetch;",[],[175,184],"aa5090dc-3d8b-11f0-9747-76b3cceeab13","services","268132c0-a6bc-4d45-83cf-6092658bf451",["D",1748633051486],[197],[175,192],{"_36":198,"_13":199,"_64":200,"_66":193,"_68":69,"_70":71,"_72":73,"_38":201,"_17":32,"_75":76,"_77":202,"_79":53,"_80":-5,"_97":203,"_18":204},"aa508ccc-3d8b-11f0-9747-76b3cceeab13","krogerAuth.ts","dc88c7ab-ff8f-4f03-9f5f-4a4eae36e17d",["D",1748633051486],"import { KrogerTokenResponse, KrogerProfileResponse } from \"../../shared/types.ts\";\n\nconst KROGER_BASE_URL = \"https://api.kroger.com\";\n\nexport class KrogerAuthService {\n private clientId: string;\n private clientSecret: string;\n private redirectUri: string;\n\n constructor() {\n this.clientId = Deno.env.get(\"KROGER_CLIENT_ID\") || \"\";\n this.clientSecret = Deno.env.get(\"KROGER_CLIENT_SECRET\") || \"\";\n this.redirectUri = Deno.env.get(\"KROGER_REDIRECT_URI\") || \"\";\n\n if (!this.clientId || !this.clientSecret || !this.redirectUri) {\n console.warn(\"Missing Kroger OAuth environment variables. OAuth features will be disabled.\");\n console.warn(\"Required variables: KROGER_CLIENT_ID, KROGER_CLIENT_SECRET, KROGER_REDIRECT_URI\");\n }\n }\n\n /**\n * Check if OAuth is properly configured\n */\n isConfigured(): boolean {\n return !!(this.clientId && this.clientSecret && this.redirectUri);\n }\n\n /**\n * Generate the authorization URL for the OAuth flow\n */\n getAuthorizationUrl(state?: string): string {\n const params = new URLSearchParams({\n client_id: this.clientId,\n redirect_uri: this.redirectUri,\n response_type: \"code\",\n scope: \"profile.compact cart.basic:write product.compact\",\n ...(state && { state }),\n });\n\n return `${KROGER_BASE_URL}/v1/connect/oauth2/authorize?${params.toString()}`;\n }\n\n /**\n * Exchange authorization code for access token\n */\n async exchangeCodeForToken(code: string): Promise {\n const credentials = btoa(`${this.clientId}:${this.clientSecret}`);\n \n const response = await fetch(`${KROGER_BASE_URL}/v1/connect/oauth2/token`, {\n method: \"POST\",\n headers: {\n \"Authorization\": `Basic ${credentials}`,\n \"Content-Type\": \"application/x-www-form-urlencoded\",\n },\n body: new URLSearchParams({\n grant_type: \"authorization_code\",\n code,\n redirect_uri: this.redirectUri,\n }),\n });\n\n if (!response.ok) {\n const errorText = await response.text();\n throw new Error(`Token exchange failed: ${response.status} ${errorText}`);\n }\n\n return await response.json() as KrogerTokenResponse;\n }\n\n /**\n * Refresh an expired access token\n */\n async refreshToken(refreshToken: string): Promise {\n const credentials = btoa(`${this.clientId}:${this.clientSecret}`);\n \n const response = await fetch(`${KROGER_BASE_URL}/v1/connect/oauth2/token`, {\n method: \"POST\",\n headers: {\n \"Authorization\": `Basic ${credentials}`,\n \"Content-Type\": \"application/x-www-form-urlencoded\",\n },\n body: new URLSearchParams({\n grant_type: \"refresh_token\",\n refresh_token: refreshToken,\n }),\n });\n\n if (!response.ok) {\n const errorText = await response.text();\n throw new Error(`Token refresh failed: ${response.status} ${errorText}`);\n }\n\n return await response.json() as KrogerTokenResponse;\n }\n\n /**\n * Get user profile information\n */\n async getUserProfile(accessToken: string): Promise {\n const response = await fetch(`${KROGER_BASE_URL}/v1/identity/profile`, {\n headers: {\n \"Authorization\": `Bearer ${accessToken}`,\n \"Accept\": \"application/json\",\n },\n });\n\n if (!response.ok) {\n const errorText = await response.text();\n throw new Error(`Profile fetch failed: ${response.status} ${errorText}`);\n }\n\n return await response.json() as KrogerProfileResponse;\n }\n\n /**\n * Check if a token is expired (with 5 minute buffer)\n */\n isTokenExpired(expiresAt: number): boolean {\n const bufferMs = 5 * 60 * 1000; // 5 minutes\n return Date.now() >= (expiresAt - bufferMs);\n }\n\n /**\n * Get a valid access token, refreshing if necessary\n */\n async getValidAccessToken(\n currentToken: string,\n refreshToken: string,\n expiresAt: number\n ): Promise<{ accessToken: string; refreshToken: string; expiresIn: number } | null> {\n if (!this.isTokenExpired(expiresAt)) {\n return {\n accessToken: currentToken,\n refreshToken,\n expiresIn: Math.floor((expiresAt - Date.now()) / 1000),\n };\n }\n\n try {\n const tokenResponse = await this.refreshToken(refreshToken);\n return {\n accessToken: tokenResponse.access_token,\n refreshToken: tokenResponse.refresh_token,\n expiresIn: tokenResponse.expires_in,\n };\n } catch (error) {\n console.error(\"Failed to refresh token:\", error);\n return null;\n }\n }\n}",[],[175,192,199],"aa508ace-3d8b-11f0-9747-76b3cceeab13","database","056d0904-adfc-465a-b104-0e003c3916af",["D",1748633051486],[211,212],[175,206],{"_36":220,"_13":221,"_64":222,"_66":207,"_68":69,"_70":71,"_72":73,"_38":223,"_17":32,"_75":76,"_77":224,"_79":53,"_80":-5,"_97":225,"_18":226},{"_36":213,"_13":214,"_64":215,"_66":207,"_68":69,"_70":71,"_72":73,"_38":216,"_17":32,"_75":76,"_77":217,"_79":53,"_80":-5,"_97":218,"_18":219},"aa508858-3d8b-11f0-9747-76b3cceeab13","migrations.ts","dbff31ff-790c-4dc5-929b-9e79c005a25b",["D",1748633051486],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Table names - change these when modifying schemas\nconst USERS_TABLE = \"kroger_users_1\";\nconst GUIDANCE_TABLE = \"guidance_1\";\nconst SELECTIONS_TABLE = \"selections_1\";\n\nexport async function runMigrations() {\n // Create users table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${USERS_TABLE} (\n id TEXT PRIMARY KEY,\n krogerProfileId TEXT UNIQUE NOT NULL,\n accessToken TEXT NOT NULL,\n refreshToken TEXT NOT NULL,\n tokenExpiresAt INTEGER NOT NULL,\n preferredLocationId TEXT,\n createdAt INTEGER NOT NULL,\n updatedAt INTEGER NOT NULL\n )\n `);\n\n // Create guidance table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${GUIDANCE_TABLE} (\n id TEXT PRIMARY KEY,\n userId TEXT NOT NULL,\n itemName TEXT NOT NULL,\n guidance TEXT NOT NULL,\n createdAt INTEGER NOT NULL,\n updatedAt INTEGER NOT NULL,\n FOREIGN KEY (userId) REFERENCES ${USERS_TABLE}(id) ON DELETE CASCADE\n )\n `);\n\n // Create selections table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${SELECTIONS_TABLE} (\n id TEXT PRIMARY KEY,\n userId TEXT NOT NULL,\n itemName TEXT NOT NULL,\n upc TEXT NOT NULL,\n productName TEXT NOT NULL,\n createdAt INTEGER NOT NULL,\n updatedAt INTEGER NOT NULL,\n FOREIGN KEY (userId) REFERENCES ${USERS_TABLE}(id) ON DELETE CASCADE,\n UNIQUE(userId, itemName)\n )\n `);\n\n // Create indexes for better performance\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_guidance_user_item \n ON ${GUIDANCE_TABLE}(userId, itemName)\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_selections_user_item \n ON ${SELECTIONS_TABLE}(userId, itemName)\n `);\n}\n\nexport { USERS_TABLE, GUIDANCE_TABLE, SELECTIONS_TABLE };",[],[175,206,214],"aa50306a-3d8b-11f0-9747-76b3cceeab13","krogerQueries.ts","bd3c8a59-2c7c-4a14-974c-4a97d9f9bb3f",["D",1748633051486],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { nanoid } from \"https://esm.sh/nanoid@5.0.5\";\nimport { KrogerUser, Guidance, Selection } from \"../../shared/types.ts\";\nimport { USERS_TABLE, GUIDANCE_TABLE, SELECTIONS_TABLE } from \"./migrations.ts\";\n\n// User queries\nexport async function createUser(userData: Omit): Promise {\n const id = nanoid(10);\n const now = Date.now();\n \n const user: KrogerUser = {\n ...userData,\n id,\n createdAt: now,\n updatedAt: now,\n };\n\n await sqlite.execute(`\n INSERT INTO ${USERS_TABLE} \n (id, krogerProfileId, accessToken, refreshToken, tokenExpiresAt, preferredLocationId, createdAt, updatedAt)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n user.id,\n user.krogerProfileId,\n user.accessToken,\n user.refreshToken,\n user.tokenExpiresAt,\n user.preferredLocationId || null,\n user.createdAt,\n user.updatedAt,\n ]);\n\n return user;\n}\n\nexport async function getUserByKrogerProfileId(krogerProfileId: string): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM ${USERS_TABLE} WHERE krogerProfileId = ?\n `, [krogerProfileId]);\n\n if (result.rows.length === 0) return null;\n\n const row = result.rows[0];\n return {\n id: row.id as string,\n krogerProfileId: row.krogerProfileId as string,\n accessToken: row.accessToken as string,\n refreshToken: row.refreshToken as string,\n tokenExpiresAt: row.tokenExpiresAt as number,\n preferredLocationId: row.preferredLocationId as string | undefined,\n createdAt: row.createdAt as number,\n updatedAt: row.updatedAt as number,\n };\n}\n\nexport async function getUserById(id: string): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM ${USERS_TABLE} WHERE id = ?\n `, [id]);\n\n if (result.rows.length === 0) return null;\n\n const row = result.rows[0];\n return {\n id: row.id as string,\n krogerProfileId: row.krogerProfileId as string,\n accessToken: row.accessToken as string,\n refreshToken: row.refreshToken as string,\n tokenExpiresAt: row.tokenExpiresAt as number,\n preferredLocationId: row.preferredLocationId as string | undefined,\n createdAt: row.createdAt as number,\n updatedAt: row.updatedAt as number,\n };\n}\n\nexport async function updateUserTokens(\n userId: string, \n accessToken: string, \n refreshToken: string, \n expiresIn: number\n): Promise {\n const tokenExpiresAt = Date.now() + (expiresIn * 1000);\n const updatedAt = Date.now();\n\n await sqlite.execute(`\n UPDATE ${USERS_TABLE} \n SET accessToken = ?, refreshToken = ?, tokenExpiresAt = ?, updatedAt = ?\n WHERE id = ?\n `, [accessToken, refreshToken, tokenExpiresAt, updatedAt, userId]);\n}\n\nexport async function updateUserLocation(userId: string, locationId: string): Promise {\n const updatedAt = Date.now();\n\n await sqlite.execute(`\n UPDATE ${USERS_TABLE} \n SET preferredLocationId = ?, updatedAt = ?\n WHERE id = ?\n `, [locationId, updatedAt, userId]);\n}\n\n// Guidance queries\nexport async function createGuidance(guidanceData: Omit): Promise {\n const id = nanoid(10);\n const now = Date.now();\n \n const guidance: Guidance = {\n ...guidanceData,\n id,\n createdAt: now,\n updatedAt: now,\n };\n\n await sqlite.execute(`\n INSERT INTO ${GUIDANCE_TABLE} \n (id, userId, itemName, guidance, createdAt, updatedAt)\n VALUES (?, ?, ?, ?, ?, ?)\n `, [\n guidance.id,\n guidance.userId,\n guidance.itemName,\n guidance.guidance,\n guidance.createdAt,\n guidance.updatedAt,\n ]);\n\n return guidance;\n}\n\nexport async function getGuidanceByUserId(userId: string): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM ${GUIDANCE_TABLE} WHERE userId = ? ORDER BY updatedAt DESC\n `, [userId]);\n\n return result.rows.map(row => ({\n id: row.id as string,\n userId: row.userId as string,\n itemName: row.itemName as string,\n guidance: row.guidance as string,\n createdAt: row.createdAt as number,\n updatedAt: row.updatedAt as number,\n }));\n}\n\nexport async function searchGuidance(userId: string, itemName: string): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM ${GUIDANCE_TABLE} \n WHERE userId = ? AND (itemName LIKE ? OR guidance LIKE ?)\n ORDER BY \n CASE WHEN itemName LIKE ? THEN 1 ELSE 2 END,\n updatedAt DESC\n `, [userId, `%${itemName}%`, `%${itemName}%`, `%${itemName}%`]);\n\n return result.rows.map(row => ({\n id: row.id as string,\n userId: row.userId as string,\n itemName: row.itemName as string,\n guidance: row.guidance as string,\n createdAt: row.createdAt as number,\n updatedAt: row.updatedAt as number,\n }));\n}\n\nexport async function updateGuidance(id: string, updates: Partial>): Promise {\n const fields = Object.keys(updates);\n const values = Object.values(updates);\n \n if (fields.length === 0) return;\n\n const setClause = fields.map(field => `${field} = ?`).join(\", \");\n const updatedAt = Date.now();\n\n await sqlite.execute(`\n UPDATE ${GUIDANCE_TABLE} \n SET ${setClause}, updatedAt = ?\n WHERE id = ?\n `, [...values, updatedAt, id]);\n}\n\nexport async function deleteGuidance(id: string): Promise {\n await sqlite.execute(`DELETE FROM ${GUIDANCE_TABLE} WHERE id = ?`, [id]);\n}\n\n// Selection queries\nexport async function createSelection(selectionData: Omit): Promise {\n const id = nanoid(10);\n const now = Date.now();\n \n const selection: Selection = {\n ...selectionData,\n id,\n createdAt: now,\n updatedAt: now,\n };\n\n await sqlite.execute(`\n INSERT OR REPLACE INTO ${SELECTIONS_TABLE} \n (id, userId, itemName, upc, productName, createdAt, updatedAt)\n VALUES (?, ?, ?, ?, ?, ?, ?)\n `, [\n selection.id,\n selection.userId,\n selection.itemName,\n selection.upc,\n selection.productName,\n selection.createdAt,\n selection.updatedAt,\n ]);\n\n return selection;\n}\n\nexport async function getSelectionByUserAndItem(userId: string, itemName: string): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM ${SELECTIONS_TABLE} WHERE userId = ? AND itemName = ?\n `, [userId, itemName]);\n\n if (result.rows.length === 0) return null;\n\n const row = result.rows[0];\n return {\n id: row.id as string,\n userId: row.userId as string,\n itemName: row.itemName as string,\n upc: row.upc as string,\n productName: row.productName as string,\n createdAt: row.createdAt as number,\n updatedAt: row.updatedAt as number,\n };\n}\n\nexport async function getSelectionsByUserId(userId: string): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM ${SELECTIONS_TABLE} WHERE userId = ? ORDER BY updatedAt DESC\n `, [userId]);\n\n return result.rows.map(row => ({\n id: row.id as string,\n userId: row.userId as string,\n itemName: row.itemName as string,\n upc: row.upc as string,\n productName: row.productName as string,\n createdAt: row.createdAt as number,\n updatedAt: row.updatedAt as number,\n }));\n}\n\nexport async function updateSelection(id: string, updates: Partial>): Promise {\n const fields = Object.keys(updates);\n const values = Object.values(updates);\n \n if (fields.length === 0) return;\n\n const setClause = fields.map(field => `${field} = ?`).join(\", \");\n const updatedAt = Date.now();\n\n await sqlite.execute(`\n UPDATE ${SELECTIONS_TABLE} \n SET ${setClause}, updatedAt = ?\n WHERE id = ?\n `, [...values, updatedAt, id]);\n}\n\nexport async function deleteSelection(id: string): Promise {\n await sqlite.execute(`DELETE FROM ${SELECTIONS_TABLE} WHERE id = ?`, [id]);\n}",[],[175,206,221],"aa49917e-3d8b-11f0-9747-76b3cceeab13",["D",1748633051486],"legacyEnvVars","httpPrivacy","description","imageUrl","userId","c156eb0e-8b9d-4104-a055-502e9a0eb441","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","2019e55b-c541-4c51-bef0-008eef10ef88","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_270":266},"org",{"_11":12,"_264":-5,"_265":266,"_233":234,"_267":268,"_269":53},"branch",{"_17":71,"_13":16,"_36":69,"_42":227,"_45":37,"_47":260,"_261":55,"_262":43,"_263":59,"_60":14,"_56":12},67,"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ4cFpFME5pSXNZamJNd296dlZSYVJ0OVF1RSJ9","tier","pro","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":227,"_13":14,"_38":366,"_51":-5,"_229":53,"_54":55,"_230":55,"_231":-5,"_232":-5,"_233":234,"_235":185,"_236":73,"_237":73,"_238":-5,"_239":32,"_58":240,"_241":-5,"_242":-5,"_243":-5,"_244":-5,"_245":246,"_247":246,"_248":249,"_250":249,"_251":249,"_252":246,"_253":246,"_254":367,"_256":368,"_258":369,"_52":53},[309,316,322,324,326,327],"files",[309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327],"counts",{"_299":32,"_300":71,"_301":32,"_35":302,"_303":304},[297],{"_36":82,"_13":19,"_64":67,"_66":-5,"_68":69,"_70":71,"_72":73,"_38":83,"_17":32,"_75":84,"_77":-5,"_79":53,"_80":-5,"_18":296},"upstreamProject",{"_36":43,"_13":14,"_231":-5,"_232":-5,"_54":55,"_254":294},"upstreamBranch",{"_36":37,"_38":292,"_40":293,"_13":16,"_42":43,"_17":44,"_45":46,"_47":48,"_49":50,"_51":-5,"_52":53,"_54":55,"_56":57,"_58":59,"_60":14},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1748492167939],["D",1750393319539],{"_11":57,"_270":295},"https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yeGtwbDJtR1BUTXlCMWc5R1Qwb2ZzTlFYQzgifQ",[19],{"_36":62,"_13":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":73,"_38":74,"_17":32,"_75":76,"_77":78,"_79":53,"_80":-5,"_18":298},[19,63],"pulls","branches","forks",{"_305":307,"_308":307},"connections",{"_305":32,"_306":32},"count","unfilledCount",4,"emptyCount",{"_36":174,"_13":175,"_64":176,"_66":-5,"_68":69,"_70":71,"_72":73,"_38":177,"_17":32,"_75":84,"_77":-5,"_79":53,"_80":-5,"_97":364,"_18":365},{"_36":205,"_13":206,"_64":207,"_66":176,"_68":69,"_70":71,"_72":73,"_38":208,"_17":32,"_75":84,"_77":-5,"_79":53,"_80":-5,"_97":362,"_18":363},{"_36":220,"_13":221,"_64":222,"_66":207,"_68":69,"_70":71,"_72":73,"_38":223,"_17":32,"_75":76,"_77":224,"_79":53,"_80":-5,"_97":360,"_18":361},{"_36":213,"_13":214,"_64":215,"_66":207,"_68":69,"_70":71,"_72":73,"_38":216,"_17":32,"_75":76,"_77":217,"_79":53,"_80":-5,"_97":358,"_18":359},{"_36":191,"_13":192,"_64":193,"_66":176,"_68":69,"_70":71,"_72":73,"_38":194,"_17":32,"_75":84,"_77":-5,"_79":53,"_80":-5,"_97":356,"_18":357},{"_36":198,"_13":199,"_64":200,"_66":193,"_68":69,"_70":71,"_72":73,"_38":201,"_17":32,"_75":76,"_77":202,"_79":53,"_80":-5,"_97":354,"_18":355},{"_36":183,"_13":184,"_64":185,"_66":176,"_68":69,"_70":71,"_72":73,"_38":186,"_17":32,"_75":187,"_77":188,"_79":53,"_80":-5,"_97":352,"_18":353},{"_36":128,"_13":129,"_64":130,"_66":-5,"_68":69,"_70":71,"_72":73,"_38":131,"_17":32,"_75":84,"_77":-5,"_79":53,"_80":-5,"_97":350,"_18":351},{"_36":167,"_13":168,"_64":169,"_66":130,"_68":69,"_70":71,"_72":73,"_38":170,"_17":32,"_75":24,"_77":171,"_79":53,"_80":-5,"_97":348,"_18":349},{"_36":160,"_13":161,"_64":162,"_66":130,"_68":69,"_70":71,"_72":73,"_38":163,"_17":32,"_75":24,"_77":164,"_79":53,"_80":-5,"_97":346,"_18":347},{"_36":153,"_13":154,"_64":155,"_66":130,"_68":69,"_70":71,"_72":73,"_38":156,"_17":32,"_75":24,"_77":157,"_79":53,"_80":-5,"_97":344,"_18":345},{"_36":146,"_13":147,"_64":148,"_66":130,"_68":69,"_70":71,"_72":73,"_38":149,"_17":32,"_75":24,"_77":150,"_79":53,"_80":-5,"_97":342,"_18":343},{"_36":139,"_13":140,"_64":141,"_66":130,"_68":69,"_70":71,"_72":73,"_38":142,"_17":32,"_75":24,"_77":143,"_79":53,"_80":-5,"_97":340,"_18":341},{"_36":114,"_13":115,"_64":116,"_66":-5,"_68":69,"_70":71,"_72":73,"_38":117,"_17":32,"_75":84,"_77":-5,"_79":53,"_80":-5,"_97":338,"_18":339},{"_36":121,"_13":122,"_64":123,"_66":116,"_68":69,"_70":71,"_72":73,"_38":124,"_17":32,"_75":24,"_77":125,"_79":53,"_80":-5,"_97":336,"_18":337},{"_36":82,"_13":19,"_64":67,"_66":-5,"_68":69,"_70":71,"_72":73,"_38":107,"_17":32,"_75":84,"_77":-5,"_79":53,"_80":-5,"_97":334,"_18":335},{"_36":62,"_13":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":73,"_38":111,"_17":32,"_75":76,"_77":78,"_79":53,"_80":-5,"_97":332,"_18":333},{"_36":100,"_13":101,"_64":102,"_66":-5,"_68":69,"_70":71,"_72":73,"_38":103,"_17":32,"_75":24,"_77":104,"_79":53,"_80":-5,"_97":330,"_18":331},{"_36":92,"_13":93,"_64":94,"_66":-5,"_68":69,"_70":71,"_72":73,"_38":95,"_17":32,"_75":24,"_77":96,"_79":53,"_80":-5,"_97":328,"_18":329},[],[93],[],[101],[],[19,63],[325],[19],[],[115,122],[323],[115],[],[129,140],[],[129,147],[],[129,154],[],[129,161],[],[129,168],[317,318,319,320,321],[129],[],[175,184],[],[175,192,199],[314],[175,192],[],[175,206,214],[],[175,206,221],[311,312],[175,206],[310,313,315],[175],["D",1748633051486],{"_11":12,"_270":266},{"_11":12,"_264":-5,"_265":266,"_233":234,"_267":268,"_269":53},{"_17":71,"_13":16,"_36":69,"_42":227,"_45":37,"_47":260,"_261":55,"_262":43,"_263":59,"_60":14,"_56":12},"ctx",{"_254":-5,"_289":403,"_404":405,"_406":407,"_408":53,"_409":53,"_410":53,"_411":73,"_412":-5,"_413":-7,"_414":-7,"_415":32,"_416":53,"_417":53,"_418":-5,"_419":53,"_420":53,"_421":53,"_422":-5},"ENV",{"_374":375,"_376":377,"_378":16,"_379":380,"_381":382,"_383":384,"_385":386,"_387":388,"_389":390,"_391":392,"_393":394,"_395":396,"_397":398,"_399":400,"_401":402},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e8c4b7030cb7600e4eb0736b15f422c8b8bd130f","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]