Skip to contents

Compare two fingerprints of a database

Usage

compare_fingerprints(here, other)

Arguments

here, other

Fingerprints from db_fingerprint() (data frames, or paths of CSV files where they were saved).

Value

A data.table with table, n_rows_here, n_rows_other and status: "identical", "different content" (same rows count), "different row count", "missing here" or "missing in other".

See also

Other fingerprints: db_fingerprint()

Examples

a <- data.frame(table = c("document", "author"), n_rows = c(2, 3), hash = c("1", "2"))
b <- data.frame(table = c("document", "text"), n_rows = c(2, 9), hash = c("9", "4"))
compare_fingerprints(a, b)
#> ! 3 tables differ.
#>       table n_rows_here n_rows_other            status
#>      <char>       <num>        <num>            <char>
#> 1:   author           3           NA  missing in other
#> 2: document           2            2 different content
#> 3:     text          NA            9      missing here