code

Documentation

Index

• Constants
• type LocalPermHelp
  • func NewLocalPermHelp(exceptControllerFiles ...string) *LocalPermHelp
  • func (this *LocalPermHelp) CreateSql(output string) error
  • func (this *LocalPermHelp) PrintDiff()
  • func (this *LocalPermHelp) UpdateTable() error
• type Perm
• type RemotePermHelp
  • func NewRemotePermHelp() *RemotePermHelp
  • func (this *RemotePermHelp) CreateSql(output string) error

Constants

const (
	ControllerDir = "./controllers/" //控制器目录
	TablePrefix   = "t_"             //表前缀

	PermTableName = "t_perm" //权限表名称

	LocalDatableName  = "goadmin" //本地数据库名
	RemoteDatableName = "sdrms"   //远地数据库名

	//数据库连接信息
	LocalDatabase  = "root:root@tcp(localhost)/" + LocalDatableName + "?charset=utf8"
	RemoteDatabase = "root:root@tcp(localhost)/" + RemoteDatableName + "?charset=utf8"

	UpdatePermSql = "UPDATE `" + LocalDatableName + "`.`" + PermTableName + "` SET `name`='%s',`perm_tree_id`='%d' WHERE `id`='%d';\n"               //更新sql
	InsertPermSql = "INSERT INTO `" + LocalDatableName + "`.`" + PermTableName + "` (`name`, `perm_url`, `perm_tree_id`) VALUES ('%s', '%s', %d);\n" //插入sql

	SyncUpdateSql = "UPDATE `" + RemoteDatableName + "`.`" + PermTableName + "` SET `name`='%s',`permtree_id`='%d' WHERE `id`='%d';\n"
	SyncInsertSql = "INSERT INTO `" + RemoteDatableName + "`.`" + PermTableName + "` (`id`,`name`, `perm_url`, `perm_tree_id`) VALUES (%d,'%s', '%s', %d);\n"

	LocalSqlFile  = "./local-permhelp.sql"  //输出sql文件位置
	RemoteSqlFile = "./remote-permhelp.sql" //远程sql文件位置
)

Types

type LocalPermHelp

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

本地数据库权限自动生成

func NewLocalPermHelp

func NewLocalPermHelp(exceptControllerFiles ...string) *LocalPermHelp

本地数据库权限自动生成

func (*LocalPermHelp) CreateSql

func (this *LocalPermHelp) CreateSql(output string) error

生成sql文件

func (*LocalPermHelp) PrintDiff

func (this *LocalPermHelp) PrintDiff()

打印数据库中多余的权限

func (*LocalPermHelp) UpdateTable

func (this *LocalPermHelp) UpdateTable() error

直接更新本地数据

type Perm

type Perm struct {
	Id         uint32
	Name       string
	PermUrl    string
	PermTreeId uint32 //用于树形结构展示
	Sort       uint32 //排序字段
}

权限表结构

type RemotePermHelp

type RemotePermHelp struct {
	DstPerms    []Perm //目标数据库权限
	DstPermsMap map[string]Perm

	SrcPerms    []Perm //本地数据库权限
	SrcPermsMap map[string]Perm
}

对比两个数据库t_perm 生成差异sql

func NewRemotePermHelp

func NewRemotePermHelp() *RemotePermHelp

远程数据权限自动生成

func (*RemotePermHelp) CreateSql

func (this *RemotePermHelp) CreateSql(output string) error

生成sql