mysql

Documentation

Index

• func CreateDepartmentMemberTable(db *sql.DB, DBName, TableName string) error
• func CreateDepartmentTable(db *sql.DB, DBName, TableName string) error
• func InsertDepartment(db *sql.DB, DBName, TableName string, d *Department) (int64, error)
• func InsertDepartmentMember(db *sql.DB, DBName, TableName string, dm *DepartmentMember) (int64, error)
• type Department
• type DepartmentMember

Functions

func CreateDepartmentMemberTable

func CreateDepartmentMemberTable(db *sql.DB, DBName, TableName string) error

CreateDepartmentMemberTable create an administrative userAuth

func CreateDepartmentTable

func CreateDepartmentTable(db *sql.DB, DBName, TableName string) error

CreateTable create

func InsertDepartment

func InsertDepartment(db *sql.DB, DBName, TableName string, d *Department) (int64, error)

func InsertDepartmentMember

func InsertDepartmentMember(db *sql.DB, DBName, TableName string, dm *DepartmentMember) (int64, error)

InsertDepartmentMember create an

Types

type Department

type Department struct {
	Id               int64     `json:"id,omitempty"`
	Code             string    `json:"code,omitempty"`
	OrganizationCode string    `json:"organization_code,omitempty"`
	Name             string    `json:"name,omitempty"`
	Sort             string    `json:"sort,omitempty"`
	Pcode            string    `json:"pcode,omitempty"`
	Icon             string    `json:"icon,omitempty"`
	CreateTime       time.Time `json:"create_time,omitempty"`
	Path             string    `json:"path,omitempty"`
}

type DepartmentMember

type DepartmentMember struct {
	Id               int64     `json:"id,omitempty"`
	Code             string    `json:"code,omitempty"`
	DepartmentCode   string    `json:"department_code,omitempty"`
	OrganizationCode string    `json:"organization_code,omitempty"`
	AccountCode      string    `json:"account_code,omitempty"`
	JoinTime         time.Time `json:"join_time,omitempty"`
	IsPrincipal      int8      `json:"is_principal,omitempty"`
	IsOwner          int8      `json:"is_owner,omitempty"`
	Authorize        string    `json:"authorize,omitempty"`
}