db

package
v0.0.1 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: May 5, 2023 License: MIT Imports: 0 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type DB

type DB interface {
	Open() error
	Close() error
	GetTopicID(slug []string) (int, error)
	ListTopics(parent_id int) ([]Topic, error)
}

type Thread

type Thread struct {
	ID          int    `db:"id" json:"id"`
	TopicID     int    `db:"topic_id" json:"topic_id"`
	Slug        string `db:"slug" json:"slug,omitempty"`
	Title       string `db:"title" json:"title"`
	Description string `db:"description" json:"description,omitempty"`
	CreatedAt   string `db:"created_at" json:"created_at,omitempty"`
	UpdatedAt   string `db:"updated_at" json:"updated_at,omitempty"`
}

type Topic

type Topic struct {
	ID          int      `db:"id" json:"id"`
	ParentID    int      `db:"parent_id" json:"parent_id,omitempty"`
	Level       int      `db:"level" json:"level,omitempty"`
	ZOrder      int      `db:"zorder" json:"zorder,omitempty"`
	Slug        string   `db:"slug" json:"slug,omitempty"`
	Title       string   `db:"title" json:"title"`
	Description string   `db:"description" json:"description,omitempty"`
	CreatedAt   string   `db:"created_at" json:"created_at,omitempty"`
	UpdatedAt   string   `db:"updated_at" json:"updated_at,omitempty"`
	Topics      []Topic  `db:"-" json:"subtopic,omitempty"`
	Threads     []Thread `db:"-" json:"threads,omitempty"`
}

Directories

Path Synopsis

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL