I have a directory of migrations.
One of those migration files has the name of 20240718160024_initial_tables.sql
This migration file contains the sql to create the users table.
When I run sqlc generate
i get the following error.
<code>db/queries/users.sql:1:1: relation "users" does not exist
</code>
<code>db/queries/users.sql:1:1: relation "users" does not exist
</code>
db/queries/users.sql:1:1: relation "users" does not exist
Now, if I create another file called “20240718160024_users.sql” to create the users
table then it works.
Here is my sqlc.yml
<code>version: "2"
sql:
- name: "db"
queries: "./db/queries"
schema: "./db/migrations"
engine: "postgresql"
gen:
go:
package: "sqlc"
out: "./internal/database/sqlc"
sql_package: "pgx/v5"
</code>
<code>version: "2"
sql:
- name: "db"
queries: "./db/queries"
schema: "./db/migrations"
engine: "postgresql"
gen:
go:
package: "sqlc"
out: "./internal/database/sqlc"
sql_package: "pgx/v5"
</code>
version: "2"
sql:
- name: "db"
queries: "./db/queries"
schema: "./db/migrations"
engine: "postgresql"
gen:
go:
package: "sqlc"
out: "./internal/database/sqlc"
sql_package: "pgx/v5"
And my users.sql query
<code>-- name: GetUserByID :one
SELECT
id,
email,
first_name,
last_name,
date_of_birth,
phone_number,
terms_accepted,
created_at,
updated_at
FROM users
WHERE id = $1
limit 1;
</code>
<code>-- name: GetUserByID :one
SELECT
id,
email,
first_name,
last_name,
date_of_birth,
phone_number,
terms_accepted,
created_at,
updated_at
FROM users
WHERE id = $1
limit 1;
</code>
-- name: GetUserByID :one
SELECT
id,
email,
first_name,
last_name,
date_of_birth,
phone_number,
terms_accepted,
created_at,
updated_at
FROM users
WHERE id = $1
limit 1;
1