db-initializer-sqlite3 v1.0.3

node-db-initializer-sqlite3

Initialize DB schema and tables very quickly. and Available with the webpack plugin.

Install

$ npm install db-initializer-sqlite3

Usage

Writing the configuration.json

Example

{
    "workspace": [workspace directory(option)]
    "data": [
        {
            "action": "Execute-SQL",
            "sql": "CREATE TABLE hello (a int, b char);"
        },
        {
            "action": "Execute-SQL",
            "file": "CREATE_TABLE.sql"
        },
        {
            "action": "Import-CSV",
            "sql": "INSERT INTO HOGE VALUES ($ProcessIdentifier,$LEVEL,$PARENT,$Process,$Category,$OriginalProcessIdentifier,$ExtendedDescription,'',$BriefDescription,$Domain,$VerticalGroup,$MaturityLevel,$Status)",
            "file": "HOGE.csv"
        },
        {
            "action": "Export-CSV",
            "sql": "SELECT * FROM HOGE;",
            "file": "test.csv"
        }
    ]
}

Detailed explanation about Import-CSV

sql parameter is compatible with SQLite BindParams.

Example

configuration.json

"sql": "INSERT INTO HOGE VALUES ($ProcessIdentifier,$LEVEL)"

Import csv

Process,Process Identifier,LEVEL
A,B,C

result

INSERT INTO HOGE VALUES ('B','C')

Rule to convert header name to BindParams

  replace(/[\n\r\s\&]/g, '') // [a&b] → [ab]  , [A and B] → [AandB]
  replace(/\(.+\)/g, '')     // [a(b)] → [ab]

Building the database in node.js

The Initdb module provides utilities for Initialize DB schema and tables.

Install with npm package manager:
npm install db-initializer-sqlite3

Load this library as follows:

const Initdb = require('db-initializer-sqlite3')
const initdb = new Initdb()

Use code like this to build your database:

const fs = require('fs')
const Initdb  = require('db-initializer-sqlite3')

async function main() {

    const initdb = new Initdb()
    const configdata = require('PATH_TO_CONFIGURATION.json')
    configdata.workspace = process.cwd()
    const content = await initdb.init(configdata)
    
    async function save(content) {
        fs.writeFileSync('DATABASE_PATH.db', content)
    }
    await save(content)
}
main()

dbinit.init(settings[, dbfile_path])

• settings {jsonObject} configuration.json data
• dbfile_path {string} load DB data
• Returns: {Promise} Export the database to an Uint8Array containing the SQLite database file

Building the database in webpack.config.js

Install with npm package manager:
npm install db-initializer-sqlite3

Use code like this to build your database:

const webpack = require('webpack')
const Initdb  = require('db-initializer-sqlite3')
const initdb = new Initdb()
const CopyFilePlugin = require('copy-webpack-plugin')

module.exports = {
  plugins: [
    new CopyFilePlugin(
        [
            {
                from: 'assets/datas/*.json',
                to: dist+"/assets/[name].db",
                transform(content, absoluteFrom) {
                  return initdb.init(require(absoluteFrom)).then(function (savedata) {
                          return savedata;
                        }
                    );
                }
            }
        ],
        { copyUnmodified: true }
    ),
    new WriteFilePlugin()
  ]
}

Building the database in windows-x86 exe

db-initializer-sqlite3.exe -c tests\test.json -o test.db   

options

• -c, --config <type> config file path
• -i, --input <type> input db file path(option)
• -o, --output <type> output db file path
• -d, --debug output extra debugging

Development

1. init

$ npm install

2. build

npm run build

3. test

cd tests && node test.js && cd ..

4. bundle test

node dist\index.bundle.js -c tests\test.json -o test.db

5. exe build

npm run nexebuild

6. exe test

dist\bin\db-initializer-sqlite3.exe -c tests\test.json -o test.db

Contribution

1. Fork (https://github.com/nojaja/node-db-initializer-sqlite3)
2. Create a feature branch
3. Commit your changes
4. Rebase your local changes against the master branch
5. Run test suite with the node test.js command and confirm that it passes
6. Create new Pull Request

Dependencies

• csv-parse
• csv-stringify
• sql.js

License

Licensed under the MIT License.