name: CI
on:
pull_request:
push:
branches:
- master
jobs:
build:
name: Auto Build CI
runs-on: ${{ matrix.os }}
strategy:
matrix:
os: [ ubuntu-latest, windows-latest, macOS-latest ]
rust: [ stable ]
steps:
- name: Checkout Repository
uses: actions/checkout@master
- name: Install Rust toolchain
uses: dtolnay/rust-toolchain@master
with:
toolchain: ${{ matrix.rust }}
components: rustfmt, clippy
- name: Cargo Clippy
run: cargo clippy -- -D warnings
- name: Cargo Fmt Check
run: cargo fmt --all -- --check
- name: Cargo Build
run: cargo build
- name: Setup PostgreSQL & MySQL & SQLite (for ubuntu)
if: matrix.os == 'ubuntu-latest'
run: |
sudo apt-get update
sudo apt-get upgrade
sudo apt-get install -y libpq-dev postgresql libmysqlclient-dev mysql-client libsqlite3-dev sqlite3
echo "host all all 127.0.0.1/32 md5" > sudo tee -a /etc/postgresql/10/main/pg_hba.conf
sudo service postgresql restart && sleep 3
sudo -u postgres createuser casbin_rs
sudo -u postgres createdb casbin
sudo -u postgres psql -c "alter user casbin_rs with encrypted password 'casbin_rs'; grant all privileges on database casbin to casbin_rs;"
sudo -u postgres psql -c "GRANT USAGE, CREATE ON SCHEMA public TO casbin_rs;"
sudo -u postgres psql -c "GRANT ALL ON DATABASE casbin TO casbin_rs;"
sudo -u postgres psql -c "ALTER DATABASE casbin OWNER TO casbin_rs;"
sudo service postgresql restart && sleep 3
sudo systemctl start mysql.service
mysql -e "create user 'casbin_rs'@'localhost' identified by 'casbin_rs'; create database casbin; grant all on \`casbin\`.* to 'casbin_rs'@'localhost';" -uroot -proot
- name: Setup PostgreSQL & MySQL & SQLite (for macOS)
if: matrix.os == 'macOS-latest'
run: |
brew update
brew install postgresql mariadb
brew services start postgresql
# pg_ctl -D /usr/local/var/postgres start
sleep 3
createuser casbin_rs
createdb casbin
psql postgres -c "alter user casbin_rs with encrypted password 'casbin_rs'; grant all privileges on database casbin to casbin_rs;"
psql postgres -c "GRANT USAGE, CREATE ON SCHEMA public TO casbin_rs;"
psql postgres -c "GRANT ALL ON DATABASE casbin TO casbin_rs;"
psql postgres -c "ALTER DATABASE casbin OWNER TO casbin_rs;"
#echo "/usr/local/opt/mariadb@10.5/bin" >> $GITHUB_PATH
#/usr/local/opt/mariadb@10.5/bin/mysql_install_db
#/usr/local/opt/mariadb@10.5/bin/mysql.server start
brew services start mariadb
sleep 3
mysql -e "create user 'casbin_rs'@'localhost' identified by 'casbin_rs'; create database casbin; grant all on \`casbin\`.* to 'casbin_rs'@'localhost';" -urunner
#echo "MYSQLCLIENT_LIB_DIR=/usr/local/opt/mariadb@10.5/lib" >> $GITHUB_ENV
- name: Setup PostgreSQL & MySQL & SQLite (for windows)
if: matrix.os == 'windows-latest'
shell: cmd
run: |
choco install postgresql11 --force --params '/Password:root'
choco install mysql sqlite
"C:\Program Files\PostgreSQL\11\bin\createuser" casbin_rs
"C:\Program Files\PostgreSQL\11\bin\createdb" casbin
"C:\Program Files\PostgreSQL\11\bin\psql" -c "alter user casbin_rs with encrypted password 'casbin_rs'; grant all privileges on database casbin to casbin_rs;"
"C:\tools\mysql\current\bin\mysql" -e "create user 'casbin_rs'@'localhost' identified by 'casbin_rs'; create database casbin; grant all on `casbin`.* to 'casbin_rs'@'localhost';" -uroot
cd /D C:\ProgramData\chocolatey\lib\SQLite\tools
call "C:\Program Files\Microsoft Visual Studio\2022\Enterprise\VC\Auxiliary\Build\vcvars64.bat"
lib /machine:x64 /def:sqlite3.def /out:sqlite3.lib
- name: Set environment variables (for windows)
if: matrix.os == 'windows-latest'
shell: bash
run: |
echo "C:\Program Files\PostgreSQL\11\bin" >> $GITHUB_PATH
echo "PQ_LIB_DIR=C:\Program Files\PostgreSQL\11\lib" >> $GITHUB_ENV
echo "MYSQLCLIENT_LIB_DIR=C:\tools\mysql\current\lib" >> $GITHUB_ENV
echo "SQLITE3_LIB_DIR=C:\ProgramData\chocolatey\lib\SQLite\tools" >> $GITHUB_ENV
- name: Create SQLite DB
run: |
touch casbin.db
- name: Create PostgresSQL Table
run: psql -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)
);" postgres://casbin_rs:casbin_rs@127.0.0.1:5432/casbin
- name: Create MySQL Table
run: |
mysql -ucasbin_rs -pcasbin_rs -e "USE 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;"
- name: Create SQLite Table
run: |
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_sqlx_adapter UNIQUE(ptype, v0, v1, v2, v3, v4, v5)
);"
- name: Cargo Test For PostgreSQL
env:
DATABASE_URL: postgres://casbin_rs:casbin_rs@localhost:5432/casbin
run: |
cargo test --no-default-features --features postgres,runtime-async-std-native-tls
cargo test --no-default-features --features postgres,runtime-async-std-rustls
cargo test --no-default-features --features postgres,runtime-tokio-native-tls
cargo test --no-default-features --features postgres,runtime-tokio-rustls
- name: Cargo Test For MySQL
env:
DATABASE_URL: mysql://casbin_rs:casbin_rs@localhost:3306/casbin
run: |
cargo test --no-default-features --features mysql,runtime-async-std-native-tls
cargo test --no-default-features --features mysql,runtime-async-std-rustls
cargo test --no-default-features --features mysql,runtime-tokio-native-tls
cargo test --no-default-features --features mysql,runtime-tokio-rustls
- name: Cargo Test For SQLite
env:
DATABASE_URL: sqlite:casbin.db
run: |
cargo test --no-default-features --features sqlite,runtime-async-std-native-tls
cargo test --no-default-features --features sqlite,runtime-async-std-rustls
cargo test --no-default-features --features sqlite,runtime-tokio-native-tls
cargo test --no-default-features --features sqlite,runtime-tokio-rustls