microsoft / pgtoolsservice
File Age

File age measurements show the distribution of file ages (days since the first commit) and the recency of file updates (days since the latest commit).

Summary
  • Number of files: 299
  • Daily file updates (only one update per file and date counted): 1788
  • First update: 2017-02-02
  • Latest update: 2021-11-11
  • Days between first and latest update: 1744 (249 weeks, estimated 1245 working days)
  • Active days (at least one file change): 148
  • Data:
File Change History Overall
File Age Distribution Overall
Days since first update
  • There are 299 files with 14,490 lines of code in files.
    • 298 files that are 366+ days old (14,311 lines of code)
    • 0 files that are 181-365 days old (0 lines of code)
    • 1 files that are 91-180 days old (179 lines of code)
    • 0 files that are 31-90 days old (0 lines of code)
    • 0 files that are 1-30 days old (0 lines of code)
98% | 0% | 1% | 0% | 0%
Legend:
366+
181-365
91-180
31-90
1-30
Latest Change Distribution Overall
Days since last update
  • There are 299 files with 14,490 lines of code in files.
    • 279 files have been last changed 366+ days ago (11,850 lines of code)
    • 0 files have been last changed 181-365 days ago (0 lines of code)
    • 19 files have been last changed 91-180 days ago (2,429 lines of code)
    • 1 files have been last changed 31-90 days ago (211 lines of code)
    • 0 files have been last changed 1-30 days ago (0 lines of code)
81% | 0% | 16% | 1% | 0%
Legend:
366+
181-365
91-180
31-90
1-30
File Change History per File Extension
sql, py, json, txt, sh, ps1, gitignore, md
File Age Distribution per Extension
Days since first update
366+
181-365
91-180
31-90
1-30
py98% | 0% | 1% | 0% | 0%
ps1100% | 0% | 0% | 0% | 0%
Latest Change Distribution per Extension
Days since last update
366+
181-365
91-180
31-90
1-30
py82% | 0% | 16% | 1% | 0%
ps130% | 0% | 69% | 0% | 0%
File Change History per Logical Decomposition
primary
primary (file age distribution)
Days since first update
366+
181-365
91-180
31-90
1-30
pgsmo/objects94% | 0% | 5% | 0% | 0%
ossdbtoolsservice/language100% | 0% | 0% | 0% | 0%
ossdbtoolsservice/query100% | 0% | 0% | 0% | 0%
ossdbtoolsservice/object_explorer100% | 0% | 0% | 0% | 0%
ossdbtoolsservice/disaster_recovery100% | 0% | 0% | 0% | 0%
ossdbtoolsservice/edit_data100% | 0% | 0% | 0% | 0%
ossdbtoolsservice/query_execution100% | 0% | 0% | 0% | 0%
ossdbtoolsservice/capabilities100% | 0% | 0% | 0% | 0%
mysqlsmo/objects100% | 0% | 0% | 0% | 0%
ossdbtoolsservice/hosting100% | 0% | 0% | 0% | 0%
ossdbtoolsservice/workspace100% | 0% | 0% | 0% | 0%
ossdbtoolsservice/driver100% | 0% | 0% | 0% | 0%
ossdbtoolsservice/converters100% | 0% | 0% | 0% | 0%
ossdbtoolsservice/connection100% | 0% | 0% | 0% | 0%
smo/common100% | 0% | 0% | 0% | 0%
smo/utils100% | 0% | 0% | 0% | 0%
ossdbtoolsservice/parsers100% | 0% | 0% | 0% | 0%
ossdbtoolsservice/tasks100% | 0% | 0% | 0% | 0%
ossdbtoolsservice/utils100% | 0% | 0% | 0% | 0%
ossdbtoolsservice/scripting100% | 0% | 0% | 0% | 0%
ossdbtoolsservice/metadata100% | 0% | 0% | 0% | 0%
ossdbtoolsservice100% | 0% | 0% | 0% | 0%
scripts100% | 0% | 0% | 0% | 0%
ossdbtoolsservice/admin100% | 0% | 0% | 0% | 0%
pgsmo100% | 0% | 0% | 0% | 0%
ossdbtoolsservice/serialization100% | 0% | 0% | 0% | 0%
mysqlsmo100% | 0% | 0% | 0% | 0%
ROOT100% | 0% | 0% | 0% | 0%
smo100% | 0% | 0% | 0% | 0%
primary (latest change distribution)
Days since last update
366+
181-365
91-180
31-90
1-30
pgsmo/objects66% | 0% | 33% | 0% | 0%
ossdbtoolsservice/language72% | 0% | 27% | 0% | 0%
ossdbtoolsservice/object_explorer100% | 0% | 0% | 0% | 0%
ossdbtoolsservice/query77% | 0% | 22% | 0% | 0%
ossdbtoolsservice/disaster_recovery100% | 0% | 0% | 0% | 0%
ossdbtoolsservice/edit_data100% | 0% | 0% | 0% | 0%
ossdbtoolsservice/query_execution100% | 0% | 0% | 0% | 0%
mysqlsmo/objects100% | 0% | 0% | 0% | 0%
ossdbtoolsservice/hosting100% | 0% | 0% | 0% | 0%
ossdbtoolsservice/workspace100% | 0% | 0% | 0% | 0%
ossdbtoolsservice/converters100% | 0% | 0% | 0% | 0%
ossdbtoolsservice/capabilities56% | 0% | 43% | 0% | 0%
ossdbtoolsservice/driver63% | 0% | 36% | 0% | 0%
smo/common100% | 0% | 0% | 0% | 0%
smo/utils100% | 0% | 0% | 0% | 0%
ossdbtoolsservice/parsers100% | 0% | 0% | 0% | 0%
ossdbtoolsservice/connection44% | 0% | 0% | 55% | 0%
ossdbtoolsservice/tasks100% | 0% | 0% | 0% | 0%
ossdbtoolsservice/utils100% | 0% | 0% | 0% | 0%
ossdbtoolsservice/scripting100% | 0% | 0% | 0% | 0%
ossdbtoolsservice/metadata100% | 0% | 0% | 0% | 0%
ossdbtoolsservice100% | 0% | 0% | 0% | 0%
ossdbtoolsservice/admin100% | 0% | 0% | 0% | 0%
pgsmo100% | 0% | 0% | 0% | 0%
ossdbtoolsservice/serialization100% | 0% | 0% | 0% | 0%
mysqlsmo100% | 0% | 0% | 0% | 0%
scripts30% | 0% | 69% | 0% | 0%
smo100% | 0% | 0% | 0% | 0%
ROOT0% | 0% | 100% | 0% | 0%
Oldest Files (Top 20)
File# lines# unitslast modified
(days ago)		created
(days ago)		# changes
setup.py
in root
 14 - 163 1712 10
