Generate AML from PostgreSQL documentation

pg_catalog_schema.js

// to execute in the console of https://www.postgresql.org/docs/current/catalog-pg-class.html
// and paste the copied result into https://azimutt.app ;)
function generateTableAml() {
  const url = window.location.href
  const table_schema = 'pg_catalog'
  const table_name = document.querySelector('h2.title .structname').textContent
  const table_description = document.querySelector('p').textContent
  const column_rows = Array.from(document.querySelector('.table-contents').querySelectorAll('tbody tr'))
  const columns = column_rows.map(r => {
    return {
      name: r.querySelector('.structfield').textContent,
      type: r.querySelector('.type').textContent,
      description: r.querySelectorAll('p')[1].textContent
    }
  })
  const relations = column_rows.flatMap(r => {
    const rel_table = r.querySelector('.column_definition .structname')?.textContent
    if (rel_table) {
      return [{
        from: r.querySelector('.structfield').textContent,
        to_table: rel_table, 
        to_column: r.querySelectorAll('.column_definition .structfield')[1].textContent
      }]
    } else {
      return []
    }
  })
  return `${table_schema}.${table_name} | ${table_description}\\n${url}` 
    + `${columns.map(c => `\n  ${c.name} ${c.type} | ${c.description}`).join('')}` 
    + `${relations.map(r => `\nfk ${table_schema}.${table_name}.${r.from} -> ${table_schema}.${r.to_table}.${r.to_column}`).join('')}`
}
copy(generateTableAml())