knex-tenanty
v0.0.1-beta.1
Published
Multi tenant knex middleware. Allows for multiple clients using the same application saving data in different schemas.
Downloads
2
Readme
knex-tenanty
Knex middleware to handle multiple tenants.
You can run your application for several clients and the database will be created in different schemas.
Example usage
KnexTenanty(
/* knex config object */,
/* function to extract client-id from request object */
);
Sample project
https://github.com/brunolm/knex-mt
Setting up the middleware
import * as express from 'express';
import { KnexTenanty } from 'knex-tenanty';
import knexSettings from '../knexfile';
const app = express.Router();
const settings = knexSettings[process.env.NODE_ENV];
const extractClientId = (req) => req.headers['x-client-id'];
const middleware = KnexTenanty(settings, extractClientId);
app.use(middleware);
export default app;
Using knex to access the database
app.get('/', async (req, res) => {
console.log('route /');
const knex = req['knex'] as Knex.QueryBuilder;
const values = await knex.from('test');
res.send(values);
});
app.get('/insert', async (req, res) => {
console.log('route /insert');
const knex = req['knex'] as Knex.QueryBuilder;
const values = await knex.insert({ name: req.query.name || 'bruno' }).into('test');
res.send(values);
});