mysql

Permissions MYSQL Store

Usage

Make sure that sql service has been deployed.

import (
_ "github.com/aacfactory/fns-contrib/permissions/store/mysql"
)

Config setting

permissions:
  store:
    model: 
      schema: "schema"
      table: "table name"
    policy:
      schema: "schema"
      table: "table name"

DML

Model table

CREATE TABLE IF NOT EXISTS `YOUR TABLE` (
    `NAME`      VARCHAR (255),
    `PARENT`    VARCHAR (255) NOT NULL,
    `RESOURCES` JSON,
    `VERSION`   bigint,
    PRIMARY KEY (`NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Policy table

CREATE TABLE IF NOT EXISTS `YOUR TABLE` (
    `USER_ID`   VARCHAR (63),
    `ROLES`     VARCHAR (255) NOT NULL,
    `VERSION`   bigint,
    PRIMARY KEY (`USER_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;