sqlboiler icon indicating copy to clipboard operation
sqlboiler copied to clipboard

Unused import "database/sql" in view models

Open adatob opened this issue 2 years ago • 2 comments

Hey, I've noticed that the model generator added unused "database/sql" import for SQL VIEW models.

image

version of SQLBoiler: 4.14.2

database version: Postgresql 10

adatob avatar May 30 '23 15:05 adatob

Can you share some sort of schema for the VIEW?

stephenafamo avatar May 31 '23 08:05 stephenafamo

The view was created as follow: CREATE OR REPLACE VIEW myschema.jets_pilots AS SELECT jets.id AS jet_id, jets.name as name, pilots.name AS pilot_name FROM myschema.jets AS jets LEFT JOIN myschema.pilots AS pilots ON pilots.id=jets.pilot_id;

Tables pilots and jets was created within myschema.

Sqlboiler invoked using command: sqlboiler psql --debug --no-tests --add-enum-types --always-wrap-errors --pkgname myschema -c sqlboiler.toml -o sql/models/mydb/myschema

adatob avatar Jun 02 '23 21:06 adatob