dal

package
v0.0.0-...-bed3fb8 Latest Latest
Warning

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

 Go to latest Published: Jun 16, 2023 License: Apache-2.0 Imports: 9 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

View Source 
var DB *gorm.DB

Functions

func InitDB 

func InitDB() error

Types

type Account 

type Account struct {
	Id       uint64 `gorm:"primaryKey"`
	UserId   uint64 `gorm:"not null"`
	Username string `gorm:"not null; unique"`
	Password string `gorm:"not null"`
	Deleted  gorm.DeletedAt
}

func (Account) FindById 

func (a Account) FindById(ctx context.Context, id uint64) (account *Account, err error)

func (Account) FindByUserId 

func (a Account) FindByUserId(ctx context.Context, id uint64) (account *Account, err error)

func (Account) FindByUsername 

func (a Account) FindByUsername(ctx context.Context, username string) (account *Account, err error)

func (Account) RegisterNewUser 

func (a Account) RegisterNewUser(ctx context.Context, username, passwordHash string) (user *User, err error)

RegisterNewUser register a new Account along with a linked User, using transaction

func (Account) Update 

func (a Account) Update(ctx context.Context, account *Account) error

type AllTable 

type AllTable struct {
	Account  Account
	Building Building
	Dorm     Dorm
	Order    Order
	Team     Team
	TeamUser TeamUser
	Token    Token
	User     User
}
var Table AllTable

type Building 

type Building struct {
	Id      uint64 `gorm:"primaryKey" json:"-"`
	Num     string `gorm:"size:10; not null; unique" json:"num,omitempty"`
	Info    string `json:"info,omitempty"`
	ImgUrl  string `json:"imgUrl,omitempty"`
	Enabled bool   `gorm:"not null" json:"enabled,omitempty"`
	Deleted gorm.DeletedAt
}

func (Building) FindAllEnabled 

func (b Building) FindAllEnabled(ctx context.Context) (buildings []*Building, err error)

func (Building) FindById 

func (b Building) FindById(ctx context.Context, id uint64) (building *Building, err error)

func (Building) FindByNum 

func (b Building) FindByNum(ctx context.Context, num string) (building *Building, err error)

func (Building) PluckAllEnabledIds 

func (b Building) PluckAllEnabledIds(ctx context.Context) (ids []uint64, err error)

type Dorm 

type Dorm struct {
	Id         uint64 `gorm:"primaryKey" json:"-"`
	Num        string `gorm:"size:10; not null; unique" json:"num,omitempty"`
	BuildingId uint64 `gorm:"not null" json:"buildingId,omitempty"`
	Gender     string `gorm:"size:10; not null" json:"gender,omitempty"`
	RemainCnt  uint64 `gorm:"not null" json:"remainCnt,omitempty"`
	BedCnt     uint64 `gorm:"not null" json:"bedCnt,omitempty"`
	Info       string `json:"info,omitempty"`
	Enabled    bool   `gorm:"not null" json:"enabled,omitempty"`
	Deleted    gorm.DeletedAt
}

func (Dorm) Allocate 

func (d Dorm) Allocate(ctx context.Context, buildingId uint64, memberCnt uint64, gender string) (dorm *Dorm, err error)

Allocate find a suitable dorm for the order

func (Dorm) FindAllEnabled 

func (d Dorm) FindAllEnabled(ctx context.Context) (dorms []*Dorm, err error)

func (Dorm) FindById 

func (d Dorm) FindById(ctx context.Context, id uint64) (dorm *Dorm, err error)

func (Dorm) SumRemainCntByBuildingId 

func (d Dorm) SumRemainCntByBuildingId(ctx context.Context, id uint64) (sum int64, err error)

func (Dorm) Update 

func (d Dorm) Update(ctx context.Context, dorm *Dorm) error

type Order 

type Order struct {
	Id         uint64 `gorm:"primaryKey"`
	BuildingId uint64 `gorm:"not null"`
	DormId     uint64 `gorm:"not null; default:0"`
	TeamId     uint64 `gorm:"not null"`
	Code       string `gorm:"not null; unique"`
	Info       string
	Success    bool `gorm:"not null; default:0"`
	Deleted    gorm.DeletedAt
}

func (Order) Create 

func (o Order) Create(ctx context.Context, order *Order) error

func (Order) Delete 

func (o Order) Delete(ctx context.Context, order *Order) error

func (Order) FindAllByTeamIdWithDeleted 

func (o Order) FindAllByTeamIdWithDeleted(ctx context.Context, id uint64) (orders []*Order, err error)

func (Order) FindByCodeWithDeleted 

func (o Order) FindByCodeWithDeleted(ctx context.Context, code string) (order *Order, err error)

FindByCodeWithDeleted is to make sure code is unique, this will include deleted records

func (Order) FindById 

func (o Order) FindById(ctx context.Context, id uint64) (order *Order, err error)

func (Order) FindByIdWithDeleted 

func (o Order) FindByIdWithDeleted(ctx context.Context, id uint64) (order *Order, err error)

func (Order) FindSuccessByTeamId 

