database

package
v0.0.0-...-e91f821 Latest Latest
Warning

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

 Go to latest Published: Mar 23, 2022 License: MulanPSL-2.0 Imports: 7 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

View Source 
var AddCommentableColumnRepositoriesTableSQL = fmt.Sprintf(`ALTER TABLE %s
	ADD commentable BOOLEAN NOT NULL DEFAULT 1`, RepositoriesTableName)

AddCommentableColumnRepositoriesTableSQL adds a new column: commmentable

View Source 
var BranchesTableName = "branches"

BranchesTableName defines

View Source 
var BranchesTableSQL = fmt.Sprintf(`CREATE TABLE %s (
	id int(10) unsigned NOT NULL AUTO_INCREMENT,
	created_at timestamp NULL DEFAULT NULL,
	updated_at timestamp NULL DEFAULT NULL,
	deleted_at timestamp NULL DEFAULT NULL,
	owner varchar(255) DEFAULT NULL,
	repo varchar(255) DEFAULT NULL,
	name varchar(255) DEFAULT NULL,
	type varchar(255) DEFAULT NULL,
	additional_info text,
	PRIMARY KEY (id)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8`, BranchesTableName)

BranchesTableSQL matches with Branches Object

View Source 
var CLADetailsTableName = "cla_details"

CLADetailsTableName defines

View Source 
var CLADetailsTableSQL = fmt.Sprintf(`CREATE TABLE %s (
	id int(10) unsigned NOT NULL AUTO_INCREMENT,
	created_at timestamp NULL DEFAULT NULL,
	updated_at timestamp NULL DEFAULT NULL,
	deleted_at timestamp NULL DEFAULT NULL,
	type int(10) unsigned DEFAULT NULL,
	name varchar(255) DEFAULT NULL,
	title varchar(255) DEFAULT NULL,
	corporation varchar(255) DEFAULT NULL,
	address varchar(255) DEFAULT NULL,
	date varchar(255) DEFAULT NULL,
	email varchar(255) DEFAULT NULL,
	telephone varchar(255) DEFAULT NULL,
	fax varchar(255) DEFAULT NULL,
	additional_info text,
	PRIMARY KEY (id)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8`, CLADetailsTableName)

CLADetailsTableSQL matches with CLADetails Object

View Source 
var DBConnection *gorm.DB

DBConnection is used to operate on database

View Source 
var PrivilegesTableName = "privileges"

PrivilegesTableName defines

View Source 
var PrivilegesTableSQL = fmt.Sprintf(`CREATE TABLE %s (
	id int(10) unsigned NOT NULL AUTO_INCREMENT,
	created_at timestamp NULL DEFAULT NULL,
	updated_at timestamp NULL DEFAULT NULL,
	deleted_at timestamp NULL DEFAULT NULL,
	owner varchar(255) DEFAULT NULL,
	repo varchar(255) DEFAULT NULL,
	user varchar(255) DEFAULT NULL,
	type varchar(255) DEFAULT NULL,
	additional_info text,
	PRIMARY KEY (id)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8`, PrivilegesTableName)

PrivilegesTableSQL matches with Privileges Object

View Source 
var ProjectFilesTableName = "project_files"

ProjectFilesTableName defines

View Source 
var ProjectFilesTableSQL = fmt.Sprintf(`CREATE TABLE %s (
	id int(10) unsigned NOT NULL AUTO_INCREMENT,
	created_at timestamp NULL DEFAULT NULL,
	updated_at timestamp NULL DEFAULT NULL,
	deleted_at timestamp NULL DEFAULT NULL,
	owner varchar(255) DEFAULT NULL,
	repo varchar(255) DEFAULT NULL,
	path varchar(255) DEFAULT NULL,
	ref varchar(255) DEFAULT NULL,
	current_sha varchar(255) DEFAULT NULL,
	target_sha varchar(255) DEFAULT NULL,
	waiting_sha varchar(255) DEFAULT NULL,
	additional_info text,
	PRIMARY KEY (id)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8`, ProjectFilesTableName)

ProjectFilesTableSQL matches with ProjectFiles Object

