dao

package
v0.0.1 Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Dec 17, 2024 License: MIT Imports: 7 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func InitTable 

func InitTable(db *gorm.DB)

InitTable init tables A bad practice

Types

type Article 

type Article struct {
	ID        int64  `gorm:"primary_key;AUTO_INCREMENT"`
	Title     string `gorm:"type:varchar(4096);"`
	Content   string `gorm:"type:text;"`
	AuthorID  int64  `gorm:"index"`
	Status    uint8
	CreatedAt int64
	UpdatedAt int64
}

type ArticleDao 

type ArticleDao interface {
	Insert(ctx context.Context, art Article) (int64, error)
	UpdateByID(ctx context.Context, art Article) error
	Sync(ctx context.Context, art Article) (int64, error)
	SyncStatus(ctx context.Context, uid int64, id int64, status uint8) error
	ListByAuthor(ctx context.Context, uid int64, page int64, pageSize int64) ([]Article, error)
	GetById(ctx context.Context, uid int64, id int64) (Article, error)
	GetPubById(ctx context.Context, uid int64, id int64) (PublishedArticle, error)
}

func NewArticleDao 

func NewArticleDao(db *gorm.DB) ArticleDao

type GormArticleDao 

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

func (*GormArticleDao) GetById 

func (dao *GormArticleDao) GetById(ctx context.Context, uid int64, id int64) (Article, error)

func (*GormArticleDao) GetPubById 

func (dao *GormArticleDao) GetPubById(ctx context.Context, uid int64, id int64) (PublishedArticle, error)

func (*GormArticleDao) Insert 

func (dao *GormArticleDao) Insert(ctx context.Context, art Article) (int64, error)

func (*GormArticleDao) ListByAuthor 

func (dao *GormArticleDao) ListByAuthor(ctx context.Context, uid int64, page int64, pageSize int64) ([]Article, error)

func (*GormArticleDao) Sync 

func (dao *GormArticleDao) Sync(ctx context.Context, art Article) (int64, error)

func (*GormArticleDao) SyncStatus 

func (dao *GormArticleDao) SyncStatus(ctx context.Context, uid int64, id int64, status uint8) error

func (*GormArticleDao) UpdateByID 

func (dao *GormArticleDao) UpdateByID(ctx context.Context, art Article) error

type GormHistoryDao 

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

func (*GormHistoryDao) GetByUser 

func (dao *GormHistoryDao) GetByUser(ctx context.Context, userId int64) ([]History, error)

func (*GormHistoryDao) Insert 

func (dao *GormHistoryDao) Insert(ctx context.Context, history History) error

type GormInteractiveDao 

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

func (*GormInteractiveDao) DeleteLikeBiz 

func (dao *GormInteractiveDao) DeleteLikeBiz(ctx context.Context, userId int64, bizID int64, biz string) error

func (*GormInteractiveDao) Get 

func (dao *GormInteractiveDao) Get(ctx context.Context, id int64, biz string) (Interactive, error)

func (*GormInteractiveDao) GetCollectInfo 

func (dao *GormInteractiveDao) GetCollectInfo(ctx context.Context, uid int64, id int64, biz string) (UserCollectionBiz, error)

func (*GormInteractiveDao) GetLikedInfo 

func (dao *GormInteractiveDao) GetLikedInfo(ctx context.Context, uid int64, id int64, biz string) (UserLikeBiz, error)

func (*GormInteractiveDao) IncrReadCnt 

func (dao *GormInteractiveDao) IncrReadCnt(ctx context.Context, bizID int64, biz string) error

func (*GormInteractiveDao) InsertCollectBiz 

func (dao *GormInteractiveDao) InsertCollectBiz(ctx context.Context, uid int64, id int64, cid int64, biz string) error

func (*GormInteractiveDao) InsertLikeBiz 

func (dao *GormInteractiveDao) InsertLikeBiz(ctx context.Context, userId int64, bizID int64, biz string) error

type History 

type History struct {
	ID        int64 `gorm:"primary_key;AUTO_INCREMENT"`
	UserID    int64
	BizID     int64
	CreatedAt int64
	UpdatedAt int64
}

type HistoryDao 

type HistoryDao interface {
	GetByUser(ctx context.Context, userId int64) ([]History, error)
	Insert(ctx context.Context, history History) error
}

func NewHistoryDao 

func NewHistoryDao(db *gorm.DB) HistoryDao

