db

package

v0.3.0-alpha-2 Latest Latest Go to latest Published: Nov 17, 2023 License: AGPL-3.0 Imports: 13 Imported by: 0

Details

Valid go.mod file
Redistributable license
Tagged version
Stable version
Learn more about best practices

Repository

github.com/synctv-org/synctv

Links

Open Source Insights

Documentation ¶

Index ¶

func AddAdmin(u *model.User) error
func AddAdminByID(userID string) error
func AddRoot(u *model.User) error
func AddRootByID(userID string) error
func AddUserPermission(roomID string, userID string, permission model.RoomUserPermission) error
func AssignFirstOrCreateVendorByUserIDAndVendor(userID string, vendor model.StreamingVendor, conf ...CreateVendorConfig) (*model.StreamingVendorInfo, error)
func AutoMigrate(dst ...any) error
func BanUser(u *model.User) error
func BanUserByID(userID string) error
func Close()
func CreateMovie(movie *model.Movie) error
func CreateMovies(movies []*model.Movie) error
func CreateOrLoadUser(username string, p provider.OAuth2Provider, puid uint64, ...) (*model.User, error)
func CreateRoom(name, password string, maxCount int64, conf ...CreateRoomConfig) (*model.Room, error)
func CreateUser(username string, p provider.OAuth2Provider, puid uint64, ...) (*model.User, error)
func DB() *gorm.DB
func DeleteMovieByID(roomID, id string) error
func DeleteMoviesByRoomID(roomID string) error
func DeleteRoomByID(roomID string) error
func DeleteSettingItem(item *model.Setting) error
func DeleteSettingItemByName(name string) error
func DeleteUserByID(userID string) error
func DeleteVendorByUserIDAndVendor(userID string, vendor model.StreamingVendor) error
func FirstOrCreateRoomUserRelation(roomID, userID string, conf ...CreateRoomUserRelationConfig) (*model.RoomUserRelation, error)
func FirstOrCreateSettingItemValue(s *model.Setting) error
func FirstOrCreateVendorByUserIDAndVendor(userID string, vendor model.StreamingVendor, conf ...CreateVendorConfig) (*model.StreamingVendorInfo, error)
func FirstOrInitVendorByUserIDAndVendor(userID string, vendor model.StreamingVendor, conf ...CreateVendorConfig) (*model.StreamingVendorInfo, error)
func GerUsersIDByIDLike(id string, scopes ...func(*gorm.DB) *gorm.DB) []string
func GerUsersIDByUsernameLike(username string, scopes ...func(*gorm.DB) *gorm.DB) []string
func GetAdmins() []*model.User
func GetAllMoviesByRoomID(roomID string) []*model.Movie
func GetAllRoomUsersRelation(roomID string, scopes ...func(*gorm.DB) *gorm.DB) []*model.RoomUserRelation
func GetAllRoomUsersRelationCount(roomID string, scopes ...func(*gorm.DB) *gorm.DB) int64
func GetAllRooms(scopes ...func(*gorm.DB) *gorm.DB) []*model.Room
func GetAllRoomsAndCreator(scopes ...func(*gorm.DB) *gorm.DB) []*model.Room
func GetAllRoomsByUserID(userID string) []*model.Room
func GetAllRoomsCount(scopes ...func(*gorm.DB) *gorm.DB) int64
func GetAllUserCount(scopes ...func(*gorm.DB) *gorm.DB) int64
func GetAllUsers(scopes ...func(*gorm.DB) *gorm.DB) []*model.User
func GetProviderUserID(p provider.OAuth2Provider, puid uint64) (string, error)
func GetRoomByID(id string) (*model.Room, error)
func GetRoomUserRelation(roomID, userID string) (*model.RoomUserRelation, error)
func GetRoots() []*model.User
func GetSettingItemByName(name string) (*model.Setting, error)
func GetSettingItemValue(name string) (string, error)
func GetSettingItems() ([]*model.Setting, error)
func GetUserByID(id string) (*model.User, error)
func GetUserByIDOrUsernameLike(idOrUsername string, scopes ...func(*gorm.DB) *gorm.DB) ([]*model.User, error)
func GetUserByUsername(username string) (*model.User, error)
func GetUserByUsernameLike(username string, scopes ...func(*gorm.DB) *gorm.DB) []*model.User
func GetVendorByUserID(userID string) ([]*model.StreamingVendorInfo, error)
func GetVendorByUserIDAndVendor(userID string, vendor model.StreamingVendor) (*model.StreamingVendorInfo, error)
func HasRoom(roomID string) (bool, error)
func HasRoomByName(name string) (bool, error)
func Init(d *gorm.DB, t conf.DatabaseType) error
func LoadAndDeleteMovieByID(roomID, id string, columns ...clause.Column) (*model.Movie, error)
func LoadAndDeleteMoviesByRoomID(roomID string, columns ...clause.Column) ([]*model.Movie, error)
func LoadAndDeleteUserByID(userID string, columns ...clause.Column) (*model.User, error)
func OrderByAsc(column string) func(db *gorm.DB) *gorm.DB
func OrderByCreatedAtAsc(db *gorm.DB) *gorm.DB
func OrderByCreatedAtDesc(db *gorm.DB) *gorm.DB
func OrderByDesc(column string) func(db *gorm.DB) *gorm.DB
func OrderByIDAsc(db *gorm.DB) *gorm.DB
func OrderByIDDesc(db *gorm.DB) *gorm.DB
func Paginate(page, pageSize int) func(db *gorm.DB) *gorm.DB
func PreloadRoomUserRelation(scopes ...func(*gorm.DB) *gorm.DB) func(db *gorm.DB) *gorm.DB
func RemoveAdmin(u *model.User) error
func RemoveAdminByID(userID string) error
func RemoveRoot(u *model.User) error
func RemoveRootByID(userID string) error
func RemoveUserPermission(roomID string, userID string, permission model.RoomUserPermission) error
func SaveMovie(movie *model.Movie, columns ...clause.Column) error
func SaveRoomSettings(roomID string, setting model.RoomSettings) error
func SaveSettingItem(item *model.Setting) error
func SaveUser(u *model.User) error
func Select(columns ...string) func(db *gorm.DB) *gorm.DB
func SetRole(u *model.User, role model.Role) error
func SetRoleByID(userID string, role model.Role) error
func SetRoomHashedPassword(roomID string, hashedPassword []byte) error
func SetRoomPassword(roomID, password string) error
func SetRoomStatus(roomID string, status model.RoomStatus) error
func SetRoomStatusByCreator(userID string, status model.RoomStatus) error
func SetRoomUserStatus(roomID string, userID string, status model.RoomUserStatus) error
func SetUserPermission(roomID string, userID string, permission model.RoomUserPermission) error
func SetUsernameByID(userID string, username string) error
func SwapMoviePositions(roomID, movie1ID, movie2ID string) (err error)
func UnbanUser(u *model.User) error
func UnbanUserByID(userID string) error
func UpdateMovie(movie *model.Movie, columns ...clause.Column) error
func UpdateSettingItemValue(name, value string) error
func WhereCreatorID(creatorID string) func(db *gorm.DB) *gorm.DB
func WhereCreatorIDIn(ids []string) func(db *gorm.DB) *gorm.DB
func WhereEqual(column string, value interface{}) func(db *gorm.DB) *gorm.DB
func WhereIDIn(ids []string) func(db *gorm.DB) *gorm.DB
func WhereIDLike(id string) func(db *gorm.DB) *gorm.DB
func WhereLike(column string, value string) func(db *gorm.DB) *gorm.DB
func WhereRole(role model.Role) func(db *gorm.DB) *gorm.DB
func WhereRoomID(roomID string) func(db *gorm.DB) *gorm.DB
func WhereRoomNameLike(name string) func(db *gorm.DB) *gorm.DB
func WhereRoomNameLikeOrCreatorInOrIDLike(name string, ids []string, id string) func(db *gorm.DB) *gorm.DB
func WhereRoomNameLikeOrIDLike(name string, id string) func(db *gorm.DB) *gorm.DB
func WhereRoomSettingHidden() func(db *gorm.DB) *gorm.DB
func WhereRoomSettingWithoutHidden() func(db *gorm.DB) *gorm.DB
func WhereRoomUserStatus(status model.RoomUserStatus) func(db *gorm.DB) *gorm.DB
func WhereStatus(status model.RoomStatus) func(db *gorm.DB) *gorm.DB
func WhereUserID(userID string) func(db *gorm.DB) *gorm.DB
func WhereUsernameLike(name string) func(db *gorm.DB) *gorm.DB
func WhereUsernameLikeOrIDIn(name string, ids []string) func(db *gorm.DB) *gorm.DB
func WithUser(db *gorm.DB) *gorm.DB
func WithUserAndProvider(db *gorm.DB) *gorm.DB
type CreateRoomConfig
- func WithCreator(creator *model.User) CreateRoomConfig
- func WithRelations(relations []model.RoomUserRelation) CreateRoomConfig
- func WithSetting(setting model.RoomSettings) CreateRoomConfig
- func WithStatus(status model.RoomStatus) CreateRoomConfig
type CreateRoomUserRelationConfig
- func WithRoomUserRelationPermissions(permissions model.RoomUserPermission) CreateRoomUserRelationConfig
- func WithRoomUserRelationStatus(status model.RoomUserStatus) CreateRoomUserRelationConfig
type CreateUserConfig
- func WithRole(role model.Role) CreateUserConfig
type CreateVendorConfig
- func WithCookie(cookie []*http.Cookie) CreateVendorConfig

