models

type Export struct {
	Pk uint `gorm:"column:pk;primaryKey"`

	Slug    string    `gorm:"column:slug"`    // slug of instance
	Created time.Time `gorm:"column:created"` // time the backup was created

	Path   string `gorm:"column:path;not null"`   // path the export is stored at
	Packed bool   `gorm:"column:packed;not null"` // was the export packed, or was it staging only?
}

type Grant struct {
	Pk uint `gorm:"column:pk;primaryKey"`

	User string `gorm:"column:user;not null;index:user_slug,unique"`            // (distillery) username
	Slug string `gorm:"column:slug;not null;index:user_slug;index:drupal_slug"` // (distillery) instance slug

	DrupalUsername  string `gorm:"column:drupal_user;not null;index:drupal_slug,unique"` // drupal username
	DrupalAdminRole bool   `gorm:"column:admin;not null"`                                // drupal admin rights
}

type Instance struct {

	// Primary key for the instance
	Pk uint `gorm:"column:pk;primaryKey"`

	// time the instance was created
	Created time.Time `gorm:"column:created;autoCreateTime"`

	// slug of the system
	Slug string `gorm:"column:slug;not null;unique"`

	// email address of the system owner (if any)
	OwnerEmail string `gorm:"column:owner_email;type:varchar(320)"`

	// should we automatically enable updates for the system?
	AutoBlindUpdateEnabled SQLBit1 `gorm:"column:auto_blind_update_enabled;default:1"`

	// The filesystem path the system can be found under
	FilesystemBase string `gorm:"column:filesystem_base;not null"`

	// information about the system being used
	System `gorm:"embed"`

	// SQL Database credentials for the system
	SqlDatabase string `gorm:"column:sql_database;not null"`
	SqlUsername string `gorm:"column:sql_user;not null"`
	SqlPassword string `gorm:"column:sql_password;not null"`

	// GraphDB Repository
	GraphDBRepository string `gorm:"column:graphdb_repository;not null"`
	GraphDBUsername   string `gorm:"column:graphdb_user;not null"`
	GraphDBPassword   string `gorm:"column:graphdb_password;not null"`
}

type Keys struct {
	Pk uint `gorm:"column:pk;primaryKey"`

	User string `gorm:"column:user;not null"` // username of the ssh key

	Signature []byte `gorm:"column:signature;not null"` // signature of the ssh key
	Comment   string `gorm:"column:comment"`
}

type Lock struct {
	Pk uint `gorm:"column:pk;primaryKey"`

	Slug string `gorm:"column:slug;not null"` // slug of instance
}

type Metadatum struct {
	Pk uint `gorm:"column:pk;primaryKey"`

	Key   string `gorm:"column:key;not null"` // key for the value, see the keys below
	Slug  string `gorm:"column:slug"`         // optional slug of instance
	Value []byte `gorm:"column:value"`        // serialized json value of the data
}

type SQLBit1 bool

type System struct {
	// NOTE(twiesing): Any changes here should be reflected in instance_{provision,rebuild}.html and remote/api.ts.
	PHP                string `gorm:"column:php;not null"`           // php version to use
	OpCacheDevelopment bool   `gorm:"column:opcache_devel;not null"` // opcache development

	ContentSecurityPolicy string `gorm:"column:csp;not null"` // content security policy for the system
}

type Token struct {
	Pk uint `gorm:"column:pk;primaryKey"`

	Token   string `json:"-" gorm:"column:token;unique:true;not null"` // token used by the actual api (shown only once)
	TokenID string `gorm:"column:id;unique:true;not null"`             // token id (displayed to user, used for finding it)

	User string `gorm:"column:user;not null"` // (distillery) username

	Description string `gorm:"column:description"`

	AllScopes bool   `gorm:"column:all;not null"`
	Scopes    []byte `gorm:"column:scopes;not null"` // comma-seperated list of scopes
}

type User struct {
	Pk uint `gorm:"column:pk;primaryKey"`

	User string `gorm:"column:user;not null;unique"` // name of the user

	PasswordHash []byte `gorm:"column:password" json:"-"`    // password of the user, hashed
	TOTPEnabled  *bool  `gorm:"column:totpenabled" json:"-"` // is totp enabled for the user
	TOTPURL      string `gorm:"column:totp" json:"-"`        // the totp of the user

	Enabled *bool `gorm:"enabled;not null" json:"enabled"`
	Admin   *bool `gorm:"column:admin;not null" json:"admin"`
}