View Source 
var RepositoriesTableName = "repositories"

RepositoriesTableName defines

View Source 
var RepositoriesTableSQL = fmt.Sprintf(`CREATE TABLE %s (
	id int(10) unsigned NOT NULL AUTO_INCREMENT,
	created_at timestamp NULL DEFAULT NULL,
	updated_at timestamp NULL DEFAULT NULL,
	deleted_at timestamp NULL DEFAULT NULL,
	owner varchar(255) DEFAULT NULL,
	repo varchar(255) DEFAULT NULL,
	description varchar(255) DEFAULT NULL,
	type varchar(255) DEFAULT NULL,
	additional_info text,
	PRIMARY KEY (id)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8`, RepositoriesTableName)

RepositoriesTableSQL matches with Repositories Object

View Source 
var SigFilesTableName = "sig_files"

SigFilesTableName defines

View Source 
var SigFilesTableSQL = fmt.Sprintf(`CREATE TABLE %s (
	id int(10) unsigned NOT NULL AUTO_INCREMENT,
	created_at timestamp NULL DEFAULT NULL,
	updated_at timestamp NULL DEFAULT NULL,
	deleted_at timestamp NULL DEFAULT NULL,
	owner varchar(255) DEFAULT NULL,
	repo varchar(255) DEFAULT NULL,
	path varchar(255) DEFAULT NULL,
	ref varchar(255) DEFAULT NULL,
	current_sha varchar(255) DEFAULT NULL,
	target_sha varchar(255) DEFAULT NULL,
	waiting_sha varchar(255) DEFAULT NULL,
	additional_info text,
	PRIMARY KEY (id)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8`, SigFilesTableName)

SigFilesTableSQL matches with SigFiles Object

View Source 
var SigRecordsTableName = "sig_records"

SigRecordsTableName defines

View Source 
var SigRecordsTableSQL = fmt.Sprintf(`CREATE TABLE %s (
	id int(10) unsigned NOT NULL AUTO_INCREMENT,
	created_at timestamp NULL DEFAULT NULL,
	updated_at timestamp NULL DEFAULT NULL,
	deleted_at timestamp NULL DEFAULT NULL,
	name varchar(255) DEFAULT NULL,
	additional_info text,
	PRIMARY KEY (id)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8`, SigRecordsTableName)

SigRecordsTableSQL matches with sig_records Object

View Source 
var SigRepositoriesTableName = "sig_repositories"

SigRepositoriesTableName defines

View Source 
var SigRepositoriesTableSQL = fmt.Sprintf(`CREATE TABLE %s (
	id int(10) unsigned NOT NULL AUTO_INCREMENT,
	created_at timestamp NULL DEFAULT NULL,
	updated_at timestamp NULL DEFAULT NULL,
	deleted_at timestamp NULL DEFAULT NULL,
	name varchar(255) DEFAULT NULL,
	repo_name varchar(255) DEFAULT NULL,
	additional_info text,
	PRIMARY KEY (id)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8`, SigRepositoriesTableName)

SigRepositoriesTableSQL matches with sig_repositories Object

View Source 
var UpgradesTableName = "upgrades"

UpgradesTableName defines

View Source 
var UpgradesTableSQL = fmt.Sprintf(`CREATE TABLE %s (
	id int(10) unsigned NOT NULL AUTO_INCREMENT,
	created_at timestamp NULL DEFAULT NULL,
	updated_at timestamp NULL DEFAULT NULL,
	deleted_at timestamp NULL DEFAULT NULL,
	upgrade_id int(10) DEFAULT NULL,
	PRIMARY KEY (id)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8`, UpgradesTableName)

UpgradesTableSQL matches with Upgrades Object

Functions

func ConnectDataBase 

func ConnectDataBase(config config.Config) (*gorm.DB, error)

ConnectDataBase connect database

func New 

func New(config config.Config) error

New Database Connection

func UpgradeDataBase 

func UpgradeDataBase(db *gorm.DB) error

UpgradeDataBase upgrades tables and datas

Types

type Branches 

type Branches struct {
	gorm.Model
	Owner string
	Repo  string
	Name  string
	// "protected" or "readonly", only protected is supported yet
	Type           string
	AdditionalInfo string `sql:"type:text"`
}

