sql

Documentation

Index

• type Danmaku
• type Db
  • func NewDb(filename string) (*Db, error)
  • func (db *Db) Close() error
  • func (db *Db) InsertDanmaku(ctx context.Context, t *Danmaku) error
  • func (db *Db) InsertDelSC(ctx context.Context, id int64) error
  • func (db *Db) InsertGift(ctx context.Context, gift *Gift) error
  • func (db *Db) InsertHot(ctx context.Context, hot, watched int64) error
  • func (db *Db) InsertSC(ctx context.Context, sc *Sc) error
  • func (db *Db) InsertViewer(ctx context.Context, viewer *Viewer) error
• type Gift
• type Hot
• type Sc
• type Viewer

Types

type Danmaku

type Danmaku struct {
	DanmakuId    int    `db:"danmaku_id" json:"danmaku_id"`
	SendMode     int    `db:"send_mode" json:"send_mode"`
	SendFontSize int    `db:"send_font_size" json:"send_font_size"`
	DanmakuColor int64  `db:"danmaku_color" json:"danmaku_color"`
	Time         int64  `db:"time" json:"time"`
	Dmid         int64  `db:"dmid" json:"dmid"`
	MsgType      int    `db:"msg_type" json:"msg_type"`
	Bubble       string `db:"bubble" json:"bubble"`
	Content      string `db:"content" json:"content"`
	Mid          int64  `db:"mid" json:"mid"`
	Uname        string `db:"uname" json:"uname"`
	RoomAdmin    int    `db:"room_admin" json:"room_admin"`
	Vip          int    `db:"vip" json:"vip"`
	Svip         int    `db:"svip" json:"svip"`
	Rank         int    `db:"rank" json:"rank"`
	MobileVerify int    `db:"mobile_verify" json:"mobile_verify"`
	UnameColor   string `db:"uname_color" json:"uname_color"`
	MedalName    string `db:"medal_name" json:"medal_name"`
	UpName       string `db:"up_name" json:"up_name"`
	MedalLevel   int    `db:"medal_level" json:"medal_level"`
	UserLevel    int    `db:"user_level" json:"user_level"`
}

type Db

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

func NewDb

func NewDb(filename string) (*Db, error)

func (*Db) Close

func (db *Db) Close() error

func (*Db) InsertDanmaku

func (db *Db) InsertDanmaku(ctx context.Context, t *Danmaku) error

func (*Db) InsertDelSC

func (db *Db) InsertDelSC(ctx context.Context, id int64) error

func (*Db) InsertGift

func (db *Db) InsertGift(ctx context.Context, gift *Gift) error

func (*Db) InsertHot

func (db *Db) InsertHot(ctx context.Context, hot, watched int64) error

func (*Db) InsertSC

func (db *Db) InsertSC(ctx context.Context, sc *Sc) error

func (*Db) InsertViewer

func (db *Db) InsertViewer(ctx context.Context, viewer *Viewer) error

type Gift

type Gift struct {
	Id        int64  `db:"id" json:"id"`
	Uname     string `db:"uname" json:"uname"`
	Uid       int64  `db:"uid" json:"uid"`
	GiftName  string `db:"gift_name" json:"gift_name"`
	GiftNum   int    `db:"gift_num" json:"gift_num"`
	GiftID    int64  `db:"gift_id" json:"gift_id"`
	Action    string `db:"action" json:"action"`
	GiftPrice int    `db:"gift_price" json:"gift_price"`
	Time      int64  `db:"time" json:"time"`
}

type Hot

type Hot struct {
	Time    int64 `db:"time" json:"time"`
	Hot     int64 `db:"hot" json:"hot"`
	Watched int64 `db:"watched" json:"watched"`
}

type Sc

type Sc struct {
	ScId      int64  `db:"sc_id" json:"sc_id"`
	ID        int64  `db:"id" json:"id"`
	Uname     string `db:"uname" json:"uname"`
	Uid       int64  `db:"uid" json:"uid"`
	Time      int64  `db:"time" json:"time"`
	StartTime int64  `db:"start_time" json:"start_time"`
	Message   string `db:"message" json:"message"`
	Price     int    `db:"price" json:"price"`
}

type Viewer

type Viewer struct {
	ViewerId   int64  `db:"viewer_id" json:"viewer_id"`
	Uid        int64  `db:"uid" json:"uid"`
	Uname      string `db:"uname" json:"uname"`
	Time       int64  `db:"time" json:"time"`
	Score      int64  `db:"score" json:"score"`
	Dmscore    int    `db:"dmscore" json:"dmscore"`
	Medallevel int64  `db:"medallevel" json:"medallevel"`
	Medalname  string `db:"medalname" json:"medalname"`
	Targetid   int64  `db:"targetid" json:"targetid"`
}