build.ps1
in scripts
 13 - 1678 1712 4
flake8.ps1
in scripts
 14 - 139 1683 5
table.py
in pgsmo/objects/table
 358 80 139 1680 20
database.py
in pgsmo/objects/database
 180 38 537 1680 19
server.py
in pgsmo/objects/server
 168 31 537 1680 15
schema.py
in pgsmo/objects/schema
 131 31 537 1680 22
__init__.py
in pgsmo
 50 - 537 1680 14
view.py
in pgsmo/objects/view
 22 4 537 1680 16
__init__.py
in pgsmo/objects
 1 - 1680 1680 1
__init__.py
in pgsmo/objects/database
 1 - 1680 1680 1
__init__.py
in pgsmo/objects/schema
 1 - 1680 1680 1
__init__.py
in pgsmo/objects/server
 1 - 1680 1680 1
__init__.py
in pgsmo/objects/table
 1 - 1680 1680 1
__init__.py
in pgsmo/objects/view
 1 - 1680 1680 1
role.py
in pgsmo/objects/role
 115 22 537 1678 11
__init__.py
in pgsmo/objects/role
 1 - 1677 1678 2
tablespace.py
in pgsmo/objects/tablespace
 68 13 537 1677 10
__init__.py
in pgsmo/objects/tablespace
 1 - 1677 1677 1
function.py
in pgsmo/objects/functions
 9 1 537 1669 5
Files Not Recently Changed (Top 20)
File# lines# unitslast modified
(days ago)		created
(days ago)		# changes
__init__.py
in pgsmo/objects/view
 1 - 1680 1680 1
__init__.py
in pgsmo/objects/table
 1 - 1680 1680 1
__init__.py
in pgsmo/objects/server
 1 - 1680 1680 1
__init__.py
in pgsmo/objects/schema
 1 - 1680 1680 1
__init__.py
in pgsmo/objects/database
 1 - 1680 1680 1
__init__.py
in pgsmo/objects
 1 - 1680 1680 1
build.ps1
in scripts
 13 - 1678 1712 4
__init__.py
in pgsmo/objects/tablespace
 1 - 1677 1677 1
__init__.py
in pgsmo/objects/role
 1 - 1677 1678 2
__init__.py
in pgsmo/objects/datatype
 1 - 1623 1623 1
