mysql / mysql-shell-plugins

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

30% duplication:

161,550 cleaned lines of cleaned code (without empty lines, comments, and frequently duplicated constructs such as imports)
49,066 duplicated lines

44,123 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
gui (<1%) --> mrs_plugin (3%)	2301	7 file pairs	details...
mrs_plugin (1%) --> msm_plugin (16%)	652	4 file pairs	details...
gui (<1%) --> mds_plugin (<1%)	119	4 file pairs	details...
mds_plugin (<1%) --> msm_plugin (2%)	118	1 file pair	details...
mds_plugin (<1%) --> mrs_plugin (<1%)	118	1 file pair	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 44,123 duplicates...

Size	#	Folders	Files	Lines	Code
4381	x 2	gui/frontend/src/parsing/mysql gui/frontend/src/parsing/mysql	MySQLMRSParser.g4 MySQLParser.g4	68:5248 (74%) 67:5247 (89%)	view
1928	x 2	mrs_plugin/db_schema/mys...ect/releases/deployment mrs_plugin/db_schema/mys...oject/releases/versions	mysql_tasks_deployment_3.0.0.sql mysql_tasks_3.0.0.sql	39:2473 (100%) 39:2473 (100%)	view
1928	x 2	mrs_plugin/db_schema/mys...msm.project/development mrs_plugin/db_schema/mys...oject/releases/versions	mysql_tasks_next.sql mysql_tasks_3.0.0.sql	39:2473 (100%) 39:2473 (100%)	view
1928	x 2	mrs_plugin/db_schema/mys...msm.project/development mrs_plugin/db_schema/mys...ect/releases/deployment	mysql_tasks_next.sql mysql_tasks_deployment_3.0.0.sql	39:2473 (100%) 39:2473 (100%)	view
893	x 2	gui/frontend/src/parsing/mysql mrs_plugin/grammar	MySQLMRSParser.g4 MRSParser.g4	5783:6858 (15%) 40:1115 (92%)	view
474	x 2	gui/backend/gui_plugin/d...t/global/request_errors gui/backend/gui_plugin/d...t/global/request_errors	message_too_big.js message_too_big.js	42:515 (11%) 3927:4400 (11%)	view
444	x 2	gui/frontend/src/parsing/mysql gui/frontend/src/parsing/mysql	MySQLMRSParser.g4 MySQLParser.g4	5331:5780 (7%) 5249:5698 (9%)	view
225	x 2	gui/frontend/src/parsing/mysql gui/frontend/src/parsing/mysql	MySQLLexer.g4 MySQLMRSLexer.g4	833:1075 (20%) 834:1076 (19%)	view
188	x 2	mrs_plugin/db_schema/mys...ct/development/sections mrs_plugin/db_schema/mys...roject/releases/updates	170_roles.sql mysql_rest_service_metadata_4.0.4_to_...	12:307 (93%) 142:437 (51%)	view
142	x 2	mrs_plugin/db_schema/mys...ct/development/sections mrs_plugin/db_schema/mys...roject/releases/updates	150-20_procedures_functions.sql mysql_rest_service_metadata_4.0.4_to_...	473:655 (26%) 467:649 (38%)	view
119	x 2	mrs_plugin/db_schema/mys...ct/development/sections mrs_plugin/db_schema/mys...roject/releases/updates	150-20_procedures_functions.sql mysql_rest_service_metadata_4.0.0_to_...	158:285 (21%) 122:249 (38%)	view
107	x 2	gui/frontend/src/parsing/mysql gui/frontend/src/parsing/mysql	MySQLLexer.g4 MySQLMRSLexer.g4	412:518 (9%) 413:519 (9%)	view
90	x 2	mrs_plugin/lib msm_plugin/lib	core.py core.py	322:454 (11%) 228:360 (18%)	view
89	x 2	gui/frontend/src/parsing/mysql gui/frontend/src/parsing/mysql	MySQLLexer.g4 MySQLMRSLexer.g4	606:694 (8%) 607:695 (7%)	view
86	x 2	gui/frontend/src/parsing/mysql gui/frontend/src/parsing/mysql	MySQLLexer.g4 MySQLMRSLexer.g4	3:107 (7%) 3:107 (7%)	view
81	x 2	gui/frontend/src/parsing/mysql mrs_plugin/grammar	MySQLMRSLexer.g4 MRSLexer.g4	1080:1163 (6%) 102:185 (26%)	view
72	x 2	gui/backend/gui_plugin/debugger/scripts/unit/files gui/backend/gui_plugin/debugger/scripts/unit/files	list_files.js list_files_single_user_mode.js	2:87 (29%) 2:87 (50%)	view
64	x 2	gui/backend/gui_plugin/d...t/global/request_errors gui/backend/gui_plugin/d...t/global/request_errors	message_too_big.js message_too_big.js	1010:1101 (1%) 3832:3923 (1%)	view
64	x 2	gui/frontend/src/parsing/mysql gui/frontend/src/parsing/mysql	MySQLLexer.g4 MySQLMRSLexer.g4	310:373 (5%) 311:374 (5%)	view
62	x 2	mrs_plugin/db_schema/mys...ct/development/sections mrs_plugin/db_schema/mys...roject/releases/updates	150-20_procedures_functions.sql mysql_rest_service_metadata_4.0.0_to_...	322:395 (11%) 287:360 (20%)	view
61	x 2	mrs_plugin/db_schema/mys...ct/development/sections mrs_plugin/db_schema/mys...roject/releases/updates	150-20_procedures_functions.sql mysql_rest_service_metadata_4.0.0_to_...	399:461 (11%) 364:426 (19%)	view
61	x 2	mds_plugin mds_plugin	mysql_database_service.py mysql_database_service.py	1927:2008 (5%) 2063:2144 (5%)	view
57	x 2	gui/frontend/src/parsing/mysql gui/frontend/src/parsing/mysql	MySQLLexer.g4 MySQLMRSLexer.g4	1091:1166 (5%) 1179:1254 (4%)	view
56	x 2	gui/backend/gui_plugin/d...s/user_stories/metadata gui/backend/gui_plugin/d...s/user_stories/metadata	_get_table_objects_mysql.js _get_table_objects_mysql.js	69:134 (12%) 220:285 (12%)	view
52	x 2	gui/frontend/src/parsing/mysql gui/frontend/src/parsing/mysql	MySQLLexer.g4 MySQLMRSLexer.g4	131:192 (4%) 132:193 (4%)	view
50	x 2	gui/backend/gui_plugin/debugger/scripts/unit/files gui/backend/gui_plugin/debugger/scripts/unit/files	list_files.js list_files_single_user_mode.js	90:150 (20%) 34:94 (34%)	view
49	x 2	gui/backend/gui_plugin/d...ipts/user_stories/shell gui/backend/gui_plugin/d...ipts/user_stories/shell	new_session_with_connection.js new_session_with_connection.js	31:97 (26%) 181:247 (26%)	view
46	x 2	gui/backend/gui_plugin/d...scripts/unit/sql_editor gui/backend/gui_plugin/d...scripts/unit/sql_editor	_auto_commit_mysql.js _auto_commit_mysql.js	165:222 (17%) 228:285 (17%)	view
46	x 2	gui/backend/gui_plugin/d...scripts/unit/sql_editor gui/backend/gui_plugin/d...scripts/unit/sql_editor	_auto_commit_mysql.js _auto_commit_mysql.js	40:97 (17%) 102:159 (17%)	view
45	x 2	gui/backend/gui_plugin/debugger/scripts/unit/files gui/backend/gui_plugin/debugger/scripts/unit/files	list_files.js list_files.js	34:87 (18%) 90:143 (18%)	view
44	x 2	gui/frontend/src/parsing/mysql gui/frontend/src/parsing/mysql	MySQLMRSParser.g4 MySQLParser.g4	3:50 (<1%) 3:50 (<1%)	view
43	x 2	gui/backend/gui_plugin/d...scripts/unit/sql_editor gui/backend/gui_plugin/d...scripts/unit/sql_editor	_auto_commit_sqlite.js _auto_commit_sqlite.js	99:153 (23%) 174:228 (23%)	view
42	x 2	gui/frontend/src/parsing/mysql gui/frontend/src/parsing/mysql	MySQLLexer.g4 MySQLMRSLexer.g4	241:282 (3%) 242:283 (3%)	view
42	x 2	mrs_plugin/lib mrs_plugin/lib	MrsDdlListener.py MrsDdlListener.py	963:1008 (2%) 1049:1094 (2%)	view
41	x 2	gui/extension/src gui/extension/src	CodeBlocks.ts MrsScriptBlocks.ts	252:292 (14%) 229:269 (23%)	view
41	x 2	gui/backend/gui_plugin/d...user_stories/sql_editor gui/backend/gui_plugin/d...user_stories/sql_editor	_db_notebook_code_history.js _db_notebook_code_history.js	536:580 (6%) 582:626 (6%)	view
41	x 2	mrs_plugin/db_schema/mys...ct/development/sections mrs_plugin/db_schema/mys...roject/releases/updates	150-20_procedures_functions.sql mysql_rest_service_metadata_4.0.2_to_...	104:152 (7%) 127:175 (47%)	view
41	x 2	gui/frontend/src/parsing/mysql gui/frontend/src/parsing/mysql	MySQLLexer.g4 MySQLMRSLexer.g4	564:604 (3%) 565:605 (3%)	view
41	x 2	gui/frontend/src/parsing/mysql gui/frontend/src/parsing/mysql	MySQLLexer.g4 MySQLMRSLexer.g4	696:736 (3%) 697:737 (3%)	view
39	x 2	gui/frontend/src/parsing/mysql gui/frontend/src/parsing/mysql	MySQLMRSLexer.g4 MySQLParser.g4	3:42 (3%) 3:42 (<1%)	view
39	x 2	gui/frontend/src/parsing/mysql gui/frontend/src/parsing/mysql	MySQLMRSLexer.g4 MySQLMRSParser.g4	3:42 (3%) 3:42 (<1%)	view
39	x 2	gui/frontend/src/parsing/mysql gui/frontend/src/parsing/mysql	MySQLLexer.g4 MySQLMRSParser.g4	3:42 (3%) 3:42 (<1%)	view
39	x 2	gui/frontend/src/parsing/mysql gui/frontend/src/parsing/mysql	MySQLLexer.g4 MySQLParser.g4	3:42 (3%) 3:42 (<1%)	view
38	x 2	gui/frontend/src/parsing/mysql gui/frontend/src/parsing/mysql	MySQLLexer.g4 MySQLMRSLexer.g4	789:826 (3%) 790:827 (3%)	view
37	x 2	gui/frontend/src/parsing/mysql mrs_plugin/grammar	MySQLLexer.g4 MRSLexer.g4	128:169 (3%) 241:282 (11%)	view
37	x 2	gui/backend/gui_plugin/d...t/global/request_errors gui/backend/gui_plugin/d...t/global/request_errors	message_too_big.js message_too_big.js	944:995 (<1%) 3772:3823 (<1%)	view
36	x 2	gui/backend/gui_plugin/d...user_stories/sql_editor gui/backend/gui_plugin/d...user_stories/sql_editor	_db_notebook_code_history.js _db_notebook_code_history.js	187:225 (5%) 245:283 (5%)	view
36	x 2	gui/backend/gui_plugin/d...s/user_stories/metadata gui/backend/gui_plugin/d...s/user_stories/metadata	_get_table_objects_mysql.js _get_table_objects_mysql.js	178:222 (8%) 269:312 (8%)	view
36	x 2	gui/frontend/src/parsing/mysql gui/frontend/src/parsing/mysql	MySQLLexer.g4 MySQLMRSLexer.g4	375:410 (3%) 376:411 (3%)	view
35	x 2	gui/backend/gui_plugin/d...user_stories/sql_editor gui/backend/gui_plugin/d...user_stories/sql_editor	_db_notebook_code_history.js _db_notebook_code_history.js	334:372 (5%) 560:598 (5%)	view

Duplicated Units

The list of top 4 duplicated units.

See data for all 4 unit duplicates...

Size	#	Folders	Files	Lines	Code
8	x 2	gui/frontend/src/modules/db-editor gui/frontend/src/modules/db-editor	ScriptEditor.tsx SimpleEditor.tsx	380:390 168:178	view
8	x 2	gui/frontend/src/supplement/ShellInterface gui/frontend/src/supplement/ShellInterface	ShellInterfaceSqlEditor.ts ShellInterfaceShellSession.ts	362:371 162:171	view
7	x 2	gui/frontend/src/modules/db-editor gui/frontend/src/modules/db-editor	ScriptEditor.tsx SimpleEditor.tsx	144:153 90:99	view
6	x 2	gui/extension/src gui/extension/src	MrsScriptBlocks.ts CodeBlocks.ts	298:306 436:444	view