type Interactive 

type Interactive struct {
	ID         int64  `gorm:"primary_key;AUTO_INCREMENT"`
	BizID      int64  `gorm:"uniqueIndex:biz_type_id"`
	Biz        string `gorm:"type:varchar(128);uniqueIndex:biz_type_id"`
	ReadCnt    int
	LikeCnt    int
	CollectCnt int
	CreatedAt  int64
	UpdatedAt  int64
}

type InteractiveDao 

type InteractiveDao interface {
	IncrReadCnt(ctx context.Context, bizID int64, biz string) error
	InsertLikeBiz(ctx context.Context, userId int64, bizID int64, biz string) error
	DeleteLikeBiz(ctx context.Context, userId int64, bizID int64, biz string) error
	InsertCollectBiz(ctx context.Context, uid int64, id int64, cid int64, biz string) error
	Get(ctx context.Context, id int64, biz string) (Interactive, error)
	GetLikedInfo(ctx context.Context, uid int64, id int64, biz string) (UserLikeBiz, error)
	GetCollectInfo(ctx context.Context, uid int64, id int64, biz string) (UserCollectionBiz, error)
}

func NewInteractiveDao 

func NewInteractiveDao(db *gorm.DB) InteractiveDao

type PublishedArticle 

type PublishedArticle Article

type User 

type User struct {
	ID        int64   `gorm:"primary_key;AUTO_INCREMENT"`
	Password  string  `gorm:"size:255;"`
	Email     *string `gorm:"unique;size:255;"`
	Phone     string
	Nickname  string `gorm:"type:varchar(255)"`
	Birthday  int64
	AboutMe   string `gorm:"type:varchar(4096)"`
	CreatedAt int64
	UpdatedAt int64
}

User user table construct

type UserCollectionBiz 

type UserCollectionBiz struct {
	ID        int64  `gorm:"primary_key;AUTO_INCREMENT"`
	UserID    int64  `gorm:"uniqueIndex:user_biz_type_id"`
	BizID     int64  `gorm:"uniqueIndex:user_biz_type_id"`
	Biz       string `gorm:"type:varchar(128);uniqueIndex:user_biz_type_id"`
	CID       int64  `gorm:"index"`
	CreatedAt int64
	UpdatedAt int64
}

type UserDAO 

type UserDAO interface {
	Insert(ctx context.Context, user User) error
	FindByEmail(ctx context.Context, email string) (User, error)
	FindByID(ctx context.Context, id int64) (User, error)
	UpdateByID(ctx context.Context, user User) error
	GetList(ctx context.Context, page, pageSize int) ([]User, int, error)
	FindOrCreateByPhone(ctx context.Context, phone string) (User, error)
}

func NewUserDAOGORM 

func NewUserDAOGORM(db *gorm.DB) UserDAO

type UserDAOGORM 

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

func (*UserDAOGORM) FindByEmail 

func (dao *UserDAOGORM) FindByEmail(ctx context.Context, email string) (User, error)

FindByEmail Finds user by email

func (*UserDAOGORM) FindByID 

func (dao *UserDAOGORM) FindByID(ctx context.Context, id int64) (User, error)

FindByID find user by id

func (*UserDAOGORM) FindOrCreateByPhone 

func (dao *UserDAOGORM) FindOrCreateByPhone(ctx context.Context, phone string) (User, error)

func (*UserDAOGORM) GetList 

func (dao *UserDAOGORM) GetList(ctx context.Context, page, pageSize int) ([]User, int, error)

func (*UserDAOGORM) Insert 

func (dao *UserDAOGORM) Insert(ctx context.Context, user User) error

Insert implements UserDAO.

func (*UserDAOGORM) UpdateByID 

func (dao *UserDAOGORM) UpdateByID(ctx context.Context, user User) error

UpdateByID update by id,only can update birthday, aboutme, nickname

type UserLikeBiz 

type UserLikeBiz struct {
	ID        int64  `gorm:"primary_key;AUTO_INCREMENT"`
	UserID    int64  `gorm:"uniqueIndex:user_biz_type_id"`
	BizID     int64  `gorm:"uniqueIndex:user_biz_type_id"`
	Biz       string `gorm:"type:varchar(128);uniqueIndex:user_biz_type_id"`
	Status    int    `gorm:"comment:0-取消 1-喜爱"`
	CreatedAt int64
	UpdatedAt int64
}

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.