GoogleCloudPlatform / database-assessment

Intro

For duplication, we look at places in code where there are 6 or more lines of code that are exactly the same.
Before duplication is calculated, the code is cleaned to remove empty lines, comments, and frequently duplicated constructs such as imports.
You should aim at having as little as possible (<5%) of duplicated code as high-level of duplication can lead to maintenance difficulties, poor factoring, and logical contradictions.

Learn more...

Duplication Overall

58% duplication:

23,163 cleaned lines of cleaned code (without empty lines, comments, and frequently duplicated constructs such as imports)
13,561 duplicated lines

1,560 duplicates

dependency graphs: 2D graph | 3D graph | 3D graph (with duplicates)...

Duplication per Extension

Duplication per Component (primary)

Duplication Between Components (50+ lines)

Download: SVG DOT (open online Graphviz editor)

From Component --> To Component	Duplicated Lines	File Pairs	Details
scripts (20%) --> src (33%)	5816	48 file pairs	details...

Open 2D force graph... Open 3D force graph...

Show more details on duplication between components...

Longest Duplicates

The list of 50 longest duplicates.

See data for all 1,560 duplicates...

Size	#	Folders	Files	Lines	Code
812	x 2	src/dma/collector/workfl...adiness_check/_postgres src/dma/collector/workfl...adiness_check/_postgres	constants.py constants.py	204:1015 (44%) 1017:1828 (44%)	view
544	x 2	scripts/collector/mysql/sql src/dma/collector/sql/sources/mysql	config.sql collection-config.sql	22:565 (98%) 23:566 (98%)	view
380	x 2	scripts/collector/postgres/sql src/dma/collector/sql/sources/postgres	aws_extension_dependency.sql collection-aws_extension_dependency.sql	16:395 (97%) 17:396 (97%)	view
222	x 2	scripts/collector/postgres/sql src/dma/collector/sql/sources/postgres	calculated_metrics.sql collection-calculated_metrics.sql	16:237 (96%) 17:238 (96%)	view
177	x 2	scripts/collector/postgres/sql src/dma/collector/sql/sources/postgres	schema_objects.sql collection-schema_objects.sql	16:193 (94%) 17:194 (94%)	view
171	x 2	scripts/collector/mysql/sql src/dma/collector/sql/sources/mysql	schema_objects.sql collection-schema_objects.sql	26:196 (94%) 27:197 (94%)	view
160	x 2	scripts/collector/mysql/sql src/dma/collector/sql/sources/mysql	database_details.sql collection-database_details.sql	22:181 (96%) 23:182 (96%)	view
139	x 2	src/dma/collector/sql/sources/postgres src/dma/collector/sql/sources/postgres	collection-table_details.sql collection-table_details.sql	17:155 (29%) 299:437 (29%)	view
139	x 2	scripts/collector/postgres/sql/13 scripts/collector/postgres/sql/base	table_details.sql table_details.sql	16:154 (100%) 16:154 (100%)	view
124	x 2	scripts/collector/oracle/sql/extracts/statspack scripts/collector/oracle/sql/extracts/statspack	awrhistcmdtypes.sql sqlstats.sql	38:161 (76%) 59:182 (64%)	view
121	x 2	scripts/collector/oracle/sql/extracts/awr scripts/collector/oracle/sql/extracts/statspack	iofunction.sql iofunction.sql	70:190 (69%) 73:193 (68%)	view
120	x 2	src/dma/collector/sql/sources/postgres src/dma/collector/sql/sources/postgres	collection-database_details.sql collection-database_details.sql	129:262 (35%) 253:386 (35%)	view
106	x 2	scripts/collector/postgres/sql/13 src/dma/collector/sql/sources/postgres	table_details.sql collection-table_details.sql	16:121 (76%) 299:404 (22%)	view
106	x 2	scripts/collector/postgres/sql/base src/dma/collector/sql/sources/postgres	table_details.sql collection-table_details.sql	16:121 (76%) 17:122 (22%)	view
106	x 2	scripts/collector/postgres/sql/13 src/dma/collector/sql/sources/postgres	table_details.sql collection-table_details.sql	16:121 (76%) 17:122 (22%)	view
106	x 2	scripts/collector/postgres/sql/base src/dma/collector/sql/sources/postgres	table_details.sql collection-table_details.sql	16:121 (76%) 299:404 (22%)	view
104	x 2	scripts/collector/postgres/sql/12 src/dma/collector/sql/sources/postgres	table_details.sql collection-table_details.sql	16:121 (75%) 158:263 (22%)	view
97	x 2	scripts/collector/mysql/sql src/dma/collector/sql/sources/mysql	table_details.sql collection-table_details.sql	37:133 (82%) 38:134 (82%)	view
95	x 2	src/dma/collector/sql/sources/postgres src/dma/collector/sql/sources/postgres	collection-table_details.sql collection-table_details.sql	100:196 (20%) 241:337 (20%)	view
94	x 2	scripts/collector/postgres/sql/12 scripts/collector/postgres/sql/13	database_details.sql database_details.sql	16:121 (85%) 16:121 (85%)	view
78	x 2	src/dma/collector/sql/sources/mysql src/dma/collector/sql/sources/mysql	collection-database_details.sql collection-table_details.sql	102:179 (47%) 56:133 (66%)	view
78	x 2	scripts/collector/mysql/sql src/dma/collector/sql/sources/mysql	database_details.sql collection-table_details.sql	101:178 (47%) 56:133 (66%)	view
78	x 2	scripts/collector/mysql/sql scripts/collector/mysql/sql	database_details.sql table_details.sql	101:178 (47%) 55:132 (66%)	view
78	x 2	scripts/collector/mysql/sql src/dma/collector/sql/sources/mysql	table_details.sql collection-database_details.sql	55:132 (66%) 102:179 (47%)	view
77	x 2	scripts/collector/postgres/sql/base src/dma/collector/sql/sources/postgres	database_details.sql collection-database_details.sql	16:92 (63%) 17:93 (22%)	view
71	x 2	src/dma/collector/sql/sources/postgres src/dma/collector/sql/sources/postgres	collection-calculated_metrics.sql collection-calculated_metrics.sql	49:119 (31%) 124:194 (31%)	view
71	x 2	scripts/collector/postgres/sql src/dma/collector/sql/sources/postgres	calculated_metrics.sql collection-calculated_metrics.sql	123:193 (31%) 49:119 (31%)	view
71	x 2	scripts/collector/postgres/sql src/dma/collector/sql/sources/postgres	calculated_metrics.sql collection-calculated_metrics.sql	48:118 (31%) 124:194 (31%)	view
71	x 2	scripts/collector/postgres/sql scripts/collector/postgres/sql	calculated_metrics.sql calculated_metrics.sql	48:118 (31%) 123:193 (31%)	view
65	x 2	scripts/collector/postgres/sql/13 src/dma/collector/sql/sources/postgres	database_details.sql collection-database_details.sql	16:92 (59%) 141:217 (19%)	view
65	x 2	scripts/collector/postgres/sql/12 src/dma/collector/sql/sources/postgres	database_details.sql collection-database_details.sql	16:92 (59%) 265:341 (19%)	view
65	x 2	scripts/collector/postgres/sql/13 src/dma/collector/sql/sources/postgres	database_details.sql collection-database_details.sql	16:92 (59%) 265:341 (19%)	view
65	x 2	scripts/collector/postgres/sql/12 src/dma/collector/sql/sources/postgres	database_details.sql collection-database_details.sql	16:92 (59%) 141:217 (19%)	view
62	x 2	scripts/collector/sqlserver scripts/collector/sqlserver	dmaSQLServerPerfmonDataset.ps1 dmaSQLServerPerfmonDataset.ps1	129:190 (9%) 257:318 (9%)	view
58	x 2	scripts/collector/sqlserver/sql scripts/collector/sqlserver/sql	tableList.sql tableList.sql	216:273 (12%) 363:420 (12%)	view
57	x 2	src/dma/cli src/dma/cli	main.py main.py	62:118 (18%) 206:262 (18%)	view
56	x 2	src/dma/collector/sql/sources/postgres src/dma/collector/sql/sources/postgres	collection-table_details.sql collection-table_details.sql	241:296 (11%) 382:437 (11%)	view
56	x 2	scripts/collector/postgres/sql/12 scripts/collector/postgres/sql/13	table_details.sql table_details.sql	99:154 (40%) 99:154 (40%)	view
56	x 2	scripts/collector/postgres/sql/12 scripts/collector/postgres/sql/base	table_details.sql table_details.sql	99:154 (40%) 99:154 (40%)	view
51	x 2	scripts/collector/oracle/sql/extracts/awr scripts/collector/oracle/sql/extracts/statspack	ioevents.sql ioevents.sql	50:100 (60%) 51:101 (59%)	view
49	x 2	src/dma/lib/db/adapters src/dma/lib/db/adapters	aioodbc.py oracledb.py	82:139 (58%) 85:142 (57%)	view
48	x 2	scripts/collector/postgres/sql src/dma/collector/sql/sources/postgres	schema_details.sql collection-schema_details.sql	16:63 (78%) 17:64 (78%)	view
47	x 2	scripts/collector/postgres/sql src/dma/collector/sql/sources/postgres	data_types.sql collection-data_types.sql	16:62 (83%) 17:63 (83%)	view
46	x 2	scripts/collector/mysql/sql src/dma/collector/sql/sources/mysql	config.sql collection-config.sql	124:169 (8%) 377:422 (8%)	view
46	x 2	scripts/collector/mysql/sql src/dma/collector/sql/sources/mysql	config.sql collection-config.sql	124:169 (8%) 327:372 (8%)	view
46	x 2	scripts/collector/mysql/sql src/dma/collector/sql/sources/mysql	config.sql collection-config.sql	326:371 (8%) 73:118 (8%)	view
46	x 2	src/dma/collector/sql/sources/mysql src/dma/collector/sql/sources/mysql	collection-config.sql collection-config.sql	73:118 (8%) 377:422 (8%)	view
46	x 2	src/dma/collector/sql/sources/mysql src/dma/collector/sql/sources/mysql	collection-config.sql collection-config.sql	73:118 (8%) 327:372 (8%)	view
46	x 2	scripts/collector/mysql/sql src/dma/collector/sql/sources/mysql	config.sql collection-config.sql	124:169 (8%) 177:222 (8%)	view
46	x 2	src/dma/collector/sql/sources/mysql src/dma/collector/sql/sources/mysql	collection-config.sql collection-config.sql	73:118 (8%) 227:272 (8%)	view

Duplicated Units

The list of top 1 duplicated units.

See data for all 1 unit duplicate

Size	#	Folders	Files	Lines	Code
26	x 2	src/dma/lib/db/adapters src/dma/lib/db/adapters	aioodbc.py oracledb.py	0:0 0:0	view