Control where individual generated files go?

[Nikola-Milovic]

Hello everyone, just wandering if something like this is possible, I have the following

db/schema/main.sql <- here are all my tables
and db/queries/user.sql | payment.sql | document.sql and so on

I would like to move each of the *.sql file into a specific directory and output package, so the user would go into user module under user/queries/.

Using golang, is there a way currently to achieve this?

My current config

version: "2" sql: - engine: "postgresql" queries: "db/queries" schema: - "db/schemas" database: uri: postgres//postgres:postgres@postgres:5432/seolitic gen: go: package: "db" out: "internal/db"

[MWT-proger]

Hi, try something like this.

version: "2" sql: - name: usersql engine: "postgresql" queries: "db/queries/user.sql" schema: - "db/schemas"  database: uri: postgres//postgres:postgres@postgres:5432/seolitic  gen: go: package: "userdb" out: "internal/db/user" - name: paymentsql engine: "postgresql" queries: "db/queries/payment.sql" schema: - "db/schemas"  database: uri: postgres//postgres:postgres@postgres:5432/seolitic  gen: go: package: "paymentdb" out: "internal/db/payment

[MWT-proger]

And I use this parameter to remove unnecessary things during generation

omit_unused_structs

If true, sqlc won’t generate table and enum structs that aren’t used in queries for a given package. Defaults to false.

[Nikola-Milovic]

Was just looking for this option, perfect