query

package
v0.0.0-...-4a8c6e9 Latest Latest
Warning

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

 Go to latest Published: Aug 12, 2023 License: GPL-2.0 Imports: 12 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func HaveCid 

func HaveCid(Db *sqlx.DB, cid int) bool

func IPInt 

func IPInt(ip string) int64

IPInt ip地址转数字

func InsertComment 

func InsertComment(Db *sqlx.DB, data Comments)

func NextPageNum 

func NextPageNum(Db *sqlx.DB, status string, limit, pageNum int) int

给定当前页数和一页的数量，查询剩余页数

func String2Bytes 

func String2Bytes(s string) []byte

String2Bytes直接转换底层指针，两者指向的相同的内存，改一个另外一个也会变。 效率是string([]byte{})的百倍以上，且转换量越大效率优势越明显。 转换之后若没做其他操作直接改变里面的字符，则程序会崩溃。 如 b:=String2bytes("xxx"); b[1]='d'; 程序将panic。

func TestAffairs 

func TestAffairs(Db *sqlx.DB, status string, limit, pagenum int) ([]Contents, []Contents)

TestAffairs 测试事务

Types

type Access 

type Access struct {
	ID               int            `db:"id"`
	UA               string         `db:"ua"`
	BrowserID        string         `db:"browser_id"`
	BrowserVersion   string         `db:"browser_version"`
	OSID             string         `db:"os_id"`
	OSVersion        string         `db:"os_version"`
	URL              string         `db:"url"`
	Path             string         `db:"path"`
	QueryString      sql.NullString `db:"query_string"`
	IP               int64          `db:"ip"`
	Entrypoint       string         `db:"entrypoint"`
	EntrypointDomain sql.NullString `db:"entrypoint_domain"`
	Referer          string         `db:"referer"`
	RefererDomain    sql.NullString `db:"referer_domain"`
	Time             int64          `db:"time"`
	ContentID        sql.NullInt64  `db:"content_id"`
	MetaID           sql.NullInt64  `db:"meta_id"`
	Robot            int8           `db:"robot"`
	RobotID          string         `db:"robot_id"`
	RobotVersion     string         `db:"robot_version"`
}

func AccessArr 

func AccessArr(Db *sqlx.DB, limit, pageNum int) []Access

func (Access) IPString 

func (a Access) IPString() string

IPString 数字转ip地址

func (Access) SimplifyUserAgent 

func (a Access) SimplifyUserAgent() string

SimplifyUserAgent 简化浏览器的User-Agent字符串并检测爬虫（bot）

func (Access) SubReferer 

func (a Access) SubReferer() string

func (Access) UnixFormat 

func (a Access) UnixFormat() string

type Comments 

type Comments struct {
	Coid     uint32         `db:"coid"     form:"coid"`
	Cid      uint32         `db:"cid"      form:"cid"`
	OwnerId  uint32         `db:"ownerId"  form:"ownerId"`
	Parent   uint32         `db:"parent"   form:"parent"`
	Created  int64          `db:"created"  form:"created"`
	Author   string         `db:"author"   form:"author"`
	Mail     string         `db:"mail"     form:"mail"`
	Ip       string         `db:"ip"       form:"ip"`
	Agent    string         `db:"agent"    form:"agent"`
	Text     string         `db:"text"     form:"text"`
	Type     string         `db:"type"     form:"type"`
	Status   string         `db:"status"   form:"status"`
	AuthorId uint8          `db:"authorId" form:"authorId"`
	Url      sql.NullString `db:"url"      form:"url"`
}

func CommentsWithCid 

func CommentsWithCid(Db *sqlx.DB, cid int) []Comments

CommentsWithCid 根据文章cid查询该文章的评论

func (Comments) MD5Mail 

func (c Comments) MD5Mail() string

func (Comments) SubText 

func (c Comments) SubText() string

func (Comments) UnixFormat 

func (c Comments) UnixFormat() string

type CommsWithTitleMix 

type CommsWithTitleMix struct {
	Comments
	Title string `db:"title"     form:"title"`
}

func CommsWithTitle 

func CommsWithTitle(Db *sqlx.DB, status string, limit, pagenum int) []CommsWithTitleMix

CommsWithTitle 查询评论组，后台专用

type Contents 