Branches defines

func (Branches) GetAdditionalInfo 

func (bs Branches) GetAdditionalInfo(additionalinfo interface{}) error

GetAdditionalInfo for Branches

func (Branches) ToString 

func (bs Branches) ToString() (string, error)

ToString for convert

type CLADetails 

type CLADetails struct {
	gorm.Model
	Type           int
	Name           string
	Title          string
	Corporation    string
	Address        string
	Date           string
	Email          string
	Telephone      string
	Fax            string
	AdditionalInfo string `sql:"type:text"`
}

CLADetails defines

func (CLADetails) GetAdditionalInfo 

func (cds CLADetails) GetAdditionalInfo(additionalinfo interface{}) error

GetAdditionalInfo for CLADetails

func (CLADetails) ToString 

func (cds CLADetails) ToString() (string, error)

ToString for convert

type Privileges 

type Privileges struct {
	gorm.Model
	Owner          string
	Repo           string
	User           string
	Type           string
	AdditionalInfo string `sql:"type:text"`
}

Privileges defines

func (Privileges) GetAdditionalInfo 

func (ps Privileges) GetAdditionalInfo(additionalinfo interface{}) error

GetAdditionalInfo for Privileges

func (Privileges) ToString 

func (ps Privileges) ToString() (string, error)

ToString for convert

type ProjectFiles 

type ProjectFiles struct {
	gorm.Model
	Owner          string
	Repo           string
	Path           string
	Ref            string
	CurrentSha     string
	TargetSha      string
	WaitingSha     string
	AdditionalInfo string `sql:"type:text"`
}

ProjectFiles defines

func (ProjectFiles) GetAdditionalInfo 

func (pfs ProjectFiles) GetAdditionalInfo(additionalinfo interface{}) error

GetAdditionalInfo for ProjectFiles

func (ProjectFiles) ToString 

func (pfs ProjectFiles) ToString() (string, error)

ToString for convert

type Repositories 

type Repositories struct {
	gorm.Model
	Owner          string
	Repo           string
	Description    string
	Type           string
	Commentable    bool
	AdditionalInfo string `sql:"type:text"`
}

Repositories defines

func (Repositories) GetAdditionalInfo 

func (rs Repositories) GetAdditionalInfo(additionalinfo interface{}) error

GetAdditionalInfo for Repositories

func (Repositories) ToString 

func (rs Repositories) ToString() (string, error)

ToString for convert

type SigFiles 

type SigFiles struct {
	gorm.Model
	Owner          string
	Repo           string
	Path           string
	Ref            string
	CurrentSha     string
	TargetSha      string
	WaitingSha     string
	AdditionalInfo string `sql:"type:text"`
}

SigFiles defines

func (SigFiles) GetAdditionalInfo 

func (sfs SigFiles) GetAdditionalInfo(additionalinfo interface{}) error

GetAdditionalInfo for SigFiles

func (SigFiles) ToString 

func (sfs SigFiles) ToString() (string, error)

ToString for convert

type SigRecords 

type SigRecords struct {
	gorm.Model
	Name           string
	AdditionalInfo string `sql:"type:text"`
}

SigRecords defines

func (SigRecords) GetAdditionalInfo 

func (srs SigRecords) GetAdditionalInfo(additionalinfo interface{}) error

GetAdditionalInfo for SigRecords

func (SigRecords) ToString 

func (srs SigRecords) ToString() (string, error)

ToString for convert

type SigRepositories 

type SigRepositories struct {
	gorm.Model
	Name           string
	RepoName       string
	AdditionalInfo string `sql:"type:text"`
}

SigRepositories defines

func (SigRepositories) GetAdditionalInfo 

func (srs SigRepositories) GetAdditionalInfo(additionalinfo interface{}) error

GetAdditionalInfo for SigRepositories

func (SigRepositories) ToString 

func (srs SigRepositories) ToString() (string, error)

ToString for convert

type Upgrades 

type Upgrades struct {
	gorm.Model
	UpgradeID int
}

Upgrades defines for back database

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.