Bob Gen for SQL

Generates an ORM based on SQL schema files

Usage

# With env variable
SQL_DIALECT=psql go run github.com/stephenafamo/bob/gen/bobgen-sql@latest

# With configuration file
go run github.com/stephenafamo/bob/gen/bobgen-sql@latest -c ./config/bobgen.yaml

Driver Configuration

Link to general configuration and usage

The configuration for the sql driver must be prefixed by the driver name. You must use a configuration file or environment variables for configuring the database driver.

In the configuration file for sql for example you would do:

sql:
  dialect: psql

When you use an environment variable it must also be prefixed by the driver name:

SQL_DIALECT=psql

The values that exist for the drivers:

Name	Description	Default
dialect	Database dialect to use (REQUIRED)
dir	Path to directory containing schema files	.
schemas	The database schemas to generate models for	public (psql dialect), main (sqlite dialect)
shared_schema	Schema to not include prefix in model	first schema found
output	Folder for generated files	"models"
pkgname	Package name for generated code	"models"
uuid_pkg	UUID package to use (gofrs or google)	"gofrs"
only	Only generate these
except	Skip generation for these

Example of Only/Except:

sql:
  # Removes public.migrations table, the name column from the addresses table, and
  # secret_col of any table from being generated. Foreign keys that reference tables
  # or columns that are no longer generated may cause problems.
  except:
    public.migrations:
    public.addresses:
      - name
    "*":
      - secret_col