Quick Setup of SQLite

Quick-Setup-SQLite

// First you need to install the dependencies - insert this to your package.json and run npm install
"sequelize": "^3.5.1",
"sqlite3": "^3.1.4"

// Require Sequelize 
// (new Sequelize dependencies can be (undefined, undefined, undefined) for quick setup
// set dialect to a 'sqlite' db
// set storage to the file you want the db to be with a .sqlite at the end

var Sequelize = require('Sequelize');
var sequelize = new Sequelize(database, username, password, {
	'dialect': 'sqlite',
	'storage': __dirname + '/[[add-file-name]].sqlite'
});

// Create model that will be stored in database
var Item = sequelize.define('item', {
	string: {
		type: Sequelize.STRING
	},
	boolean: {
		type: Sequelize.BOOLEAN
	}
})

// Check that sequelize has synced
sequelize.sync().then(function () {
	console.log('Everything is synced');

// Push a new item to the db and check that it logs the item to the console
	item.create({
		 "string": "",
	    "boolean": true
	}).then(function (item) {
		console.log('Finished');
		console.log(item);
	});
});