2023/04/16 18:28:07 connect db server fail: dsn cannot be empty

[donhuvy]

My file gen.tool

version: "0.1"
database:
  # consult[https://gorm.io/docs/connecting_to_the_database.html]"
  dsn : "host=localhost user=postgres password=postgres dbname=vy_gorm port=5432 sslmode=disable TimeZone=Asia/Shanghai"
  # input mysql or postgres or sqlite or sqlserver. consult[https://gorm.io/docs/connecting_to_the_database.html]
  db  : "postgres"
  # enter the required data table or leave it blank.You can input : orders,users,goods
  tables  : "account,account_object"
  # specify a directory for output
  outPath :  "./dao/query"
  # query code file name, default: gen.go
  outFile :  ""
  # generate unit test for query code
  withUnitTest  : false
  # generated model code's package name
  modelPkgName  : "vydb"
  # generate with pointer when field is nullable
  fieldNullable : false
  # generate field with gorm index tag
  fieldWithIndexTag : false
  # generate field with gorm column type tag
  fieldWithTypeTag  : false

command

To have this happen automatically for branches without a tracking
upstream, see 'push.autoSetupRemote' in 'git help config'.

PS C:\Users\donhu\acc_go> git push --set-upstream origin main
Enumerating objects: 5, done.
Counting objects: 100% (5/5), done.
Delta compression using up to 16 threads
Compressing objects: 100% (5/5), done.
Writing objects: 100% (5/5), 4.71 KiB | 4.71 MiB/s, done.
Total 5 (delta 0), reused 0 (delta 0), pack-reused 0
To https://github.com/donhuvy/acc_go.git
 * [new branch]      main -> main
branch 'main' set up to track 'origin/main'.
PS C:\Users\donhu\acc_go> git remove -v
        remote
PS C:\Users\donhu\acc_go> gentool -c .\gen.tool                                              2023/04/16 18:24:39 connect db server fail: dsn cannot be empty
PS C:\Users\donhu\acc_go> gentool -c ".\gen.tool"
2023/04/16 18:25:22 connect db server fail: dsn cannot be empty
PS C:\Users\donhu\acc_go> gentool -c "gen.tool"  
2023/04/16 18:27:55 connect db server fail: dsn cannot be empty
PS C:\Users\donhu\acc_go> gentool -c ".\gen.tool"
2023/04/16 18:27:58 connect db server fail: dsn cannot be empty
PS C:\Users\donhu\acc_go> gentool -c ".\gen.tool"
2023/04/16 18:28:07 connect db server fail: dsn cannot be empty
PS C:\Users\donhu\acc_go>

My project https://github.com/donhuvy/acc_go

How to run gen success?

[donhuvy]

By the way, I ask

PS C:\Users\donhu\acc_go> gentool -dsn "postgres:postgres@tcp(localhost:5432)/vy_gorm?charset=utf8mb4&parseTime=True&loc=Local" -tables "account,account_default"
[mysql] 2023/04/16 19:00:23 packets.go:37: read tcp [::1]:64678->[::1]:5432: wsarecv: An existing conn[error] failed to initialize database, got error driver: bad connection
2023/04/16 19:02:23 connect db server fail: driver: bad connectionPS C:\Users\donhu\acc_go>
PS C:\Users\donhu\acc_go>PS C:\Users\donhu\acc_go>
PS C:\Users\donhu\acc_go>
PS C:\Users\donhu\acc_go>
PS C:\Users\donhu\acc_go>
PS C:\Users\donhu\acc_go>
PS C:\Users\donhu\acc_go> gentool -dsn "postgres:postgres@tcp(localhost:5432)/vy_gorm?charset=utf8mb4&parseTime=True&loc=Local" -tables "account,account_default"

[donhuvy]

https://github.com/go-gorm/gen/blob/master/tools/gentool/gentool.go#L64

[donhuvy]

The document is wrong

PS C:\Users\donhu\acc_go> gentool -dsn "host=172.25.128.1 user=postgres password=postgres dbname=vy_gorm port=5432 sslmode=disable TimeZone=Asia/Saigon" -tables "account,account_default"

2023/04/16 19:13:41 C:/Users/donhu/go/pkg/mod/gorm.io/[email protected]/tools/gentool/gentool.go:64
[error] failed to initialize database, got error default addr for network 'host=172.25.128.1 user=postgres password=postgres dbname=vy_gorm port=5432 sslmode=disable TimeZone=Asia' unknown
2023/04/16 19:13:41 connect db server fail: default addr for network 'host=172.25.128.1 user=postgres password=postgres dbname=vy_gorm port=5432 sslmode=disable TimeZone=Asia' unknown
PS C:\Users\donhu\acc_go> gentool -dsn "host=172.25.128.1 user=postgres password=postgres dbname=vy_gorm port=5432 sslmode=disable TimeZone=Asia/Saigon" -tables "account,account_default" -db postgres

2023/04/16 19:23:43 C:/Users/donhu/go/pkg/mod/gorm.io/[email protected]/tools/gentool/gentool.go:66
[error] failed to initialize database, got error failed to connect to `host=172.25.128.1 user=postgres database=vy_gorm`: server error (FATAL: no pg_hba.conf entry for host "172.25.128.1", user "postgres", database "vy_gorm", no encryption (SQLSTATE 28000))
2023/04/16 19:23:43 connect db server fail: failed to connect to `host=172.25.128.1 user=postgres database=vy_gorm`: server error (FATAL: no pg_hba.conf entry for host "172.25.128.1", user "postgres", database "vy_gorm", no encryption (SQLSTATE 28000))
PS C:\Users\donhu\acc_go> gentool -dsn "host=localhost user=postgres password=postgres dbname=vy_gorm port=5432 sslmode=disable TimeZone=Asia/Saigon" -tables "account,account_default" -db postgres        
2023/04/16 19:24:07 got 39 columns from table <account>
2023/04/16 19:24:07 got 14 columns from table <account_default>
2023/04/16 19:24:07 Start generating code.
2023/04/16 19:24:07 generate model file(table <account_default> -> {model.AccountDefault}): C:\Users\donhu\model\account_default.gen.go
2023/04/16 19:24:07 generate model file(table <account> -> {model.Account}): C:\Users\donhu\model\account.gen.go

2023/04/16 19:24:07 C:/Users/donhu/go/pkg/mod/gorm.io/[email protected]/generator.go:544
[warn] parse model pkg path fail: err: exit status 1: stderr: go: go.mod file not found in current directory or any parent directory; see 'go help modules'
2023/04/16 19:24:09 generate query file: C:\Users\donhu\acc_go/account.gen.go
2023/04/16 19:24:09 generate query file: C:\Users\donhu\acc_go/account_default.gen.go
2023/04/16 19:24:09 generate query file: C:\Users\donhu\acc_go/gen.go
2023/04/16 19:24:09 Generate code done.
PS C:\Users\donhu\acc_go>