models

package

v0.0.0-...-82c29ab Latest Latest Go to latest Published: Oct 21, 2017 License: MIT Imports: 8 Imported by: 0

Details

Valid go.mod file

The Go module system was introduced in Go 1.11 and is the official dependency management solution for Go.
Redistributable license

Redistributable licenses place minimal restrictions on how software can be used, modified, and redistributed.
Tagged version

Modules with tagged versions give importers more predictable builds.
Stable version

When a project reaches major version v1 it is considered stable.
Learn more about best practices

Repository

github.com/ztplz/blog-server

Links

Open Source Insights

Documentation ¶

Index ¶

Constants
Variables
func AddArticle(article *Article) (int64, error)
func AddCategory(category string) (int64, error)
func AddTag(color string, title string) (int64, error)
func AdminNewToken(a *Admin) (string, error)
func CheckTagTitle(tagTitle string) bool
func CountVistor(count uint) error
func DeleteCategory(category string) error
func GetAllArticle() (*[]Article, error)
func GetAllTag() (*[]Tag, error)
func GetAllUser() (*[]User, error)
func GetAllVisitorCount() (uint, error)
func GetArticleByPage(limit int64, page int64) (*[]Article, error)
func GetPasswordByUserID(userID string) (string, error)
func InitialAdmin()
func InitialDB()
func InitialRedis()
func UpdateAdminInfo(adminID, adminName, image string) error
func UpdateAdminPassword(password string) error
func UpdateCategory(category string, key string) error
func UpdateTag(id uint, color string, tagTitle string) error
func UpdateTimeIP(lastLoginAt string, ip string) error
func UpdateUserID(oldUserID string, newUserID string) error
func UpdateUserName(oldUserName string, newUserName string) error
func UpdateUserPassword(userID string, password string) error
func UserRegister(user *User) error
type Admin
- func AdminByID() (*Admin, error)
type AdminTokenClaims
type Article
- func GetArticleByID(id uint64) (*Article, error)
type Category
- func GetAllCategory() ([]Category, error)
type Tag
type Token
type User
- func GetUserByUserID(userID string) (*User, error)

Constants ¶

View Source

const (
	AdminIDLengthMin       = 5
	AdminIDLengthMax       = 20
	AdminPasswordLengthMin = 5
	AdminPasswordLengthMax = 20
)

设置后台登录账号密码长度范围

View Source

const (
	// ArticleTitleLengthMax 文章最多标题数
	ArticleTitleLengthMax = 100

	// ArticlePreviewTextLengthMax 文章预览最多字符数
	ArticlePreviewTextLengthMax = 600
)

View Source

const (
	// UserIDLengthMin 用户ID 最少长度
	UserIDLengthMin = 5

	// UserIDLengthMax 用户ID 最大长度
	UserIDLengthMax = 15

	// UserNameLengthMin 用户名 最少长度
	UserNameLengthMin = 3

	// UserNameLengthMax 用户名 最大长度
	UserNameLengthMax = 21

	// UserPasswordLengthMin 用户密码 最少长度
	UserPasswordLengthMin = 5

	// UserPasswordLengthMax 用户密码 最大长度
	UserPasswordLengthMax = 20
)

View Source

const (
	CategoryLengthMax = 20
)

设置分类名长度范围

Variables ¶

View Source

var DB *sql.DB

DB 定义为sql.DB类型

View Source

var RedisClient *redis.Client

RedisClient redis连接

Functions ¶

func AddArticle ¶

func AddArticle(article *Article) (int64, error)

AddArticle 增加文章

func AddCategory ¶

func AddCategory(category string) (int64, error)

AddCategory 增加分类名

func AddTag ¶

func AddTag(color string, title string) (int64, error)

AddTag 增加标签

func AdminNewToken ¶

func AdminNewToken(a *Admin) (string, error)

func CheckTagTitle ¶

func CheckTagTitle(tagTitle string) bool

CheckTagTitle 查询某个标签名是否存在,存在或错误返回true，不存在返回false

func CountVistor ¶

func CountVistor(count uint) error

CountVistor 数据库按日期记录访问人数加

func DeleteCategory ¶

func DeleteCategory(category string) error

删除某个分类名，删除分类名时务必删除关联 article 表的 category 字段相关的分类名

func GetAllArticle ¶

func GetAllArticle() (*[]Article, error)

GetAllArticle 取出所有博文

func GetAllTag ¶

func GetAllTag() (*[]Tag, error)

GetAllTag 获取全部标签

func GetAllUser ¶

func GetAllUser() (*[]User, error)

GetAllUser 获取所有注册用户信息

func GetAllVisitorCount ¶

func GetAllVisitorCount() (uint, error)

GetAllVisitorCount 获取数据所有访客人数

