Cu8-sequelize-oracle

New Feature - CLOB auto loading

Hey! I'm Nhua Nhua, who came from Mars. Wish you have a nice day and feel comfortable with fucking Oracle DB and NodeJs.

Note:

• Fix old functions and add more features to sequelize-oracle
• Forked repository: Sequelize-oracle

Change logs

• 0.0.4 Add destroy function for deleting objects

      model
          .destroy({where: {ID: 123}})
          .then()
          .catch();

• 0.0.5 Add $regexp_like comparator. $regexp_like: 'string'
• 0.0.6 Add TEXT (CLOB) type
• 0.0.7 Add Sequelize.insertCLOB, Sequelize.updateCLOB
  • Sequelize.prototype.updateCLOB = function(model, data, search, ClobFields, done)

    Sequelize.updateCLOB(model, req.body, {ID: req.body.ID}, ['Field1_type_clob', 'Field2_type_clob'], function (err) {
    if (err)
    return next(err);
    res.sendStatus(200);
    });

  • Sequelize.prototype.insertCLOB = function(model, data, primaryKey, ClobFields, done)

    Sequelize
    .insertCLOB(model, req.body, 'ID', ['Field1_type_clob', 'Field2_type_clob'], function (err, result) {
      res.send(result);
    });

• 1.0.0
  • Connection pool (Setup in ./lib/dialects/abstract/connection-manager.js at line 79) :

      connectionConfig.poolMax = 20;
      connectionConfig.poolMin = 0;
      connectionConfig.poolTimeout = 69;
      connectionConfig.queueRequests = true;

• 1.0.5 Fix join model cannot load CLOB

DataType: only this dataTypes are managed:

STRING (=VARCHAR2)
CHAR
DECIMAL (=NUMBER)
BIGINT (=NUMBER(19,0))
INTEGER
FLOAT
DOUBLE
UUID (=CHAR 36)
DATE (=TIMESTAMP WITH LOCAL TIME ZONE)
DATEONLY (=DATETIME)
BOOLEAN (=NUMBER(1))
TEXT (=CLOB)