dbRClmnsClassesEM: Given a Server Table, Of Its Fields, Get the Equivalent R...

In AndreMikulec/econModel: Meaningful Social and Economic Data from ALFRED and elsewhere

Description

R Classes depend upon what the server supports. SQLite R equivalents typically are "character", "integer", and "real". PostgreSQL R equivalents typically are "character", "integer", "numeric/double", "logical", "Date", (and may be others: POSIXct?).

Usage

dbRClmnsClassesEM(
  connName,
  name,
  temporary = FALSE,
  env,
  display = TRUE,
  exec = TRUE
)

Arguments

connName	String. Default is "connEM". Contains the name of the variable that contains the name of the "connection" in the environment "env".
name	Table name string, length 1-2. Requires at least one row.
temporary	Logical. This is a temporary table or not.
env	Environment. Default is the .Global environment. This is the environment to return the connection object "connEM".
display	Logical. Whether to display the query (defaults to TRUE).
exec	Logical. Whether to execute the query (defaults to TRUE).

Value

data.frame. Variables are "NAME" and "TYPE". If the number of rows in "NAME" is zero, then, instead of "numeric" being returned, "double" is returned. The reason is because a "fallback" is used.

AndreMikulec/econModel documentation built on June 30, 2021, 9:48 a.m.