node-sql-fixtures - GitLite

KO | EN

gitlite — search

#python #hacktoberfest #react #ai #typescript #deep-learning #linux #java #awesome #kubernetes #vue #ios #openai #open-source

node-sql-fixtures

(★ 79)

SQL fixtures for Node.js in PostgreSQL, MySQL, MariaDB and SQLite

File Explorer

Download Latest Version (.zip)

- workspace.xml
- execute-fk-queries.js
- fixture-generator.js
- generate-spec-ids.js
- insert-records.js
- is-postgres.js
- is-sqlite.js
- prioritize.js
- resolve-dependencies.js
- unescape.js
- util.js
- - docs.css
- index.html
- - chai-helper.js
- - integration-specs.js
  - maria-integration-spec.js
  - mysql-integration-spec.js
  - postgres-integration-spec.js
  - sqlite-integration-spec.js
- - fixture-generator-spec.js
  - generate-spec-ids-spec.js
  - is-postgres-spec.js
  - prioritize-spec.js
  - resolve-dependencies-spec.js
  - unescape-spec.js
.gitignore
CHANGELOG
deploySite.sh
docker-compose.yml
Dockerfile
gulpfile.js
index.js
integration_tests.md
LICENSE
package.json
README.md
yarn.lock

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# No longer supported

This module is now archived and no longer being updated

# sql-fixtures

Easily generate data that gets saved in the database, with foreign key dependencies automatically resolved. Ideal for integration tests and generating dummy data. Uses [knex](http://knexjs.org) internally.

# Supported Databases

| Database  | Works?   | As of version | Integration Tests? | Usage                                      |
|-----------|----------|---------------|--------------------|--------------------------------------------|
| Postgres  | Yes      | 0.0.0         | [Yes](https://github.com/city41/node-sql-fixtures/blob/master/test/integration/postgres-integration-spec.js) | several projects known   |
| MySQL     | Yes* | 0.4.0         | [Yes](https://github.com/city41/node-sql-fixtures/blob/master/test/integration/mysql-integration-spec.js) | several projects known |
| sqlite3   | Yes* | 0.3.0         | [Yes](https://github.com/city41/node-sql-fixtures/blob/master/test/integration/sqlite-integration-spec.js) | one known project |
| MariaDB   | Yes**  | 0.7.0   | [Yes](https://github.com/city41/node-sql-fixtures/blob/master/test/integration/maria-integration-spec.js) | no known projects :( |

*For MySQL and Maria you can run into issues for [tables that lack a singular primary key](http://city41.github.io/node-sql-fixtures/#no-primary-key-warning).

**For sqlite, you can hit the same issue as MySQL and Maria above if you create your tables using "without rowid"

# Install

`npm install sql-fixtures`

# Simple Example

```javascript
var sqlFixtures = require('sql-fixtures');

// depending on which database engine you are using
// this is a typical PostgreSQL config for the pg driver
var dbConfig = {
  client: 'pg',
  connection: {
    host: 'localhost',
    user: 'testdb',
    password: 'password',
    database: 'testdb',
    port: 15432
  }
};

var dataSpec = {
  users: {
    username: 'Bob',
    email: 'bob@example.com'
  }
};

sqlFixtures.create(dbConfig, dataSpec, function(err, result) {
  // at this point a row has been added to the users table
  console.log(result.users[0].username);
});
```

# Documentation and Examples

Are available at the [sql-fixtures website](http://city41.github.io/node-sql-fixtures)

# Contributing
**NOTE:** I am hesitant to add more features at this point. I feel sql-fixtures is feature complete now and I want to keep it a small, focused module. If you have an idea for a feature you want to implement, please contact me first.

Please fork and send pull requests in the typical fashion.

There are both unit and integration tests. The unit tests are invoked with `gulp test:unit`.

Checkout integration_tests.md for the scoop on the integration tests.