__init__.py
in pgsmo/objects/table_objects
 1 - 1620 1665 2
__init__.py
in pgsmo/objects/sequence
 1 - 1620 1664 2
__init__.py
in pgsmo/objects/functions
 1 - 1620 1669 3
__init__.py
in pgsmo/objects/collation
 1 - 1620 1665 3
autopep8.ps1
in scripts
 8 - 1582 1582 1
__init__.py
in pgsmo/objects/extension
 1 - 1581 1581 1
__init__.py
in smo/common
 1 - 537 537 1
__init__.py
in smo
 1 - 537 537 1
__init__.py
in ossdbtoolsservice/scripting
 1 - 537 537 1
__init__.py
in ossdbtoolsservice/language/completion/packages/pgliterals
 1 - 537 537 1
Most Recently Created Files (Top 20)
File# lines# unitslast modified
(days ago)		created
(days ago)		# changes
constraints_utils.py
in pgsmo/objects/table_objects
 179 7 139 145 2
pgcompleter.py
in ossdbtoolsservice/language/completion
 572 44 537 537 1
backup.py
in ossdbtoolsservice/disaster_recovery/contracts
 365 5 537 537 1
query_execution_service.py
in ossdbtoolsservice/query_execution
 322 38 537 537 1
pg_lightweight_metadata.py
in ossdbtoolsservice/language/query
 321 13 145 537 2
pg_routing.py
in ossdbtoolsservice/object_explorer/routing
 321 24 537 537 1
language_service.py
in ossdbtoolsservice/language
 304 26 135 537 5
sqlcompletion.py
in ossdbtoolsservice/language/completion/packages
 299 15 537 537 1
mysql_routing.py
in ossdbtoolsservice/object_explorer/routing
 268 21 537 537 1
object_explorer_service.py
in ossdbtoolsservice/object_explorer
 259 17 537 537 1
restore.py
in ossdbtoolsservice/disaster_recovery/contracts
 255 4 537 537 1
templating.py
in smo/utils
 226 12 537 537 1
connection_service.py
in ossdbtoolsservice/connection
 211 27 81 537 2
any_to_bytes_converters.py
in ossdbtoolsservice/converters/pg_converters
 201 33 537 537 1
json_rpc_server.py
in ossdbtoolsservice/hosting
 191 26 537 537 1
node_object.py
in smo/common
 186 36 537 537 1
pg_connection_options.py
in ossdbtoolsservice/capabilities/connection_options
 171 - 119 537 2
pymysql_driver.py
in ossdbtoolsservice/driver/types
 165 26 537 537 1
data_editor_session.py
in ossdbtoolsservice/edit_data
 157 14 537 537 1
mysql_connection_options.py
in ossdbtoolsservice/capabilities/connection_options
 156 - 537 537 1
Most Recently Changed Files (Top 20)
File# lines# unitslast modified
(days ago)		created
(days ago)		# changes
connection_service.py
in ossdbtoolsservice/connection
 211 27 81 537 2
column.py
in pgsmo/objects/table_objects
 344 48 117 1665 11
sequence.py
in pgsmo/objects/sequence
 132 20 117 1664 10
initialize_request.py
in ossdbtoolsservice/capabilities/contracts
 51 5 117 537 2
pg_connection_options.py
in ossdbtoolsservice/capabilities/connection_options
 171 - 119 537 2
language_service.py
in ossdbtoolsservice/language
 304 26 135 537 5
table.py
in pgsmo/objects/table
 358 80 139 1680 20
constraints_utils.py
in pgsmo/objects/table_objects
 179 7 139 145 2
batch.py
in ossdbtoolsservice/query
 136 24 139 537 3
keywords.py
in ossdbtoolsservice/language
 89 4 139 537 2
completion.py
in ossdbtoolsservice/language/contracts
 40 2 139 537 2
flake8.ps1
in scripts
 14 - 139 1683 5
test-all.ps1
in scripts
 13 - 139 1595 3
test-integration.ps1
in scripts
 13 - 139 1595 3
test-unit.ps1
in scripts
 7 - 139 1595 3
pg_lightweight_metadata.py
in ossdbtoolsservice/language/query
 321 13 145 537 2
psycopg_driver.py
in ossdbtoolsservice/driver/types
 148 27 145 537 2
service_buffer_file_stream_reader.py
in ossdbtoolsservice/query/data_storage
 50 3 163 537 3
service_buffer_file_stream_writer.py
in ossdbtoolsservice/query/data_storage
 45 5 163 537 3
setup.py
in root
 14 - 163 1712 10