database/gdb: scan zero value for google.protobuf.Timestamp

[zcyc]

Go version

go version go1.22.3 darwin/amd64

GoFrame version

v2.7.0

Can this bug be reproduced with the latest release?

Option Yes

What did you do?

I run gf-demo-grpc and use PostgresSQL for database. DDL is:

create table "user"
(
    id serial primary key,
    passport  varchar(45) not null unique,
    password  varchar(45) not null,
    nickname  varchar(45) not null,
    create_at timestamp,
    update_at timestamp,
    delete_at timestamp
);

When i request the GetById method, scan the zero value for google.protobuf.Timestamp of pbentity.User

What did you see happen?

{
    "User": {
        "Id": 1,
        "Passport": "正团小斯",
        "Password": "口际严消只但",
        "Nickname": "进影一得华来行",
        "CreateAt": {
            "seconds": "0",
            "nanos": 0
        },
        "UpdateAt": {
            "seconds": "0",
            "nanos": 0
        },
        "DeleteAt": null
    }
}

What did you expect to see?

{
    "User": {
        "Id": 1,
        "Passport": "正团小斯",
        "Password": "口际严消只但",
        "Nickname": "进影一得华来行",
        "CreateAt": {
            "seconds": "1715155546",
            "nanos": 0
        },
        "UpdateAt": {
            "seconds": "1715155546",
            "nanos": 0
        },
        "DeleteAt": null
    }
}

[zcyc]

目前是这样实现的，不知道有没有更优雅的方式

func (s *sUser) GetById(ctx context.Context, uid uint64) (*pbentity.User, error) {
    var (
        user   *entity.User
        userPB *pbentity.User
    )

    // 从数据库中获取用户信息
    err := dao.User.Ctx(ctx).Where(do.User{
        Id: uid,
    }).Scan(&user)
    if user == nil {
        return nil, gerror.NewCodef(gcode.CodeInvalidParameter, g.I18n().T(ctx, "{#user-not-found}"))
    }

    // 转换 pb 对象
    if err := gconv.Struct(user, &userPB); err != nil {
        return nil, gerror.NewCodef(gcode.CodeInternalError, g.I18n().T(ctx, "{#system-busy}"))
    }

    // 处理 pb 时间
    userPB.CreateAt = timestamppb.New(user.CreateAt.Time)
    userPB.UpdateAt = timestamppb.New(user.UpdateAt.Time)

    return userPB, err
}

[Issues-translate-bot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

---

This is currently possible, but I don’t know if there is a more elegant way.

func (s *sUser) GetById(ctx context.Context, uid uint64) (*pbentity.User, error) {
var (
user *entity.User
userPB *pbentity.User
)

// Get user information from the database err := dao.User.Ctx(ctx).Where(do.User{ Id: uid, }).Scan(&user) if user == nil { return nil, gerror.NewCodef(gcode.CodeInvalidParameter, g.I18n().T(ctx, "{#user-not-found}")) }

// Convert pb object if err := gconv.Struct(user, &userPB); err != nil { return nil, gerror.NewCodef(gcode.CodeInternalError, g.I18n().T(ctx, "{#system-busy}")) }

// Process pb time userPB.CreateAt = timestamppb.New(user.CreateAt.Time) userPB.UpdateAt = timestamppb.New(user.UpdateAt.Time)

return userPB, err }

[wln32]

@zcyc 可以试试给字段实现一个json.Unmarshaler接口