mysqlr

type AutoBlog struct {
	Id        int64     `mysql:"id"`
	UserId    int32     `mysql:"user_id"`
	Title     string    `mysql:"title"`
	Content   string    `mysql:"content"`
	Status    int32     `mysql:"status"`
	Readed    int32     `mysql:"readed"`
	CreatedAt time.Time `mysql:"created_at"`
	UpdatedAt time.Time `mysql:"updated_at"`
}

type Blog struct {
	Id        int64     `mysql:"id"`
	UserId    int32     `mysql:"user_id"`
	Title     string    `mysql:"title"`
	Content   string    `mysql:"content"`
	Status    int32     `mysql:"status"`
	Readed    int32     `mysql:"readed"`
	CreatedAt time.Time `mysql:"created_at"`
	UpdatedAt time.Time `mysql:"updated_at"`
}

type BlogAggrReq struct {
	Id int64 `sql:"id"`
}

type BlogAggrResp struct {
	Count any `sql:"count"`
}

type BlogFuncReq struct {
	Id int64 `sql:"id"`
}

type BlogFuncResp struct {
	LenTitle any `sql:"len_title"`
	UTitle   any `sql:"u_title"`
}

type BlogJoinOrderByReq struct {
	Id int64 `sql:"id"`
}

type BlogJoinOrderByResp struct {
	Bid int64 `sql:"bid"`
	Uid int64 `sql:"uid"`
}

type BlogLikeReq struct {
	Title string `sql:"title"`
}

type BlogLikeResp struct {
	Id     int64 `sql:"id"`
	Status int32 `sql:"status"`
}

type BlogOrderByReq struct {
	UserId int64 `sql:"user_id"`
	Offset int32 `sql:"offset"`
	Limit  int32 `sql:"limit"`
}

type BlogOrderByResp struct {
	Status int32 `sql:"status"`
	UserId int32 `sql:"user_id"`
}

type BlogReq struct {
	Id     int64 `sql:"id"`
	Offset int32 `sql:"offset"`
	Limit  int32 `sql:"limit"`
}

type BlogResp struct {
	Id     int64 `sql:"id"`
	Status int32 `sql:"status"`
}

type DBFetcher interface {
	FetchBySQL(sql string, args ...interface{}) ([]interface{}, error)
}

type IdOfAutoBlogPK struct {
	Id int64
}

type IdUserIdOfBlogPK struct {
	Id     int64
	UserId int32
}

type IdUserIdOfUserPK struct {
	Id     int64
	UserId int32
}

type Index interface {
	SQL
	Key() string
	PositionOffsetLimit(len int) (int, int)
}

type MySQLConfig struct {
	Host            string
	Port            int
	UserName        string
	Password        string
	Database        string
	PoolSize        int
	ConnMaxLifeTime time.Duration
}

type NameUserIdOfUserUK struct {
	Name   string
	UserId int32
}

type NameUserIdOfUserUKs []*NameUserIdOfUserUK

type PrimaryKey interface {
	Key() string
	SQLFormat() string
	SQLParams() []interface{}
	Columns() []string
	Parse(key string) error
}

type RawQueryOption struct {
	// contains filtered or unexported fields
}

type RawQueryOptionHandler func(*RawQueryOption)

type SQL interface {
	SQLFormat(limit bool) string
	SQLParams() []interface{}
	SQLLimit() int
	Offset(n int)
	Limit(n int)
}

type StatusOfAutoBlogIDX struct {
	Status int32
	// contains filtered or unexported fields
}

type StatusOfBlogIDX struct {
	Status int32
	// contains filtered or unexported fields
}

type TitleOfBlogUK struct {
	Title string
}

type TitleOfBlogUKs []*TitleOfBlogUK

type Unique interface {
	SQL
	Key() string
}

type User struct {
	Id        int64  `mysql:"id"`
	UserId    int32  `mysql:"user_id"`
	Name      string `mysql:"name"`
	CreatedAt int64  `mysql:"created_at"`
	UpdatedAt int64  `mysql:"updated_at"`
}

type UserIdTitleOfBlogUK struct {
	UserId int32
	Title  string
}

type UserIdTitleOfBlogUKs []*UserIdTitleOfBlogUK