FakeDataR (version 0.2.2)

schema_from_db: Extract a table schema from a DB connection

Description

Returns a data frame describing the columns of a database table.

Usage

schema_from_db(conn, table, level = c("medium", "low", "high"))

Value

A data.frame with column metadata (e.g., name, type).

Arguments

conn

A DBI connection.

table

Character scalar: table name to introspect.

level

Privacy preset to annotate in schema metadata: one of "low", "medium", "high". Default "medium".

Examples

if (requireNamespace("DBI", quietly = TRUE) &&
    requireNamespace("RSQLite", quietly = TRUE)) {
  con <- DBI::dbConnect(RSQLite::SQLite(), ":memory:")
  on.exit(DBI::dbDisconnect(con), add = TRUE)
  DBI::dbWriteTable(con, "mtcars", mtcars[1:3, ])
  sc <- schema_from_db(con, "mtcars")
  head(sc)
}