f2e-middle-auth

curl -o- https://gitee.com/f2e-server/f2e-middle-auth/raw/master/quick_start.sh | bash

wget -qO- https://gitee.com/f2e-server/f2e-middle-auth/raw/master/quick_start.sh | bash

module.exports = {
    ...
    middlewares: [{
        middleware: 'auth'
    }]
}

module.exports = {
    ...
    middlewares: [{
        middleware: 'auth',
        maxAge: 86400,  // session 超时时间
        test: /.*/,     // 拦截路径

        store?: Store    // 默认使用json文件保存信息

        layout_page?: string
        login_page?: string
        admin_page?: string

        login_url: 'login',     // 登录
        logout_url: 'logout',   // 登出
        admin_url: 'admin'      // 管理界面
    }]
}

const { MysqlStore } = require('f2e-middle-auth')
module.exports = {
    ...
    middlewares: [
        {
            middleware: 'auth',
            store: new lib.MysqlStore({
                host: '127.0.0.1',
                port: 3306,
                user: 'root',
                password: 'root',
                database: 'authority'
            }, {
                authorities: {
                    tablename: 'permission',
                    columns: {
                        id: 'id',
                        name: 'name'
                    }
                },
                roles: {
                    tablename: 'roles',
                    columns: {
                        id: 'id',
                        name: 'name',
                        is_admin: 'is_admin'
                    }
                },
                role_auth_rel: {
                    tablename: 'roles2permission',
                    columns: {
                        id: 'id',
                        role_id: 'role_id',
                        auth_id: 'permission_id',
                        level: 'level'
                    }
                },
                users: {
                    tablename: 'users',
                    columns: {
                        id: 'id',
                        name: 'email',
                        nickname: 'nickname',
                        role_id: 'role_id',
                        password: 'password'
                    }
                }
            })
        }
    ]
}

const { UniteMysqlStore } = require('f2e-middle-auth')
const systemConfig={
    SQL_CONFIG:{
        host: '127.0.0.1',
        port: 3306,
        user: 'root',
        password: 'root',
        database: 'now_sys_basic'
    },
    TABLE_CONFIG:{
        authorities: {
            tablename: 'auth_authorities',
            columns: {
                id: 'id',
                name: 'name'
            }
        },
        roles: {
            tablename: 'auth_roles',
            columns: {
                id: 'id',
                name: 'name',
                is_admin: 'is_admin'
            }
        },
        role_auth_rel: {
            tablename: 'auth_role_auth_rel',
            columns: {
                id: 'id',
                role_id: 'role_id',
                auth_id: 'auth_id',
                level: 'level'
            }
        },
        user_role: {
            tablename: 'auth_users',
            columns: {
                id: 'id',
                role_id: 'role_id',
                user_name: 'name'
            }
        }
    }
}
/**
 * 不传userConfig为默认配置，默认配置如下
 * 统一用户数据存储数据库，只支持mysql
*/
const userConfig={
    SQL_CONFIG:{
        host: '127.0.0.1',
        port: 3306,
        user: 'root',
        password: '123456',
        database: 'meta',        
    },
    TABLE_CONFIG:{
        users: {
            tablename: 'auth_users',
            columns: {
                id: 'id',
                name: 'name',
                nickname: 'nickname',
                password: 'password'
            }
        }
    }
}
module.exports = {
    ...
    middlewares: [
        {
            middleware: 'auth',
            store: new lib.UniteMysqlStore(systemConfig,userConfig)
        }
    ]
}

CREATE TABLE `auth_authorities`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `auth_role_auth_rel`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `role_id` int(0) NOT NULL,
  `auth_id` int(0) NOT NULL,
  `level` int(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `auth_roles`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `is_admin` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
CREATE TABLE `auth_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_id` int(11) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `nickname` varchar(255) DEFAULT NULL,
  `password` varchar(64) DEFAULT NULL,
  `lock_ips` varchar(255) DEFAULT NULL,
  `expires` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
INSERT INTO `auth_authorities` (`id`, `name`) VALUES (1,'测试权限');
INSERT INTO `auth_roles` (`id`, `name`, `is_admin`) VALUES (1,'管理员','1');
INSERT INTO `auth_users` (`id`, `role_id`, `name`, `nickname`, `password`, `lock_ips`, `expires`) VALUES (1,1,'admin','管理员','e10adc3949ba59abbe56e057f20f883e',NULL,NULL);

import { MongoStore } from 'f2e-middle-auth'

const MongoStoreConf = {
    config: {
        url: ' mongodb://127.0.0.1:27017/',
        dbName: 'authority_test'
    },
    option: {
        authorities: {
            tablename: 'authorities',
            columns: {
                id: '_id',
                name: 'name'
            }
        },
        roles: {
            tablename: 'roles',
            columns: {
                id: '_id',
                name: 'name',
                is_admin: 'isAdmin',
                authorities: 'authorities'
            }
        },
        users: {
            tablename: 'users',
            columns: {
                id: '_id',
                name: 'name',
                nickname: 'nickname',
                role_id: 'role_id',
                isSys: 'isSys',
                password: 'password',
                lock_ips: 'lock_ips',
                expires: 'expires'
            }
        }
    }
}

    /**
     * 用户表
     */
    db.getCollection("users").insert([ {
        _id: ObjectId("5f40faef0c0a000045004ce3"),
        name: "admin",
        nickname: "系统管理员",
        password: "e10adc3949ba59abbe56e057f20f883e",
        isSys: true,
        roleId: ObjectId("5f40fa160c0a000045004ce2")
    } ]);
    /**
     * 
     * 角色表
    */
   db.getCollection("roles").insert([ {
        _id: ObjectId("5f40fa160c0a000045004ce2"),
        name: "管理员",
        isSys: true,
        isAdmin: true,
        authorities: { }
    } ]);
    /**
     * 
     * 权限表
    */
   db.getCollection("authorities").insert([ {
        _id: ObjectId("5f40f5ffff580000de003b76"),
        name: "测试权限"
    } ]);