func (o Order) FindSuccessByTeamId(ctx context.Context, id uint64) (order *Order, err error)

func (Order) TransCreateAndDecreaseDormRemainCnt 

func (o Order) TransCreateAndDecreaseDormRemainCnt(ctx context.Context, order *Order, dorm *Dorm, memberCnt uint64) error

TransCreateAndDecreaseDormRemainCnt create an order and decrease the corresponding dorm's remain count

func (Order) TransDeleteAndIncreaseDormRemainCnt 

func (o Order) TransDeleteAndIncreaseDormRemainCnt(ctx context.Context, order *Order, dorm *Dorm, memberCnt uint64) error

TransDeleteAndIncreaseDormRemainCnt delete an order and increase the corresponding dorm's remain count

func (Order) Update 

func (o Order) Update(ctx context.Context, order *Order) error

type Team 

type Team struct {
	Id      uint64 `gorm:"primaryKey"`
	Code    string `gorm:"not null; unique"`
	Gender  string `gorm:"size:10; not null"`
	OwnerId uint64 `gorm:"not null; unique"`
	Deleted gorm.DeletedAt
}

func (Team) CheckIfHasTeam 

func (t Team) CheckIfHasTeam(ctx context.Context, userId uint64) (*Team, error)

CheckIfHasTeam checks if a user is a team owner OR a team member

func (Team) Delete 

func (t Team) Delete(ctx context.Context, team *Team) error

func (Team) FindByCode 

func (t Team) FindByCode(ctx context.Context, code string) (team *Team, err error)

func (Team) FindByInnerJoinUserId 

func (t Team) FindByInnerJoinUserId(ctx context.Context, id uint64) (*Team, error)

FindByInnerJoinUserId only finds team member, for owner please use FindByOwnerId

func (Team) FindByOwnerId 

func (t Team) FindByOwnerId(ctx context.Context, id uint64) (*Team, error)

func (Team) GenNew 

func (t Team) GenNew(ctx context.Context, owner *User) (team *Team, err error)

func (Team) TransSetNewOwner 

func (t Team) TransSetNewOwner(ctx context.Context, team *Team, memberRel *TeamUser) error

func (Team) Update 

func (t Team) Update(ctx context.Context, team *Team) error

type TeamUser 

type TeamUser struct {
	Id      uint64 `gorm:"primaryKey"`
	TeamId  uint64 `gorm:"not null"`
	UserId  uint64 `gorm:"not null"`
	Deleted gorm.DeletedAt
}

func (TeamUser) CntTeamMember 

func (t TeamUser) CntTeamMember(ctx context.Context, teamId uint64) (cnt uint64, err error)

func (TeamUser) Create 

func (t TeamUser) Create(ctx context.Context, teamUser *TeamUser) error

func (TeamUser) Delete 

func (t TeamUser) Delete(ctx context.Context, teamUser *TeamUser) error

func (TeamUser) FindByTeamIdAndUserId 

func (t TeamUser) FindByTeamIdAndUserId(ctx context.Context, teamId, userId uint64) (rel *TeamUser, err error)

func (TeamUser) PluckAllUserIdsByTeamId 

func (t TeamUser) PluckAllUserIdsByTeamId(ctx context.Context, teamId uint64) (userIds []uint64, err error)

type Token 

type Token struct {
	Id           uint64    `gorm:"primaryKey" json:"-"`
	RefreshToken string    `gorm:"not null" json:"refreshToken,omitempty"`
	UserId       uint64    `gorm:"not null" json:"-"`
	CreateTime   time.Time `gorm:"not null" json:"createTime,omitempty"`
	ExpTime      time.Time `gorm:"not null" json:"expTime,omitempty"`
	Deleted      gorm.DeletedAt
}

func (Token) FindByRefreshToken 

func (t Token) FindByRefreshToken(ctx context.Context, refreshToken string) (token *Token, err error)

func (Token) GenNew 

func (t Token) GenNew(ctx context.Context, id uint64) (refreshToken string, err error)

type User 

type User struct {
	Id         uint64 `gorm:"primaryKey" json:"-"`
	StudentNum string `gorm:"not null; unique" json:"studentNum,omitempty"`
	Name       string `gorm:"size:20; not null" json:"name,omitempty"`
	Gender     string `gorm:"size:10; not null" json:"gender,omitempty"`
	Role       int32  `gorm:"not null; default:1" json:"-"`
	Deleted    gorm.DeletedAt
}

func (User) Create 

func (u User) Create(ctx context.Context, user *User) error

func (User) FindAll 

func (u User) FindAll(ctx context.Context) (users []*User, err error)

func (User) FindAllByIds 

func (u User) FindAllByIds(ctx context.Context, ids []uint64) (users []*User, err error)

func (User) FindById 

func (u User) FindById(ctx context.Context, userId uint64) (user *User, err error)

func (User) FindByStudentNum 

func (u User) FindByStudentNum(ctx context.Context, studentNum string) (user *User, err error)

func (User) Update 

func (u User) Update(ctx context.Context, user *User) error

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.