Method formatError

lib/dialects/postgres/query.js:303–405

(err, errStack)

  }

  formatError(err, errStack) {
    let match;
    let table;
    let index;
    let fields;
    let errors;
    let message;

    const code = err.code || err.sqlState;
    const errMessage = err.message || err.messagePrimary;
    const errDetail = err.detail || err.messageDetail;

    switch (code) {
      case class="st">'23503':
        index = errMessage.match(/violates foreign key constraint class="st">"(.+?)"/);
        index = index ? index[1] : undefined;
        table = errMessage.match(/on table class="st">"(.+?)"/);
        table = table ? table[1] : undefined;

        return new sequelizeErrors.ForeignKeyConstraintError({
          message: errMessage,
          fields: null,
          index,
          table,
          parent: err,
          stack: errStack
        });
      case class="st">'23505':
        class="cm">// there are multiple different formats of error messages for this error code
        class="cm">// this regex should check at least two
        if (errDetail && (match = errDetail.replace(/"/g, class="st">'').match(/Key \((.*?)\)=\((.*?)\)/))) {
          fields = _.zipObject(match[1].split(class="st">', '), match[2].split(class="st">', '));
          errors = [];
          message = class="st">'Validation error';

          _.forOwn(fields, (value, field) => {
            errors.push(new sequelizeErrors.ValidationErrorItem(
              this.getUniqueConstraintErrorMessage(field),
              class="st">'unique violation', class="cm">// sequelizeErrors.ValidationErrorItem.Origins.DB,
              field,
              value,
              this.instance,
              class="st">'not_unique'
            ));
          });

          if (this.model && this.model.uniqueKeys) {
            _.forOwn(this.model.uniqueKeys, constraint => {
              if (_.isEqual(constraint.fields, Object.keys(fields)) && !!constraint.msg) {
                message = constraint.msg;
                return false;
              }
            });
          }

          return new sequelizeErrors.UniqueConstraintError({ message, errors, parent: err, fields, stack: errStack });
        }