配置

1. 设置数据库环境

   您必须准备数据库环境，以便Sqlx可以在编译时使用查询进行静态检查。一个方便的选项是使用docker来准备您的数据库环境

   #!/bin/bash
   
   DIS=$(lsb_release -is)
   
   command -v docker > /dev/null 2>&1 || {
       echo "Please install docker before running this script." && exit 1;
   }
   
   if [ $DIS == "Ubuntu" ] || [ $DIS == "LinuxMint" ]; then
       sudo apt install -y \
           libpq-dev \
           libmysqlclient-dev \
           postgresql-client \
           mysql-client-core;
   
   elif [ $DIS == "Deepin" ]; then
       sudo apt install -y \
           libpq-dev \
           libmysql++-dev \
           mysql-client \
           postgresql-client;
   elif [ $DIS == "ArchLinux" ] || [ $DIS == "ManjaroLinux" ]; then
       sudo pacman -S libmysqlclient \
           postgresql-libs \
           mysql-clients \;
   else
       echo "Unsupported system: $DIS" && exit 1;
   fi
   
   docker run -itd \
       --restart always \
       -e POSTGRES_USER=casbin_rs \
       -e POSTGRES_PASSWORD=casbin_rs \
       -e POSTGRES_DB=casbin \
       -p 5432:5432 \
       -v /srv/docker/postgresql:/var/lib/postgresql \
       postgres:11;
   
   docker run -itd \
       --restart always \
       -e MYSQL_ALLOW_EMPTY_PASSWORD=yes \
       -e MYSQL_USER=casbin_rs \
       -e MYSQL_PASSWORD=casbin_rs \
       -e MYSQL_DATABASE=casbin \
       -p 3306:3306 \
       -v /srv/docker/mysql:/var/lib/mysql \
       mysql:8 \
       --default-authentication-plugin=mysql_native_password;
   
   

2. 创建表casbin_rule

   # PostgreSQL
   psql postgres://casbin_rs:[email protected]:5432/casbin -c "CREATE TABLE IF NOT EXISTS casbin_rule (
       id SERIAL PRIMARY KEY,
       ptype VARCHAR NOT NULL,
       v0 VARCHAR NOT NULL,
       v1 VARCHAR NOT NULL,
       v2 VARCHAR NOT NULL,
       v3 VARCHAR NOT NULL,
       v4 VARCHAR NOT NULL,
       v5 VARCHAR NOT NULL,
       CONSTRAINT unique_key_sqlx_adapter UNIQUE(ptype, v0, v1, v2, v3, v4, v5)
       );"
   
   # MySQL
   mysql -h 127.0.0.1 -u casbin_rs -pcasbin_rs casbin 
   
   CREATE TABLE IF NOT EXISTS casbin_rule (
       id INT NOT NULL AUTO_INCREMENT,
       ptype VARCHAR(12) NOT NULL,
       v0 VARCHAR(128) NOT NULL,
       v1 VARCHAR(128) NOT NULL,
       v2 VARCHAR(128) NOT NULL,
       v3 VARCHAR(128) NOT NULL,
       v4 VARCHAR(128) NOT NULL,
       v5 VARCHAR(128) NOT NULL,
       PRIMARY KEY(id),
       CONSTRAINT unique_key_sqlx_adapter UNIQUE(ptype, v0, v1, v2, v3, v4, v5)
       ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
   
   # SQLite
   touch casbin.db
   
   sqlite3 casbin.db -cmd "CREATE TABLE IF NOT EXISTS casbin_rule (
      id INTEGER PRIMARY KEY,
      ptype VARCHAR(12) NOT NULL,
      v0 VARCHAR(128) NOT NULL,
      v1 VARCHAR(128) NOT NULL,
      v2 VARCHAR(128) NOT NULL,
      v3 VARCHAR(128) NOT NULL,
      v4 VARCHAR(128) NOT NULL,
      v5 VARCHAR(128) NOT NULL,
      CONSTRAINT unique_key_diesel_adapter UNIQUE(ptype, v0, v1, v2, v3, v4, v5)
      );"
   

3. 配置env

   将sample.env重命名为.env并将DATABASE_URL和POOL_SIZE放入其中

   DATABASE_URL=postgres://casbin_rs:casbin_rs@localhost:5432/casbin
   # DATABASE_URL=mysql://casbin_rs:casbin_rs@localhost:3306/casbin
   # DATABASE_URL=sqlite:casbin.db
   POOL_SIZE=8
   

   或者您可以导出 DATABASE_URL、POOL_SIZE

   export DATABASE_URL=postgres://casbin_rs:casbin_rs@localhost:5432/casbin
   export POOL_SIZE=8
   

示例

use sqlx_adapter::casbin::prelude::*;
use sqlx_adapter::casbin::Result;
use sqlx_adapter::SqlxAdapter;

#[tokio::main]
async fn main() -> Result<()> {
    let m = DefaultModel::from_file("examples/rbac_model.conf").await?;
    
    let a = SqlxAdapter::new("postgres://casbin_rs:[email protected]:5432/casbin", 8).await?;
    let mut e = Enforcer::new(m, a).await?;
    
    Ok(())
}

功能

• postgres
• mysql
• sqlite

注意： postgres、mysql、sqlite 互相排斥，这意味着您只能激活它们中的一个。