volatiletech / sqlboiler

Generate a Go ORM tailored to your database schema.
BSD 3-Clause "New" or "Revised" License
6.66k stars 539 forks source link

Unused import "database/sql" in view models #1279

Open adatob opened 1 year ago

adatob commented 1 year ago

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

stephenafamo commented 1 year ago

Can you share some sort of schema for the VIEW?

adatob commented 1 year ago

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