models

package

v0.0.0-...-af63903 Latest Latest Go to latest Published: Aug 4, 2019 License: Apache-2.0 Imports: 11 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/can2049/weread

Links

Open Source Insights

Documentation ¶

Overview ¶

记载所有图书馆活动，包括管理员添加图书、用户借阅、归还图书这个表很庞大，要考虑分表之类的事情

Index ¶

Variables
func AddBook(b *Book) (int64, error)
func AddRecord(r *Record) (int64, error)
func AddUser(u *User) (int64, error)
func Connect()
func DelBookById(Id uint32) (int64, error)
func DelBookByName(Name string) (int64, error)
func DelUserById(Id uint32) (int64, error)
func Getuserlist(page int64, page_size int64, sort string) (users []orm.Params, count int64)
func InsertInitBooks()
func InsertInitLibraries()
func InsertInitOperations()
func InsertInitUsers()
func Syncdb()
func UpdateBook(b *Book) (int64, error)
func UpdateUser(u *User) (int64, error)
type Book
type Library
type Operation
type Record
type User
- func GetUserById(id uint32) (user User)
- func GetUserByUsername(username string) (user User)
- func (u *User) TableName() string
- func (u *User) Valid(v *validation.Validation)

Constants ¶

This section is empty.

Variables ¶

View Source

var BOOK = []Book{
	{Id: 0, Name: "NULL-BOOK", Isbn: 0, Library: 0},
}

View Source

var LIBRARY = []Library{

	{Id: 0, City: "NULL-LIBRARY", Building: "NULL"},
	{Id: 1, City: "SongShanHu", Building: "F1"},
	{Id: 2, City: "SongShanHu", Building: "M2"},
}

View Source

var OPERATION = []Operation{
	{Id: 0, Name: "NULL-OPERATION"},

	{Id: 1, Name: "UserBorrowBook"},
	{Id: 2, Name: "UserReturnBook"},

	{Id: 11, Name: "AdminAddNewBook"},
	{Id: 12, Name: "AdminModifyBookInfo"},
	{Id: 13, Name: "AdminDeleteBook"},

	{Id: 21, Name: "UserRigister"},
	{Id: 22, Name: "UserModifyInfo"},

	{Id: 31, Name: "AdminAddUser"},
	{Id: 32, Name: "AdminModifyUserInfo"},
	{Id: 33, Name: "AdminDeleteUser"},
}

View Source

var USER = []User{
	{
		Id:       1,
		Username: beego.AppConfig.String("rbac_admin_user"),
		Password: utils.Pwdhash(beego.AppConfig.String("default_admin_passwd")),
		EmployId: "NULL",
		Email:    "null@null",
	},
}

Functions ¶

func AddBook ¶

func AddBook(b *Book) (int64, error)

添加图书

func AddRecord ¶

func AddRecord(r *Record) (int64, error)

func AddUser ¶

func AddUser(u *User) (int64, error)

添加用户

func Connect ¶

func Connect()

数据库连接

func DelBookById ¶

func DelBookById(Id uint32) (int64, error)

func DelBookByName ¶

func DelBookByName(Name string) (int64, error)

func DelUserById ¶

func DelUserById(Id uint32) (int64, error)

func Getuserlist ¶

func Getuserlist(page int64, page_size int64, sort string) (users []orm.Params, count int64)

get user list

func InsertInitBooks ¶

func InsertInitBooks()

func InsertInitLibraries ¶

func InsertInitLibraries()

func InsertInitOperations ¶

func InsertInitOperations()

func InsertInitUsers ¶

func InsertInitUsers()

func Syncdb ¶

func Syncdb()

func UpdateBook ¶

func UpdateBook(b *Book) (int64, error)

func UpdateUser ¶

func UpdateUser(u *User) (int64, error)

更新用户

Types ¶

type Book ¶

type Book struct {
	Id          uint32    `orm:"pk"`
	Name        string    `orm:"size(40)"`
	Isbn        uint64    `orm:"" form:"Isbn"`
	Library     uint16    `orm:""`
	CoverPath   string    `orm:"null"`
	Added       time.Time `orm:"auto_now_add;type(datetime)"`
	Description string    `orm:"null;size(1000)"`
}

图书信息表

type Library ¶

type Library struct {
	Id       uint16 `orm:"pk"`
	City     string `orm:"size(40)"`
	Building string `orm:"size(10)"`
	Note     string `orm:"null;size(500)"`
}

图书馆表，便于对馆进行调整，新增、合并、撤销一个图书馆可以对应多个ID，便于兼容历史图书馆的撤销

type Operation ¶

type Operation struct {
	Id   uint8  `orm:"pk;unique"`
	Name string `orm:"size(20);unique"`
}

用户表

type Record ¶

type Record struct {
	Id          uint64
	UserId      uint32 `orm:""`
	BookId      uint32 `orm:"null"`
	OperationId uint8  `orm:""`
	LibraryId   uint64 `orm:"null"`
	// TODO  add sql comment
	Date time.Time `orm:"auto_now_add;type(datetime);comment(comment);description(UTC time)"`
	// 备用，记事
	Note string `orm:"null;size(500)"`
}

各种操作记录表

type User ¶

type User struct {
	Id            uint32    `orm:"pk"`
	Username      string    `orm:"size(32)" form:"Username"  valid:"Required;MaxSize(20);MinSize(6)"`
	EmployId      string    `orm:"unique;size(10)"`
	Password      string    `orm:"size(32)" form:"Password" valid:"Required;MaxSize(20);MinSize(6)"`
	Repassword    string    `orm:"-" form:"Repassword" valid:"Required"`
	Email         string    `orm:"null;size(32)" form:"Email" valid:"Email"`
	Status        int8      `orm:"default(2)" form:"Status" valid:"Range(1,2)"`
	Lastlogintime time.Time `orm:"null;type(datetime)" form:"-"`
	// auto_now 每次 model 保存时都会对时间自动更新
	// auto_now_add 第一次保存时才设置时间
	Created   time.Time `orm:"type(datetime);auto_now_add" `
	LastLogin time.Time //`orm:"type(datetime);auto_now"`
	//role, nomal user 0, admin 1
	LastIp string
	Role   int8 `orm:""`
}

用户表

func GetUserById ¶

func GetUserById(id uint32) (user User)

func GetUserByUsername ¶

func GetUserByUsername(username string) (user User)

func (*User) TableName ¶

func (u *User) TableName() string

func (*User) Valid ¶

func (u *User) Valid(v *validation.Validation)

Source Files ¶

View all Source files

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