FM / mssql

/opt/canhelp/node_modules/kysely/dist/esm/dialect/mssql/

/opt/canhelp/node_modules/kysely/dist/esm/dialect/mssql

Name	Size	Mode	Actions
mssql-adapter.d.ts	3795	0644	edit dl rm
mssql-adapter.js	1202	0644	edit dl rm
mssql-dialect-config.d.ts	6716	0644	edit dl rm
mssql-dialect-config.js	65	0644	edit dl rm
mssql-dialect.d.ts	2020	0644	edit dl rm
mssql-dialect.js	1521	0644	edit dl rm
mssql-driver.d.ts	2447	0644	edit dl rm
mssql-driver.js	12632	0644	edit dl rm
mssql-introspector.d.ts	747	0644	edit dl rm
mssql-introspector.js	5395	0644	edit dl rm
mssql-query-compiler.d.ts	1134	0644	edit dl rm
mssql-query-compiler.js	2842	0644	edit dl rm

Edit: /opt/canhelp/node_modules/kysely/dist/esm/dialect/mssql/mssql-query-compiler.js (2842B)

/// <reference types="./mssql-query-compiler.d.ts" />
import { DefaultQueryCompiler } from '../../query-compiler/default-query-compiler.js';
const COLLATION_CHAR_REGEX = /^[a-z0-9_]$/i;
export class MssqlQueryCompiler extends DefaultQueryCompiler {
    getCurrentParameterPlaceholder() {
        return `@${this.numParameters}`;
    }
    visitOffset(node) {
        super.visitOffset(node);
        this.append(' rows');
    }
    // mssql allows multi-column alterations in a single statement,
    // but you can only use the command keyword/s once.
    // it also doesn't support multiple kinds of commands in the same
    // alter table statement, but we compile that anyway for the sake
    // of WYSIWYG.
    compileColumnAlterations(columnAlterations) {
        const nodesByKind = {};
        for (const columnAlteration of columnAlterations) {
            if (!nodesByKind[columnAlteration.kind]) {
                nodesByKind[columnAlteration.kind] = [];
            }
            nodesByKind[columnAlteration.kind].push(columnAlteration);
        }
        let first = true;
        if (nodesByKind.AddColumnNode) {
            this.append('add ');
            this.compileList(nodesByKind.AddColumnNode);
            first = false;
        }
        // multiple of these are not really supported by mssql,
        // but for the sake of WYSIWYG.
        if (nodesByKind.AlterColumnNode) {
            if (!first)
                this.append(', ');
            this.compileList(nodesByKind.AlterColumnNode);
        }
        if (nodesByKind.DropColumnNode) {
            if (!first)
                this.append(', ');
            this.append('drop column ');
            this.compileList(nodesByKind.DropColumnNode);
        }
        // not really supported by mssql, but for the sake of WYSIWYG.
        if (nodesByKind.ModifyColumnNode) {
            if (!first)
                this.append(', ');
            this.compileList(nodesByKind.ModifyColumnNode);
        }
        // not really supported by mssql, but for the sake of WYSIWYG.
        if (nodesByKind.RenameColumnNode) {
            if (!first)
                this.append(', ');
            this.compileList(nodesByKind.RenameColumnNode);
        }
    }
    visitAddColumn(node) {
        this.visitNode(node.column);
    }
    visitDropColumn(node) {
        this.visitNode(node.column);
    }
    visitMergeQuery(node) {
        super.visitMergeQuery(node);
        this.append(';');
    }
    visitCollate(node) {
        this.append('collate ');
        const { name } = node.collation;
        for (const char of name) {
            if (!COLLATION_CHAR_REGEX.test(char)) {
                throw new Error(`Invalid collation: ${name}`);
            }
        }
        this.append(name);
    }
    announcesNewColumnDataType() {
        return false;
    }
}

cmd: