Sql-nodejs NPM

Overview

The purpose of this project is to create an SQL database which is stored in memory.

Supported Statements:

Create
Insert (Currently limited to only one record at a time)
Select
Drop

How to use

In your Project require the module:

const sqlMock = require('sql-mock');

Then write the following to create your database:

let db = new sqlMock();

Logging is diabled by default, to enable logging pass true in as an argument to the constructor (i.e sqlMock(true))

Then use the parse function and pass in an SQL statement. For example:

p.Parse("CREATE DATABASE databasename;");
db.Parse("CREATE table tablename (test INT, test1 INT, test2 INT);");
db.Parse("INSERT INTO tablename (test, test1, test2) VALUES (" + 0 + ", " + 2 + ", " + 0 + ");")
db.Parse("INSERT INTO tablename (test, test1, test2) VALUES (" + 0 + ", " + 2 + ", " + 0 + ");")
db.Parse("INSERT INTO tablename (test, test1, test2) VALUES (" + 1 + ", " + 0 + ", " + 0 + ");")
db.Parse("Select test, test1, test2 from tablename WHERE test = " + 0 + ";");
db.Parse("Select test, test1 from tablename;");
db.Parse("Select * from tablename WHERE test = " + 1 + ";");
db.Parse("Select * from tablename;");