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 11352x 11352x 11352x 11352x 44750x 44750x 44750x 44750x 44750x 44750x 44750x 11352x 11352x 233x 233x 11352x 11352x 10854x 10854x 11352x 11352x 233x 233x 11352x 11352x 304x 282x 282x 22x 22x 304x 20x 20x 2x 2x 304x 3x 3x 5x 3x 3x 2x 2x 2x 5x 3x 1x 1x 1x 3x 5x 1x 1x 1x 1x 5x 3x 2x 2x 2x 11352x 11352x | 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;
}
} |