si3nloong / sqlgen Goto Github PK

Right now, we automatic assign the marshaler and unmarshaler by default, should have a way to set custom marshaler and unmarshaler instead.

Currently, we cannot enforce the unsigned decimal schema.

Add documentation and guide

Support fixed size byte, rune

The current codegen doesn't map the multi pointers struct field, it will ignore instead.

type DblPtr struct {
	ID             uint64 `sql:",auto_increment"`
	PtrInt64       *int64
	L7PtrStr       *******string
	L3PtrUint      ***uint
	L5PtrInt8      *****int8
}

Maybe we can have a InsertOneStmt.

Configure getter prefix name.

Currently, we didn't support mssql driver. To support it, may refer to https://github.com/microsoft/go-mssqldb

The current version of sqlgen is too simple, it unable to handle complex situation like WHERE, ORDER BY, LIMIT etc.

Allow codegen to respect glob value, such as ./**/*, *.go, **/model.go, */model.go

Generated columns doesn't follow the order of struct properties

The latest updated code is a bug, it affected our github actions, migration and others. Following are the bugs :

• VALUE column is not found
• unsigned integer doesn't support 0, should be greater and equal to 0

It's now static, should provide unsafe option, remove existing column, add any new column

Strict mode should sound when:

- [ ] invalid tag with go type

• invalid tag with go marshaler and unmarshaler (e.g binary)
• duplicate primary key
• duplicate column name
• unmatched function footprint with sequel interfaces
• validate custom column name

We should allow user to configure whether to generate the migration functionality, such as CREATE TABLE, ALTER TABLE, etc

The current support for Postgres is quite buggy

Question ask from ChinHan: If I customize the table name by defining my own func (User) TableName(), would AlterTableStmt() use that?

Composite key is a key which is the combination of more than one field or column of a given table. It may be a candidate key or primary key.

Sometime, it doesn't make sense for us to specify a PK, but we want to combine multiple column to become a primary key.
https://www.javatpoint.com/sql-composite-key

Currently, when we run the generate function, it will generate the codes even for the struct that sqlgen generated, but this is not the thing we want.

Please, don't generate codes for any code generated file or we should have an option to optin.

To debug and check what output files has been created

Since we're parsing the go package, we should be able to check the custom type enum values.

Currently, the codegen didn't validate the name provided in tag, we need to validate it to prevent invalid value to become column name.

Currently, we only include the Table name in the SQL statement, not included the database name. Sometime, we need to specific some table to specific database.

Minimum requirement:

• Database name is optional

Example :

ts.go

type ts struct{
  CreatedAt time.Time
}

user.go

type User struct{
  ts
}

Previous generated code has type declaration for every getter, but go1.22 has infer type, no longer need to declare type explicitly.

https://go.dev/blog/generate

• Binary uuid primary key
• Auto increment pk
• Embedded imported struct
• Embedded local struct
• Type definition struct
• Custom marshaler and unmarshaler
• Custom data type

For example:

import (
	"cloud.google.com/go/civil"
)

type B struct {
   civil.DateTime
}

This will not work atm.

Currently, we cannot UPSERT the record, it's better we generate the UPSERT code in db module