query

type AddUserParams struct {
	Name     string   `db:"name"`
	Email    string   `db:"email"`
	Password string   `db:"password"`
	Role     UserRole `db:"role"`
}

type DBTX interface {
	Exec(context.Context, string, ...interface{}) (pgconn.CommandTag, error)
	Query(context.Context, string, ...interface{}) (pgx.Rows, error)
	QueryRow(context.Context, string, ...interface{}) pgx.Row
}

type Post struct {
	ID          int32          `db:"id"`
	Title       string         `db:"title"`
	Slug        string         `db:"slug"`
	Summary     string         `db:"summary"`
	FeatureImg  sql.NullString `db:"feature_img"`
	Content     string         `db:"content"`
	Status      string         `db:"status"`
	Likes       int64          `db:"likes"`
	Views       int64          `db:"views"`
	PublishedAt sql.NullTime   `db:"published_at"`
	CreatedAt   time.Time      `db:"created_at"`
	UpdatedAt   time.Time      `db:"updated_at"`
}

type PostAuthor struct {
	UserID int32 `db:"user_id"`
	PostID int32 `db:"post_id"`
}

type PostStatus string

type PostTag struct {
	PostID int32 `db:"post_id"`
	TagID  int32 `db:"tag_id"`
}

type PostTopic struct {
	TopicID int32 `db:"topic_id"`
	PostID  int32 `db:"post_id"`
}

type Queries struct {
	// contains filtered or unexported fields
}

type Setting struct {
	ID        int32     `db:"id"`
	SiteName  string    `db:"site_name"`
	Favicon   string    `db:"favicon"`
	CreatedAt time.Time `db:"created_at"`
	UpdatedAt time.Time `db:"updated_at"`
}

type Subscriber struct {
	ID            int32     `db:"id"`
	Email         string    `db:"email"`
	EmailVerified bool      `db:"email_verified"`
	Unsubscribed  bool      `db:"unsubscribed"`
	CreatedAt     time.Time `db:"created_at"`
	UpdatedAt     time.Time `db:"updated_at"`
}

type Tag struct {
	ID        int32     `db:"id"`
	Name      string    `db:"name"`
	CreatedAt time.Time `db:"created_at"`
	UpdatedAt time.Time `db:"updated_at"`
}

type Topic struct {
	ID        int32         `db:"id"`
	Name      string        `db:"name"`
	ParentID  sql.NullInt32 `db:"parent_id"`
	CreatedAt time.Time     `db:"created_at"`
	UpdatedAt time.Time     `db:"updated_at"`
}

type UpdateUserParams struct {
	Name          string   `db:"name"`
	Email         string   `db:"email"`
	Role          UserRole `db:"role"`
	EmailVerified bool     `db:"email_verified"`
	ID            int32    `db:"id"`
}

type UpdateUserPasswordParams struct {
	Password string `db:"password"`
	ID       int32  `db:"id"`
}

type User struct {
	ID            int32     `db:"id"`
	Name          string    `db:"name"`
	Email         string    `db:"email"`
	Password      string    `db:"password"`
	Role          UserRole  `db:"role"`
	EmailVerified bool      `db:"email_verified"`
	CreatedAt     time.Time `db:"created_at"`
	UpdatedAt     time.Time `db:"updated_at"`
}

type UserRole string