Skip to main content

Bob Gen for SQLite

Generates an ORM based on a sqlite database schema

Usage

# With env variable
SQLITE_DSN=test.db go run github.com/stephenafamo/bob/gen/bobgen-sqlite@latest

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

Driver Configuration

The configuration for the sqlite driver must all 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 sqlite for example you would do:

sqlite:
dsn: "file.db"

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

SQLITE_DSN="file.db"

The values that exist for the drivers:

NameDescriptionDefault
dsnPath to database
attachSchemas to attach and the path the the dbmap[string]string{}
shared_schemaSchema to not include prefix in model"main"
outputFolder for generated files"models"
pkgnamePackage name for generated code"models"
no_factorySkip generation of factoriesfalse
onlyOnly generate these
exceptSkip generation for these

Example of Only/Except:

sqlite:
# 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