/* ==========================================================
Use Middleware
============================================================ */
app.use(logger('dev')); //log every request to the console
// parse application/json
app.use(bodyParser.json()) //Get info from $HTTP POST/PUT packets - needed for req.body
/* ==========================================================
Connect to MySql database using express-myconnection middleware
DB settings are contained in var dbOptions defined in database.js
single database connection. Connection is never closed.
In case of disconnection it will try to reconnect again
============================================================ */
app.use(myConnection(mysql, dbOptions, 'single'));
/* ==========================================================
ROUTES - using Express
============================================================ */
routes(app);
/* ==========================================================
Create HTTP Server using Express
============================================================ */
var server = http.createServer(app);
/* ==========================================================
Bind to a port and listen for connections on it
app.use(express.static(path.join(__dirname, 'public')));
app.use(bodyParser.urlencoded({ extended: true })); //support x-www-form-urlencoded
app.use(bodyParser.json());
app.use(expressValidator());
/*MySql connection*/
var connection = require('express-myconnection'),
mysql = require('mysql');
app.use(
connection(mysql,{
host : 'localhost',
user : '******',
password : '',
database : 'test',
debug : false //set true if you wanna see debug logger
},'request')
);
app.get('/',function(req,res){
res.send('Welcome');
});
//RESTful route
var router = express.Router();
slide = require('./routes/dashboard/slideshow/slide/index'),
content = require('./routes/dashboard/content/index');
// Defining database options
var dbconfig = {
host: 'localhost',
user: '******',
password: '******',
database: 'dpd',
port: 3306
};
// Connecting with Twitter
// Connect with the database by extending the request object
app.use(myConnection(mysql, dbconfig, 'single'));
// Define the templating engine we'll be using (handlebars)
app.set('views', path.join(__dirname, 'views'));
app.set('view engine', 'hbs');
hbs.registerPartials(__dirname + '/views/partials'); //register hbs partials
// Define static path for css/js
app.use('/', express.static(__dirname + '/public'));
// Defining the body parser to parse user data from the <body>
app.use(bodyParser.urlencoded({extended: true}));
// Defining the cookie parser to parse cookies
app.use(cookieParser()); //enable cookies
var db_config_dev = {
host:'localhost',
port:3306,
user:'******',
password:'',
database:'locater'
};
app.use(express.logger('dev'));
app.use(express.json());
app.use(express.urlencoded());
app.use(express.methodOverride());
app.set('port', process.env.PORT || 4300 );
app.use (connection(mysql,db_config_prod,'pool'));
/*
will call every time for incoming requests
*/
app.use(function (req, res, next) {
console.log('Time: %d', Date.now());
next();
})
app.get('/',indexroute.index);
app.get('/customers', customerroutes.list);
app.post('/customers/add', customerroutes.save);
//app.get('/send',userroute.sendemail);
http.createServer(app).listen( app.get('port'),function(){
var mysql = require("mysql"),
myconnection = require("express-myconnection"),
opciones = {
database: "peliculas",
host: "localhost",
user: "******",
password: "******",
port: 3306
},
Peliculas = myconnection(mysql, opciones, "request");
module.exports = Peliculas
var LocalStrategy = require('passport-local').Strategy;
app.use(express.cookieParser());
app.use(express.bodyParser());
app.use(express.session({ secret: 'keyboard cat' }));
app.use(passport.initialize());
app.use(passport.session());
//app.use(app.router);
app.use(
connection1(mysql,{
host: 'us-cdbr-iron-east-01.cleardb.net',
user: '******',
password: '******',
database: 'ad_555f3ebb1eb886a',
port: 3306
},'pool') //or single
);
app.use(app.router);
var sess;
var connectionsArray = [],
connection = mysql.createConnection({
host: 'us-cdbr-iron-east-01.cleardb.net',
user: '******',
password: '******',
database: 'ad_555f3ebb1eb886a',
if ('development' == app.get('env')) {
app.use(express.errorHandler());
}
/*------------------------------------------
connection peer, register as middleware
type koneksi : single,pool and request
-------------------------------------------*/
app.use(
connection(mysql,{
host: 'localhost',
user: '******',
password : '******',
port : 3306, //port mysql
database:'test'
},'pool') //or single
);
app.get('/', routes.index);
app.get('/customers', customers.list);
app.get('/customers/add', customers.add);
app.post('/customers/add', customers.save);
app.get('/customers/delete/:id', customers.delete_customer);
app.get('/customers/edit/:id', customers.edit);
var express = require('express');
var app = express();
var path = require('path');
var mysql = require('mysql');
var myConnection = require('express-myconnection');
var fs = require('fs');
var multiparty = require('multiparty');
var nodemailer = require('nodemailer');
// config
var config = require('./config');
// mysql
app.use(myConnection(mysql, config.mysql, 'pool'));
// router
var router = express.Router();
app.use(router);
// static files
router.use(express.static(path.join(__dirname, '../client')));
// route: mysql test
router.use('/users', function(req, res, next) {
req.getConnection(function(err, connection) {
connection.query('SELECT * FROM users', function(err, results) {
if (err) {
return next(err);
}
return res.json(results);
});
}
if(err) throw err;
})
}
}));
*/
app.use(compress());
app.use(bodyParser());
app.use(cookieParser());
app.use(bodyParser());
app.use(myConnection(mysql, connectionPool, 'pool'));
app.use('/',express.static(location));
console.log(__dirname);
app.all('*', function(req, res, next) {
res.set('Access-Control-Allow-Origin', '*');
res.set('Access-Control-Allow-Credentials', true);
res.set('Access-Control-Allow-Methods', 'GET, POST, DELETE, PUT');
res.set('Access-Control-Allow-Headers', 'X-Requested-With, Content-Type, Authorization');
if ('OPTIONS' === req.method) return res.send(200);
next();
});
// production error handler
// no stacktraces leaked to user
app.use(function (err, req, res, next) {
res.status(err.status || 500);
// view engine setup
app.set('views', path.join(__dirname, 'views'));
app.set('view engine', 'ejs');
app.use(favicon());
app.use(logger('dev'));
app.use(bodyParser.json());
app.use(bodyParser.urlencoded());
app.use(cookieParser());
app.use(express.static(path.join(__dirname, 'public')));
app.use(
connection(mysql,{
host: 'localhost',
user: '******',
password : '******',
port : 3306, //port mysql
database:'nodejs'
},'pool')
);
app.use('/', routes);
app.use('/users', users);
app.use('/customers', customers.list);
app.use('/save', customers.save);
app.use('/add', customers.add);
/// catch 404 and forward to error handler
app.use(function(req, res, next) {
var err = new Error('Not Found');
err.status = 404;
if ('development' == app.get('env')) {
app.use(express.errorHandler());
}
/*------------------------------------------
connection peer, register as middleware
type koneksi : single,pool and request
-------------------------------------------*/
app.use(
connection(mysql,{
host: 'us-cdbr-azure-west-c.cloudapp.net',
user: '******',
password : '******',
port : 3306, //port mysql
database:'Test4023MySqlDB'
},'pool') //or single
);
//app.get('/',routes.index1);
app.get('/',customers.list);
app.get('/customers', customers.list);
app.get('/customers/add', customers.add);
app.post('/customers/add', customers.save);
app.get('/customers/delete/:id', customers.delete_customer);
// Configuracion Passport. Indicamos que Passport maneje la sesion
app.use(passport.initialize());
app.use(passport.session());
/*------------------
connection peer
-------------------*/
app.use(
connection(mysql,{
host: 'localhost',
user: '******',
password : '******',
port : 3306, //port mysql
database:'enigmadb'
},'pool')
);
app.use(express.static(path.join(__dirname, 'public')));
// Algunas concrecciones para URLS
app.use('/jb', express.static(__dirname + '/node_modules/bootstrap/dist/js')); // redirect bootstrap JS
app.use('/jq', express.static(__dirname + '/node_modules/jquery/dist')); // redirect JS jQuery
app.use('/ng', express.static(__dirname + '/node_modules/angular/')); // redirect JS jQuery
app.use('/css', express.static(__dirname + '/node_modules/bootstrap/dist/css')); // redirect CSS bootstrap
app.use('/stylesheets',express.static(__dirname + '/public/stylesheets/'));
// view engine setup
app.set('views', path.join(__dirname, 'views'));
app.set('view engine', 'jade');
// uncomment after placing your favicon in /public
//app.use(favicon(__dirname + '/public/favicon.ico'));
app.use(logger('dev'));
app.use(bodyParser.json());
app.use(bodyParser.urlencoded({ extended: false }));
app.use(cookieParser());
app.use(express.static(path.join(__dirname, 'public')));
app.use(
connection(mysql,{
host: 'localhost',
user: '******',
password : '',
port : 3306, //port mysql
database:'test'
},'request')
);
app.use('/', routes);
app.use('/users', users);
app.get('/customers', customers.list);
// catch 404 and forward to error handler
app.use(function(req, res, next) {
var err = new Error('Not Found');
err.status = 404;
next(err);
});
var config = require('./config');
var express = require('express');
var app = express();
var http = require('http').Server(app);
var io = require('socket.io')(http);
var connection = require('express-myconnection');
var mysql = require('mysql');
app.use(
connection(mysql, {
host: config.db.host,
user: config.db.user,
password: config.db.password,
port: config.db.port,
database: config.db.database
}, 'request')
);
app.use('/static', express.static(__dirname + '/static'));
app.get('/', function(req, res) {
res.sendFile(__dirname + '/templates/index.html');
});
io.on('connection', function(socket) {
console.log('New Connection');
socket.on('post', function(content) {
io.emit('post', content);
});
});
//app.use(favicon(__dirname + '/public/favicon.ico'));
app.use(logger('dev'));
app.use(bodyParser.json());
app.use(bodyParser.urlencoded({ extended: false }));
app.use(cookieParser());
app.use(function(req,res,next){
console.log(req.cookies);
next();
});
app.use(express.static(path.join(__dirname, 'public')));
app.use(myConnection(mysql, {
host: 'localhost',
user: '******',
password: '******',
database: 'Klassmate'
}, 'single'));
app.use('/', index);
app.use('/loginpage', loginpage);
app.use('/users', users);
app.use('/signuppage', signuppage);
app.use('/signup', signup);
app.use('/login', login);
app.use('/homepage', homepage);
app.use('/profile', profile);
app.use('/classpage', classpage);
// catch 404 and forward to error handler
app.use(function(req, res, next) {
app.set('view engine', 'jade');
// app.use(favicon(__dirname + '/public/img/favicon.ico'));
app.use(logger('dev'));
app.use(bodyParser.json());
app.use(bodyParser.urlencoded({
extended: true
}));
app.use(cookieParser());
app.use(express.static(path.join(__dirname, 'public')));
app.use(
connection(mysql,{
host: 'localhost',
user: '******',
password : '******',
port : 3306,
database:'mpf'
},'request')
);
app.all('/oauth/token', app.oauth.grant());
app.use(app.oauth.errorHandler());
//app.use('/', routes);
//app.use('/users', users);
app.get('/', app.oauth.authorise(), function (req, res) {
res.send('Secret area');
app.use(express.static(path.join(__dirname, 'public')));
// development only
if ('development' == app.get('env')) {
app.use(express.errorHandler());
}
app.use(
connection(mysql,{
host: 'localhost',
user: '******',
password : '******',
port : 3306, //port mysql
database:'dheeraj'
})
);
app.get('/', routes.index);
app.get('/users', rest.get);
app.get('/users/add', rest.add);
app.post('/users/add', rest.post);
app.get('/users/delete/:id', rest.delete_user);
app.get('/users/edit/:id', rest.edit);
var mysql = require('mysql');
var mysqlMiddleware = require('express-myconnection');
// Server configuration
//Create new http server with express
var app = express();
app.use(bodyParser.json());
//Read the database configuration
var dbConfig = JSON.parse(fs.readFileSync('./config/db_config.json'));
//Adding the middleware for database connection
app.use(mysqlMiddleware(mysql, dbConfig, 'single'));
//Session for the http server
var sessionConfig = session({
secret: 'test',
resave: true,
saveUninitialized: true
});
app.use(sessionConfig);
//Routes and handelr registration
var test = require("./routes/test");
app.use(test.routePrefix, test.router);
var photo = require("./routes/photo");
app.use(photo.routePrefix, photo.router);
app.use(bodyParser.json());
app.use(function (req, res, next) {
res.header('Access-Control-Allow-Origin', '*');
res.header('Access-Control-Allow-Methods', 'GET,PUT,POST,DELETE');
res.header('Access-Control-Allow-Headers', 'Origin, X-Requested-With, Content-Type, Authorization, Accept, amc-sessionid');
res.header('Cache-Control', 'no-cache, no-store, must-revalidate');
res.header('Pragma', 'no-cache');
res.header('Expires', 0);
next();
});
app.use(bodyParser.urlencoded({ extended: true }));
app.use(connection(mysql, {
host: 'db-dionisio.mysql.uhserver.com',
user: '******',
password: '******',
database: 'db_dionisio'
}, 'single'));
app.use(express.static(path.join(__dirname, 'web')));
app.use('/', routes);
process.on('uncaughtException', function (err) {
console.error(err.stack);
console.log("Node NOT Exiting...");
log.saveLog("Erro: " + err.stack);
});
module.exports = app;
// app.set('port', process.env.PORT || 3000);
app.use(express.methodOverride());
app.use(express.static(path.join(__dirname, 'public')));
// development only
if ('development' == app.get('env')) {
app.use(express.errorHandler());
}
app.use(
connection(mysql,{
host: 'localhost',
user: '******',
password : '******',
port : 3306, //port mysql
database:'qbank'
},'pool') //or single
);
app.get('/', routes.index);
app.get('/customers/:id', customers.listid);
//app.get('/customers/', customers.listid);
//app.get('/customers/add', customers.add);
//app.post('/customers/add', customers.save);
//app.get('/customers/delete/:id', customers.delete_customer);
// 设置中间件和静态文件路径
app.use(express.static(path.join(__dirname, 'public')));
app.use(bodyParser.urlencoded({ extended: true })); //support x-www-form-urlencoded
app.use(bodyParser.json());
app.use(expressValidator());
// 设置mysql连接
const connection = require('express-myconnection');
mysql = require('mysql');
// 应用连接数据库
app.use(
connection(mysql, {
host: 'localhost',
user: '******',
password : '******',
port : 3306, //port mysql
database:'test'
},'single')
);
// 路由
routes(app)
// 设置应用监听的端口
const server = app.listen(3000, function(){
var host = server.address().address;
var port = server.address().port;
console.log('Express app listening at: http://%s:%s ' ,host, port);
});
*/
next(null, config);
}
};
app = module.exports = express();
app.use(kraken(options));
app.on('start', function () {
console.log('Application ready to serve requests.');
console.log('Environment: %s', app.kraken.get('env:env'));
});
app.use(cookieParser());
app.use(myConnection(mysql, {
host:'localhost',
user:'******',
password:'',
port:3306,
database:'savi'
}, 'single'));
/*
* Create and start HTTP server.
*/
if (!module.parent) {
/*
* This is only done when this module is run directly, e.g. `node .` to allow for the
* application to be used in tests without binding to a port or file descriptor.
*/
server = http.createServer(app);
server.listen(process.env.PORT || 8000);