SurrealDB Data Provider and Auth Provider for React Admin

This package provides a data provider and auth provider for react admin to integrate with SurrealDB.
It uses surrealdb.js as driver to the database.

Usage

$3

``shell
yarn add ra-surrealdb
`

$3

In your code:

`typescript
import { Admin, Resource } from 'react-admin';
import { surrealDbDataProvider, useRaSurrealDb } from 'ra-surrealdb';

const App = () => (
dataProvider={surrealDbDataProvider(
useRaSurrealDb({
url: 'http://127.0.0.1:8000/rpc',
signinOptions: {
NS: 'test',
DB: 'test',
SC: 'account_scope',
user: 'user',
pass: 'password',
},
})
)}
>


);
export default App;
`

The hook useRaSurrealDb creates the connexion to SurrealDB. It takes these parameters:

- the url of the database;
- signinOptions is the Auth object used by SurrealDB to connect.
- localStorage, if set to a string then the library stores the auth informations (jwt token) in local storage. If not set the auth informations are stored in memory and are reseted on page reload. The string represents the key used in the local storage.

The result of the hook is passed to the provider function surrealDbDataProvider.

$3

`typescript
import { Admin, Resource } from 'react-admin';
import { surrealDbAuthProvider, surrealDbDataProvider, useRaSurrealDb } from 'ra-surrealdb';

const App = () => {
const surreal = useRaSurrealDb({
url: 'http://127.0.0.1:8000/rpc',
signinOptions: {
NS: 'test',
DB: 'test',
SC: 'account_scope',
},
});
const authProvider = surrealDbAuthProvider(surreal);
const dataProvider = surrealDbDataProvider(surreal);
return (



);
};
export default App;
`

useRaSurrealDb creates a connexion to SurrealDB.
The same result is sent to both the auth provider and the data provider.

$3

All queries can be customized when you call useRasurrealDb.
The queries option have the following structure:

`typescript
{resource_name: {
getList:(/.../)=>{},
getOne:(/.../)=>{},
getMany:(/.../)=>{},
update:(/.../)=>{},
create:(/.../)=>{},
delete:(/.../)=>{},
}}
`

#### Example

In this example, we manage relations in custom queries.

`typescript
const surreal = useRaSurrealDb({
/ ... /
queries: {
person: {
getOne: async (resource: string, { id }: GetOneParams, db: Surreal) => {
const results = await db.query[]>(
select , ->parent->person. as parents from ${id};
);
const result = results[0].result?.[0];
if (result) return result;
else throw new Error('Person not found');
},
create: async (resource: string, { data }: CreateParams, db: Surreal) => {
const { parents, ...person } = data;
const relations = (
parents
? parents.map(
({ person, role }) =>
RELATE $p->parent->${person} SET time.written = time::now(), role = "${role}";
)
: []
).join('\n');
const q = BEGIN;
LET $p = (CREATE ${resource} CONTENT $person);
SELECT * FROM $p;
${relations}
COMMIT;
;
const results = await db.query[]>(q, { person });
const result = results?.[1].result?.[0];
if (result === undefined) throw new Error('');
return result;
},
/ ... /
},
},
});
`

$3

useRaSurrealDb accepts an option named getIdentity.
The function signature is: (id: Identifier, db: Surreal) => Promise;

An example is present in src/App.tsx.

$3

useRaSurrealDb accepts an option named getPermissions.
The function signature is: (id: Identifier, db: Surreal, params: any) => Promise.

Development

The library code is in ./src/lib.

The repository also provides an example in ./src/App.tsx.

To run the example, you need to setup a SurrealDB instance. It can be launch with the following commands:

`shell
docker compose up -d
curl -k -L -s --compressed POST --header "Accept: application/json" --header "NS: test" --header "DB: test" --user "root:root" --data-binary "@surreal_example.sql" http://localhost:8000/sql
`

Then launch the app:

`
yarn dev
``

The login is _user_:_password_ ...