Constants ¶

This section is empty.

Variables ¶

This section is empty.

Functions ¶

func AddAdmin ¶

func AddAdmin(u *model.User) error

func AddAdminByID ¶

func AddAdminByID(userID string) error

func AddRoot ¶

func AddRoot(u *model.User) error

func AddRootByID ¶

func AddRootByID(userID string) error

func AddUserPermission ¶

func AddUserPermission(roomID string, userID string, permission model.RoomUserPermission) error

func AssignFirstOrCreateVendorByUserIDAndVendor ¶

func AssignFirstOrCreateVendorByUserIDAndVendor(userID string, vendor model.StreamingVendor, conf ...CreateVendorConfig) (*model.StreamingVendorInfo, error)

func AutoMigrate ¶

func AutoMigrate(dst ...any) error

func BanUser ¶

func BanUser(u *model.User) error

func BanUserByID ¶

func BanUserByID(userID string) error

func Close ¶

func Close()

func CreateMovie ¶

func CreateMovie(movie *model.Movie) error

func CreateMovies ¶

func CreateMovies(movies []*model.Movie) error

func CreateOrLoadUser ¶

func CreateOrLoadUser(username string, p provider.OAuth2Provider, puid uint64, conf ...CreateUserConfig) (*model.User, error)

只有当provider和puid没有找到对应的user时才会创建

