database

package
v0.0.0-...-ff179e1 Latest Latest
Warning

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

 Go to latest Published: Oct 18, 2021 License: MIT Imports: 16 Imported by: 0

Documentation

Index

Constants

View Source 
const (
	DialectSqlite   = "sqlite"
	DialectMySql    = "mysql"
	DialectPostgres = "postgres"
)
View Source 
const (
	VISIBILITY_HIDDEN     = 1
	VISIBILITY_SEARCHABLE = 2
	VISIBILITY_VISIBLE    = 3
)

Variables

View Source 
var (
	ErrEmptyDbUsername   = errors.New("empty db username")
	ErrEmptyDbPassword   = errors.New("empty db password")
	ErrEmptyDbName       = errors.New("empty db name")
	ErrUnknownSqlDialect = errors.New(
		"unknown dialect (allowed: sqlite, mysql, postgres)")
	ErrUsernameAlreadyExists    = errors.New("username already exists")
	ErrSitePathAlreadyExists    = errors.New("website path already exists")
	ErrVersionNameAlreadyExists = errors.New("version name already exists in website")
	ErrVersionFileAlreadyExists = errors.New("version file already exists in version")
	ErrEmptyUser                = errors.New("user empty")
	ErrEmptyWebsite             = errors.New("website empty")
	ErrEmptyVersion             = errors.New("version empty")
	ErrEmptyFile                = errors.New("file empty")
)
View Source 
var AllModels = []interface{}{
	&Website{},
	&Version{},
	&VersionFile{},
	&File{},
	&User{},
	&ApiUser{},
	&Permission{},
}
View Source 
var TableNames = []string{
	"version_files",
	"versions",
	"websites",
	"files",
	"api_users",
	"users",
	"permissions",
}

Functions

This section is empty.

Types

type ApiUser 

type ApiUser struct {
	ID           uint        `gorm:"primary_key;unique_index;not null;auto_increment"`
	KeyHash      string      `gorm:"type:varchar(200);not null"`
	CreatedAt    time.Time   ``
	Creator      *User       `gorm:"constraint:OnUpdate:CASCADE,OnDelete:CASCADE"`
	CreatorID    uint        ``
	Permission   *Permission `gorm:"constraint:OnUpdate:CASCADE,OnDelete:RESTRICT"`
	PermissionID uint        ``
}

type Connection 

type Connection struct {
	Dialect string
	File    string
	Host    string
	User    string
	Pass    string
	DbName  string
}

func (*Connection) Open 

func (c *Connection) Open() (d gorm.Dialector, caught try.Err)

type Database 

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

func Open 

func Open(conn *Connection, lgr *log.Logger) (db *Database, caught try.Err)

func (*Database) Exec 

func (db *Database) Exec(sql string, values ...interface{}) (rows int, err error)

func (*Database) FileAdd 

func (db *Database) FileAdd(file *File) (caught try.Err)

func (*Database) FileByHash 

func (db *Database) FileByHash(hash string) (file *File, caught try.Err)

func (*Database) FileByID 

func (db *Database) FileByID(id uint) (file *File, caught try.Err)

func (*Database) FileHashExists 

func (db *Database) FileHashExists(hash string) (exists bool, caught try.Err)

func (*Database) FilesCount 

func (db *Database) FilesCount(query ...interface{}) (count int64, caught try.Err)

func (*Database) FilesDeleteOrphans 

func (db *Database) FilesDeleteOrphans() (caught try.Err)

func (*Database) FilesGet 

func (db *Database) FilesGet(query ...interface{}) (files []*File, caught try.Err)

func (*Database) FilesGetOrphans 

func (db *Database) FilesGetOrphans() (files []*File, caught try.Err)

func (*Database) GetDialect 

func (db *Database) GetDialect() string

func (*Database) GetVersion 

func (db *Database) GetVersion() (version string, caught try.Err)

func (*Database) IsDialect 

func (db *Database) IsDialect(dialect string) bool

func (*Database) Migrate 

func (db *Database) Migrate(printCmds bool) (caught try.Err)

func (*Database) UserAdd 

func (db *Database) UserAdd(user *User) (caught try.Err)

func (*Database) UserByID 

func (db *Database) UserByID(id uint) (user *User, caught try.Err)

func (*Database) UserByName 

func (db *Database) UserByName(name string) (user *User, caught try.Err)

func (*Database) UserDeleteByID 

func (db *Database) UserDeleteByID(id uint) (caught try.Err)

func (*Database) UserNameExists 

func (db *Database) UserNameExists(name string) (exists bool, caught try.Err)

func (*Database) UserUpdate 

func (db *Database) UserUpdate(user *User) (caught try.Err)

func (*Database) UsersCount 

func (db *Database) UsersCount(query ...interface{}) (count int64, caught try.Err)

func (*Database) UsersGet 

func (db *Database) UsersGet(query ...interface{}) (users []*User, caught try.Err)

func (*Database) VersionAdd 

func (db *Database) VersionAdd(version *Version) (caught try.Err)

func (*Database) VersionByID 

func (db *Database) VersionByID(id uint, deep bool) (version *Version, caught try.Err)

func (*Database) VersionDeleteByID 

func (db *Database) VersionDeleteByID(id uint) (caught try.Err)

func (*Database) VersionFileAdd 

