Build a join plan

Please see vignette('DependencySorting', package = 'replyr') and vignette('joinController', package= 'replyr') for more details.

buildJoinPlan(tDesc, ..., check = TRUE)

Arguments

tDesc	description of tables from tableDescription (and likely altered by user). Note: no column names must intersect with names of the form table_CLEANEDTABNAME_present.
...	force later arguments to bind by name.
check	logical, if TRUE check the join plan for consistency.

Value

detailed column join plan (appropriate for editing)

See also

tableDescription, inspectDescrAndJoinPlan, makeJoinDiagramSpec, executeLeftJoinPlan

Examples

d <- data.frame(id=1:3, weight= c(200, 140, 98))
tDesc <- rbind(tableDescription('d1', d),
               tableDescription('d2', d))
#> Warning: `data_frame()` is deprecated as of tibble 1.1.0.
#> Please use `tibble()` instead.
#> This warning is displayed once every 8 hours.
#> Call `lifecycle::last_warnings()` to see where this warning was generated.
tDesc$keys[[1]] <- list(PrimaryKey= 'id')
tDesc$keys[[2]] <- list(PrimaryKey= 'id')
buildJoinPlan(tDesc)
#> # A tibble: 4 x 6
#>   tableName sourceColumn sourceClass resultColumn isKey want 
#>   <chr>     <chr>        <chr>       <chr>        <lgl> <lgl>
#> 1 d1        id           integer     PrimaryKey   TRUE  TRUE 
#> 2 d1        weight       numeric     d1_weight    FALSE TRUE 
#> 3 d2        id           integer     PrimaryKey   TRUE  TRUE 
#> 4 d2        weight       numeric     d2_weight    FALSE TRUE