_pkgdown.yml

url: https://scotgovanalysis.github.io/RtoSQLServer

template:
  bootstrap: 5
  bslib:
    base_font: {google: "Roboto"}

development:
  mode: auto

authors:
  Tom Wilson:
    html: "Tom Wilson  \
    <a href='mailto:thomas.wilson@gov.scot'>\
    <i class='fas fa-envelope' aria-hidden='true'></i>\
    <span class='visually-hidden'>Email Tom Wilson></span></a>&nbsp;&nbsp;\
    <a href='https://github.com/tomwilsonsco'>\
    <i class='fab fa-github' aria-hidden='true'></i>\
    <span class='visually-hidden'>Tom Wilson GitHub profile></span></a>"
  Scottish Government:
    html: "Scottish Government&nbsp;&nbsp;\
    <a href='mailto:statistics.enquiries@gov.scot'>\
    <i class='fas fa-envelope' aria-hidden='true'></i>\
    <span class='visually-hidden'>Email Scottish Government></span></a>\
    &nbsp;&nbsp;\
    <a href='https://github.com/scotgovanalysis'>\
    <i class='fab fa-github' aria-hidden='true'></i>\
    <span class='visually-hidden'>Scottish Government GitHub profile></span>\
    </a>"
  sidebar:
    roles: [cre, aut]
  footer:
    roles: [cph]
    text: "Developed by the"

navbar:
  components:
    articles:
      text: Articles
      menu:
        - text: Get started
          href: articles/RtoSQLServer.html
        - text: Read table with column or row filtering
          href: articles/read_filter.html
        - text: Table loading method description
          href: articles/load_method.html
        - text: Why use this package?
          href: articles/why_use.html

reference:
  - title: Write
    contents:
      - write_dataframe_to_db

  - title: Read
    contents:
      - read_table_from_db

  - title: Modify
    contents:
      - add_column
      - delete_table_rows
      - drop_column
      - drop_table_from_db
      - rename_table
      - rename_column

  - title: Metadata
    contents:
      - db_table_metadata
      - show_schema_tables

  - title: Database other
    contents:
      - create_sqlserver_connection
      - execute_sql