Skip to content

Function: drizzleMysqlAdapter() ​

ts
function drizzleMysqlAdapter(
   db, 
   schema?, 
   options?
): RbacAdapter;

Defined in: packages/drizzle/src/mysql.ts:22

Creates an RbacAdapter backed by a Drizzle MySQL database (mysql2, PlanetScale, TiDB Serverless, ...).

Parameters ​

ParameterTypeDescription
dbMySqlDatabase<any, any, any, any>any Drizzle MySQL database instance
schema?| { modelHasPermissions: MySqlTableWithColumns<{ }>; modelHasRoles: MySqlTableWithColumns<{ }>; permissions: MySqlTableWithColumns<{ }>; roleHasPermissions: MySqlTableWithColumns<{ }>; roles: MySqlTableWithColumns<{ }>; } | { modelHasPermissions: MySqlTableWithColumns<{ }>; modelHasRoles: MySqlTableWithColumns<{ }>; permissions: MySqlTableWithColumns<{ }>; roleHasPermissions: MySqlTableWithColumns<{ }>; roles: MySqlTableWithColumns<{ }>; }the tables from mysqlRbacSchema() (defaults to the unprefixed tables)
options?DrizzleAdapterOptions{ expiry: true } to store an expiry per link (needs mysqlRbacSchema({ expiry: true }))

Returns ​

RbacAdapter

Released under the MIT License. Inspired by spatie/laravel-permission.