database

type Account struct {
	ID           int64  `json:"-" db:"id"`
	Email        string `json:"email" db:"email"`
	Name         string `json:"name" db:"name"`
	PasswordHash string `json:"-" db:"password_hash"`
}

type File struct {
	ID         int64     `json:"id,omitempty" db:"id"`
	Name       string    `json:"name" db:"name"`
	MimeType   string    `json:"mime_type" db:"mime_type"`
	Size       int64     `json:"size" db:"size"`
	SystemPath string    `json:"system_path" db:"system_path"`
	FolderId   int64     `json:"folder_id" db:"folder_id"`
	CreatedAt  time.Time `json:"created_at,omitempty" db:"created_at"`
}

type Folder struct {
	ID        int64     `json:"id" db:"id"`
	Name      string    `json:"name" db:"name"`
	Color     string    `json:"color" db:"color"`
	CreatedAt time.Time `json:"created_at" db:"created_at"`
}

type Repository interface {
	Migrate() error
	GetAccount(id int64) (*Account, error)
	GetAccountByEmail(email string) (*Account, error)
	CreateAccount(email, name, password string) (*Account, error)
	ChangeAccount(id int64, user *Account) error
	AllFiles() ([]File, error)
	SaveFile(file *File) error
	GetFile(file_id int64) (*File, error)
	DeleteFile(file_id int64) error
	ChangeFile(file *File) error
	GetFolder(folder_id int64) (*Folder, error)
	CreateFolder(folder *Folder) error
	ChangeFolder(folder *Folder) error
	DeleteFolder(folder_id int64) error
}

type SQLiteRepository struct {
	DB *sql.DB
}