Copied the example of sqlc.yaml generated by 'sqlc init' from https://docs.sqlc.dev/en/stable/tutorials/getting-started-postgresql.html# .
Changed it as following:
version: "2"
sql:
- engine: "postgresql"
queries: "db/sqlc/query"
schema: "db/schema"
gen:
go:
package: "db"
out: "./db/sqlc"
emit_json_tags: true
Ran 'sqlc generate':
zzh@ZZHPC:~/zd/Github/zimplebank$ sqlc generate # package db db/sqlc/query/account.sql:1:1: relation "accounts" does not exist
Got the above error.
This was because there were two .sql files in directory "db/schema", and sqlc can't recognize the schema file. Changed the value of schema from db/schema" to "db/schema/0001_create_tables.sql", then 'sqlc generate' succeeded.
- quot relation accounts ERROR existquot relation accounts error property error route exist account_id account quot 39 merge_head concluded exists error module ir_module_module quot relation quot system nginx error quot error error_description description expire_nodest_conn quot error expire quot characters literal error quot husky-run command error