data

type DBConf struct {
	Database        string   `toml:"database"`
	Hosts           []string `toml:"hosts"`
	Username        string   `toml:"username"`
	Password        string   `toml:"password"`
	DebugQueries    bool     `toml:"debug_queries"`
	ApplicationName string   `toml:"application_name"`
	MaxConnection   int      `toml:"max_connection"`
	SSLMode         string   `toml:"ssl_mode"`
	DatabaseURL     string   `env:"DATABASE_URL"`
}

type Database struct {
	db.Session

	User     *UsersStore
	TodoList *TodoListStore
	TodoItem *TodoItemStore
}

type Item struct {
	ID         int64      `db:"id"           json:"id"`
	TodoListID int64      `db:"todo_list_id" json:"todo_list_id"`
	Title      string     `db:"title"        json:"title"`
	Todo       string     `db:"todo"         json:"todo"`
	Comment    string     `db:"comment"      json:"comment"`
	ListStatus ListStatus `db:"list_status"  json:"list_status"`
	ItemStatus TodoStatus `db:"todo_status"  json:"todo_status"`
}

type ListStatus string

type TodoItem struct {
	ID         int64      `db:"id,omitempty" json:"id"`
	TodoListID int64      `db:"todo_list_id,omitempty" json:"todo_list_id"`
	Status     TodoStatus `db:"status" json:"status"`
	Todo       string     `db:"todo,omitempty" json:"todo"`
	Comment    string     `db:"comment,omitempty" json:"comment"`
	CreatedAt  *time.Time `db:"created_at,omitempty" json:"createdAt"`
	UpdatedAt  *time.Time `db:"updated_at,omitempty" json:"updatedAt"`
}

type TodoItemStore struct {
	db.Collection
}

type TodoList struct {
	ID        int64      `db:"id,omitempty" json:"id"`
	Status    ListStatus `db:"status,omitempty" json:"status"`
	Title     string     `db:"title,omitempty" json:"title"`
	CreatedAt *time.Time `db:"created_at,omitempty" json:"createdAt"`
	UpdatedAt *time.Time `db:"updated_at,omitempty" json:"updatedAt"`
}

type TodoListItems []Item

type TodoListStore struct {
	db.Collection
}

type TodoStatus string

type User struct {
	ID           int64      `db:"id,omitempty" json:"id"`
	Email        string     `db:"email,omitempty" json:"email"`
	PasswordHash string     `db:"password_hash,omitempty" json:"-"`
	Role         UserRole   `db:"role" json:"role"`
	FirstName    string     `db:"first_name,omitempty" json:"firstName"`
	LastName     string     `db:"last_name,omitempty" json:"lastName"`
	Location     string     `db:"location,omitempty" json:"location"`
	Etc          UserEtc    `db:"etc,omitempty" json:"etc"`
	CreatedAt    *time.Time `db:"created_at,omitempty" json:"createdAt"`
	UpdatedAt    *time.Time `db:"updated_at,omitempty" json:"updatedAt"`

	// Display Only
	Biography string `json:"biography"`
	Name      string `json:"name"`
}

type UserEtc struct {
	HasProfile bool

	*postgresql.JSONBConverter
}

type UserRole string

type UsersStore struct {
	db.Collection
}