func CreateRoom ¶

func CreateRoom(name, password string, maxCount int64, conf ...CreateRoomConfig) (*model.Room, error)

if maxCount is 0, it will be ignored

func CreateUser ¶

func CreateUser(username string, p provider.OAuth2Provider, puid uint64, conf ...CreateUserConfig) (*model.User, error)

func DB ¶

func DB() *gorm.DB

func DeleteMovieByID ¶

func DeleteMovieByID(roomID, id string) error

func DeleteMoviesByRoomID ¶

func DeleteMoviesByRoomID(roomID string) error

func DeleteRoomByID ¶

func DeleteRoomByID(roomID string) error

func DeleteSettingItem ¶

func DeleteSettingItem(item *model.Setting) error

func DeleteSettingItemByName ¶

func DeleteSettingItemByName(name string) error

func DeleteUserByID ¶

func DeleteUserByID(userID string) error

func DeleteVendorByUserIDAndVendor ¶

func DeleteVendorByUserIDAndVendor(userID string, vendor model.StreamingVendor) error

func FirstOrCreateRoomUserRelation ¶

func FirstOrCreateRoomUserRelation(roomID, userID string, conf ...CreateRoomUserRelationConfig) (*model.RoomUserRelation, error)

func FirstOrCreateSettingItemValue ¶

