write_db_fields_csv: Writes the csv file that is formatted according to the...

In N1h1l1sT/dbautojoinr: Automatic Joining of SQL Tables

Description

Creates a .csv file with columns: KeyType, Table, Column, Type, Comment, RelationshipWithTable, RelationshipWithColumn, Transformation

Usage

write_db_fields_csv(db_fields, csv_path, Update_DBEnv_DBFields = FALSE)

Arguments

db_fields	A DF. A dataframe formatted according to the db_fields standard.
csv_path	A String. The path of the db_fields .csv file.
Update_DBEnv_DBFields	A Boolean. If set to TRUE, you can have an internal main db_fields accessible via db$db_fields usually acting as the main db_fields. Default is FALSE as having local db_fields variables is the default behaviour.

Examples

Example 1:
db_fields <- zinternal_create_default_db_fields_from_db_con(csv_path)
write_db_fields_csv(db_fields, "db_fields.csv")

Example 2:
db_fields <- read_db_fields_csv("db_fields.csv")
write_db_fields_csv(db_fields, "db_fields.csv")

N1h1l1sT/dbautojoinr documentation built on Jan. 24, 2021, 10:15 a.m.