## ----include = FALSE----------------------------------------------------------
knitr::opts_chunk$set(
  collapse = TRUE,
  comment = "#>"
)

## ----eval=FALSE---------------------------------------------------------------
# # From GitHub:
# # install.packages("remotes")
# remotes::install_github("HealthInformaticsUT/syrona")

## ----eval=FALSE---------------------------------------------------------------
# library(syrona)
# 
# # PostgreSQL (the typical production CDM; e.g. via SSH tunnel).
# # Omit `password` and set PGPASSWORD in ~/.Renviron, or use ~/.pgpass.
# db <- syrona_connect_pg(
#   dbname = "omop",
#   user = "analyst",
#   cdm_schema = "cdm",
#   write_schema = "results_analyst"
# )
# 
# # Or a local DuckDB file (read-only by default)
# db <- syrona_connect("path/to/omop.duckdb")

## ----eval=FALSE---------------------------------------------------------------
# # Extract all three domains
# tables <- extract_all("Dataset_A", db = db)
# 
# # Or a single domain (faster for large databases)
# tables <- extract_all("Dataset_A", db = db, domains = "conditions")

## ----eval=FALSE---------------------------------------------------------------
# # After extracting both datasets:
# compare_all("Dataset_A", "Dataset_B")

## ----eval=FALSE---------------------------------------------------------------
# syrona_disconnect(db)