func FirstOrCreateSettingItemValue(s *model.Setting) error

func FirstOrCreateVendorByUserIDAndVendor ¶

func FirstOrCreateVendorByUserIDAndVendor(userID string, vendor model.StreamingVendor, conf ...CreateVendorConfig) (*model.StreamingVendorInfo, error)

func FirstOrInitVendorByUserIDAndVendor ¶

func FirstOrInitVendorByUserIDAndVendor(userID string, vendor model.StreamingVendor, conf ...CreateVendorConfig) (*model.StreamingVendorInfo, error)

func GerUsersIDByIDLike ¶

func GerUsersIDByIDLike(id string, scopes ...func(*gorm.DB) *gorm.DB) []string

func GerUsersIDByUsernameLike ¶

func GerUsersIDByUsernameLike(username string, scopes ...func(*gorm.DB) *gorm.DB) []string

func GetAdmins ¶

func GetAdmins() []*model.User

func GetAllMoviesByRoomID ¶

func GetAllMoviesByRoomID(roomID string) []*model.Movie

func GetAllRoomUsersRelation ¶

func GetAllRoomUsersRelation(roomID string, scopes ...func(*gorm.DB) *gorm.DB) []*model.RoomUserRelation

func GetAllRoomUsersRelationCount ¶

func GetAllRoomUsersRelationCount(roomID string, scopes ...func(*gorm.DB) *gorm.DB) int64

func GetAllRooms ¶

func GetAllRooms(scopes ...func(*gorm.DB) *gorm.DB) []*model.Room

func GetAllRoomsAndCreator ¶

func GetAllRoomsAndCreator(scopes ...func(*gorm.DB) *gorm.DB) []*model.Room

func GetAllRoomsByUserID ¶

func GetAllRoomsByUserID(userID string) []*model.Room

func GetAllRoomsCount ¶

func GetAllRoomsCount(scopes ...func(*gorm.DB) *gorm.DB) int64

func GetAllUserCount ¶

func GetAllUserCount(scopes ...func(*gorm.DB) *gorm.DB) int64

func GetAllUsers ¶

func GetAllUsers(scopes ...func(*gorm.DB) *gorm.DB) []*model.User

func GetProviderUserID ¶

func GetProviderUserID(p provider.OAuth2Provider, puid uint64) (string, error)

func GetRoomByID ¶

func GetRoomByID(id string) (*model.Room, error)

func GetRoomUserRelation ¶

func GetRoomUserRelation(roomID, userID string) (*model.RoomUserRelation, error)

func GetRoots ¶

func GetRoots() []*model.User

func GetSettingItemByName ¶

func GetSettingItemByName(name string) (*model.Setting, error)

func GetSettingItemValue ¶

func GetSettingItemValue(name string) (string, error)

func GetSettingItems ¶

func GetSettingItems() ([]*model.Setting, error)

func GetUserByID ¶

func GetUserByID(id string) (*model.User, error)

func GetUserByIDOrUsernameLike ¶

func GetUserByIDOrUsernameLike(idOrUsername string, scopes ...func(*gorm.DB) *gorm.DB) ([]*model.User, error)

func GetUserByUsername ¶

func GetUserByUsername(username string) (*model.User, error)

func GetUserByUsernameLike ¶

func GetUserByUsernameLike(username string, scopes ...func(*gorm.DB) *gorm.DB) []*model.User

func GetVendorByUserID ¶

func GetVendorByUserID(userID string) ([]*model.StreamingVendorInfo, error)

func GetVendorByUserIDAndVendor ¶

