Function normalizeDataType has a Cognitive Complexity of 8 (exceeds 5 allowed). Consider refactoring.

Open

  normalizeDataType(Type) {
    let type = typeof Type === 'function' ? new Type() : Type;
    const dialectTypes = this.dialect.DataTypes || {};

    if (dialectTypes[type.key]) {

• Read up
  Read up

Avoid deeply nested control flow statements.

Open

            if (/(UPDATE|DELETE)/.test(defParts[i])) {
              row[`on_${defParts[i].toLowerCase()}`] = defParts[i + 1];
            }

Function mapOptionFieldNames has a Cognitive Complexity of 8 (exceeds 5 allowed). Consider refactoring.

Open

function mapOptionFieldNames(options, Model) {
  if (Array.isArray(options.attributes)) {
    options.attributes = options.attributes.map(attr => {
      // Object lookups will force any variable to strings, we don't want that for special objects etc
      if (typeof attr !== 'string') return attr;

• Read up
  Read up

Function selectFromTableFragment has a Cognitive Complexity of 8 (exceeds 5 allowed). Consider refactoring.

Open

  selectFromTableFragment(options, model, attributes, tables, mainTableAs, where) {
    this._throwOnEmptyAttributes(attributes, {
      modelName: model && model.name,
      as: mainTableAs
    });

• Read up
  Read up

Avoid deeply nested control flow statements.

Open

            if (split[1].toLowerCase() !== 'regclass)') {
              result[row.Field].defaultValue = split[0];
            }

Function toDefaultValue has a Cognitive Complexity of 8 (exceeds 5 allowed). Consider refactoring.

Open

function toDefaultValue(value, dialect) {
  if (typeof value === 'function') {
    const tmp = value();
    if (tmp instanceof DataTypes.ABSTRACT) {
      return tmp.toSql();

• Read up
  Read up

Function _invokeCustomValidator has a Cognitive Complexity of 8 (exceeds 5 allowed). Consider refactoring.

Open

  async _invokeCustomValidator(validator, validatorType, optAttrDefined, optValue, optField) {
    let isAsync = false;

    const validatorArity = validator.length;
    // check if validator is async and requires a callback

• Read up
  Read up

Function prepareEnvironment has a Cognitive Complexity of 8 (exceeds 5 allowed). Consider refactoring.

Open

  async prepareEnvironment(useCLS) {
    let connectionPromise;

    if (useCLS === undefined) {
      useCLS = true;

• Read up
  Read up

Function _extractValidatorArgs has a Cognitive Complexity of 8 (exceeds 5 allowed). Consider refactoring.

Open

  _extractValidatorArgs(test, validatorType, field) {
    let validatorArgs = test.args || test;
    const isLocalizedValidator =
      typeof validatorArgs !== 'string' &&
      (validatorType === 'isAlpha' || validatorType === 'isAlphanumeric' || validatorType === 'isMobilePhone');

• Read up
  Read up

Function run has a Cognitive Complexity of 8 (exceeds 5 allowed). Consider refactoring.

Open

  async run(sql, parameters) {
    this.sql = sql;
    const { connection, options } = this;

    const showWarnings = this.sequelize.options.showWarnings || options.showWarnings;

• Read up
  Read up

Avoid deeply nested control flow statements.

Open

            if (newIdx > rightestPosition) {
              rightestPosition = newIdx;
            }

Avoid deeply nested control flow statements.

Open

              if (Array.isArray(order)) {
                order = order[0];
              }

Avoid deeply nested control flow statements.

Open

              if (!item) {
                item = previousModel.getAssociationForAlias(model, model.name);
              }

Avoid deeply nested control flow statements.

Open

            if ($length === 1) {
              itemHash += stringify(row[`${prefix}.${primaryKeyAttributes[0]}`]);
            } else if ($length > 0) {
              for ($i = 0; $i < $length; $i++) {
                itemHash += stringify(row[`${prefix}.${primaryKeyAttributes[$i]}`]);

Avoid deeply nested control flow statements.

Open

            for (let reverseIdx = newValuesBefore.length - 1; reverseIdx >= 0; reverseIdx--) {
              if (~enumVals.indexOf(newValuesBefore[reverseIdx])) {
                break;
              }

Function _whereGroupBind has a Cognitive Complexity of 8 (exceeds 5 allowed). Consider refactoring.

Open

  _whereGroupBind(key, value, options) {
    const binding = key === Op.or ? this.OperatorMap[Op.or] : this.OperatorMap[Op.and];
    const outerBinding = key === Op.not ? 'NOT ' : '';

    if (Array.isArray(value)) {

• Read up
  Read up

Function selectFromTableFragment has a Cognitive Complexity of 8 (exceeds 5 allowed). Consider refactoring.

Open

  selectFromTableFragment(options, model, attributes, tables, mainTableAs) {
    this._throwOnEmptyAttributes(attributes, {
      modelName: model && model.name,
      as: mainTableAs
    });

• Read up
  Read up

Avoid deeply nested control flow statements.

Open

            if (itemHash === topHash) {
              if (!resultMap[itemHash]) {
                resultMap[itemHash] = values;
              } else {
                topExists = true;

Function whereItemsQuery has a Cognitive Complexity of 8 (exceeds 5 allowed). Consider refactoring.

Open

  whereItemsQuery(where, options, binding) {
    if (where === null || where === undefined || Utils.getComplexSize(where) === 0) {
      // NO OP
      return '';
    }

• Read up
  Read up

Avoid deeply nested control flow statements.

Open

              if (previousModel.rawAttributes[itemSplit[0]].type instanceof DataTypes.JSON) {
                // just quote identifiers for now
                const identifier = this.quoteIdentifiers(
                  `${previousModel.name}.${previousModel.rawAttributes[itemSplit[0]].field}`
                );