how i get this running locally with docker

[seankross]

just throwing this here, maybe it's worth putting in a doc somewhere some day

library(RPostgres)
library(dplyr)
library(dbplyr)
library(tibble)
library(rls)

# docker pull postgres

# docker run --name my_postgres -e POSTGRES_USER=myuser -e POSTGRES_PASSWORD=mypassword -e POSTGRES_DB=mydatabase -p 5432:5432 -d postgres

Sys.setenv(
  "PGHOST" = "localhost",
  "PGPORT" = 5432,
  "PGUSER" = "myuser",
  "PGPASSWORD" = "mypassword",
  "PGDATABASE" = "mydatabase"
)

con <- dbConnect(
  RPostgres::Postgres(),
  dbname = Sys.getenv("PGDATABASE"),
  host = Sys.getenv("PGHOST"),
  port = Sys.getenv("PGPORT"),
  user = Sys.getenv("PGUSER"),
  password = Sys.getenv("PGPASSWORD")
)

dbListTables(con)

devtools::test()

covr::report()