dfServerFieldsClassesEM: Given an R data.frame, Get The Equivalent Database Server...

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

Description

Given an R data.frame, Get The Equivalent Database Server Column Types If a data.frame would be promoted to be on a database server, then these would be the equivalent Server datatypes.

Usage

dfServerFieldsClassesEM(connName, value, env, exec = TRUE, display = TRUE)

Arguments

connName	String. Default is "connEM". Contains the name of the variable that contains the name of the "connection" in the environment "env".
value	data.frame
env	Environment. Default is the .Global environment. This is the environment to return the connection object "connEM".
exec	Logical. Whether to execute the query (defaults to TRUE).
display	Logical. Whether to display the query (defaults to TRUE).

Details

typical SQLite results of TYPE values:
"TEXT"  "REAL" "INTEGER"

typical PostgreSQL results of TYPE values:
"text"  "float8" "bool"  "integer" "date"

Value

data.frame. Variables are "name" and "type"

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