article

package
v0.0.0-...-a7f0746 Latest Latest
Warning

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

Go to latest
Published: Jan 10, 2021 License: MIT Imports: 3 Imported by: 0

Documentation

Overview

Package note provides access to the note table in the MySQL database.

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func ByUserIDCount

func ByUserIDCount(db Connection, userID string) (int, error)

ByUserIDCount counts the number of Articles for a user.

func Create

func Create(db Connection, tittle string, issian string, publish string, userID string) (sql.Result, error)

Create adds an Article.

func DeleteHard

func DeleteHard(db Connection, articleID string, userID string) (sql.Result, error)

DeleteHard removes an Article.

func DeleteSoft

func DeleteSoft(db Connection, articleID string, userID string) (sql.Result, error)

DeleteSoft marks an Article as removed.

func Update

func Update(db Connection, tittle string, issian string, articleID string, userID string) (sql.Result, error)

Update makes changes to an existing Article.

Types

type Article

type Article struct {
	ArticleID uint32         `db:"article_id"`
	Tittle    string         `db:"tittle"`
	Issian    string         `db:"issian"`
	UserID    uint32         `db:"user_id"`
	CreatedAt mysql.NullTime `db:"created_at"`
	UpdatedAt mysql.NullTime `db:"updated_at"`
	DeletedAt mysql.NullTime `db:"deleted_at"`
	Publish   uint32         `db:"publish"`
}

Article defines the model.

func ByID

func ByID(db Connection, ArticleID string, userID string) (Article, bool, error)

ByID gets an Article by ArticleID.

func ByUserID

func ByUserID(db Connection, userID string) ([]Article, bool, error)

ByUserID gets all Articles for a user.

func ByUserIDPaginate

func ByUserIDPaginate(db Connection, userID string, max int, page int) ([]Article, bool, error)

ByUserIDPaginate gets Articles for a user based on page and max variables.

type Connection

type Connection interface {
	Exec(query string, args ...interface{}) (sql.Result, error)
	Get(dest interface{}, query string, args ...interface{}) error
	Select(dest interface{}, query string, args ...interface{}) error
}

Connection is an interface for making queries.

Jump to

Keyboard shortcuts

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