1. module sequelize-auto
   1. function sequelize-auto (database, username, password, options)
   2. object sequelize-auto.sql_string
2. module sequelize-auto.sql_string
   1. function sequelize-auto.sql_string.escape (val, timeZone, dialect, format)
   2. function sequelize-auto.sql_string.format (sql, values, timeZone, dialect)
   3. function sequelize-auto.sql_string.formatNamedParameters (sql, values, timeZone, dialect)

module sequelize-auto

function sequelize-auto (database, username, password, options)

• description and source-code

  function AutoSequelize(database, username, password, options) {
    if (options && options.dialect === 'sqlite' && ! options.storage)
      options.storage = database;
  
    if (database instanceof Sequelize) {
      this.sequelize = database;
    } else {
      this.sequelize = new Sequelize(database, username, password, options || {});
    }
  
    this.queryInterface = this.sequelize.getQueryInterface();
    this.tables = {};
    this.foreignKeys = {};
    this.dialect = dialects[this.sequelize.options.dialect];
  
    this.options = _.extend({
      global: 'Sequelize',
      local: 'sequelize',
      spaces: false,
      indentation: 1,
      directory: './models',
      additional: {},
      freezeTableName: true
    }, options || {});
  }

• example usage

  n/a

module sequelize-auto.sql_string

function sequelize-auto.sql_string.escape (val, timeZone, dialect, format)

• description and source-code

  function escape(val, timeZone, dialect, format) {
    var prependN = false;
    if (val === undefined || val === null) {
      return 'NULL';
    }
    switch (typeof val) {
      case 'boolean':
      // SQLite doesn't have true/false support. MySQL aliases true/false to 1/0
      // for us. Postgres actually has a boolean type with true/false literals,
      // but sequelize doesn't use it yet.
        if (dialect === 'sqlite' || dialect === 'mssql') {
          return +!!val;
        }
        return '' + !!val;
      case 'number':
        return val + '';
      case 'string':
      // In mssql, prepend N to all quoted vals which are originally a string (for
      // unicode compatibility)
        prependN = dialect === 'mssql';
        break;
    }
  
    if (val instanceof Date) {
      val = dataTypes[dialect].DATE.prototype.stringify(val, { timezone: timeZone });
    }
  
    if (Buffer.isBuffer(val)) {
      if (dataTypes[dialect].BLOB) {
        return dataTypes[dialect].BLOB.prototype.stringify(val);
      }
  
      return dataTypes.BLOB.prototype.stringify(val);
    }
  
    if (Array.isArray(val)) {
      var partialEscape = _.partial(escape, _, timeZone, dialect, format);
      if (dialect === 'postgres' && !format) {
        return dataTypes.ARRAY.prototype.stringify(val, {escape: escape});
      }
      return val.map(partialEscape);
    }
  
    if (!val.replace) {
      throw new Error('Invalid value ' + val);
    }
  
    if (dialect === 'postgres' || dialect === 'sqlite' || dialect === 'mssql') {
      // http://www.postgresql.org/docs/8.2/static/sql-syntax-lexical.html#SQL-SYNTAX-STRINGS
      // http://stackoverflow.com/q/603572/130598
      val = val.replace(/'/g, "''");
    } else {
      val = val.replace(/[\0\n\r\b\t\\\'\"\x1a]/g, function(s) {
        switch (s) {
          case '\0': return '\\0';
          case '\n': return '\\n';
          case '\r': return '\\r';
          case '\b': return '\\b';
          case '\t': return '\\t';
          case '\x1a': return '\\Z';
          default: return '\\' + s;
        }
      });
    }
    return (prependN ? "N'" : "'") + val + "'";
  }

• example usage

  ...
        val_text = quoteWrapper + val_text + quoteWrapper
      }
    }
  
    if(defaultVal === null || defaultVal === undefined) {
      return true;
    } else {
      val_text = _.isString(val_text) && !val_text.match(/^sequelize\.[^(]+\(.*\)$/) ? SqlString.escape(_.trim(val_text, '"'), null, self.options.dialect) : val_text;
  
      // don't prepend N for MSSQL when building models...
      val_text = _.trimStart(val_text, 'N')
      text[table] += spaces + spaces + spaces + attr + ": " + val_text;
    }
  }
  else if (attr === "type" && self.tables[table][field][attr].indexOf('ENUM') === 0) {
  ...

function sequelize-auto.sql_string.format (sql, values, timeZone, dialect)

• description and source-code

  function format(sql, values, timeZone, dialect) {
    values = [].concat(values);
  
    if (typeof sql !== 'string') {
      throw new Error('Invalid SQL string provided: ' + sql);
    }
    return sql.replace(/\?/g, function(match) {
      if (!values.length) {
        return match;
      }
  
      return escape(values.shift(), timeZone, dialect, true);
    });
  }

• example usage

  n/a

function sequelize-auto.sql_string.formatNamedParameters (sql, values, timeZone, dialect)

• description and source-code

  function formatNamedParameters(sql, values, timeZone, dialect) {
    return sql.replace(/\:+(?!\d)(\w+)/g, function(value, key) {
      if ('postgres' === dialect && '::' === value.slice(0, 2)) {
        return value;
      }
  
      if (values[key] !== undefined) {
        return escape(values[key], timeZone, dialect, true);
      } else {
        throw new Error('Named parameter "' + value + '" has no value in the given object.');
      }
    });
  }

• example usage

  n/a