func GetVendorByUserIDAndVendor(userID string, vendor model.StreamingVendor) (*model.StreamingVendorInfo, error)

func HasRoom ¶

func HasRoom(roomID string) (bool, error)

func HasRoomByName ¶

func HasRoomByName(name string) (bool, error)

func Init ¶

func Init(d *gorm.DB, t conf.DatabaseType) error

func LoadAndDeleteMovieByID ¶

func LoadAndDeleteMovieByID(roomID, id string, columns ...clause.Column) (*model.Movie, error)

func LoadAndDeleteMoviesByRoomID ¶

func LoadAndDeleteMoviesByRoomID(roomID string, columns ...clause.Column) ([]*model.Movie, error)

func LoadAndDeleteUserByID ¶

func LoadAndDeleteUserByID(userID string, columns ...clause.Column) (*model.User, error)

func OrderByAsc ¶

func OrderByAsc(column string) func(db *gorm.DB) *gorm.DB

func OrderByCreatedAtAsc ¶

func OrderByCreatedAtAsc(db *gorm.DB) *gorm.DB

func OrderByCreatedAtDesc ¶

func OrderByCreatedAtDesc(db *gorm.DB) *gorm.DB

func OrderByDesc ¶

func OrderByDesc(column string) func(db *gorm.DB) *gorm.DB

func OrderByIDAsc ¶

func OrderByIDAsc(db *gorm.DB) *gorm.DB

func OrderByIDDesc ¶

func OrderByIDDesc(db *gorm.DB) *gorm.DB

func Paginate ¶

func Paginate(page, pageSize int) func(db *gorm.DB) *gorm.DB

func PreloadRoomUserRelation ¶

func PreloadRoomUserRelation(scopes ...func(*gorm.DB) *gorm.DB) func(db *gorm.DB) *gorm.DB

func RemoveAdmin ¶

func RemoveAdmin(u *model.User) error

func RemoveAdminByID ¶

func RemoveAdminByID(userID string) error

func RemoveRoot ¶

func RemoveRoot(u *model.User) error

func RemoveRootByID ¶

func RemoveRootByID(userID string) error

func RemoveUserPermission ¶

func RemoveUserPermission(roomID string, userID string, permission model.RoomUserPermission) error

func SaveMovie ¶

func SaveMovie(movie *model.Movie, columns ...clause.Column) error

func SaveRoomSettings ¶

func SaveRoomSettings(roomID string, setting model.RoomSettings) error

func SaveSettingItem ¶

func SaveSettingItem(item *model.Setting) error

func SaveUser ¶

func SaveUser(u *model.User) error

func Select ¶

func Select(columns ...string) func(db *gorm.DB) *gorm.DB

func SetRole ¶

func SetRole(u *model.User, role model.Role) error

func SetRoleByID ¶

func SetRoleByID(userID string, role model.Role) error

func SetRoomHashedPassword ¶

func SetRoomHashedPassword(roomID string, hashedPassword []byte) error

func SetRoomPassword ¶

func SetRoomPassword(roomID, password string) error

func SetRoomStatus ¶

func SetRoomStatus(roomID string, status model.RoomStatus) error

func SetRoomStatusByCreator ¶

func SetRoomStatusByCreator(userID string, status model.RoomStatus) error

func SetRoomUserStatus ¶

func SetRoomUserStatus(roomID string, userID string, status model.RoomUserStatus) error

func SetUserPermission ¶

func SetUserPermission(roomID string, userID string, permission model.RoomUserPermission) error

func SetUsernameByID ¶

func SetUsernameByID(userID string, username string) error

func SwapMoviePositions ¶

func SwapMoviePositions(roomID, movie1ID, movie2ID string) (err error)

func UnbanUser ¶

func UnbanUser(u *model.User) error

func UnbanUserByID ¶

func UnbanUserByID(userID string) error

func UpdateMovie ¶

func UpdateMovie(movie *model.Movie, columns ...clause.Column) error

func UpdateSettingItemValue ¶

