Ejemplo n.º 1
0
  scenariosByCTCNames: function(req, res, next){

   var companyName   = req.params.companyName;
   var teamName      = req.params.teamName;
   var componentName = req.params.componentName;
   if(companyName && teamName && componentName){
     knex.raw('SELECT tc_id, tc_scenario, tc_steps ' +
                'FROM testcases ' +
                'WHERE tc_relate_id = ' +
                '(SELECT r_id ' +
                 'FROM relate ' +
                 'WHERE c_id = (SELECT company_id FROM company WHERE company_name = ?) ' +
                 'AND t_id   = (SELECT team_id FROM team WHERE team_name = ?) ' +
                 'AND co_id  = (SELECT co_id FROM component WHERE co_name = ?)) ', 
              [companyName, teamName, componentName])
              .then(function(scenarios){
                if(req.route.path.match('/testcases')){
                  res.locals.scenarios = _.first(scenarios);
                  next();
                 }else{  
                  res.send(200, _.first(scenarios)); 
                  next();
                 }
              });
   }else{
    next();
   }
  },
Ejemplo n.º 2
0
 'generate object format will not escape': function() {
   var now = Mysql.raw('NOW()');
   assert.equal(
     Mysql.format('SELECT * FROM ?? WHERE ?? >= ?', ['table', 'property', now]),
     'SELECT * FROM `table` WHERE `property` >= NOW()'
   );
 }
Ejemplo n.º 3
0
 bowerstatic.raw('/bc/eventEmitter', function (ee) {
   logger.debug(ee);
   bowerstatic.raw('/bc/rsvp', function (rsvp) {
     logger.debug(rsvp);
     async.eachSeries([
       ee,
       rsvp,
       path.join(__api, '/abstract/StreamPromise.js'),
       path.join(__api, '/abstract/MessageRouter.js'),
       path.join(__api, '/abstract/MessageWriter.js'),
       path.join(__api, '/abstract/MessageDuplex.js'),
       path.join(__api, '/window/Window2Server_com.js'),
       path.join(__api, '/window/WindowAbstract.js'),
       path.join(__api, '/window/FrameContext.js'),
       path.join(__api, '/window/WindowManager.js'),
       path.join(__api, '/window/Window2Server_com.js'),
       path.join(__api, '/network/NetworkHost.js'),
       path.join(__api, '/network/NetworkUser.js')
     ], function (file, next) {
       var temp = fs.createReadStream(file, { encoding: 'utf-8' });
       temp.on('data', res.write.bind(res));
       temp.on('end', next);
       temp.on('error', next);
     }, function (err) {
       if (err) return next(err);
       res.end();
     });
   });
 });