models

Documentation

Index

• func ConnectDb(host string) (db *sql.DB, err error)
• func NewMessage(p NewMessageParams) (id int64, err error)
• func ResetDb(host string) (res sql.Result, err error)
• type MessageItem
  • func FindMessages() (items []MessageItem, err error)
• type NewMessageParams
• type RankingItem
  • func FindRanking(ym string) (items []RankingItem, err error)

Functions

func ConnectDb

func ConnectDb(host string) (db *sql.DB, err error)

ConnectDb trys to connect specified host and returns connection.

func NewMessage

func NewMessage(p NewMessageParams) (id int64, err error)

NewMessage inserts a message record and returns last insert id.

func ResetDb

func ResetDb(host string) (res sql.Result, err error)

ResetDb drops all tables and re-creates messages table.

Types

type MessageItem

type MessageItem struct {
	Id        int64
	FromName  string
	ToName    string
	CreatedAt time.Time
	Message   string
}

func FindMessages

func FindMessages() (items []MessageItem, err error)

FindMessages returns Messages slice.

type NewMessageParams

type NewMessageParams struct {
	From, To, Message, CreatedAt string
}

type RankingItem

type RankingItem struct {
	Name  string
	Count int
}

func FindRanking

func FindRanking(ym string) (items []RankingItem, err error)

FindRanking returns ranking slice. Parameter 'ym' should be as `201608`