models

Documentation

Index

• func SaveUser(user *User) error
• type DB
  • func NewDB() *DB
  • func (db *DB) AllVisitCount(key string) error
  • func (db *DB) Begin()
  • func (db *DB) Commit()
  • func (db *DB) DelMessage(n *Message) error
  • func (db *DB) DelNoteByKey(key string, userId int) error
  • func (db *DB) GetDBTime() *time.Time
  • func (db *DB) QueryMessageByKey(key string) (message Message, err error)
  • func (db *DB) QueryMessageForNote(key string) (messages []*Message, err error)
  • func (db *DB) QueryMessageForNoteByPage(key string, page, limit int) (messages []*Message, err error)
  • func (db *DB) QueryMessageForNoteCount(key string) (count int, err error)
  • func (db *DB) QueryNoteByKey(key string) (note Note, err error)
  • func (db *DB) QueryNoteByKeyAndUserId(key string, userId int) (note Note, err error)
  • func (db *DB) QueryNoteByKeyWithAuthLimit(key string, userId int) (note Note, err error)
  • func (db *DB) QueryNotesByPage(page, limit int, title string, userId uint, notetype string) (note []*Note, err error)
  • func (db *DB) QueryNotesCount(title string, userId uint, notetype string) (cnt int, err error)
  • func (db *DB) QueryPraiseLog(key string, user_id int, ttype string) (parselog PraiseLog, err error)
  • func (db *DB) QueryUserByEmail(email string) (user User, err error)
  • func (db *DB) QueryUserByEmailAndPassword(email, password string) (user User, err error)
  • func (db *DB) QueryUserByName(name string) (user User, err error)
  • func (db *DB) Rollback()
  • func (db *DB) SaveMessage(n *Message) error
  • func (db *DB) SaveNote(n *Note) error
  • func (db *DB) SavePraiseLog(p *PraiseLog) error
  • func (db *DB) UpdateMessage4Praise(n *Message) error
  • func (db *DB) UpdateNote4Praise(n *Note) error
  • func (db *DB) UpdateUserEditor(editor string) (err error)
• type Message
• type Model
• type Note
• type PraiseLog
• type User

Functions

func SaveUser

func SaveUser(user *User) error

Types

type DB

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

func NewDB

func NewDB() *DB

func (*DB) AllVisitCount

func (db *DB) AllVisitCount(key string) error

func (*DB) Begin

func (db *DB) Begin()

func (*DB) Commit

func (db *DB) Commit()

func (*DB) DelMessage

func (db *DB) DelMessage(n *Message) error

func (*DB) DelNoteByKey

func (db *DB) DelNoteByKey(key string, userId int) error

func (*DB) GetDBTime

func (db *DB) GetDBTime() *time.Time

func (*DB) QueryMessageByKey

func (db *DB) QueryMessageByKey(key string) (message Message, err error)

func (*DB) QueryMessageForNote

func (db *DB) QueryMessageForNote(key string) (messages []*Message, err error)

func (*DB) QueryMessageForNoteByPage

func (db *DB) QueryMessageForNoteByPage(key string, page, limit int) (messages []*Message, err error)

func (*DB) QueryMessageForNoteCount

func (db *DB) QueryMessageForNoteCount(key string) (count int, err error)

func (*DB) QueryNoteByKey

func (db *DB) QueryNoteByKey(key string) (note Note, err error)

func (*DB) QueryNoteByKeyAndUserId

func (db *DB) QueryNoteByKeyAndUserId(key string, userId int) (note Note, err error)

func (*DB) QueryNoteByKeyWithAuthLimit

func (db *DB) QueryNoteByKeyWithAuthLimit(key string, userId int) (note Note, err error)

详情页展示，增加权限控制

func (*DB) QueryNotesByPage

func (db *DB) QueryNotesByPage(page, limit int, title string, userId uint, notetype string) (note []*Note, err error)

func (*DB) QueryNotesCount

func (db *DB) QueryNotesCount(title string, userId uint, notetype string) (cnt int, err error)

func (*DB) QueryPraiseLog

func (db *DB) QueryPraiseLog(key string, user_id int, ttype string) (parselog PraiseLog, err error)

func (*DB) QueryUserByEmail

func (db *DB) QueryUserByEmail(email string) (user User, err error)

func (*DB) QueryUserByEmailAndPassword

func (db *DB) QueryUserByEmailAndPassword(email, password string) (user User, err error)

func (*DB) QueryUserByName

func (db *DB) QueryUserByName(name string) (user User, err error)

func (*DB) Rollback

func (db *DB) Rollback()

func (*DB) SaveMessage

func (db *DB) SaveMessage(n *Message) error

func (*DB) SaveNote

func (db *DB) SaveNote(n *Note) error

func (*DB) SavePraiseLog

func (db *DB) SavePraiseLog(p *PraiseLog) error

func (*DB) UpdateMessage4Praise

func (db *DB) UpdateMessage4Praise(n *Message) error

func (*DB) UpdateNote4Praise

func (db *DB) UpdateNote4Praise(n *Note) error

func (*DB) UpdateUserEditor

func (db *DB) UpdateUserEditor(editor string) (err error)

type Message

type Message struct {
	Model
	Key    string `gorm:"unique_index;not null;" json:"key"`
	UserID int    `json:"user_id"`
	User   User   `json:"user"`
	//NoteID  int
	//Note    Note
	NoteKey string `sql:"index" json:"note_key"`
	Content string `json:"content"`
	Praise  int    `gorm:"default:0" json:"praise"`
}

type Model

type Model struct {
	ID        uint       `gorm:"primary_key" json:"id"`
	CreatedAt time.Time  `json:"createtime"`
	UpdatedAt time.Time  `json:"updatetime"`
	DeletedAt *time.Time `sql:"index" json:"-"`
}

type Note

type Note struct {
	//("created_at","updated_at","deleted_at","key","user_id","title","summary","content","source","editor","files"
	Model
	Key     string `gorm:"unique_index;not null;"`
	UserID  int
	User    User
	Title   string
	Summary string `gorm:"type:text"`
	Content string `gorm:"type:text"`
	Source  string `gorm:"type:text" json:"source"`
	Editor  string `gorm:"varchar(40)'" `
	Files   string `gorm:"type:text"`
	Visit   int    `gorm:"default:0"`
	Praise  int    `gorm:"default:0"`
	Open    int
	Type    string
}

type PraiseLog

type PraiseLog struct {
	Model
	Key    string `sql:"index"`
	UserID int    `sql:"index"`
	Type   string `sql:"index"`
	Flag   bool
}

type User

type User struct {
	Model
	Name   string `gorm:"unique_index" json:"name"`
	Email  string `gorm:"unique_index" json:"email"`
	Avatar string `json:"avatar"`
	Pwd    string `json:"-"`
	Role   int    `gorm:"default:0" json:"role"` // 0 管理员 1正常用户
	Editor string `json:"editor"`
}

用户表