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-adapter.js (1202B)

/// <reference types="./mssql-adapter.d.ts" />
import { DEFAULT_MIGRATION_TABLE } from '../../migration/migrator.js';
import { sql } from '../../raw-builder/sql.js';
import { DialectAdapterBase } from '../dialect-adapter-base.js';
export class MssqlAdapter extends DialectAdapterBase {
    get supportsCreateIfNotExists() {
        return false;
    }
    get supportsTransactionalDdl() {
        return true;
    }
    get supportsOutput() {
        return true;
    }
    async acquireMigrationLock(db) {
        // Acquire a transaction-level exclusive lock on the migrations table.
        // https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-getapplock-transact-sql?view=sql-server-ver16
        await sql `exec sp_getapplock @DbPrincipal = ${sql.lit('dbo')}, @Resource = ${sql.lit(DEFAULT_MIGRATION_TABLE)}, @LockMode = ${sql.lit('Exclusive')}`.execute(db);
    }
    async releaseMigrationLock() {
        // Nothing to do here. `sp_getapplock` is automatically released at the
        // end of the transaction and since `supportsTransactionalDdl` true, we know
        // the `db` instance passed to acquireMigrationLock is actually a transaction.
    }
}

/// import { DEFAULT_MIGRATION_TABLE } from '../../migration/migrator.js'; import { sql } from '../../raw-builder/sql.js'; import { DialectAdapterBase } from '../dialect-adapter-base.js'; export class MssqlAdapter extends DialectAdapterBase { get supportsCreateIfNotExists() { return false; } get supportsTransactionalDdl() { return true; } get supportsOutput() { return true; } async acquireMigrationLock(db) { // Acquire a transaction-level exclusive lock on the migrations table. // https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-getapplock-transact-sql?view=sql-server-ver16 await sql `exec sp_getapplock @DbPrincipal = ${sql.lit('dbo')}, @Resource = ${sql.lit(DEFAULT_MIGRATION_TABLE)}, @LockMode = ${sql.lit('Exclusive')}`.execute(db); } async releaseMigrationLock() { // Nothing to do here. `sp_getapplock` is automatically released at the // end of the transaction and since `supportsTransactionalDdl` true, we know // the `db` instance passed to acquireMigrationLock is actually a transaction. } }