Index

C

case_insensitive_collation (sqlcompyre.analysis.dialects.DialectProtocol attribute) (sqlcompyre.analysis.dialects.duckdb.DuckDBDialect attribute) (sqlcompyre.analysis.dialects.mssql.MssqlDialect attribute) (sqlcompyre.analysis.dialects.sqlite.SQLiteDialect attribute) case_sensitive_collation (sqlcompyre.analysis.dialects.DialectProtocol attribute) (sqlcompyre.analysis.dialects.duckdb.DuckDBDialect attribute) (sqlcompyre.analysis.dialects.mssql.MssqlDialect attribute) (sqlcompyre.analysis.dialects.sqlite.SQLiteDialect attribute) column_matches (sqlcompyre.analysis.table_comparison.TableComparison property), [1] (sqlcompyre.analysis.TableComparison property) column_names (sqlcompyre.analysis.table_comparison.TableComparison property), [1] (sqlcompyre.analysis.TableComparison property) column_stats() (sqlcompyre.analysis.query_inspection.QueryInspection method), [1] (sqlcompyre.analysis.QueryInspection method) ColumnMatches (class in sqlcompyre.results), [1] (class in sqlcompyre.results.column_matches)

ColumnStats (class in sqlcompyre.analysis.query_inspection) compare_matched_table() (sqlcompyre.analysis.schema_comparison.SchemaComparison method), [1] (sqlcompyre.analysis.SchemaComparison method) compare_schemas() (in module sqlcompyre), [1] (in module sqlcompyre.api) compare_tables() (in module sqlcompyre), [1] (in module sqlcompyre.api) Config (class in sqlcompyre) (class in sqlcompyre.config) (class in sqlcompyre.config.model) content (sqlcompyre.report.schema.schema.Section attribute) (sqlcompyre.report.schema.Section attribute) Counts (class in sqlcompyre.results), [1] (class in sqlcompyre.results.counts)

D

description (sqlcompyre.report.schema.Metadata attribute) (sqlcompyre.report.schema.schema.Metadata attribute) DialectProtocol (class in sqlcompyre.analysis.dialects) diff (sqlcompyre.results.Counts property), [1] (sqlcompyre.results.counts.Counts property)

distinct_row_count() (sqlcompyre.analysis.query_inspection.QueryInspection method), [1] (sqlcompyre.analysis.QueryInspection method) DuckDBDialect (class in sqlcompyre.analysis.dialects.duckdb)

E

equal (sqlcompyre.analysis.table_comparison.TableComparison property), [1] (sqlcompyre.analysis.TableComparison property) (sqlcompyre.results.Counts property), [1] (sqlcompyre.results.counts.Counts property) (sqlcompyre.results.Names property), [1] (sqlcompyre.results.names.Names property)

F

file_extension (sqlcompyre.report.formatters._base.Formatter property) (sqlcompyre.report.formatters.Formatter property) (sqlcompyre.report.formatters.terminal.TerminalFormatter property), [1] (sqlcompyre.report.formatters.TerminalFormatter property) FileWriter (class in sqlcompyre.report.writers) (class in sqlcompyre.report.writers.file), [1] format() (sqlcompyre.report.formatters._base.Formatter method) (sqlcompyre.report.formatters.Formatter method) (sqlcompyre.report.formatters.terminal.TerminalFormatter method), [1] (sqlcompyre.report.formatters.TerminalFormatter method) (sqlcompyre.report.Report method) (sqlcompyre.report.report.Report method), [1]

Formatter (class in sqlcompyre.report.formatters) (class in sqlcompyre.report.formatters._base) fraction_left (sqlcompyre.results.Counts property), [1] (sqlcompyre.results.counts.Counts property) fraction_right (sqlcompyre.results.Counts property), [1] (sqlcompyre.results.counts.Counts property) fraction_same (sqlcompyre.results.column_matches.ColumnMatches attribute) (sqlcompyre.results.ColumnMatches attribute), [1]

G

gain_left (sqlcompyre.results.Counts property), [1] (sqlcompyre.results.counts.Counts property) gain_right (sqlcompyre.results.Counts property), [1] (sqlcompyre.results.counts.Counts property) get_formatter() (in module sqlcompyre.report.formatters) (in module sqlcompyre.report.formatters._factory)

get_table_creation_timestamps() (sqlcompyre.analysis.dialects.DialectProtocol method) (sqlcompyre.analysis.dialects.mssql.MssqlDialect method) get_top_changes() (sqlcompyre.analysis.table_comparison.TableComparison method), [1] (sqlcompyre.analysis.TableComparison method) get_writer() (in module sqlcompyre.report.writers)

I

ignore_table_columns (sqlcompyre.Config attribute) (sqlcompyre.config.Config attribute) (sqlcompyre.config.model.Config attribute) ignore_tables (sqlcompyre.Config attribute) (sqlcompyre.config.Config attribute) (sqlcompyre.config.model.Config attribute)

in_common (sqlcompyre.results.Names property), [1] (sqlcompyre.results.names.Names property) inspect() (in module sqlcompyre) (in module sqlcompyre.api) inspect_table() (in module sqlcompyre), [1] (in module sqlcompyre.api)

