database

type Database interface {
	TransactionMethods
	UsersDatabaseMethods
	FilesDatabaseMethods
}

type FilesDatabaseMethods interface {
	AddFileTypeIfNotExist(string) error
	GetFileTypes() ([]models.FileType, error)
	GetFilesSize() (int, error)
	SaveFile(models.File) error
	GetFile([]string, []string) (models.File, error)
	GetFileList() ([]models.File, error)
}

type Transaction interface {
	UsersDatabaseMethods
	FilesDatabaseMethods
	Commit() error
	Rollback() error
}

type TransactionMethods interface {
	NewSerializableTransaction(ctx context.Context) (Transaction, error)
	NewTransaction(ctx context.Context, isolation sql.IsolationLevel) (Transaction, error)
}

type UsersDatabaseMethods interface {
	GetUserByEmail(email string) (*models.UserWithPassword, error)
	CreateUser(spec models.UserCreationParameters) (models.User, error)
	UpdateUserLastLogin(userId int) error
	GetUserList() ([]models.User, error)
}