mirror of
https://github.com/owncast/owncast.git
synced 2026-03-13 09:51:16 +08:00
* feat(ap): add validation+update+cleanup AP actor job * fix(test): use time.Time instead of sql.NullTime * feat(test): add integration test for AP follower cleanup/validation job
SQL Queries
sqlc generates type-safe code from SQL. Here's how it works:
- You define the schema in
schema.sql. - You write your queries in
query.sqlusing regular SQL. - You run
sqlc generateto generate Go code with type-safe interfaces to those queries. - You write application code that calls the generated code.
Only those who need to create or update SQL queries will need to have sqlc installed on their system. It is not a dependency required to build the codebase.
Using sqlc
Run from the repository root:
make sqlc
Or manually:
./bin/sqlc generate
Managing Tool Versions
To upgrade sqlc to a specific version, edit tools/go.mod and run:
cd tools && go get github.com/sqlc-dev/sqlc@latest && go mod tidy
Then reinstall:
rm ./bin/sqlc && make sqlc