How to use

query

function

in

Sequelize

start: async () => {
 await db.sequelize.query('PRAGMA journal_mode=WAL;');

// 数据库升级一个版本
const upgradAsync = async (v1, v2, sqlFiles) => {
 logger.info(`upgrade from version ${v1} to version ${v2}`)
 for (let sqlFile of sqlFiles) {
  let sqlPath = path.join(__dirname, sqlFile)
  let sql = fs.readFileSync(sqlPath, 'utf-8')
  await sequelize.query(sql)
 }
 return true
}

/*
 * stream past 24 hours HN activity data points;
 */
app.get('/variance', function (req, res) {
 sequelize.query('SELECT * FROM datapoints WHERE time > current_date - 1 ORDER BY time desc', {model: DataPoint})
  .then(function(dps) {
    var varianceDps = smoothenData(dps);
    // return varianceDps;
    return res.json({datapoints: varianceDps});
    
  });
});

models.sequelize.query(request, {type: models.sequelize.QueryTypes.SELECT}).then(function(result){
    if(result.length > 0)
      return callback(result[0].DATA_TYPE, result[0].CHARACTER_MAXIMUM_LENGTH);
    callback(false, false)
  })

// userInfo resolver
const userInfo = ({id}) => {
  let sql = `
    SELECT *
    FROM users
  `

  if (id) {
    sql += `WHERE id = ${id};`
  }

  return sequelize.query(sql, {
    type:sequelize.QueryTypes.SELECT
  })
}

// updateMessage resolver
const updateMessage = (id, input) => {
  const sql = `
    UPDATE messages
    SET content = '${input.content}'
    WHERE id = ${id};
  `
  return sequelize.query(sql, {
    type: sequelize.QueryTypes.UPDATE
  })
}

router.get('/:id/remove', function (req, res, next) {
  var id = req.params.id;
  if(!id){
    id=1;
  }
  sequelize.query('delete  from rdm_reports where id=' + id + ' ').spread(function (results, metadata) {
    res.redirect('/reportRoutes');
  });
});

sequelize.query(query).then(function (constraintName) {
    if (typeof constraintName[0][0] === "undefined")
      return callback();

    query = "ALTER TABLE " + table_name + " DROP FOREIGN KEY " + constraintName[0][0].constraint_name + "; ALTER TABLE " + table_name + " DROP " + attr.fieldToDrop.toLowerCase() +";";
    if (!pushToSyncQuery(attr.id_application, query))
      return callback("ERROR: Can't delete in database");
    callback();
  }).catch(function (err) {
    callback(err);
  });

// createUser resolver
const createUser = (input) => {
  const sql = `
    INSERT INTO users (name, nickname, created_at, updated_at)
    VALUES ('${input.name}', '${input.nickname}', datetime('now'), datetime('now'));
  `
  return sequelize.query(sql, {
    type: sequelize.QueryTypes.INSERT
  })
}

db.sequelize.query("SELECT vh.id, vh.date, vh.weight, vh.height, vh.comment, v.id as vaccine_id, v.name as vaccine_name FROM vaccine_history vh "+
            "JOIN vaccine v ON vh.id_vaccine = v.id join child c ON vh.id_child = c.id WHERE vh.id_child = :id", 
                  
            { replacements: { id: req.params.id }, type: db.sequelize.QueryTypes.SELECT }
                     
  ).then(vaccineHistories => {
   res.send(vaccineHistories);
  })

sequelize.query(`DROP TABLE ${table_name};`).then(_ =>{
    callback();
  }).catch(err => {
    console.error(err);
    callback(err);
  })

// createMessage resolver
const createMessage = (input) => {
  const sql = `
    INSERT INTO messages (user_id, content, created_at, updated_at)
    VALUES ('${input.user_id}', '${input.content}', datetime('now'), datetime('now'));
  `
  return sequelize.query(sql, {
    type: sequelize.QueryTypes.INSERT
  })
}

// updateUser resolver
const updateUser = (id, input) => {
  const sql = `
    UPDATE users
    SET name = '${input.name}', nickname = '${input.nickname}'
    WHERE id = ${id};
  `
  return sequelize.query(sql, {
    type: sequelize.QueryTypes.UPDATE
  })
}

api.get("/product_types", (req, res)=>{
 // db.ProductTypes.findAll({}).then((result)=>{
 //   res.json(result)
 // });
 db.sequelize.query("SELECT M.id, PT.market_id, Sub.id as subcategory_id, PT.nameSpanish as Product_Name, Sub.nameSpanish as Subcategory_Name FROM brandeller.ProductTypes as PT, brandeller.Markets as M, brandeller.Subcategories as Sub WHERE M.id = PT.market_id and Sub.id = PT.subcategory_id;")
 .then((result)=>{
  res.json(result[0])
 })
 
});

sequelize.query(query).then(function (constraintName) {
    if (typeof constraintName[0][0] === "undefined")
      return callback();
    query = "ALTER TABLE " + table_name + " DROP FOREIGN KEY " + constraintName[0][0].constraint_name + "; ALTER TABLE " + table_name + " DROP " + attr.fieldToDrop.toLowerCase() +";";
    if (!pushToSyncQuery(attr.id_application, query))
      return callback("ERROR: Can't delete in database");
    callback();
  }).catch(function (err) {
    callback(err);
  });