Example 2: MVC App

var express                                         = require(‘express’);

var bodyParser                                 = require(‘body-parser’);

var path                                               = require(‘path’);

var fs                                                     = require(‘fs’);

var morgan                                         = require(‘morgan’);

var FileStreamRotator                    = require(‘file-stream-rotator’);

var db                                                   = require(‘./config/db’);

var app = express();

var logFolder = __dirname + ‘/log’;

fs.existsSync(logFolder) || fs.mkdirSync(logFolder);

//Logger details

var logFileStream = FileStreamRotator.getStream({

date_format:   ‘YYYY-MM-DD’,

filename:           logFolder + ‘/demo2_%DATE%.log’,

frequency:        ‘daily’,

verbose:                            false

});

//Setup app variables

app.set(‘port’, 3000);

app.set(‘views’, __dirname + ‘/app/views’);

app.set(‘view engine’, ‘ejs’);

app.use(morgan(‘combined’, {stream: logFileStream}));

app.use(express.static( path.join(__dirname, ‘/public’)));

app.use(bodyParser.json());

app.use(bodyParser.urlencoded({ extended: true }));

//Setup the routes

app.use(require(‘./app/controllers’));

//Setup Listener with Port app.get(‘port’)

app.listen(app.get(‘port’), function () {

console.log(‘Demo 2 listening on port ‘ + app.get(‘port’));

});

var mysql = require(‘mysql’);

//Declare MySQL connection pool

var pool =  mysql.createPool({

host:                      ‘localhost’,

                user:                      ‘root’,

                password:           ‘root’,

                database:            ‘itblogs’,

                port:                      3306

});

//Running select SQL

exports.runQuery = function(query,callback) {

//Making Query

pool.getConnection(function(err, connection){

connection.query( query, function(err, rows){

if(err)    {

throw err;

}else{

console.log( query );

callback(rows);

}

});

connection.release();

});

};

//Running insert,update,delete SQL

exports.runSQL = function(sql,callback) {

//Making Query

pool.getConnection(function(err, connection){

connection.query( sql, function(err){

if(err)    {

console.log( sql + ‘ ::: ‘ + err );

callback(false);

}else{

console.log( sql );

callback(true);

}

});

connection.release();

});

};

.listControls md-divider {

margin-top: 10px;

margin-bottom: 10px; }

.listControls md-list-item > p,

.listControls md-list-item > .md-list-item-inner > p,

.listControls md-list-item .md-list-item-inner > p,

.listControls md-list-item .md-list-item-inner > .md-list-item-inner > p {

-webkit-user-select: none;

/* Chrome all / Safari all */

-moz-user-select: none;

/* Firefox all */

-ms-user-select: none;

/* IE 10+ */

user-select: none;

/* Likely future */ }

.listControls .secondary-button-padding p {

padding-right: 100px; }

.listControls md-list-item > .md-button {

width: 130px; }

.ng-table select {

width: 80px;

padding: 0px 3px; }

.module(‘AngularApp’, [‘ngMaterial’, ‘ngTable’, ‘ngMessages’])

.controller(‘AppController’, function ($scope, $log) {

$log.debug(“App start…”);

})

.controller(‘HeaderController’, function ($scope, $timeout, $mdSidenav, $log) {

$scope.toggleLeft = buildDelayedToggler(‘leftMenu’);

/**

* Supplies a function that will continue to operate until the

* time is up.

*/

$scope.triggerMenu = function () {

$mdSidenav(‘leftMenu’).toggle()

.then(function () {

$log.debug(“toggle Menu is done”);

});

};

function debounce(func, wait, context) {

var timer;

return function debounced() {

var context = $scope,

args = Array.prototype.slice.call(arguments);

$timeout.cancel(timer);

timer = $timeout(function() {

timer = undefined;

func.apply(context, args);

}, wait || 10);

};

}

/**

* Build handler to open/close a SideNav; when animation finishes

* report completion in console

*/

function buildDelayedToggler(navID) {

return debounce(function() {

$mdSidenav(navID)

.toggle()

.then(function () {

$log.debug(“toggle ” + navID + ” is done”);

});

}, 200);

}

function buildToggler(navID) {

return function() {

$mdSidenav(navID)

.toggle()

.then(function () {

$log.debug(“toggle ” + navID + ” is done”);

});

}

}

})

.controller(‘MenuController’, function ($scope, $mdSidenav, $window, $log) {

$scope.close = function () {

$mdSidenav(‘leftMenu’).close()

.then(function () {

$log.debug(“close leftMenu is done”);

});

};

$scope.goURL = function ( url ) {

$window.location.href = url;

};

})

.controller(‘TableController’, function($scope, NgTableParams){

var self = this;

self.tableParams = new NgTableParams({ count: 5}, { counts: [5, 10, 25], dataset: data});

$scope.getStatus = function(data) {

return [{id:”1″, title:”1″}, {id:”0″, title:”0″}];

};

})

.controller(‘FormController’, function($scope){

$scope.record = {

};

});