func (db *Database) VersionFileAdd(versionFile *VersionFile) (caught try.Err)

func (*Database) VersionFileByID 

func (db *Database) VersionFileByID(id uint, deep bool) (
	versionFile *VersionFile, caught try.Err)

func (*Database) VersionFileByPath 

func (db *Database) VersionFileByPath(versionId uint, filePath string) (
	versionFile *VersionFile, caught try.Err)

func (*Database) VersionFilesCount 

func (db *Database) VersionFilesCount(query ...interface{}) (
	count int64, caught try.Err)

func (*Database) VersionFilesGet 

func (db *Database) VersionFilesGet(deep bool, query ...interface{}) (
	versionFiles []*VersionFile, caught try.Err)

func (*Database) VersionIDByWebsite 

func (db *Database) VersionIDByWebsite(websiteId uint, versionName string) (
	versionId uint, caught try.Err)

func (*Database) VersionUpdate 

func (db *Database) VersionUpdate(version *Version) (caught try.Err)

func (*Database) VersionsCount 

func (db *Database) VersionsCount(query ...interface{}) (
	count int64, caught try.Err)

func (*Database) VersionsGet 

func (db *Database) VersionsGet(deep bool, query ...interface{}) (
	versions []*Version, caught try.Err)

func (*Database) WebsiteAdd 

func (db *Database) WebsiteAdd(website *Website) (caught try.Err)

func (*Database) WebsiteByID 

func (db *Database) WebsiteByID(id uint, deep bool) (website *Website, caught try.Err)

func (*Database) WebsiteByPath 

func (db *Database) WebsiteByPath(sitePath string, deep bool) (
	website *Website, caught try.Err)

func (*Database) WebsiteDeleteByID 

func (db *Database) WebsiteDeleteByID(id uint) (caught try.Err)

func (*Database) WebsitePathExists 

func (db *Database) WebsitePathExists(sitePath string) (exists bool, caught try.Err)

func (*Database) WebsiteUpdate 

func (db *Database) WebsiteUpdate(website *Website) (caught try.Err)

func (*Database) WebsitesCount 

func (db *Database) WebsitesCount(query ...interface{}) (
	count int, caught try.Err)

func (*Database) WebsitesGet 

func (db *Database) WebsitesGet(deep bool, query ...interface{}) (
	websites []*Website, caught try.Err)

type File 

type File struct {
	ID   uint   `gorm:"primary_key;unique_index;not null;auto_increment"`
	Hash string `gorm:"type:varchar(64);unique_index;not null"`
}

type Permission 

type Permission struct {
	ID            uint   `gorm:"primary_key;unique_index;not null;auto_increment"`
	AllowedPaths  string `gorm:"type:varchar(500);not null"`
	IsAdmin       bool   ``
	CanCreate     bool   ``
	MaxSize       int    ``
	MaxVersions   int    ``
	MaxVisibility int    ``
}

type User 

type User struct {
	ID           uint        `gorm:"primary_key;unique_index;not null;auto_increment"`
	Name         string      `gorm:"type:varchar(50);not null;unique_index"`
	PasswordHash string      `gorm:"type:varchar(200);not null"`
	CreatedAt    time.Time   ``
	Permission   *Permission `gorm:"constraint:OnUpdate:CASCADE,OnDelete:RESTRICT"`
	PermissionID uint        ``
}

type Version 

type Version struct {
	ID        uint          `gorm:"primary_key;unique_index;not null;auto_increment"`
	Name      string        `gorm:"type:varchar(200);not null"`
	Tags      string        `gorm:"type:varchar(1000);not null"`
	Website   *Website      ``
	WebsiteID uint          ``
	User      *User         `gorm:"constraint:OnUpdate:CASCADE,OnDelete:SET NULL"`
	UserID    uint          ``
	CreatedAt time.Time     ``
	Files     []VersionFile `gorm:"constraint:OnUpdate:CASCADE,OnDelete:CASCADE"`
}

type VersionFile 

type VersionFile struct {
	ID        uint     `gorm:"primary_key;unique_index;not null;auto_increment"`
	Path      string   `gorm:"type:varchar(200);not null"`
	Version   *Version `gorm:"constraint:OnUpdate:CASCADE,OnDelete:RESTRICT"`
	VersionID uint     ``
	File      *File    `gorm:"constraint:OnUpdate:CASCADE,OnDelete:RESTRICT"`
	FileID    uint     ``
}

type Website 

type Website struct {
	ID          uint          `gorm:"primary_key;unique_index;not null;auto_increment"`
	Name        string        `gorm:"type:varchar(200);not null"`
	Path        string        `gorm:"type:varchar(200);not null"`
	PathLower   string        `gorm:"type:varchar(200);not null;unique_index"`
	LogoID      sql.NullInt64 `gorm:"type:uint"`
	Color       string        `gorm:"type:varchar(20);not null"`
	Visibility  int           ``
	User        *User         `gorm:"constraint:OnUpdate:CASCADE,OnDelete:SET NULL"`
	UserID      uint          ``
	CreatedAt   time.Time     ``
	MaxVersions int           ``
	SourceUrl   string        `gorm:"type:varchar(200);not null"`
	SourceType  string        `gorm:"type:varchar(20);not null"`
	Versions    []Version     `gorm:"constraint:OnUpdate:CASCADE,OnDelete:CASCADE"`
}

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.