DB

cwgo integrates gorm/gen to help users generate Model code and basic CURD code.

Basic commands

Use cwgo model -h to view usage details

NAME:
    cwgo model-generate DB model

                 Examples:
                   # Generate DB model code
                   cwgo model --db_type mysql --dsn "gorm:gorm@tcp(localhost:9910)/gorm?charset=utf8&parseTime=True&loc=Local"


USAGE:
    cwgo model [command options] [arguments...]

OPTIONS:
    --dsn value Specify the database source name. (https://gorm.io/docs/connecting_to_the_database.html)
    --db_type value Specify database type. (mysql or sqlserver or sqlite or postgres) (default: mysql)
    --out_dir value Specify output directory (default: biz/dao/query)
    --out_file value Specify output filename (default: gen.go)
    --tables value [ --tables value ] Specify databases tables
    --exclude_tables value [ --exclude_tables value ]  Specify exclude tables
    --unittest Specify generate unit test (default: false)
    --only_model Specify only generate model code (default: false)
    --model_pkg value Specify model package name
    --nullable Specify generate with pointer when field is nullable (default: false)
    --signable Specify detect integer field\'s unsigned type, adjust generated data type (default: false)
    --type_tag Specify generate field with gorm column type tag (default: false)
    --index_tag Specify generate field with gorm index tag (default: false)
    --sql_dir value Specify a sql file or directory(Note: The 'dsn' parameter is invalid when using this parameter)
    --help, -h show help (default: false)

All tables in the SQLite database that start with sqlite will be ignored, such as sqlite_sequence and sqlite_master.

Specification

    --dsn value specify database DSN
    --db_type value specifies the database type (mysql or sqlserver or sqlite or postgres) (default mysql)
    --out_dir value specifies the output directory path, the default is biz/dao/query
    --out_file value specify the output file name, the default is gen.go
    --tables value specifies the database table, the default is the full table
    --exclude_tables value [ --exclude_tables value ]  Specify exclude tables, the default is empty
    --unittest specifies whether to generate unit tests, the default is false
    --only_model specifies whether to generate only model, default is false
    --model_pkg value specifies the package name of the model
    --nullable specifies whether the generated field is a pointer when the field is nullable, the default is false
    --signable specifies detect integer field\'s unsigned type, adjust generated data type, the default is false
    --type_tag specifies whether to generate gorm's type tag for the specified field, the default is false
    --index_tag specifies whether to generate gorm's index tag for the specified field, the default is false
    --sql_dir value Specify a sql file or directory(Note: The 'dsn' parameter is invalid when using this parameter)
## Example

```sh
cwgo model --db_type mysql --dsn "gorm:gorm@tcp(localhost:9910)/gorm?charset=utf8&parseTime=True&loc=Local"

Last modified December 9, 2024 : Update prerequisite.md (#1178) (b5e2299)