1. // myproject/lib/sequelize-additions.js
    3. module.exports = function sequelizeAdditions(Sequelize) {
    5.   DataTypes = Sequelize.DataTypes
    7.   /*
    8.    * Create new types
    9.    */
    10.   class NEWTYPE extends DataTypes.ABSTRACT {
    11.     // Mandatory, complete definition of the new type in the database
    12.     toSql() {
    13.       return 'INTEGER(11) UNSIGNED ZEROFILL'
    14.     }
    16.     // Optional, validator function
    17.     validate(value, options) {
    18.     }
    20.     // Optional, sanitizer
    21.     _sanitize(value) {
    22.       // Force all numbers to be positive
    23.       if (value < 0) {
    24.         value = 0
    25.       }
    27.       return Math.round(value)
    28.     }
    30.     // Optional, value stringifier before sending to database
    31.     _stringify(value) {
    32.       return value.toString()
    33.     }
    36.       return Number.parseInt(value)
    37.     }
    38.   }
    40.   DataTypes.NEWTYPE = NEWTYPE;
    42.   // Mandatory, set key
    43.   DataTypes.NEWTYPE.prototype.key = DataTypes.NEWTYPE.key = 'NEWTYPE'
    45.   // Optional, disable escaping after stringifier. Not recommended.
    46.   // Warning: disables Sequelize protection against SQL injections
    47.   // DataTypes.NEWTYPE.escape = false
    49.   // For convenience
    50.   // `classToInvokable` allows you to use the datatype without `new`
    51.   Sequelize.NEWTYPE = Sequelize.Utils.classToInvokable(DataTypes.NEWTYPE)