func UpdateSettingItemValue(name, value string) error

func WhereCreatorID ¶

func WhereCreatorID(creatorID string) func(db *gorm.DB) *gorm.DB

func WhereCreatorIDIn ¶

func WhereCreatorIDIn(ids []string) func(db *gorm.DB) *gorm.DB

func WhereEqual ¶

func WhereEqual(column string, value interface{}) func(db *gorm.DB) *gorm.DB

column cannot be a user parameter

func WhereIDIn ¶

func WhereIDIn(ids []string) func(db *gorm.DB) *gorm.DB

func WhereIDLike ¶

func WhereIDLike(id string) func(db *gorm.DB) *gorm.DB

func WhereLike ¶

func WhereLike(column string, value string) func(db *gorm.DB) *gorm.DB

column cannot be a user parameter

func WhereRole ¶

func WhereRole(role model.Role) func(db *gorm.DB) *gorm.DB

func WhereRoomID ¶

func WhereRoomID(roomID string) func(db *gorm.DB) *gorm.DB

func WhereRoomNameLike ¶

func WhereRoomNameLike(name string) func(db *gorm.DB) *gorm.DB

func WhereRoomNameLikeOrCreatorInOrIDLike ¶

func WhereRoomNameLikeOrCreatorInOrIDLike(name string, ids []string, id string) func(db *gorm.DB) *gorm.DB

func WhereRoomNameLikeOrIDLike ¶

func WhereRoomNameLikeOrIDLike(name string, id string) func(db *gorm.DB) *gorm.DB

func WhereRoomSettingHidden ¶

func WhereRoomSettingHidden() func(db *gorm.DB) *gorm.DB

func WhereRoomSettingWithoutHidden ¶

func WhereRoomSettingWithoutHidden() func(db *gorm.DB) *gorm.DB

func WhereRoomUserStatus ¶

func WhereRoomUserStatus(status model.RoomUserStatus) func(db *gorm.DB) *gorm.DB

func WhereStatus ¶

func WhereStatus(status model.RoomStatus) func(db *gorm.DB) *gorm.DB

func WhereUserID ¶

func WhereUserID(userID string) func(db *gorm.DB) *gorm.DB

func WhereUsernameLike ¶

func WhereUsernameLike(name string) func(db *gorm.DB) *gorm.DB

func WhereUsernameLikeOrIDIn ¶

func WhereUsernameLikeOrIDIn(name string, ids []string) func(db *gorm.DB) *gorm.DB

func WithUser ¶

func WithUser(db *gorm.DB) *gorm.DB

func WithUserAndProvider ¶

func WithUserAndProvider(db *gorm.DB) *gorm.DB

Types ¶

type CreateRoomConfig ¶

type CreateRoomConfig func(r *model.Room)

func WithCreator ¶

func WithCreator(creator *model.User) CreateRoomConfig

func WithRelations ¶

func WithRelations(relations []model.RoomUserRelation) CreateRoomConfig

func WithSetting ¶

func WithSetting(setting model.RoomSettings) CreateRoomConfig

func WithStatus ¶

func WithStatus(status model.RoomStatus) CreateRoomConfig

type CreateRoomUserRelationConfig ¶

type CreateRoomUserRelationConfig func(r *model.RoomUserRelation)

func WithRoomUserRelationPermissions ¶

func WithRoomUserRelationPermissions(permissions model.RoomUserPermission) CreateRoomUserRelationConfig

func WithRoomUserRelationStatus ¶

func WithRoomUserRelationStatus(status model.RoomUserStatus) CreateRoomUserRelationConfig

type CreateUserConfig ¶

type CreateUserConfig func(u *model.User)

func WithRole ¶

func WithRole(role model.Role) CreateUserConfig

type CreateVendorConfig ¶

type CreateVendorConfig func(*model.StreamingVendorInfo)

func WithCookie ¶

func WithCookie(cookie []*http.Cookie) CreateVendorConfig

Source Files ¶

View all Source files

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL