azure / sql-action
File Change Frequency

File change frequency (churn) shows the distribution of file updates (days with at least one commit).

Overview
File Change Frequency Overall
  • There are 14 files with 984 lines of code.
    • 0 files changed more than 100 times (0 lines of code)
    • 0 files changed 51-100 times (0 lines of code)
    • 0 files changed 21-50 times (0 lines of code)
    • 6 files changed 6-20 times (730 lines of code)
    • 8 files changed 1-5 times (254 lines of code)
0% | 0% | 0% | 74% | 25%
Legend:
101+
51-100
21-50
6-20
1-5

explore: grouped by folders | grouped by update frequency | data
Contributors Count Frequency Overall
  • There are 14 files with 984 lines of code.
    • 0 files changed by more than 25 contributors (0 lines of code)
    • 0 files changed by 11-25 contributors (0 lines of code)
    • 0 files changed by 6-10 contributors (0 lines of code)
    • 8 files changed by 2-5 contributors (844 lines of code)
    • 6 files changed by 1 contributor (140 lines of code)
0% | 0% | 0% | 85% | 14%
Legend:
26+
11-25
6-10
2-5
1

explore: grouped by folders | grouped by contributors count | data
File Change Frequency per File Extension
ts, yaml, md, sql, json, js, gitignore, txt
File Change Frequency per Extension
The number of recorded file updates
101+
51-100
21-50
6-20
1-5
ts0% | 0% | 0% | 74% | 25%
sql0% | 0% | 0% | 0% | 100%
File Change Frequency per Logical Decomposition
primary
primary (file change frequency)
The number of recorded file updates
101+
51-100
21-50
6-20
1-5
src0% | 0% | 0% | 74% | 25%
__testdata__0% | 0% | 0% | 0% | 100%
Most Frequently Changed Files (Top 14)

See data for all files...

File# lines# unitscreatedlast modified# changes
(days)		# contributorsfirst
contributor		latest
contributor
main.ts
in src
 96 3 2019-09-30 2024-07-01 13 5 asranja@microsoft.com 13544267+zijchen@users.nore...
120 6 2019-09-30 2024-06-28 11 4 asranja@microsoft.com dzsquared@users.noreply.git...
26 3 2019-09-30 2022-11-03 7 3 asranja@microsoft.com 13544267+zijchen@users.nore...
335 18 2019-09-30 2024-06-28 7 4 asranja@microsoft.com dzsquared@users.noreply.git...
Setup.ts
in src
 30 2 2022-09-28 2024-06-27 6 3 13544267+zijchen@users.nore... 13544267+zijchen@users.nore...
123 6 2019-09-30 2023-02-21 6 3 asranja@microsoft.com dzsquared@users.noreply.git...
9 - 2020-09-23 2024-06-27 5 2 58936966+aksm-ms@users.nore... 13544267+zijchen@users.nore...
105 4 2020-09-23 2024-07-01 5 3 58936966+aksm-ms@users.nore... 13544267+zijchen@users.nore...
110 11 2022-09-28 2024-07-01 4 1 13544267+zijchen@users.nore... 13544267+zijchen@users.nore...
testsql.sql
in __testdata__
 2 - 2022-02-22 2022-09-28 3 1 13544267+zijchen@users.nore... 13544267+zijchen@users.nore...
cleanup.sql
in __testdata__
 1 - 2022-02-22 2022-02-22 1 1 13544267+zijchen@users.nore... 13544267+zijchen@users.nore...
View1.sql
in __testdata__/TestProject
 2 - 2022-02-23 2022-02-23 1 1 13544267+zijchen@users.nore... 13544267+zijchen@users.nore...
Table1.sql
in __testdata__/TestProject
 5 - 2022-02-23 2022-02-23 1 1 13544267+zijchen@users.nore... 13544267+zijchen@users.nore...
20 2 2022-02-23 2022-02-23 1 1 13544267+zijchen@users.nore... 13544267+zijchen@users.nore...
Files With Most Contributors (Top 14)
Based on the number of unique email addresses found in commits.

See data for all files...

