配置

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 互斥，这意味着您只能激活其中一个。