J

join_columns (sqlcompyre.analysis.table_comparison.TableComparison property), [1] (sqlcompyre.analysis.TableComparison property) joined_equal (sqlcompyre.results.row_matches.RowMatches attribute) (sqlcompyre.results.RowMatches attribute), [1]

joined_total (sqlcompyre.results.row_matches.RowMatches attribute) (sqlcompyre.results.RowMatches attribute), [1] joined_unequal (sqlcompyre.results.row_matches.RowMatches attribute) (sqlcompyre.results.RowMatches attribute), [1]

L

left (sqlcompyre.results.Counts attribute), [1] (sqlcompyre.results.counts.Counts attribute) (sqlcompyre.results.Names property), [1] (sqlcompyre.results.names.Names property)

M

MarkdownWriter (class in sqlcompyre.report.writers) (class in sqlcompyre.report.writers.markdown) max (sqlcompyre.analysis.query_inspection.ColumnStats property) Metadata (class in sqlcompyre.report.schema) (class in sqlcompyre.report.schema.schema) min (sqlcompyre.analysis.query_inspection.ColumnStats property) mismatch_selects (sqlcompyre.results.column_matches.ColumnMatches attribute) (sqlcompyre.results.ColumnMatches attribute), [1] missing_left (sqlcompyre.results.Names property), [1] (sqlcompyre.results.names.Names property) missing_right (sqlcompyre.results.Names property), [1] (sqlcompyre.results.names.Names property) model_config (sqlcompyre.Config attribute) (sqlcompyre.config.Config attribute) (sqlcompyre.config.model.Config attribute) module sqlcompyre sqlcompyre.analysis sqlcompyre.analysis.dialects sqlcompyre.analysis.dialects.duckdb sqlcompyre.analysis.dialects.mssql sqlcompyre.analysis.dialects.sqlite sqlcompyre.analysis.query_inspection sqlcompyre.analysis.schema_comparison sqlcompyre.analysis.table_comparison sqlcompyre.api sqlcompyre.cli sqlcompyre.config sqlcompyre.config.model sqlcompyre.config.validation sqlcompyre.report sqlcompyre.report.formatters, [1] sqlcompyre.report.formatters.terminal sqlcompyre.report.formatters.text sqlcompyre.report.report sqlcompyre.report.schema sqlcompyre.report.schema.schema sqlcompyre.report.writers, [1] sqlcompyre.report.writers.file sqlcompyre.report.writers.markdown sqlcompyre.report.writers.stdout sqlcompyre.results sqlcompyre.results.column_matches sqlcompyre.results.counts sqlcompyre.results.names sqlcompyre.results.row_matches

MssqlDialect (class in sqlcompyre.analysis.dialects.mssql)

N

n_joined_equal (sqlcompyre.results.row_matches.RowMatches attribute) (sqlcompyre.results.RowMatches attribute), [1] n_joined_total (sqlcompyre.results.row_matches.RowMatches attribute) (sqlcompyre.results.RowMatches attribute), [1] n_joined_unequal (sqlcompyre.results.row_matches.RowMatches attribute) (sqlcompyre.results.RowMatches attribute), [1] n_unjoined_left (sqlcompyre.results.row_matches.RowMatches attribute) (sqlcompyre.results.RowMatches attribute), [1] n_unjoined_right (sqlcompyre.results.row_matches.RowMatches attribute) (sqlcompyre.results.RowMatches attribute), [1]

name (sqlcompyre.analysis.dialects.DialectProtocol attribute) (sqlcompyre.analysis.dialects.duckdb.DuckDBDialect attribute) (sqlcompyre.analysis.dialects.mssql.MssqlDialect attribute) (sqlcompyre.analysis.dialects.sqlite.SQLiteDialect attribute) (sqlcompyre.report.schema.schema.Section attribute) (sqlcompyre.report.schema.Section attribute) Names (class in sqlcompyre.results), [1] (class in sqlcompyre.results.names)

O

object_1 (sqlcompyre.report.schema.Metadata attribute) (sqlcompyre.report.schema.schema.Metadata attribute) object_2 (sqlcompyre.report.schema.Metadata attribute) (sqlcompyre.report.schema.schema.Metadata attribute)

object_type (sqlcompyre.report.schema.Metadata attribute) (sqlcompyre.report.schema.schema.Metadata attribute)

Q

QueryInspection (class in sqlcompyre.analysis) (class in sqlcompyre.analysis.query_inspection), [1]

R

read_config() (in module sqlcompyre.config) (in module sqlcompyre.config.validation) Report (class in sqlcompyre.report) (class in sqlcompyre.report.report), [1] right (sqlcompyre.results.Counts attribute), [1] (sqlcompyre.results.counts.Counts attribute) (sqlcompyre.results.Names property), [1] (sqlcompyre.results.names.Names property)

row_count (sqlcompyre.analysis.query_inspection.QueryInspection property), [1] (sqlcompyre.analysis.QueryInspection property) row_counts (sqlcompyre.analysis.table_comparison.TableComparison property), [1] (sqlcompyre.analysis.TableComparison property) row_matches (sqlcompyre.analysis.table_comparison.TableComparison property), [1] (sqlcompyre.analysis.TableComparison property) RowMatches (class in sqlcompyre.results), [1] (class in sqlcompyre.results.row_matches)

