sqlcompyre.results.column_matches module

class sqlcompyre.results.column_matches.ColumnMatches(fraction_same: dict[str, float], mismatch_selects: dict[str, Select])[source]

Bases: object

Investigate column value changes between database tables.

fraction_same: dict[str, float]: Dictionary mapping the name of the left-table column to the fraction of joined rows for which that column has the same value in both tables.

mismatch_selects: dict[str, Select]: Dictionary mapping the name of the left-table column to a query of all joined rows for which the column does not have the same value in both tables.