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 | 1x 1x |
import {Query} from './Query';
/**
* @since v0.2.0
*/
export interface ICreateIndexQueryParams {
indexName: string;
tableName: string;
columnName: string;
}
/**
* @since v0.2.0
*/
export class CreateIndexQuery extends Query<void, void> {
private $options: ICreateIndexQueryParams;
public constructor(options: ICreateIndexQueryParams) {
super();
this.$options = options;
}
private $sanitize(value: string): string {
Iif (typeof value !== 'string') {
value = JSON.stringify(value);
}
return `\`${value}\``;
}
public override getQuery(): string {
let options: ICreateIndexQueryParams = this.$options;
return `
CREATE INDEX IF NOT EXISTS ${this.$sanitize(options.indexName)}
ON ${this.$sanitize(options.tableName)} (${this.$sanitize(options.columnName)})
`;
}
}
|