type Contents struct {
	Cid          int            `db:"cid"`
	Title        string         `db:"title"`
	Slug         string         `db:"slug"`
	Created      int64          `db:"created"`
	Modified     int64          `db:"modified"`
	Text         []byte         `db:"text"`
	Order        uint8          `db:"order"`
	AuthorId     uint8          `db:"authorId"`
	Template     sql.NullString `db:"template"`
	Type         string         `db:"type"`
	Status       string         `db:"status"`
	Password     sql.NullString `db:"password"`
	AllowComment uint8          `db:"allowComment"`
	AllowPing    uint8          `db:"allowPing"`
	AllowFeed    uint8          `db:"allowFeed"`
	CommentsNum  uint16         `db:"commentsNum"`
	Parent       uint16         `db:"parent"`
	Views        uint16         `db:"views"`
	Likes        uint32         `db:"likes"`
}

func Media 

func Media(Db *sqlx.DB, limit, pageNum int) []Contents

查询文件组，后台专用

func PageArr 

func PageArr(Db *sqlx.DB) []Contents

PageArr 根据条件查询多条页面

func PageWithCid 

func PageWithCid(Db *sqlx.DB, cid int) Contents

PageWithCid 根据Cid查询单条文章或独立页面

func PostArr 

func PostArr(Db *sqlx.DB, status string, limit, pageNum int) []Contents

PostArr 根据条件查询多条文章 状态 条数 页数

func PostWithCid 

func PostWithCid(Db *sqlx.DB, cid int) Contents

PostWithCid 根据Cid查询单条文章或独立页面

func TestQueryPostWithCid 

func TestQueryPostWithCid(Db *sqlx.DB, cid int) Contents

TestQueryPostWithCid 测试是否是指针变量

func (Contents) Bytes2String 

func (c Contents) Bytes2String(b []byte) string

Bytes2String直接转换底层指针，两者指向的相同的内存，改一个另外一个也会变。 效率是string([]byte{})的百倍以上，且转换量越大效率优势越明显。

func (Contents) MD2HTML 

func (c Contents) MD2HTML() string

MD2HTML markdown转换为html

func (Contents) MDCount 

func (c Contents) MDCount() int

MDCount 计算文章字数

func (Contents) MDSub 

func (c Contents) MDSub() string

MDSub 截取前95字符串作为摘要

func (Contents) UnixFormat 

func (c Contents) UnixFormat() string

func (Contents) UnixToStr 

func (c Contents) UnixToStr() string

type Fields 

type Fields struct {
	Cid        int     `db:"cid"`
	Name       string  `db:"name"`
	Type       string  `db:"type"`
	StrValue   string  `db:"str_value"`
	IntValue   int     `db:"int_value"`
	FloatValue float64 `db:"float_value"`
}

type MediasWithTitleMix 

type MediasWithTitleMix struct {
	Contents
	PostTitle string `db:"post_title"     form:"post_title"`
}

func MediasWithTitle 

func MediasWithTitle(Db *sqlx.DB, limit, pagenum int) []MediasWithTitleMix

type PostWithBGMusicMix 

type PostWithBGMusicMix struct {
	Contents
	Music string `db:"music"     form:"music"`
}

func PostWithBGMusic 

func PostWithBGMusic(Db *sqlx.DB, status string, limit, pagenum int) PostWithBGMusicMix

PostWithBGMusic 查询带封面的文章

type PostsWithCoverMix 

type PostsWithCoverMix struct {
	Contents
	Cover string `db:"cover"     form:"cover"`
}

func PostsWithCover 

func PostsWithCover(Db *sqlx.DB, status string, limit, pagenum int) []PostsWithCoverMix

PostsWithCover 查询带封面的文章组

type User 

type User struct {
	Uid        string `db:"uid"`
	Name       string `db:"name"`
	Password   string `db:"password"`
	Mail       string `db:"mail"`
	Url        string `db:"url"`
	ScreenName string `db:"screenName"`
	Created    int64  `db:"created"`
	Activated  int64  `db:"activated"`
	Logged     int64  `db:"logged"`
	Group      string `db:"group"`
	AuthCode   string `db:"authCode"`
}

内存对齐 https://geektutu.com/post/hpg-struct-alignment.html

func UserWithName 

func UserWithName(Db *sqlx.DB, name string) (User, error)

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.