File# lines# unitscreatedlast modified# changes
(days)		# contributorsfirst
contributor		latest
contributor
main.ts
in src
 96 3 2019-09-30 2024-07-01 13 5 asranja@microsoft.com 13544267+zijchen@users.nore...
120 6 2019-09-30 2024-06-28 11 4 asranja@microsoft.com dzsquared@users.noreply.git...
335 18 2019-09-30 2024-06-28 7 4 asranja@microsoft.com dzsquared@users.noreply.git...
26 3 2019-09-30 2022-11-03 7 3 asranja@microsoft.com 13544267+zijchen@users.nore...
Setup.ts
in src
 30 2 2022-09-28 2024-06-27 6 3 13544267+zijchen@users.nore... 13544267+zijchen@users.nore...
123 6 2019-09-30 2023-02-21 6 3 asranja@microsoft.com dzsquared@users.noreply.git...
105 4 2020-09-23 2024-07-01 5 3 58936966+aksm-ms@users.nore... 13544267+zijchen@users.nore...
9 - 2020-09-23 2024-06-27 5 2 58936966+aksm-ms@users.nore... 13544267+zijchen@users.nore...
110 11 2022-09-28 2024-07-01 4 1 13544267+zijchen@users.nore... 13544267+zijchen@users.nore...
testsql.sql
in __testdata__
 2 - 2022-02-22 2022-09-28 3 1 13544267+zijchen@users.nore... 13544267+zijchen@users.nore...
20 2 2022-02-23 2022-02-23 1 1 13544267+zijchen@users.nore... 13544267+zijchen@users.nore...
cleanup.sql
in __testdata__
 1 - 2022-02-22 2022-02-22 1 1 13544267+zijchen@users.nore... 13544267+zijchen@users.nore...
Table1.sql
in __testdata__/TestProject
 5 - 2022-02-23 2022-02-23 1 1 13544267+zijchen@users.nore... 13544267+zijchen@users.nore...
View1.sql
in __testdata__/TestProject
 2 - 2022-02-23 2022-02-23 1 1 13544267+zijchen@users.nore... 13544267+zijchen@users.nore...
Files With Least Contributors (Top 14)
Based on the number of unique email addresses found in commits.

See data for all files...

File# lines# unitscreatedlast modified# changes
(days)		# contributorsfirst
contributor		latest
contributor
110 11 2022-09-28 2024-07-01 4 1 13544267+zijchen@users.nore... 13544267+zijchen@users.nore...
20 2 2022-02-23 2022-02-23 1 1 13544267+zijchen@users.nore... 13544267+zijchen@users.nore...
Table1.sql
in __testdata__/TestProject
 5 - 2022-02-23 2022-02-23 1 1 13544267+zijchen@users.nore... 13544267+zijchen@users.nore...
View1.sql
in __testdata__/TestProject
 2 - 2022-02-23 2022-02-23 1 1 13544267+zijchen@users.nore... 13544267+zijchen@users.nore...
testsql.sql
in __testdata__
 2 - 2022-02-22 2022-09-28 3 1 13544267+zijchen@users.nore... 13544267+zijchen@users.nore...
cleanup.sql
in __testdata__
 1 - 2022-02-22 2022-02-22 1 1 13544267+zijchen@users.nore... 13544267+zijchen@users.nore...
9 - 2020-09-23 2024-06-27 5 2 58936966+aksm-ms@users.nore... 13544267+zijchen@users.nore...
123 6 2019-09-30 2023-02-21 6 3 asranja@microsoft.com dzsquared@users.noreply.git...
105 4 2020-09-23 2024-07-01 5 3 58936966+aksm-ms@users.nore... 13544267+zijchen@users.nore...
Setup.ts
in src
 30 2 2022-09-28 2024-06-27 6 3 13544267+zijchen@users.nore... 13544267+zijchen@users.nore...
26 3 2019-09-30 2022-11-03 7 3 asranja@microsoft.com 13544267+zijchen@users.nore...
335 18 2019-09-30 2024-06-28 7 4 asranja@microsoft.com dzsquared@users.noreply.git...
120 6 2019-09-30 2024-06-28 11 4 asranja@microsoft.com dzsquared@users.noreply.git...
main.ts
in src
 96 3 2019-09-30 2024-07-01 13 5 asranja@microsoft.com 13544267+zijchen@users.nore...