func GetArticleByPage ¶

func GetArticleByPage(limit int64, page int64) (*[]Article, error)

GetArticleByPage 分页查询

func GetPasswordByUserID ¶

func GetPasswordByUserID(userID string) (string, error)

GetPasswordByUserID 根据 userID 查询密码

func InitialAdmin ¶

func InitialAdmin()

InitialAdmin 初始化管理员账号

func InitialDB ¶

func InitialDB()

InitialDB 数据库初始化连接函数

func InitialRedis ¶

func InitialRedis()

InitialRedis 初始化连接redis

func UpdateAdminInfo ¶

func UpdateAdminInfo(adminID, adminName, image string) error

UpdateAdminInfo 更改管理员信息

func UpdateAdminPassword ¶

func UpdateAdminPassword(password string) error

UpdateAdminPassword 数据库更改管理员密码

func UpdateCategory ¶

func UpdateCategory(category string, key string) error

UpdateCategory 修改某个分类名

func UpdateTag ¶

func UpdateTag(id uint, color string, tagTitle string) error

UpdateTag 修改某个标签

func UpdateTimeIP ¶

func UpdateTimeIP(lastLoginAt string, ip string) error

UpdateTimeIP 存储管理员登录时间

func UpdateUserID ¶

func UpdateUserID(oldUserID string, newUserID string) error

UpdateUserID 更改用户ID

func UpdateUserName ¶

func UpdateUserName(oldUserName string, newUserName string) error

UpdateUserName 更改用户名字

func UpdateUserPassword ¶

func UpdateUserPassword(userID string, password string) error

UpdateUserPassword 更新用户密码

func UserRegister ¶

func UserRegister(user *User) error

UserRegister 用户信息存储进数据库

Types ¶

type Admin ¶

type Admin struct {
	ID          uint   `db:"id" json:"id"`
	AdminID     string `db:"admin_id" json:"admin_id"`
	Password    string `db:"password" json:"password"`
	AdminName   string `db:"admin_name" json:"admin_name"`
	Image       string `db:"image" json:"image"`
	LastLoginAt string `db:"last_login_at" json:"last_login_at"`
	IP          string `db:"ip" json:"ip"`
}

Admin 定义Admin结构体

func AdminByID ¶

func AdminByID() (*Admin, error)

AdminByID 从数据库根据 ID 查询管理员信息

type AdminTokenClaims ¶

type AdminTokenClaims struct {
	Admin *Admin
	jwt.StandardClaims
}

TokenClaims

type Article ¶

type Article struct {
	ID                 uint   `db:"id" json:"id"`
	CreateAt           string `db:"create_at" json:"create_at"`
	UpdateAt           string `db:"update_at" json:"update_at"`
	VisitCount         uint   `db:"visit_count" json:"visit_count"`
	ReplyCount         uint   `db:"reply._count" json:"reply_count"`
	ArticleTitle       string `db:"article_title" json:"article_title"`
	ArticlePreviewText string `db:"article_previewtext" json:"article_previewtext"`
	ArticleContent     string `db:"article_content" json:"article_content"`
	Top                bool   `db:"top" json:"top"`
	Category           uint   `db:"category" json:"category"`
	TagList            string `db:"tag_list" json:"tag_list"`
}

Article 文章的数据结构

func GetArticleByID ¶

func GetArticleByID(id uint64) (*Article, error)

GetArticleByID 根据 id 查询

type Category ¶

type Category struct {
	ID       uint   `db:"id" json:"id"`
	Category string `db:"category" json:"category"`
}

Category 文章的数据结构

func GetAllCategory ¶

func GetAllCategory() ([]Category, error)

GetAllCategory 获取全部分类名

type Tag ¶

type Tag struct {
	ID       uint   `db:"id" json:"id"`
	Color    string `db:"color" json:"color"`
	TagTitle string `db:"tag_title" json:"tag_title"`
}

Tag 定义Tag的结构

type Token ¶

type Token string

设置Token为字符类型

type User ¶

type User struct {
	ID          uint   `db:"id" json:"id"`
	UserID      string `db:"user_id" json:"user_id"`
	Password    string `db:"password" json:"password"`
	UserName    string `db:"user_name" json:"user_name"`
	Image       string `db:"image" json:"image"`
	CreateAt    string `db:"create_at" json:"create_at"`
	LastLoginAt string `db:"last_login_at" json:"last_login_at"`
	LoginCount  uint   `db:"login_count" json:"login_count"`
	IsBlacklist bool   `db:"is_blacklist" json:"is_blacklist"`
}

User 定义User结构体

func GetUserByUserID ¶

func GetUserByUserID(userID string) (*User, error)

GetUserByUserID 根据 UserID 从数据库获取数据

Source Files ¶

View all Source files

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