Secure your code as it's written. Use Snyk Code to scan source code in minutes - no build needed - and fix issues immediately.
app.use(bodyParser.json());
app.use(bodyParser.urlencoded());
app.use(expressValidator());
app.use(cookieParser());
app.use(session({cookie: { maxAge: 60000 }, secret: 'secret'}));
app.use(flash());
app.use(passport.initialize());
app.use(passport.session());
app.use(express.static(path.join(__dirname, 'public')));
// DB configuration
var sqlite3 = require('sqlite3').verbose();
var db = new sqlite3.Database(settings.db);
orm.settings.set("instance.returnAllErrors", true);
app.use(orm.express(settings.dsn, {
define: function (db, models, next) {
db.load("./models", function (err) {
models.User = db.models.users;
models.Pad = db.models.pads;
models.Note = db.models.notes;
next();
});
}
}));
// Flash Messages configuration
app.use(function(req, res, next){
res.locals.flash_messages = {
'success': req.flash('success'),
'error': req.flash('error')
}
let thisModuleName = ModuleName[item.TableName].modelName;
models[thisModuleName] = db.define(item.TableName , item.Columns);
} catch(err) {
console.log(err);
console.log(item.TableName);
console.log("========================");
}
}
models.db1 = db;
next();
}
}));
app.use(orm.express('mysql://' + rebate.username + ':' + rebate.pwd + '@' + rebate.host + '/' + rebate.database + '?timezone=CST', {
define: function(db, models, next) {
db.settings.set('instance.cache', false);
db.settings.set('instance.autoFetch', true);
models.TypeFlow = db.define("t_rebate_type_flow", TypeFlow);
models.db2 = db;
next();
}
}));
}
})
);
app.use('/js', middlewarePipe('./static/js',
/\.tpl\.js$/, function (url) {
return url.replace(/\.js/, '.html');
}).pipe(function () {
return tplPlugin();
})
);
app.use(serveStatic('static'));
var msqlUrl = GLOBAL.pjconfig.mysql.url;
app.use(orm.express(msqlUrl, {
define: function (db, models, next) {
db.use(require("orm-transaction"));
models.userDao = require('./dao/UserDao')(db);
models.applyDao = require('./dao/ApplyDao')(db);
models.approveDao = require('./dao/ApproveDao')(db);
models.userApplyDao = require('./dao/UserApplyDao')(db);
models.statisticsDao = require('./dao/StatisticsDao')(db);
models.db = db;
global.models = models;
logger.info('mysql connected');
next();
}}));
app.use(function (err, req, res, next) {
/**
* Database mongoose.
*/
var dbI = require('../settings').databaseInfo
module.exports = require('orm').express(dbI, {
define: function (db, models) {
module.exports.db = db;
models.mesg = db.define('wg_mesg', require('./mesg/schema'));
models.group = db.define('wg_group', require('./group/schema'));
db.sync();
}
});
install: function(app) {
var self = this;
var orm_name = "mongodb://localhost/" + app_name;
app.use(orm.express(orm_name, {
define: function (db, models, next) {
models.comment = db.define("comment", {
author: String,
comment: String,
paragraph: String,
public: Boolean,
resolved: Boolean,
sid: String,
time: Number,
index: Number,
pageid: String,
page: String
});
models.timespent = db.define("timespent", {
controller: String,
app.set('views',path.join(__dirname , ".." , "views"));
app.set('view engine', 'html');
app.engine('html', tpl.__express);
app.use(session({ secret: 'keyboard cat', cookie: { maxAge: 120 * 60 * 1000 } }));
app.use(bodyParser.urlencoded({ extended: false }));
app.use(cookieParser());
app.use('/static' , serveStatic(path.join(__dirname , ".." , "static")));
var msqlUrl = global.pjconfig.mysql.url;
logger.info('connect mysql: ' + msqlUrl);
app.use(orm.express(msqlUrl, {
define: function (db, models, next) {
db.use(require("orm-transaction"));
models.userDao = require('../dao/UserDao')(db);
models.applyDao = require('../dao/ApplyDao')(db);
models.approveDao = require('../dao/ApproveDao')(db);
models.userApplyDao = require('../dao/UserApplyDao')(db);
models.statisticsDao = require('../dao/StatisticsDao')(db);
models.db = db;
global.models = models;
logger.info('mysql connected');
next();
}}));
function connect(app) {
app.use(orm.express('mysql://' + mysql.username + ':' + mysql.pwd + '@' + mysql.host + '/' + mysql.database, {
define: function(db, models, next) {
db.settings.set('instance.cache', false);
db.settings.set('instance.autoFetch', true);
//db.settings.set('instance.autoFetchLimit', 9999);
//db.settings.set('instance.cacheSaveCheck', false);
//db.settings.set('instance.autoSave', true);
models.NewAccount = db.define("tbl_rt_useranalysis_newuser", obj.NewAccount);
models.Configure = db.define("tbl_rt_configure", obj.Configure);
models.UsersAccess = db.define("tbl_rt_user_access", obj.UsersAccess);
models.UserCompose = db.define("tbl_rt_use_time", obj.UserCompose);
models.MarketingFlow = db.define("tbl_rt_marketing_flow", obj.MarketingFlow);
models.MarketingCoupon = db.define("tbl_rt_marketing_coupon", obj.MarketingCoupon);
models.MarketingCouponDetails = db.define("tbl_rt_marketing_coupon_details", obj.MarketingCouponDetails);
models.OverviewPage = db.define("tbl_rt_overview_page", obj.OverviewPage);
models.OverviewPlatf = db.define("tbl_rt_overview_platf", obj.OverviewPlatf);
models.KpiValue = db.define("tbl_rt_kpi_value", obj.KpiValue);
app.configure(function(){
app.set('port', process.env.PORT || config.port);
app.set('views', __dirname + '/views');
app.set('view engine', 'jade');
app.use(orm.express(config.databaseUrl || "sqlite://database.db", {
define: function(db, models, next) {
db.use(paging);
models.image = db.define('image', {
content: { type: "binary" },
contentType: { type: "text" },
thumbnail: { type: "binary" },
fileType: { type: "text" },
thumbnailType: { type: "text" }
});
db.sync();
next();
}