casbin-databases-adapter


Namecasbin-databases-adapter JSON
Version 1.5.0 PyPI version JSON
download
home_pagehttps://github.com/officialpycasbin/casbin-databases-adapter
SummaryThis is an Adapter for PyCasbin that implemented using Databases connection to achieve async process
upload_time2025-08-20 17:48:19
maintainerNone
docs_urlNone
authorIsa Setiawan Abdurrazaq
requires_python>=3.3
licenseApache 2.0
keywords casbin asynccasbin async databases casbin-adapter rbac access control abac acl permission
VCS
bugtrack_url
requirements asynccasbin databases SQLAlchemy
Travis-CI No Travis.
coveralls test coverage No coveralls. 
            # Databases Casbin Adapter

[![build](https://github.com/officialpycasbin/casbin-databases-adapter/actions/workflows/build.yml/badge.svg)](https://github.com/officialpycasbin/casbin-databases-adapter/actions/workflows/build.yml)
[![Coverage Status](https://coveralls.io/repos/github/officialpycasbin/casbin-databases-adapter/badge.svg?branch=master)](https://coveralls.io/github/officialpycasbin/casbin-databases-adapter?branch=master)
[![Version](https://img.shields.io/pypi/v/casbin_databases_adapter.svg)](https://pypi.org/project/casbin_databases_adapter/)
[![PyPI - Wheel](https://img.shields.io/pypi/wheel/casbin_databases_adapter.svg)](https://pypi.org/project/casbin_databases_adapter/)
[![Pyversions](https://img.shields.io/pypi/pyversions/casbin_databases_adapter.svg)](https://pypi.org/project/casbin_databases_adapter/)
[![Download](https://static.pepy.tech/badge/casbin_databases_adapter)](https://pypi.org/project/casbin_databases_adapter/)
[![License](https://img.shields.io/pypi/l/casbin_databases_adapter.svg)](https://pypi.org/project/casbin_databases_adapter/)

This is an Adapter for [PyCasbin](https://github.com/casbin/pycasbin) that implemented using [Databases](https://www.encode.io/databases) connection to achieve async process

## Installation

```
pip install casbin_databases_adapter
```

## Simple Example

```python
import casbin_databases_adapter
import casbin
from databases import Database
import sqlalchemy
from sqlalchemy import Table, Column, String, Integer
from sqlalchemy.sql.ddl import CreateTable
import asyncio

DATABASE_URL = "sqlite+aiosqlite:///example.db"

async def create_casbin_rule_table(db: Database):
    metadata = sqlalchemy.MetaData()
    table = Table(
        "casbin_rules",
        metadata,
        Column("id", Integer, primary_key=True),
        Column("ptype", String(255)),
        Column("v0", String(255)),
        Column("v1", String(255)),
        Column("v2", String(255)),
        Column("v3", String(255)),
        Column("v4", String(255)),
        Column("v5", String(255)),
    )
    q = CreateTable(table)
    await db.execute(query=str(q))
    return table

async def main():
    database = Database(DATABASE_URL)
    await database.connect()
    casbin_rule_table = await create_casbin_rule_table(database)
    adapter = casbin_databases_adapter.DatabasesAdapter(db=database, table=casbin_rule_table)
    
    e = casbin.Enforcer('path/to/model.conf', adapter)
    
    sub = "alice"  # the user that wants to access a resource.
    obj = "data1"  # the resource that is going to be accessed.
    act = "read"  # the operation that the user performs on the resource.
    
    if e.enforce(sub, obj, act):
        # permit alice to read data1
        pass
    else:
        # deny the request, show an error
        pass

# run the main function
asyncio.run(main())
```

### Getting Help

- [PyCasbin](https://github.com/casbin/pycasbin)

### License

This project is licensed under the [Apache 2.0 license](LICENSE).

Raw data

            {
    "_id": null,
    "home_page": "https://github.com/officialpycasbin/casbin-databases-adapter",
    "name": "casbin-databases-adapter",
    "maintainer": null,
    "docs_url": null,
    "requires_python": ">=3.3",
    "maintainer_email": null,
    "keywords": "casbin, asynccasbin, async, databases, casbin-adapter, rbac, access control, abac, acl, permission",
    "author": "Isa Setiawan Abdurrazaq",
    "author_email": "isasetiawan@protonmail.com",
    "download_url": "https://files.pythonhosted.org/packages/c9/51/a893e1c8df6810a736965c2b5985e3267c6f84f41c58f00a0ec5ac18a849/casbin_databases_adapter-1.5.0.tar.gz",
    "platform": null,
    "description": "# Databases Casbin Adapter\n\n[![build](https://github.com/officialpycasbin/casbin-databases-adapter/actions/workflows/build.yml/badge.svg)](https://github.com/officialpycasbin/casbin-databases-adapter/actions/workflows/build.yml)\n[![Coverage Status](https://coveralls.io/repos/github/officialpycasbin/casbin-databases-adapter/badge.svg?branch=master)](https://coveralls.io/github/officialpycasbin/casbin-databases-adapter?branch=master)\n[![Version](https://img.shields.io/pypi/v/casbin_databases_adapter.svg)](https://pypi.org/project/casbin_databases_adapter/)\n[![PyPI - Wheel](https://img.shields.io/pypi/wheel/casbin_databases_adapter.svg)](https://pypi.org/project/casbin_databases_adapter/)\n[![Pyversions](https://img.shields.io/pypi/pyversions/casbin_databases_adapter.svg)](https://pypi.org/project/casbin_databases_adapter/)\n[![Download](https://static.pepy.tech/badge/casbin_databases_adapter)](https://pypi.org/project/casbin_databases_adapter/)\n[![License](https://img.shields.io/pypi/l/casbin_databases_adapter.svg)](https://pypi.org/project/casbin_databases_adapter/)\n\nThis is an Adapter for [PyCasbin](https://github.com/casbin/pycasbin) that implemented using [Databases](https://www.encode.io/databases) connection to achieve async process\n\n## Installation\n\n```\npip install casbin_databases_adapter\n```\n\n## Simple Example\n\n```python\nimport casbin_databases_adapter\nimport casbin\nfrom databases import Database\nimport sqlalchemy\nfrom sqlalchemy import Table, Column, String, Integer\nfrom sqlalchemy.sql.ddl import CreateTable\nimport asyncio\n\nDATABASE_URL = \"sqlite+aiosqlite:///example.db\"\n\nasync def create_casbin_rule_table(db: Database):\n    metadata = sqlalchemy.MetaData()\n    table = Table(\n        \"casbin_rules\",\n        metadata,\n        Column(\"id\", Integer, primary_key=True),\n        Column(\"ptype\", String(255)),\n        Column(\"v0\", String(255)),\n        Column(\"v1\", String(255)),\n        Column(\"v2\", String(255)),\n        Column(\"v3\", String(255)),\n        Column(\"v4\", String(255)),\n        Column(\"v5\", String(255)),\n    )\n    q = CreateTable(table)\n    await db.execute(query=str(q))\n    return table\n\nasync def main():\n    database = Database(DATABASE_URL)\n    await database.connect()\n    casbin_rule_table = await create_casbin_rule_table(database)\n    adapter = casbin_databases_adapter.DatabasesAdapter(db=database, table=casbin_rule_table)\n    \n    e = casbin.Enforcer('path/to/model.conf', adapter)\n    \n    sub = \"alice\"  # the user that wants to access a resource.\n    obj = \"data1\"  # the resource that is going to be accessed.\n    act = \"read\"  # the operation that the user performs on the resource.\n    \n    if e.enforce(sub, obj, act):\n        # permit alice to read data1\n        pass\n    else:\n        # deny the request, show an error\n        pass\n\n# run the main function\nasyncio.run(main())\n```\n\n### Getting Help\n\n- [PyCasbin](https://github.com/casbin/pycasbin)\n\n### License\n\nThis project is licensed under the [Apache 2.0 license](LICENSE).\n",
    "bugtrack_url": null,
    "license": "Apache 2.0",
    "summary": "This is an Adapter for PyCasbin that implemented using Databases connection to achieve async process",
    "version": "1.5.0",
    "project_urls": {
        "Homepage": "https://github.com/officialpycasbin/casbin-databases-adapter"
    },
    "split_keywords": [
        "casbin",
        " asynccasbin",
        " async",
        " databases",
        " casbin-adapter",
        " rbac",
        " access control",
        " abac",
        " acl",
        " permission"
    ],
    "urls": [
        {
            "comment_text": null,
            "digests": {
                "blake2b_256": "30f8cb56b4ffa3ac091d1274af8da518b9a80d42cf2aa3319178ae8d259ba433",
                "md5": "58da560cb86001cccc7172f353818a5f",
                "sha256": "70d95ec3f14c3c910286658d5c7ad8171e13808283619e3bc760810b8871ff95"
            },
            "downloads": -1,
            "filename": "casbin_databases_adapter-1.5.0-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "58da560cb86001cccc7172f353818a5f",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": ">=3.3",
            "size": 8100,
            "upload_time": "2025-08-20T17:48:18",
            "upload_time_iso_8601": "2025-08-20T17:48:18.524624Z",
            "url": "https://files.pythonhosted.org/packages/30/f8/cb56b4ffa3ac091d1274af8da518b9a80d42cf2aa3319178ae8d259ba433/casbin_databases_adapter-1.5.0-py3-none-any.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": null,
            "digests": {
                "blake2b_256": "c951a893e1c8df6810a736965c2b5985e3267c6f84f41c58f00a0ec5ac18a849",
                "md5": "3a0a5ff8348fe41d113a9e46ae58f3b5",
                "sha256": "39821779e4357baeb0c8c19fb516c0e43342dacefd70f5d898c22f4efa89bb58"
            },
            "downloads": -1,
            "filename": "casbin_databases_adapter-1.5.0.tar.gz",
            "has_sig": false,
            "md5_digest": "3a0a5ff8348fe41d113a9e46ae58f3b5",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": ">=3.3",
            "size": 8346,
            "upload_time": "2025-08-20T17:48:19",
            "upload_time_iso_8601": "2025-08-20T17:48:19.238721Z",
            "url": "https://files.pythonhosted.org/packages/c9/51/a893e1c8df6810a736965c2b5985e3267c6f84f41c58f00a0ec5ac18a849/casbin_databases_adapter-1.5.0.tar.gz",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "upload_time": "2025-08-20 17:48:19",
    "github": true,
    "gitlab": false,
    "bitbucket": false,
    "codeberg": false,
    "github_user": "officialpycasbin",
    "github_project": "casbin-databases-adapter",
    "travis_ci": false,
    "coveralls": false,
    "github_actions": true,
    "requirements": [
        {
            "name": "asynccasbin",
            "specs": [
                [
                    "==",
                    "1.1.7"
                ]
            ]
        },
        {
            "name": "databases",
            "specs": [
                [
                    "==",
                    "0.7.0"
                ]
            ]
        },
        {
            "name": "SQLAlchemy",
            "specs": [
                [
                    "==",
                    "1.4.42"
                ]
            ]
        }
    ],
    "lcname": "casbin-databases-adapter"
}
Isa Setiawan Abdurrazaq
Elapsed time: 0.77590s