gta_sql_create_table: Create a new table in your SQL database.

Description Usage Arguments Author(s) References

View source: R/gta_sql_create_table.R

Description

Creates a data table with the name of your dataframe. Uploads the data frame thereafter.

Usage

1
2
3
4
gta_sql_create_table(write.df = NULL, create.primary.key = NULL,
  create.primary.auto.incr = F, create.foreign.key = NULL,
  create.foreign.key.parent = NULL, create.foreign.key.del.cascade = T,
  append.existing = T, db.connection = "pool")

Arguments

write.df

The name of the data frame (in quotes) you want to add.

create.primary.key

Name of the column that is the primary key. Can only be one. GTA or SQL naming is fine.

create.primary.auto.incr

Do you want the primary key to be auto incrementing? Default is TRUE.

create.foreign.key

Vector with names of columns that are foreign keys. Can use GTA or SQL naming.

create.foreign.key.parent

On what table is the foreign key the primary key?

create.foreign.key.del.cascade

What happens to the lines of foreign key if a value is deleted from the primary key is deleted. Default is that they are removed as well.

db.connection

Specify the database connection you want to use. Default is 'pool'.

Author(s)

Global Trade Alert

References

www.globaltradealert.org


patrickbuess/gtasql_temp documentation built on Nov. 5, 2019, 12:14 a.m.