Input_db-class: Inputs loaded in the data preparation program from data...

In Pablo-Lopez-Sfi/dependenciesMap: Create objects in order to map dependencies in scripts

Description

Inputs loaded in the data preparation program from data base's tables

Fields

conn

: connection of the data base

query

: query

process

: process where input is loaded in the data preparation program (to be added by user)

table

: name of the data base's table used to get the data (to be added by the user)

Methods

f_dbGetQuery(...)

function dbGetQuery() from DBI package

By default : dbGetQuery( conn, query, ... )

Example

par_loc <- dbGetQuery( SCDatabase, 'select * from PAR_LOC_geoMapping' ) is now replaced by

par_loc <- Input_db( conn = SCDataBase, query = 'select * from PAR_LOC_geoMapping', process = 'SLA', table = 'PAR_LOC_geoMapping')$f_dbGetQuery()

Pablo-Lopez-Sfi/dependenciesMap documentation built on June 30, 2020, 2:53 p.m.