How to use the orm.express function in orm

To help you get started, we’ve selected a few orm examples, based on popular ways it is used in public projects.

Secure your code as it's written. Use Snyk Code to scan source code in minutes - no build needed - and fix issues immediately.

github komarserjio / notejam / express / notejam / app.js View on Github external
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')
  }
github gomeplusFED / DataPlatform / models2 / mysql.js View on Github external
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();
        }
    }));
}
github BetterJS / badjs-web / app.js View on Github external
})
);
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) {
github dotkrnl / write-group / models / db.js View on Github external
/**
 * 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();
    }
});
github logv / superfluous / superfluous / app / plugins / mars / models.js View on Github external
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,
github BetterJS / badjs-web / workflow / ExpressInitWorker.js View on Github external
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();
}}));
github gomeplusFED / DataPlatform / models / mysql.js View on Github external
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);
github Puut / Puut-Server / app.js View on Github external
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();
      }

orm

NodeJS Object-relational mapping

MIT
Latest version published 1 year ago

Package Health Score

60 / 100
Full package analysis