microsoft / sql-data-warehouse-samples
Source Code Overview

Analysis scope, overview of main, test, generated, deployment, build, and other code.

Source Code Analysis Scope
Files includes and excluded from analyses
csproj
txt
  • 11 extensions are included in analyses: sql, json, md, cs, ps1, js, csproj, gitignore, txt, bat, yml
  • 5 criteria are used to exclude files from analysis:
    • exclude files with path like ".*/[.][a-zA-Z0-9_]+.*" (Hidden files and folders) (2 files).
    • exclude files with path like ".*/git[-]history[.]txt" (Git history) (1 file).
    • exclude files with path like ".*/git[-][a-zA-Z0-9_]+[.]txt" (Git data exports for sokrates analyses) (0 files).
    • exclude files with path like ".*/sokrates_conventions[.]json" (Sokrates scoping conventions) (1 file).
    • exclude files with path like ".*[.]txt" (Text files) (1 file).
Overview of Analyzed Files
Basic stats on analyzed files
Intro
For analysis purposes we separate files in scope into several categories: main, test, generated, deployment and build, and other.

  • The main category contains all manually created source code files that are being used in the production.
  • Files in the main category are used as input for other analyses: logical decomposition, concerns, duplication, file size, unit size, and conditional complexity.
  • Test source code files are used only for testing of the product. These files are normally not deployed to production.
  • Build and deployment source code files are used to configure or support build and deployment process.
  • Generated source code files are automatically generated files that have not been manually changed after generation.
  • While a source code folder may contain a number of files, we are primarily interested in the source code files that are being written and maintained by developers.
  • Files containing binaries, documentation, or third-party libraries, for instance, are excluded from analysis. The exception are third-party libraries that have been changed by developers.

main1107 LOC (9%) 16 files
test0 LOC (0%) 0 files
generated0 LOC (0%) 0 files
build and deployment368 LOC (3%) 2 files
other10224 LOC (87%) 143 files
Main Code
All manually created or maintained source code that defines logic of the product that is run in a production environment.
Explore:   circles  |  sunburst
  • The following criteria are used to filter files:
    • files with paths like ".*".
  • 16 files match defined criteria (1,107 lines of code, 100.0% vs. main code):
    • 1 *.ps1 files (469 lines of code)
    • 7 *.cs files (426 lines of code)
    • 7 *.js files (211 lines of code)
    • 1 *.yml files (1 lines of code)
  • " *.ps1" is biggest, containing 42.37% of code.
  • " *.yml" is smallest, containing 0.09% of code.


*.ps1469 LOC (42%) 1 files
*.cs426 LOC (38%) 7 files
*.js211 LOC (19%) 7 files
*.yml1 LOC (<1%) 1 files
Build and Deployment Code
Source code used to configure or support build and deployment process.
csproj
Explore:   circles  |  sunburst
  • The following criteria are used to filter files:
    • files with paths like ".*[.]git[a-z]+".
    • files with paths like ".*/[.]gitignore".
    • files with paths like ".*[.]csproj".
    • files with paths like ".*/package[.]json".
    • files with paths like ".*[.]bat".
  • 2 files match defined criteria (368 lines of code, 33.2% vs. main code):
    • 1 *.csproj files (303 lines of code)
    • 1 *.bat files (65 lines of code)
  • " *.csproj" is biggest, containing 82.34% of code.
  • " *.bat" is smallest, containing 17.66% of code.


*.csproj303 LOC (82%) 1 files
*.bat65 LOC (17%) 1 files
Other Code
csproj
Explore:   circles  |  sunburst
  • The following criteria are used to filter files:
    • files with paths like ".*[.]json".
    • files with paths like ".*/[.]gitignore".
    • files with paths like ".*[.]md".
    • files with paths like ".*/README[.][a-z0-9]+".
    • files with paths like ".*[.]txt".
    • files with paths like ".*/[Ss]amples/.*".
    • files with paths like ".*[.](xml|xsd|robot|sql|pgsql|dashboard|profile|ipynb|raml|avsc|al)".
  • 143 files match defined criteria (10,224 lines of code, 923.6% vs. main code):
    • 33 *.json files (4,951 lines of code)
    • 63 *.sql files (2,274 lines of code)
    • 12 *.cs files (1,317 lines of code)
    • 25 *.md files (895 lines of code)
    • 7 *.ps1 files (500 lines of code)
    • 3 *.csproj files (287 lines of code)
  • " *.json" is biggest, containing 48.43% of code.
  • " *.csproj" is smallest, containing 2.81% of code.


*.json4951 LOC (48%) 33 files
*.sql2274 LOC (22%) 63 files
*.cs1317 LOC (12%) 12 files
*.md895 LOC (8%) 25 files
*.ps1500 LOC (4%) 7 files
*.csproj287 LOC (2%) 3 files
Analyzers
Info about analyzers used for source code examinations.
  • *.ps1 files are analyzed with DefaultLanguageAnalyzer:
    • All basic standard analyses supported (source code overview, duplication, file size, concerns, findings, metrics, controls)
    • Basic code cleaning (empty lines removed for LOC calculations and duplication calculations)
    • No unit size analysis
    • No conditional complexity analysis
    • No dependency analysis
  • *.cs files are analyzed with CSharpAnalyzer:
    • All basic standard analyses supported (source code overview, duplication, file size, concerns, findings, metrics, controls)
    • Advanced code cleaning (empty lines and comments removed for LOC calculations, additional cleaning for duplication calculations)
    • Unit size analysis
    • Conditional complexity analysis
    • Advanced heuristic dependency analysis (based on namespace heuristics)
  • *.js files are analyzed with JavaScriptAnalyzer:
    • All basic standard analyses supported (source code overview, duplication, file size, concerns, findings, metrics, controls)
    • Advanced code cleaning (empty lines and comments removed for LOC calculations, additional cleaning for duplication calculations)
    • Unit size analysis
    • Conditional complexity analysis
    • No dependency analysis
  • *.yml files are analyzed with YamlAnalyzer:
    • All basic standard analyses supported (source code overview, duplication, file size, concerns, findings, metrics, controls)
    • Advanced code cleaning (empty lines and comments removed for LOC calculations, additional cleaning for duplication calculations)
    • No unit size analysis
    • No conditional complexity analysis
    • No dependency analysis


2022-01-30 14:48