Function execute

src/lib/connectors/mssql/index.ts:35–46

(connection: Connection, databaseName: string, statement: string)

};

const execute = async (connection: Connection, databaseName: string, statement: string): Promise<any> => {
  const pool = await getMSSQLConnection(connection);
  const request = pool.request();
  const result = await request.query(`USE ${databaseName}; ${statement}`);
  await pool.close();

  const executionResult: ExecutionResult = {
    rawResult: result.recordset,
    affectedRows: result.rowsAffected.length,
  };
  return executionResult;
};

const getDatabases = async (connection: Connection): Promise<string[]> => {
  const pool = await getMSSQLConnection(connection);