Function getDatabases

src/lib/connectors/mssql/index.ts:48–60

(connection: Connection)

};

const getDatabases = async (connection: Connection): Promise<string[]> => {
  const pool = await getMSSQLConnection(connection);
  const request = pool.request();
  const result = await request.query(`SELECT name FROM sys.databases WHERE name NOT IN ('${systemDatabases.join("','")}');`);
  await pool.close();
  const databaseList = [];
  for (const row of result.recordset) {
    if (row["name"]) {
      databaseList.push(row["name"]);
    }
  }
  return databaseList;
};

const getTableSchema = async (connection: Connection, databaseName: string): Promise<Schema[]> => {
  const pool = await getMSSQLConnection(connection);