Sqlite3-to-mongodb

An utility Node js module which will migrate sqlite3 db to mongo db. For each sqlite table, a collection with the same name as the table name will be created.

Installation

You can use npm to download and install:

> npm install sqlite3-to-mongodb

API Documentation:

This module built using Builder design pattern. For more information about the Builder design pattern, click here

``
1) .setSqlitePath()
`
This method setSqlitePath() will set the sqlite3 db file path which we are gonna migrate to mongo db.

`
2) .setMongoUrl()
`
This method will set mongo db url for migration.
eg: mongodb://localhost:27017/mydb

`
3) .setLogPath()
`
This method will set the log path.
If the given path is not valid, the default log path ./migration-log.log will be taken.
If you don't use this function, the logs will get consoled.

`
4) .migrate()

``
This method will start migration and return a promise.

Example

Using Builder design pattern,

let dbMigration = new DBMigration();
let mongodb = "mongodb://localhost:27017/mydb"
let sqlitePath = "./src/sqlitedb.db";
await dbMigration
.setSqlitePath(sqlitePath)
.setMongoUrl(mongodb)
.setLogPath("migration_log.log")
.migrate()

Without using Builder design pattern,

let mongodb = "mongodb://localhost:27017/mydb"
let sqlitePath = "./src/sqlitedb.db";
let dbMigration = new DBMigration(sqlitePath, mongodb, "migration_log.log");
await dbMigration.migrate()