Dump data from sqlite databases to JSON files easily.
Create an instance of SqliteToJson.
Example:
const SqliteToJson = require('sqlite-to-json');
const sqlite3 = require('sqlite3');
const exporter = new SqliteToJson({
client: new sqlite3.Database('./mydb.sqlite3')
});A sqlite3 client instance.
Type: sqlite3.Database
Default: null
List all tables in the current database.
Example:
const SqliteToJson = require('sqlite-to-json');
const sqlite3 = require('sqlite3');
const exporter = new SqliteToJson({
client: new sqlite3.Database('./mydb.sqlite3')
});
exporter.tables(function (err, tables) {
// all your table names here
});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: new sqlite3.Database('./mydb.sqlite3')
});
exporter.save('table_name', './data/table_name.json', function (err) {
// no error and you're good.
});Returns the entire database and all tables as a single object.
Example:
const SqliteToJson = require('sqlite-to-json');
const sqlite3 = require('sqlite3');
const exporter = new SqliteToJson({
client: new sqlite3.Database('./mydb.sqlite3')
});
exporter.all(function (err, all) {
// all your data here
});
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent