Files
sponge/pkg/sql2code
2025-08-24 20:25:07 +08:00
..
2025-08-24 20:25:07 +08:00
2025-03-02 20:07:58 +08:00
2025-03-13 21:51:10 +08:00
2025-03-02 20:07:58 +08:00
2022-11-21 22:12:49 +08:00

sql2code

sql2code is a code generation engine that generates CRUD code for model, dao, handler, service, protobuf based on sql and supports database types mysql, mongodb, postgresql, sqlite3.


Example of use

Generate code based on database table.

    import "github.com/go-dev-frame/sponge/pkg/sql2code"

    // generate model, dao, handler, service and protobuf code, supports database type: mysql, mongodb, postgres, sqlite3
    codes, err := sql2code.Generate(&sql2code.Args{
      DBDriver: "mysql",
      DBDsn: "root:123456@(127.0.0.1:3306)/account"
      DBTable "user"
      GormType: true,
      JSONTag: true,
      IsEmbed: true,
      IsExtendedAPI: false
    })

    // write code to file

Generate table information based on database table, used for customized code generation.

    import "github.com/go-dev-frame/sponge/pkg/sql2code"

    // generate table information based on database table, supports database type: mysql, mongodb, postgres, sqlite3
    codes, err := sql2code.Generate(&sql2code.Args{
      DBDriver: "mysql",
      DBDsn: "root:123456@(127.0.0.1:3306)/account"
      DBTable "user"
      GormType: true,
      JSONTag: true,
      IsEmbed: true,
      IsExtendedAPI: true
    })

    // generate customized code to file