RowMatches

class sqlcompyre.results.RowMatches(n_unjoined_left: int, n_unjoined_right: int, n_joined_equal: int, n_joined_unequal: int, n_joined_total: int, unjoined_left: Select, unjoined_right: Select, joined_equal: Select, joined_unequal: Select, joined_total: Select)

Investigate (un-)matched rows between database tables.

joined_equal: Select

Query for obtaining all rows that could be joined and were identical across the two tables.

joined_total: Select

Query for obtaining all rows that were joined, regardless of equality.

joined_unequal: Select

Query for obtaining all rows that could be joined but were not identical.

n_joined_equal: int

Number of rows that were joined for which the values in both tables were identical

n_joined_total: int

Number of rows that could be joined

n_joined_unequal: int

Number of rows that were joined for which the values in both tables were not identical

n_unjoined_left: int

Number of columns in the left table that could not be joined

n_unjoined_right: int

Number of columns in the right table that could not be joined

unjoined_left: Select

Query for obtaining all rows from the left table that could not be joined.

unjoined_right: Select

Query for obtaining all rows from the right table that could not be joined.