sqlite-to-json

Dump data from sqlite3 databases to JSON files easily.

API

constructor(opts)

Create an instance of SqliteToJson.

Example:

const SqliteToJson = require('sqlite-to-json');
const sqlite3 = require('sqlite3');
const exporter = new SqliteToJson({
  client: sqlite3.Database({
    filename: 'mydb.sqlite3'
  })
});

opts.client

A sqlite3 client instance.

Type: sqlite3.Database
Default: null

tables(cb)

List all tables in the current database.

Example:

const SqliteToJson = require('sqlite-to-json');
const sqlite3 = require('sqlite3');
const exporter = new SqliteToJson({
  client: sqlite3.Database({
    filename: 'mydb.sqlite3'
  })
});
exporter.tables(function (err, tables) {
  // all your table names here
});

save(table, dest, cb)

Save the contents of a table to the specified output directory.

Example:

const SqliteToJson = require('sqlite-to-json');
const sqlite3 = require('sqlite3');
const exporter = new SqliteToJson({
  client: sqlite3.Database({
    filename: 'mydb.sqlite3'
  })
});
exporter.save('table_name', './data/table_name.json', function (err) {
  // no error and you're good.
});