Press n or j to go to the next uncovered block, b, p or k for the previous block.
| 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 | 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 11713x 11713x 11713x 11713x 34997x 34997x 34997x 34997x 34997x 34997x 34997x 11713x 11713x 253x 253x 11713x 11713x 11175x 11175x 11713x 11713x 253x 253x 11713x 11713x 343x 320x 320x 23x 23x 343x 21x 21x 2x 2x 343x 3x 3x 5x 3x 3x 2x 2x 2x 5x 3x 1x 1x 1x 3x 5x 1x 1x 1x 1x 5x 3x 2x 2x 2x 11713x 11713x | import {BasicRuleConfig} from "./_basic_rule_config";
import {IObject} from "../objects/_iobject";
import {IRule, RuleTag} from "./_irule";
import {Issue} from "../issue";
import {Position} from "../position";
import * as Objects from "../objects";
export class IndexCompletelyContainedConf extends BasicRuleConfig {
}
export class IndexCompletelyContained implements IRule {
private conf = new IndexCompletelyContainedConf();
public getMetadata() {
return {
key: "index_completely_contained",
title: "Check if database table indexes are completely contained",
shortDescription: `If indexes are completely contained in other indexes, they can be removed to improve performance.`,
tags: [RuleTag.Performance, RuleTag.SingleFile],
};
}
public initialize() {
return this;
}
public getConfig() {
return this.conf;
}
public setConfig(conf: IndexCompletelyContainedConf) {
this.conf = conf;
}
public run(obj: IObject): Issue[] {
if (!(obj instanceof Objects.Table)) {
return [];
}
const indexes = obj.getSecondaryIndexes();
if (indexes === undefined || indexes.length === 0) {
return [];
}
const issues: Issue[] = [];
for (let i = 0; i < indexes.length; i++) {
const indexA = indexes[i];
for (let j = 0; j < indexes.length; j++) {
if (i === j) {
continue;
}
const indexB = indexes[j];
let contained = true;
for (const field of indexA.fields) {
if (indexB.fields.indexOf(field) === -1) {
contained = false;
break;
}
}
if (contained) {
const position = new Position(1, 1);
const message = `Index "${indexA.name}" is completely contained in index "${indexB.name}"`;
issues.push(Issue.atPosition(obj.getFiles()[0], position, message, this.getMetadata().key, this.conf.severity));
}
}
}
return issues;
}
} |