/*
 * Database used: Mysql
 * Author: Saumya Suhagiya
 * Version: 1.0
 */
var DATABASE_NAME = 'image_db';
var DB_USERNAME = 'abc';
var DB_PASSWORD = 'abc@123';

var Sequelize = require('sequelize');
var FS = require('fs');

var sequelize = new Sequelize(
	DATABASE_NAME,
	DB_USERNAME,
	DB_PASSWORD, {
		host:'localhost',
		port:3306,
		dialect:'mysql'
});

//Connect to Database
sequelize.authenticate().then(function (e) {
	if(e) {
		console.log('There is connection ERROR');
	} else {
		console.log('Connection has been established successfully');
	}
});

sequelize.sync({
	force: true,
	logging: console.log

}).then(function () {
	console.log('Everything is synced');
	var imageData = FS.readFileSync(__dirname + '/123_icon.png'); //Give image data path
	Image_Store.create({
		image_id: 123,
		image_type: 'png',
		image: imageData,
		image_size: 3,
		image_name: 'FileName'
	}).then(function (image_store) {
		try {
			//Store image to some location
			FS.writeFileSync(__dirname + '/target.png', image_store.image);
		} catch (e) {
			console.log(e+'');
		}
	});
});