A Knex.js service adapter for FeathersJS
npm install feathers-knex --savePlease refer to the Feathers database adapter documentation for more details or directly at:
- KnexJS - The detailed documentation for this adapter
- Extending - How to extend a database adapter
- Pagination - How to use pagination
- Querying and Sorting - The common adapter querying mechanism and sorting for the database adapter
Here's a complete example of a Feathers server with a todos SQLite service. We are using the Knex schema builder
import feathers from 'feathers';
import rest from 'feathers-rest';
import bodyParser from 'body-parser';
import knexService from 'feathers-knex';
// Initialize knex database adapter
const knex = require('knex')({
client: 'sqlite3',
connection: {
filename: './db.sqlite'
}
});
// Create Knex Feathers service with a default page size of 2 items
// and a maximum size of 4
var todos = knexService({
Model: knex,
name: 'todos',
paginate: {
default: 2,
max: 4
}
});
// Create a feathers instance.
const app = feathers()
// Enable REST services
.configure(rest())
// Turn on JSON parser for REST services
.use(bodyParser.json())
// Turn on URL-encoded parser for REST services
.use(bodyParser.urlencoded({ extended: true }));
// Initialize the database table with a schema
// then mount the service and start the app
todos
.init({}, function(table) {
//define your schema
console.log(`created ${table._tableName} table`);
table.increments('id');
table.string('text');
table.boolean('complete');
}).then(() => {
app.use('/todos', todos);
app.use(function(error, req, res, next){
res.json(error);
});
// Start the server.
const port = 8080;
app.listen(port, function() {
console.log(`Feathers server listening on port ${port}`);
});
});You can run this example by using node server and going to localhost:8080/todos. You should see an empty array. That's because you don't have any Todos yet but you now have full CRUD for your new todos service!
Copyright (c) 2016
Licensed under the MIT license.