Correlations

File Size vs. Number of Changes: 14 points

src/SqlConnectionConfig.ts x: 110 lines of code y: 4 # changes src/SqlUtils.ts x: 105 lines of code y: 5 # changes src/main.ts x: 96 lines of code y: 13 # changes src/AzureSqlAction.ts x: 120 lines of code y: 11 # changes src/AzureSqlActionHelper.ts x: 335 lines of code y: 7 # changes src/Setup.ts x: 30 lines of code y: 6 # changes src/Constants.ts x: 9 lines of code y: 5 # changes src/AzureSqlResourceManager.ts x: 123 lines of code y: 6 # changes src/FirewallManager.ts x: 26 lines of code y: 7 # changes __testdata__/testsql.sql x: 2 lines of code y: 3 # changes __testdata__/TestProject/Table1.sql x: 5 lines of code y: 1 # changes __testdata__/TestProject/View1.sql x: 2 lines of code y: 1 # changes src/DotnetUtils.ts x: 20 lines of code y: 1 # changes __testdata__/cleanup.sql x: 1 lines of code y: 1 # changes
13.0
# changes
  min: 1.0
  average: 5.07
  25th percentile: 1.0
  median: 5.0
  75th percentile: 7.0
  max: 13.0
0 335.0
lines of code
min: 1.0 | average: 70.29 | 25th percentile: 4.25 | median: 28.0 | 75th percentile: 112.5 | max: 335.0

Number of Contributors vs. Number of Changes: 14 points

src/SqlConnectionConfig.ts x: 1 # contributors y: 4 # changes src/SqlUtils.ts x: 3 # contributors y: 5 # changes src/main.ts x: 5 # contributors y: 13 # changes src/AzureSqlAction.ts x: 4 # contributors y: 11 # changes src/AzureSqlActionHelper.ts x: 4 # contributors y: 7 # changes src/Setup.ts x: 3 # contributors y: 6 # changes src/Constants.ts x: 2 # contributors y: 5 # changes src/FirewallManager.ts x: 3 # contributors y: 7 # changes __testdata__/testsql.sql x: 1 # contributors y: 3 # changes __testdata__/TestProject/Table1.sql x: 1 # contributors y: 1 # changes
13.0
# changes
  min: 1.0
  average: 5.07
  25th percentile: 1.0
  median: 5.0
  75th percentile: 7.0
  max: 13.0
0 5.0
# contributors
min: 1.0 | average: 2.36 | 25th percentile: 1.0 | median: 2.5 | 75th percentile: 3.25 | max: 5.0

Number of Contributors vs. File Size: 14 points

src/SqlConnectionConfig.ts x: 1 # contributors y: 110 lines of code src/SqlUtils.ts x: 3 # contributors y: 105 lines of code src/main.ts x: 5 # contributors y: 96 lines of code src/AzureSqlAction.ts x: 4 # contributors y: 120 lines of code src/AzureSqlActionHelper.ts x: 4 # contributors y: 335 lines of code src/Setup.ts x: 3 # contributors y: 30 lines of code src/Constants.ts x: 2 # contributors y: 9 lines of code src/AzureSqlResourceManager.ts x: 3 # contributors y: 123 lines of code src/FirewallManager.ts x: 3 # contributors y: 26 lines of code __testdata__/testsql.sql x: 1 # contributors y: 2 lines of code __testdata__/TestProject/Table1.sql x: 1 # contributors y: 5 lines of code src/DotnetUtils.ts x: 1 # contributors y: 20 lines of code __testdata__/cleanup.sql x: 1 # contributors y: 1 lines of code
335.0
lines of code
  min: 1.0
  average: 70.29
  25th percentile: 4.25
  median: 28.0
  75th percentile: 112.5
  max: 335.0
0 5.0
# contributors
min: 1.0 | average: 2.36 | 25th percentile: 1.0 | median: 2.5 | 75th percentile: 3.25 | max: 5.0