Files
yokowu 34320f9ed5 feat(phase6): 添加 gitbot/gittask 实体 schema 和 migration
- 新增 git_bots, git_bot_users, git_bot_tasks, project_git_bots 表
- 添加 user, host, project 到 gitbot 的关联边
- 使用 soft delete 和 created_at 游标
2026-03-19 18:14:53 +08:00

800 lines
17 KiB
Go

// Code generated by ent, DO NOT EDIT.
package db
// Extra imports required by this file.
import (
"context"
"encoding/base64"
"fmt"
"strconv"
"strings"
"time"
"entgo.io/ent/dialect/sql"
"github.com/chaitin/MonkeyCode/backend/db/audit"
"github.com/chaitin/MonkeyCode/backend/db/gitbot"
"github.com/chaitin/MonkeyCode/backend/db/host"
"github.com/chaitin/MonkeyCode/backend/db/image"
"github.com/chaitin/MonkeyCode/backend/db/model"
"github.com/chaitin/MonkeyCode/backend/db/notifychannel"
"github.com/chaitin/MonkeyCode/backend/db/notifysendlog"
"github.com/chaitin/MonkeyCode/backend/db/project"
"github.com/chaitin/MonkeyCode/backend/db/projectissue"
"github.com/chaitin/MonkeyCode/backend/db/projectissuecomment"
"github.com/chaitin/MonkeyCode/backend/db/task"
"github.com/chaitin/MonkeyCode/backend/db/teamgroup"
"github.com/chaitin/MonkeyCode/backend/db/teamgrouphost"
"github.com/chaitin/MonkeyCode/backend/db/teamgroupmodel"
"github.com/google/uuid"
)
type Cursor struct {
Cursor string `json:"cursor,omitempty"` // 游标
HasNextPage bool `json:"has_next_page"` // 是否有下一页
}
type createdAtCursor struct {
ID any `json:"id"`
CreatedAt time.Time `json:"created_at"`
}
func (i *createdAtCursor) marshal() (string, error) {
if i == nil {
return "", nil
}
milli := i.CreatedAt.UnixMilli()
b36 := strconv.FormatInt(milli, 36)
switch ii := i.ID.(type) {
case string:
return fmt.Sprintf("s.%s.%s", b36, ii), nil
case uuid.UUID:
bb, err := ii.MarshalBinary()
if err != nil {
return "", err
}
is := base64.RawURLEncoding.EncodeToString(bb)
return fmt.Sprintf("u.%s.%s", b36, is), nil
default:
return "", fmt.Errorf("unsupported ID type")
}
}
func unmarshalCreatedAt(s string) (*createdAtCursor, error) {
if s == "" {
return nil, nil
}
parts := strings.Split(s, ".")
if len(parts) != 3 {
return nil, fmt.Errorf("invalid cursor format")
}
milli, err := strconv.ParseInt(parts[1], 36, 64)
if err != nil {
return nil, err
}
switch parts[0] {
case "s":
return &createdAtCursor{
CreatedAt: time.UnixMilli(milli),
ID: parts[2],
}, nil
case "u":
id, err := base64.RawURLEncoding.DecodeString(parts[2])
if err != nil {
return nil, err
}
uuid, err := uuid.FromBytes(id)
if err != nil {
return nil, err
}
return &createdAtCursor{
CreatedAt: time.UnixMilli(milli),
ID: uuid,
}, nil
default:
return nil, fmt.Errorf("invalid cursor prefix")
}
}
type updateAtCursor struct {
ID any `json:"id"`
UpdatedAt time.Time `json:"updated_at"`
}
func (i *updateAtCursor) marshal() (string, error) {
if i == nil {
return "", nil
}
milli := i.UpdatedAt.UnixMilli()
b36 := strconv.FormatInt(milli, 36)
switch ii := i.ID.(type) {
case string:
return fmt.Sprintf("s.%s.%s", b36, ii), nil
case uuid.UUID:
bb, err := ii.MarshalBinary()
if err != nil {
return "", err
}
is := base64.RawURLEncoding.EncodeToString(bb)
return fmt.Sprintf("u.%s.%s", b36, is), nil
default:
return "", fmt.Errorf("unsupported ID type")
}
}
func unmarshalUpdatedAt(s string) (*updateAtCursor, error) {
if s == "" {
return nil, nil
}
parts := strings.Split(s, ".")
if len(parts) != 3 {
return nil, fmt.Errorf("invalid cursor format")
}
milli, err := strconv.ParseInt(parts[1], 36, 64)
if err != nil {
return nil, err
}
switch parts[0] {
case "s":
return &updateAtCursor{
UpdatedAt: time.UnixMilli(milli),
ID: parts[2],
}, nil
case "u":
id, err := base64.RawURLEncoding.DecodeString(parts[2])
if err != nil {
return nil, err
}
uuid, err := uuid.FromBytes(id)
if err != nil {
return nil, err
}
return &updateAtCursor{
UpdatedAt: time.UnixMilli(milli),
ID: uuid,
}, nil
default:
return nil, fmt.Errorf("invalid cursor prefix")
}
}
func (q *AuditQuery) After(ctx context.Context, cursor string, limit int) ([]*Audit, *Cursor, error) {
i, err := unmarshalCreatedAt(cursor)
if err != nil {
return nil, nil, err
}
q.Order(audit.ByCreatedAt(sql.OrderDesc()), audit.ByID(sql.OrderDesc()))
q.Limit(limit + 1)
if i != nil {
q.Where(func(s *sql.Selector) {
s.Where(sql.Or(
sql.LT(s.C("created_at"), i.CreatedAt),
sql.And(
sql.EQ(s.C("created_at"), i.CreatedAt),
sql.LT(s.C("id"), i.ID),
),
))
})
}
nodes, err := q.All(ctx)
if err != nil {
return nil, nil, err
}
res := &Cursor{}
if len(nodes) > limit {
res.HasNextPage = true
nodes = nodes[:limit]
}
if len(nodes) > 0 {
last := nodes[len(nodes)-1]
i := &createdAtCursor{
CreatedAt: last.CreatedAt,
ID: last.ID,
}
cursor, err := i.marshal()
if err != nil {
return nil, nil, err
}
res.Cursor = cursor
}
return nodes, res, nil
}
func (q *GitBotQuery) After(ctx context.Context, cursor string, limit int) ([]*GitBot, *Cursor, error) {
i, err := unmarshalCreatedAt(cursor)
if err != nil {
return nil, nil, err
}
q.Order(gitbot.ByCreatedAt(sql.OrderDesc()), gitbot.ByID(sql.OrderDesc()))
q.Limit(limit + 1)
if i != nil {
q.Where(func(s *sql.Selector) {
s.Where(sql.Or(
sql.LT(s.C("created_at"), i.CreatedAt),
sql.And(
sql.EQ(s.C("created_at"), i.CreatedAt),
sql.LT(s.C("id"), i.ID),
),
))
})
}
nodes, err := q.All(ctx)
if err != nil {
return nil, nil, err
}
res := &Cursor{}
if len(nodes) > limit {
res.HasNextPage = true
nodes = nodes[:limit]
}
if len(nodes) > 0 {
last := nodes[len(nodes)-1]
i := &createdAtCursor{
CreatedAt: last.CreatedAt,
ID: last.ID,
}
cursor, err := i.marshal()
if err != nil {
return nil, nil, err
}
res.Cursor = cursor
}
return nodes, res, nil
}
func (q *HostQuery) After(ctx context.Context, cursor string, limit int) ([]*Host, *Cursor, error) {
i, err := unmarshalCreatedAt(cursor)
if err != nil {
return nil, nil, err
}
q.Order(host.ByCreatedAt(sql.OrderDesc()), host.ByID(sql.OrderDesc()))
q.Limit(limit + 1)
if i != nil {
q.Where(func(s *sql.Selector) {
s.Where(sql.Or(
sql.LT(s.C("created_at"), i.CreatedAt),
sql.And(
sql.EQ(s.C("created_at"), i.CreatedAt),
sql.LT(s.C("id"), i.ID),
),
))
})
}
nodes, err := q.All(ctx)
if err != nil {
return nil, nil, err
}
res := &Cursor{}
if len(nodes) > limit {
res.HasNextPage = true
nodes = nodes[:limit]
}
if len(nodes) > 0 {
last := nodes[len(nodes)-1]
i := &createdAtCursor{
CreatedAt: last.CreatedAt,
ID: last.ID,
}
cursor, err := i.marshal()
if err != nil {
return nil, nil, err
}
res.Cursor = cursor
}
return nodes, res, nil
}
func (q *ImageQuery) After(ctx context.Context, cursor string, limit int) ([]*Image, *Cursor, error) {
i, err := unmarshalCreatedAt(cursor)
if err != nil {
return nil, nil, err
}
q.Order(image.ByCreatedAt(sql.OrderDesc()), image.ByID(sql.OrderDesc()))
q.Limit(limit + 1)
if i != nil {
q.Where(func(s *sql.Selector) {
s.Where(sql.Or(
sql.LT(s.C("created_at"), i.CreatedAt),
sql.And(
sql.EQ(s.C("created_at"), i.CreatedAt),
sql.LT(s.C("id"), i.ID),
),
))
})
}
nodes, err := q.All(ctx)
if err != nil {
return nil, nil, err
}
res := &Cursor{}
if len(nodes) > limit {
res.HasNextPage = true
nodes = nodes[:limit]
}
if len(nodes) > 0 {
last := nodes[len(nodes)-1]
i := &createdAtCursor{
CreatedAt: last.CreatedAt,
ID: last.ID,
}
cursor, err := i.marshal()
if err != nil {
return nil, nil, err
}
res.Cursor = cursor
}
return nodes, res, nil
}
func (q *ModelQuery) After(ctx context.Context, cursor string, limit int) ([]*Model, *Cursor, error) {
i, err := unmarshalCreatedAt(cursor)
if err != nil {
return nil, nil, err
}
q.Order(model.ByCreatedAt(sql.OrderDesc()), model.ByID(sql.OrderDesc()))
q.Limit(limit + 1)
if i != nil {
q.Where(func(s *sql.Selector) {
s.Where(sql.Or(
sql.LT(s.C("created_at"), i.CreatedAt),
sql.And(
sql.EQ(s.C("created_at"), i.CreatedAt),
sql.LT(s.C("id"), i.ID),
),
))
})
}
nodes, err := q.All(ctx)
if err != nil {
return nil, nil, err
}
res := &Cursor{}
if len(nodes) > limit {
res.HasNextPage = true
nodes = nodes[:limit]
}
if len(nodes) > 0 {
last := nodes[len(nodes)-1]
i := &createdAtCursor{
CreatedAt: last.CreatedAt,
ID: last.ID,
}
cursor, err := i.marshal()
if err != nil {
return nil, nil, err
}
res.Cursor = cursor
}
return nodes, res, nil
}
func (q *NotifyChannelQuery) After(ctx context.Context, cursor string, limit int) ([]*NotifyChannel, *Cursor, error) {
i, err := unmarshalCreatedAt(cursor)
if err != nil {
return nil, nil, err
}
q.Order(notifychannel.ByCreatedAt(sql.OrderDesc()), notifychannel.ByID(sql.OrderDesc()))
q.Limit(limit + 1)
if i != nil {
q.Where(func(s *sql.Selector) {
s.Where(sql.Or(
sql.LT(s.C("created_at"), i.CreatedAt),
sql.And(
sql.EQ(s.C("created_at"), i.CreatedAt),
sql.LT(s.C("id"), i.ID),
),
))
})
}
nodes, err := q.All(ctx)
if err != nil {
return nil, nil, err
}
res := &Cursor{}
if len(nodes) > limit {
res.HasNextPage = true
nodes = nodes[:limit]
}
if len(nodes) > 0 {
last := nodes[len(nodes)-1]
i := &createdAtCursor{
CreatedAt: last.CreatedAt,
ID: last.ID,
}
cursor, err := i.marshal()
if err != nil {
return nil, nil, err
}
res.Cursor = cursor
}
return nodes, res, nil
}
func (q *NotifySendLogQuery) After(ctx context.Context, cursor string, limit int) ([]*NotifySendLog, *Cursor, error) {
i, err := unmarshalCreatedAt(cursor)
if err != nil {
return nil, nil, err
}
q.Order(notifysendlog.ByCreatedAt(sql.OrderDesc()), notifysendlog.ByID(sql.OrderDesc()))
q.Limit(limit + 1)
if i != nil {
q.Where(func(s *sql.Selector) {
s.Where(sql.Or(
sql.LT(s.C("created_at"), i.CreatedAt),
sql.And(
sql.EQ(s.C("created_at"), i.CreatedAt),
sql.LT(s.C("id"), i.ID),
),
))
})
}
nodes, err := q.All(ctx)
if err != nil {
return nil, nil, err
}
res := &Cursor{}
if len(nodes) > limit {
res.HasNextPage = true
nodes = nodes[:limit]
}
if len(nodes) > 0 {
last := nodes[len(nodes)-1]
i := &createdAtCursor{
CreatedAt: last.CreatedAt,
ID: last.ID,
}
cursor, err := i.marshal()
if err != nil {
return nil, nil, err
}
res.Cursor = cursor
}
return nodes, res, nil
}
func (q *ProjectQuery) After(ctx context.Context, cursor string, limit int) ([]*Project, *Cursor, error) {
i, err := unmarshalUpdatedAt(cursor)
if err != nil {
return nil, nil, err
}
q.Order(project.ByUpdatedAt(sql.OrderDesc()), project.ByID(sql.OrderDesc()))
q.Limit(limit + 1)
if i != nil {
q.Where(func(s *sql.Selector) {
s.Where(sql.Or(
sql.LT(s.C("updated_at"), i.UpdatedAt),
sql.And(
sql.EQ(s.C("updated_at"), i.UpdatedAt),
sql.LT(s.C("id"), i.ID),
),
))
})
}
nodes, err := q.All(ctx)
if err != nil {
return nil, nil, err
}
res := &Cursor{}
if len(nodes) > limit {
res.HasNextPage = true
nodes = nodes[:limit]
}
if len(nodes) > 0 {
last := nodes[len(nodes)-1]
i := &updateAtCursor{
UpdatedAt: last.UpdatedAt,
ID: last.ID,
}
cursor, err := i.marshal()
if err != nil {
return nil, nil, err
}
res.Cursor = cursor
}
return nodes, res, nil
}
func (q *ProjectIssueQuery) After(ctx context.Context, cursor string, limit int) ([]*ProjectIssue, *Cursor, error) {
i, err := unmarshalCreatedAt(cursor)
if err != nil {
return nil, nil, err
}
q.Order(projectissue.ByCreatedAt(sql.OrderDesc()), projectissue.ByID(sql.OrderDesc()))
q.Limit(limit + 1)
if i != nil {
q.Where(func(s *sql.Selector) {
s.Where(sql.Or(
sql.LT(s.C("created_at"), i.CreatedAt),
sql.And(
sql.EQ(s.C("created_at"), i.CreatedAt),
sql.LT(s.C("id"), i.ID),
),
))
})
}
nodes, err := q.All(ctx)
if err != nil {
return nil, nil, err
}
res := &Cursor{}
if len(nodes) > limit {
res.HasNextPage = true
nodes = nodes[:limit]
}
if len(nodes) > 0 {
last := nodes[len(nodes)-1]
i := &createdAtCursor{
CreatedAt: last.CreatedAt,
ID: last.ID,
}
cursor, err := i.marshal()
if err != nil {
return nil, nil, err
}
res.Cursor = cursor
}
return nodes, res, nil
}
func (q *ProjectIssueCommentQuery) After(ctx context.Context, cursor string, limit int) ([]*ProjectIssueComment, *Cursor, error) {
i, err := unmarshalCreatedAt(cursor)
if err != nil {
return nil, nil, err
}
q.Order(projectissuecomment.ByCreatedAt(sql.OrderDesc()), projectissuecomment.ByID(sql.OrderDesc()))
q.Limit(limit + 1)
if i != nil {
q.Where(func(s *sql.Selector) {
s.Where(sql.Or(
sql.LT(s.C("created_at"), i.CreatedAt),
sql.And(
sql.EQ(s.C("created_at"), i.CreatedAt),
sql.LT(s.C("id"), i.ID),
),
))
})
}
nodes, err := q.All(ctx)
if err != nil {
return nil, nil, err
}
res := &Cursor{}
if len(nodes) > limit {
res.HasNextPage = true
nodes = nodes[:limit]
}
if len(nodes) > 0 {
last := nodes[len(nodes)-1]
i := &createdAtCursor{
CreatedAt: last.CreatedAt,
ID: last.ID,
}
cursor, err := i.marshal()
if err != nil {
return nil, nil, err
}
res.Cursor = cursor
}
return nodes, res, nil
}
func (q *TaskQuery) After(ctx context.Context, cursor string, limit int) ([]*Task, *Cursor, error) {
i, err := unmarshalCreatedAt(cursor)
if err != nil {
return nil, nil, err
}
q.Order(task.ByCreatedAt(sql.OrderDesc()), task.ByID(sql.OrderDesc()))
q.Limit(limit + 1)
if i != nil {
q.Where(func(s *sql.Selector) {
s.Where(sql.Or(
sql.LT(s.C("created_at"), i.CreatedAt),
sql.And(
sql.EQ(s.C("created_at"), i.CreatedAt),
sql.LT(s.C("id"), i.ID),
),
))
})
}
nodes, err := q.All(ctx)
if err != nil {
return nil, nil, err
}
res := &Cursor{}
if len(nodes) > limit {
res.HasNextPage = true
nodes = nodes[:limit]
}
if len(nodes) > 0 {
last := nodes[len(nodes)-1]
i := &createdAtCursor{
CreatedAt: last.CreatedAt,
ID: last.ID,
}
cursor, err := i.marshal()
if err != nil {
return nil, nil, err
}
res.Cursor = cursor
}
return nodes, res, nil
}
func (q *TeamGroupQuery) After(ctx context.Context, cursor string, limit int) ([]*TeamGroup, *Cursor, error) {
i, err := unmarshalCreatedAt(cursor)
if err != nil {
return nil, nil, err
}
q.Order(teamgroup.ByCreatedAt(sql.OrderDesc()), teamgroup.ByID(sql.OrderDesc()))
q.Limit(limit + 1)
if i != nil {
q.Where(func(s *sql.Selector) {
s.Where(sql.Or(
sql.LT(s.C("created_at"), i.CreatedAt),
sql.And(
sql.EQ(s.C("created_at"), i.CreatedAt),
sql.LT(s.C("id"), i.ID),
),
))
})
}
nodes, err := q.All(ctx)
if err != nil {
return nil, nil, err
}
res := &Cursor{}
if len(nodes) > limit {
res.HasNextPage = true
nodes = nodes[:limit]
}
if len(nodes) > 0 {
last := nodes[len(nodes)-1]
i := &createdAtCursor{
CreatedAt: last.CreatedAt,
ID: last.ID,
}
cursor, err := i.marshal()
if err != nil {
return nil, nil, err
}
res.Cursor = cursor
}
return nodes, res, nil
}
func (q *TeamGroupHostQuery) After(ctx context.Context, cursor string, limit int) ([]*TeamGroupHost, *Cursor, error) {
i, err := unmarshalCreatedAt(cursor)
if err != nil {
return nil, nil, err
}
q.Order(teamgrouphost.ByCreatedAt(sql.OrderDesc()), teamgrouphost.ByID(sql.OrderDesc()))
q.Limit(limit + 1)
if i != nil {
q.Where(func(s *sql.Selector) {
s.Where(sql.Or(
sql.LT(s.C("created_at"), i.CreatedAt),
sql.And(
sql.EQ(s.C("created_at"), i.CreatedAt),
sql.LT(s.C("id"), i.ID),
),
))
})
}
nodes, err := q.All(ctx)
if err != nil {
return nil, nil, err
}
res := &Cursor{}
if len(nodes) > limit {
res.HasNextPage = true
nodes = nodes[:limit]
}
if len(nodes) > 0 {
last := nodes[len(nodes)-1]
i := &createdAtCursor{
CreatedAt: last.CreatedAt,
ID: last.ID,
}
cursor, err := i.marshal()
if err != nil {
return nil, nil, err
}
res.Cursor = cursor
}
return nodes, res, nil
}
func (q *TeamGroupModelQuery) After(ctx context.Context, cursor string, limit int) ([]*TeamGroupModel, *Cursor, error) {
i, err := unmarshalCreatedAt(cursor)
if err != nil {
return nil, nil, err
}
q.Order(teamgroupmodel.ByCreatedAt(sql.OrderDesc()), teamgroupmodel.ByID(sql.OrderDesc()))
q.Limit(limit + 1)
if i != nil {
q.Where(func(s *sql.Selector) {
s.Where(sql.Or(
sql.LT(s.C("created_at"), i.CreatedAt),
sql.And(
sql.EQ(s.C("created_at"), i.CreatedAt),
sql.LT(s.C("id"), i.ID),
),
))
})
}
nodes, err := q.All(ctx)
if err != nil {
return nil, nil, err
}
res := &Cursor{}
if len(nodes) > limit {
res.HasNextPage = true
nodes = nodes[:limit]
}
if len(nodes) > 0 {
last := nodes[len(nodes)-1]
i := &createdAtCursor{
CreatedAt: last.CreatedAt,
ID: last.ID,
}
cursor, err := i.marshal()
if err != nil {
return nil, nil, err
}
res.Cursor = cursor
}
return nodes, res, nil
}