models

type DB struct {
	*sqlx.DB
}

type Datastore interface {
	// User Functions
	InsertUser(uname string, digest []byte, role string, email string, gpg string) (*User, error)
	GetUserByEmail(email string) (*User, error)
	GetUserByID(user uuid.UUID) (*User, error)
	GetUserByUname(uname string) (*User, error)
	// Post Functions
	PublishedPosts(start int, end int) (*[]Post, error)
	UnpublishedPosts() (*[]Post, error)
	GetPosts(start int, end int) (*[]Post, error)
	FindPost(id uuid.UUID) (*Post, error)
	FindPostsByUser(user uuid.UUID) (*[]Post, error)
	InsertPost(user uuid.UUID, title string, slug string, subtitle string, short string, content string, digest string, published bool) (*Post, error)
	UpdatePost(id uuid.UUID, user uuid.UUID, title string, slug string, subtitle string, short string, content string, digest string, published bool) (*Post, error)
	DeletePost(id uuid.UUID, user uuid.UUID) (*Post, error)
	// Image Functions
	AllImages() (*[]Image, error)
	FindImage(id uuid.UUID) (*Image, error)
	FindImagesByUser(user uuid.UUID) (*[]Image, error)
	InsertImage(user uuid.UUID, url string, medium string, small string, caption string) (*Image, error)
	DeleteImage(id uuid.UUID) (*Image, error)
}

type Image struct {
	ID        uuid.UUID `db:"id" json:"id"`
	UserID    uuid.UUID `db:"user_id" json:"user_id"`
	URL       string    `db:"url" json:"url"`
	Medium    string    `db:"medium" json:"medium"`
	Small     string    `db:"small" json:"small"`
	Caption   string    `db:"caption" json:"caption"`
	UpdatedAt time.Time `db:"updated_at" json:"updated_at"`
	CreatedAt time.Time `db:"created_at" json:"created_at"`
}

type Post struct {
	ID          uuid.UUID `db:"id" json:"id"`
	UserID      uuid.UUID `db:"user_id" json:"user_id"`
	Title       string    `db:"title" json:"title"`
	Slug        string    `db:"slug" json:"slug"`
	SubTitle    string    `db:"sub_title" json:"sub_title"`
	Short       string    `db:"short" json:"short"`
	PostContent string    `db:"post_content" json:"post_content"`
	Digest      string    `db:"digest" json:"digest"`
	Published   bool      `db:"published" json:"published"`
	UpdatedAt   time.Time `db:"updated_at" json:"updated_at"`
	CreatedAt   time.Time `db:"created_at" json:"created_at"`
}

type Tag struct {
	ID   uuid.UUID `db:"id" json:"id"`
	Name string    `db:"name" json:"name"`
	Slug string    `db:"slug" json:"slug"`
}

type User struct {
	ID           uuid.UUID `db:"id"`
	Uname        string    `db:"uname"`
	Digest       []byte    `db:"digest"`
	Role         string    `db:"role"`
	Email        string    `db:"email"`
	GpgKey       string    `db:"email"`
	LastOnlineAt time.Time `db:"updated_at"`
	CreatedAt    time.Time `db:"created_at"`
}