it125

Class project

Share link to the Lucid Chart diagram

Quickstart

1. Adjust the MySQL env vars in suite_test.go
2. Run go-test

go test -v .

Pie chart example

1. Modify the random order item generate parameters in cmd/piechart.go
2. Build cmd/piechart.go
3. export MySQL env vars

go build -o test cmd/*.go
export DB_HOST="127.0.0.1"
export DB_PORT="3306"
export DB_USER="root"
export DB_PASS="root"
export DB_DATABASE="it125_foodtruck"
./test

Notes

Modifying sqlc-schema.sql or sqlc-query.sql requires re-generating the files in the data subdir

sqlc generate

Credits

Golang Pie with echarts

Golang SQL types with sqlc

Golang Tests with Testify

RedHat OpenShift CLI

RedHat OpenShift commands

MySQL (Cloud SQL) with Cloud Run