53 lines
1.7 KiB
Markdown
53 lines
1.7 KiB
Markdown
# Vegan Barcode
|
|
|
|
The goal of this project is to be a crowd sourced resource to find out if a product is vegan
|
|
|
|
|
|
# Project organization
|
|
|
|
- handlers: gets query parameters to call service and responds with service output
|
|
- services: takes parameters and performs business logic, calls functions to query database
|
|
- user_claims.go in database package: queries database
|
|
|
|
## Task list
|
|
- figure out how we want to handle database migrations
|
|
- database object models should be separated out from database migration function
|
|
- create main process that runs database migration and then starts api
|
|
- create search api
|
|
- create upload api
|
|
- create workers
|
|
- barnivore lookup
|
|
- alergen ingredient database lookup?
|
|
- create mobile and desktop front ends
|
|
- moderation tooling?
|
|
|
|
## Tip
|
|
Paste this to log the SQL queries in stdout.
|
|
ctx = ksql.InjectLogger(ctx, ksql.Logger)
|
|
|
|
|
|
## How to start database
|
|
|
|
- Run `brew services start postgresql`
|
|
- Create database
|
|
- Setting environment variables:
|
|
- PGHOST=localhost
|
|
- DB_NAME=veganDB (Can be arbitrary)
|
|
- Run `createdb veganDB`
|
|
(To delete in future just run dropdb <name>)
|
|
|
|
|
|
## Troubleshooting
|
|
|
|
Error:
|
|
`2025/04/17 16:21:21 ERROR: relation "idx_user_claims_product_id" already exists (SQLSTATE 42P07)`
|
|
Explanation: The database tables already exist and the program was trying to create them again.
|
|
|
|
Fix: Either don't create the databases again in the code, or run `dropdb veganDB` to allow it to recreate it.
|
|
|
|
Error:
|
|
`psql: error: connection to server at "localhost" (::1), port 5432 failed: FATAL: database "<user>" does not exist`
|
|
Explanation: Postgres automatically tryes to connect to a database with the same name as the user. Specify user and database:
|
|
`psql -U username databaseName `
|
|
|