simple-knex-fixtures


simple-knex-fixtures
====================

A simple library to help you load data to a database to facilitate testing.

Caveats:

- does not protect against duplicate records

$3

``bash
npm install --save simple-knex-fixtures
`

$3

`bash
npm test
`

$3

`javascript
const connection = require("knex")({
client: "mysql",
connection: {
host : "127.0.0.1",
user : "your_database_user",
password : "your_database_password",
database : "myapp_test"
}
});

const fixtures = require("simple-knex-fixtures");

await fixtures.loadFile("fixtures/file.json", connection)

await fixtures.loadFiles("fixtures/*.json", connection)

await fixtures.loadFiles([
"fixtures/file1.json",
"fixtures/file2.json",
], connection);
`

$3

#### javascript

`javascript
module.exports = [
{
"table": "users",
"data": {
"id": 1,
"first": "john",
"last": "doe"
}
}
];
`

#### json

`json
[
{
"table": "users",
"data": {
"id": 1,
"first": "john",
"last": "doe"
}
}
]
`

#### yaml

`yaml
fixtures:
-
table: users
data:
id: 1
first: john
last: doe
``