Function getDatabases

src/lib/connectors/mysql/index.ts:71–85

(connection: Connection)

};

const getDatabases = async (connection: Connection): Promise<string[]> => {
  const conn = await getMySQLConnection(connection);
  const [rows] = await conn.query<RowDataPacket[]>(
    `SELECT schema_name as db_name FROM information_schema.schemata WHERE schema_name NOT IN (?);`,
    [systemDatabases]
  );
  conn.destroy();
  const databaseList = [];
  for (const row of rows) {
    if (row["db_name"]) {
      databaseList.push(row["db_name"]);
    }
  }
  return databaseList;
};

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