Take a csv schema definition and create a basic sql script with it. returns string containing the sql for the table
generateSqlSchema(
csvFilepath = NULL,
schemaDefinition = NULL,
sqlOutputPath = NULL,
overwrite = FALSE
)Arguments
- csvFilepath
Path to schema file. Csv file must have the columns: "table_name", "column_name", "data_type", "primary_key"
- schemaDefinition
A schemaDefintiion data.frame` with the columns: tableName, columnName, dataType, isRequired, primaryKey
- sqlOutputPath
File to write sql to.
- overwrite
Boolean - overwrite existing file?