Py Upload data.frame

Wrapper to python function to upload a data.frame using Postgres Copy functionality

Usage

pyUploadDataFrame(data, connection, table, schema)

Arguments

data

data.frame

connection

DatabaseConnector connection instance

table

Table in database

schema

database schema containing table reference

Examples

if (FALSE) { # \dontrun{
connection <- DabaseConnector::connect(
  dbms = "postgreql",
  server = "myserver.com",
  port = 5432,
  password = "s",
  user = "me",
  database = "some_db"
)

ResultModelManager::pyUploadDataFrame(connection,
  table = "my_table",
  data.frame(id = 1:100, value = "some_value"),
  schema = "my_schema"
)
} # }