S

SchemaComparison (class in sqlcompyre.analysis) (class in sqlcompyre.analysis.schema_comparison), [1] Section (class in sqlcompyre.report.schema) (class in sqlcompyre.report.schema.schema) sqlcompyre module sqlcompyre.analysis module sqlcompyre.analysis.dialects module sqlcompyre.analysis.dialects.duckdb module sqlcompyre.analysis.dialects.mssql module sqlcompyre.analysis.dialects.sqlite module sqlcompyre.analysis.query_inspection module sqlcompyre.analysis.schema_comparison module sqlcompyre.analysis.table_comparison module sqlcompyre.api module sqlcompyre.cli module sqlcompyre.config module sqlcompyre.config.model module sqlcompyre.config.validation module sqlcompyre.report module sqlcompyre.report.formatters module, [1] sqlcompyre.report.formatters.terminal module sqlcompyre.report.formatters.text module

sqlcompyre.report.report module sqlcompyre.report.schema module sqlcompyre.report.schema.schema module sqlcompyre.report.writers module, [1] sqlcompyre.report.writers.file module sqlcompyre.report.writers.markdown module sqlcompyre.report.writers.stdout module sqlcompyre.results module sqlcompyre.results.column_matches module sqlcompyre.results.counts module sqlcompyre.results.names module sqlcompyre.results.row_matches module SQLiteDialect (class in sqlcompyre.analysis.dialects.sqlite) StdoutWriter (class in sqlcompyre.report.writers) (class in sqlcompyre.report.writers.stdout), [1] summary_report() (sqlcompyre.analysis.schema_comparison.SchemaComparison method), [1] (sqlcompyre.analysis.SchemaComparison method) (sqlcompyre.analysis.table_comparison.TableComparison method), [1] (sqlcompyre.analysis.TableComparison method) supports_multi_part_schemas (sqlcompyre.analysis.dialects.DialectProtocol attribute) (sqlcompyre.analysis.dialects.duckdb.DuckDBDialect attribute) (sqlcompyre.analysis.dialects.mssql.MssqlDialect attribute) (sqlcompyre.analysis.dialects.sqlite.SQLiteDialect attribute) supports_schemas (sqlcompyre.analysis.dialects.DialectProtocol attribute) (sqlcompyre.analysis.dialects.duckdb.DuckDBDialect attribute) (sqlcompyre.analysis.dialects.mssql.MssqlDialect attribute) (sqlcompyre.analysis.dialects.sqlite.SQLiteDialect attribute) supports_statement_cache (sqlcompyre.analysis.dialects.mssql.MssqlDialect attribute)

T

table_counts (sqlcompyre.analysis.schema_comparison.SchemaComparison property), [1] (sqlcompyre.analysis.SchemaComparison property) table_names (sqlcompyre.analysis.schema_comparison.SchemaComparison property), [1] (sqlcompyre.analysis.SchemaComparison property) table_reports() (sqlcompyre.analysis.schema_comparison.SchemaComparison method), [1] (sqlcompyre.analysis.SchemaComparison method)

TableComparison (class in sqlcompyre.analysis) (class in sqlcompyre.analysis.table_comparison), [1] TerminalFormatter (class in sqlcompyre.report.formatters) (class in sqlcompyre.report.formatters.terminal), [1] TextFormatter (class in sqlcompyre.report.formatters) (class in sqlcompyre.report.formatters.text)

U

unjoined_left (sqlcompyre.results.row_matches.RowMatches attribute) (sqlcompyre.results.RowMatches attribute), [1]

unjoined_right (sqlcompyre.results.row_matches.RowMatches attribute) (sqlcompyre.results.RowMatches attribute), [1]

V

verbose_name (sqlcompyre.analysis.dialects.DialectProtocol attribute) (sqlcompyre.analysis.dialects.duckdb.DuckDBDialect attribute) (sqlcompyre.analysis.dialects.mssql.MssqlDialect attribute) (sqlcompyre.analysis.dialects.sqlite.SQLiteDialect attribute)

views_support_notnull_columns (sqlcompyre.analysis.dialects.DialectProtocol attribute) (sqlcompyre.analysis.dialects.duckdb.DuckDBDialect attribute) (sqlcompyre.analysis.dialects.mssql.MssqlDialect attribute) (sqlcompyre.analysis.dialects.sqlite.SQLiteDialect attribute)

W

write() (sqlcompyre.report.writers._base.Writer method) (sqlcompyre.report.writers.file.FileWriter method), [1] (sqlcompyre.report.writers.FileWriter method) (sqlcompyre.report.writers.markdown.MarkdownWriter method) (sqlcompyre.report.writers.MarkdownWriter method) (sqlcompyre.report.writers.stdout.StdoutWriter method), [1] (sqlcompyre.report.writers.StdoutWriter method) (sqlcompyre.report.writers.Writer method)

Writer (class in sqlcompyre.report.writers) (class in sqlcompyre.report.writers._base)