Datasets generated for project tools.cdt

Context of this work

Crossminer is EU-funded research project that aims at providing tailored recommendations for software practitionners. Its outputs include the Scava Eclipse project and a set of public datasets extracted from a selection of representative Eclipse projects.

This report was generated on 2019-03-13.

About this document

This document is a R notebook, dynamically created from the numbers extracted on the project. It lists all datasets published for the project, providing basic numbers, figures and a quick summary, and serves as a test case to make sure that all the required data is present and roughly consistent with requirements. All plots and tables are computed from the actual data as provided in the downloads.

To re-execute the document, simply render it with the project ID as a parameter:

render("datasets_report.Rmd", params = list(project_id = "tools.cdt"))

About the downloads

Downloads are mainly composed of CSV and JSON files. CSV files always have a header to name the fields, which makes it easy to import in analysis software like R:

data <- read.csv(file='myfile.csv', header=T)
names(data)

All downloads are available as compressed (gzip’d) files to reduce bandwidth usage.

Content

List of datasets generated for the project:

Git

Git commits

Download: git_commits_evol.csv.gz

data <- read.csv(file=url_git_commits, header=T)

File is git_commits_evol.csv, and has 3 columns for 4643 commits.

data$commits_sum <- cumsum(data$commits)
data.xts <- xts(x = data[,c('commits_sum', 'commits', 'authors')], order.by=as.POSIXct(as.character(data[,c('date')]), format="%Y-%m-%d"))

p <-dygraph(data.xts[,c('commits')],
        main = paste('Daily commits for ', project_id, sep=''),
        width = 800, height = 250 ) %>%
      dyRangeSelector()
p

Git log

Download: git_log.txt.gz

File is git_log.txt, and full log has 187014 lines.

Bugzilla

Bugzilla issues

Download: bugzilla_issues.csv.gz

data <- read.csv(file=url_bz_issues, header=T)

File is bugzilla_issues.csv, and has 17 columns for 21101 issues.

Bugzilla open issues

Download: bugzilla_issues_open.csv.gz

data <- read.csv(file=url_bz_issues_open, header=T)

File is bugzilla_issues_open.csv, and has 17 columns for 4682 issues (all open).

Bugzilla evolution

Download: bugzilla_evol.csv.gz

data <- read.csv(file=url_bz_evol, header=T)

File is bugzilla_evol.csv, and has 3 columns for 4902 weeks.

data.xts <- xts(x = data, order.by = as.POSIXct(data$date))
data.monthly <- apply.monthly(x=data.xts, FUN = nrow)

p <-dygraph(data.monthly[,1],
        main = paste('Monthly issues submissions for ', project_id, sep=''),
        width = "750px", height = 250 ) %>%
      dyRangeSelector()
p

Versions

Download: bugzilla_versions.csv.gz

data <- read.csv(file=url_bz_versions, header=T)

File is bugzilla_versions.csv, and has 2 columns for 66 weeks.

Components

Download: bugzilla_components.csv.gz

data <- read.csv(file=url_bz_components, header=T)

File is bugzilla_components.csv, and has 2 columns for 27 weeks.

Eclipse Forums

Forums posts

Download: eclipse_forums_posts.csv.gz

data <- read.csv(file=url_forums_posts, header=T)

File is ../scripts/projects/tools.cdt/eclipse_forums_posts.csv, and has 6 columns for 37840 posts. The evolution of posts

data$created.date <- as.POSIXct(data$created_date, origin="1970-01-01")
posts.xts <- xts(data, order.by = data$created.date)
posts.weekly <- apply.weekly(x=posts.xts, FUN = nrow)
names(posts.weekly) <- c("posts")

p <- dygraph(
  data = posts.weekly,
  main = paste('Weekly forum posts for ', project_id, sep=''),
  width = 800, height = 250 ) %>%
  dyAxis("x", drawGrid = FALSE) %>%
  dySeries("posts", label = "Weekly posts") %>%
  dyOptions(stepPlot = TRUE) %>%
  dyRangeSelector()
p

The list of the 10 last active posts on the forums:

data$created.date <- as.POSIXct(data$created_date, origin="1970-01-01")
posts.table <- head(data[,c('id', 'subject', 'created.date', 'author_id')], 10)
posts.table$subject <- paste('<a href="', posts.table$html_url, '">', posts.table$subject, '</a>', sep='')
posts.table$created.date <- as.character(posts.table$created.date)
names(posts.table) <- c('ID', 'Subject', 'Post date', 'Post author')

print(
    xtable(head(posts.table, 10),
        caption = paste('10 most recent posts on', project_id, 'forum.', sep=" "),
        digits=0, align="lllll"), type="html",
    html.table.attributes='class="table table-striped"',
    caption.placement='bottom',
    include.rownames=FALSE,
    sanitize.text.function=function(x) { x }
)
10 most recent posts on tools.cdt forum.
ID Subject Post date Post author
1803870 Application deployment 2019-03-12 18:22:54 224711
1803863 Re: Eclipse wont compile 2019-03-12 16:50:43 224708
1803862 Re: Eclipse wont compile 2019-03-12 16:27:44 153692
1803860 Eclipse wont compile 2019-03-12 15:52:08 224708
1803858 Re: How to verify linked library? 2019-03-12 15:41:07 201632
1803851 Re: How to verify linked library? 2019-03-12 14:04:10 153692
1803846 Most useful c++ snippets of code 2019-03-12 13:07:54 224664
1803831 How to verify linked library? 2019-03-12 02:50:19 201632
1803812 libhdf5.so.103: cannot open shared object file 2019-03-11 12:28:30 224687
1803807 how to add support for custom files like assembly to cdt 2019-03-11 10:21:14 224699

Forums threads

Download: eclipse_forums_threads.csv.gz

data <- read.csv(file=url_forums_threads, header=T)

File is ../scripts/projects/tools.cdt/eclipse_forums_threads.csv, and has 8 columns for 13513 threads. A wordcloud with the main words used in threads is presented below.

The list of the 10 last active threads on the forums:

data$last.post.date <- as.POSIXct(data$last_post_date, origin="1970-01-01")
threads.table <- head(data[,c('id', 'subject', 'last.post.date', 'last_post_id', 'replies', 'views')], 10)
threads.table$subject <- paste('<a href="', threads.table$html_url, '">', threads.table$subject, '</a>', sep='')
threads.table$last.post.date <- as.character(threads.table$last.post.date)
names(threads.table) <- c('ID', 'Subject', 'Last post date', 'Last post author', 'Replies', 'Views')

print(
    xtable(threads.table,
        caption = paste('10 last active threads on', project_id, 'forum.', sep=" "),
        digits=0, align="lllllll"), type="html",
    html.table.attributes='class="table table-striped"',
    caption.placement='bottom',
    include.rownames=FALSE,
    sanitize.text.function=function(x) { x }
)
10 last active threads on tools.cdt forum.
ID Subject Last post date Last post author Replies Views
1097998 Application deployment 2019-03-12 18:22:54 1803870 0
1097995 Eclipse wont compile 2019-03-12 16:50:43 1803863 2 118
1097993 Most useful c++ snippets of code 2019-03-12 13:07:54 1803846 0
1097986 How to verify linked library? 2019-03-12 15:41:07 1803858 2 1092
1097977 libhdf5.so.103: cannot open shared object file 2019-03-11 12:28:30 1803812 0
1097974 how to add support for custom files like assembly to cdt 2019-03-11 10:21:14 1803807 0
1097972 What’s it like to be a c++ software engineer? 2019-03-11 09:06:58 1803805 0
1097958 configuering eclipse c++ for HDF libraries 2019-03-09 13:41:48 1803781 0
1097957 HDF5 Library configuration problem [can not find libhdf5_hl_cpp.so] 2019-03-09 13:09:38 1803779 0
1097955 Problem with adding a new file.h 2019-03-09 02:23:13 1803772 2 867

PMI

PMI Checks

Download: eclipse_pmi_checks.csv.gz

data <- read.csv(file=url_pmi_checks, header=T)

File is eclipse_pmi_checks.csv, and has 3 columns for 17 commits.

checks.table <- head(data[,c('Description', 'Value', 'Results')], 10)

print(
    xtable(checks.table,
        caption = paste('Extract of the 10 first PMI checks for ', 
                        project_id, '.', sep=" "),
        digits=0, align="llll"), type="html",
    html.table.attributes='class="table table-striped"',
    caption.placement='bottom',
    include.rownames=FALSE,
    sanitize.text.function=function(x) { x }
)
Extract of the 10 first PMI checks for tools.cdt .
Description Value Results
Checks if the URL can be fetched using a simple get query. https://bugs.eclipse.org/bugs/enter_bug.cgi?product=CDT OK: Create URL could be successfully fetched.
Checks if the URL can be fetched using a simple get query. https://bugs.eclipse.org/bugs/buglist.cgi?product=CDT OK: Query URL could be successfully fetched.
Sends a get request to the given CI URL and looks at the headers in the response (200 404..). Also checks if the URL is really a Hudson instance (through a call to its API). Failed: could not get CI URL [].
Checks if the Dev ML URL can be fetched using a simple get query. https://dev.eclipse.org/mailman/listinfo/cdt-dev OK: Dev ML URL could be successfully fetched.
Checks if the URL can be fetched using a simple get query. http://wiki.eclipse.org/index.php/CDT OK: Documentation URL could be successfully fetched.
Checks if the URL can be fetched using a simple get query. http://www.eclipse.org/cdt/downloads.php OK: Download URL could be successfully fetched.
Checks if the Forums URL can be fetched using a simple get query. http://www.eclipse.org/forums/eclipse.tools.cdt OK. Forum [eclipse.tools.cdt] correctly defined.\OK: Forum [eclipse.tools.cdt] URL could be successfully fetched.
Checks if the URL can be fetched using a simple get query. http://dev.eclipse.org/viewcvs/indextools.cgi/%7Echeckout%7E/cdt-home/user/Tutorials.html OK: Documentation URL could be successfully fetched.
Checks if the Mailing lists URL can be fetched using a simple get query. Failed: no mailing list defined.
Checks if the URL can be fetched using a simple get query. http://www.eclipse.org/cdt/project-info/project-plan.xml OK: Plan URL could be successfully fetched.

SonarQube

SonarQube blocker issues

Download: sq_issues_blocker.csv.gz

data <- read.csv(file=url_sq_issues_blocker, header=T)

File is sq_issues_blocker.csv, and has 5 columns for 140 issues.

data$last.update <- as.POSIXct(data$last_update, origin="1970-01-01")
issues.table <- head(data[,c('key', 'rule', 'sev', 'last.update', 'message')], 10)
issues.table$last.update <- as.character(issues.table$last.update)
names(issues.table) <- c('Key', 'Rule', 'Severity', 'Last update', 'Message')

print(
    xtable(issues.table,
        caption = paste('Extract of 10 SonarQube blocker issues for ', 
                        project_id, '.', sep=" "),
        digits=0, align="llllll"), type="html",
    html.table.attributes='class="table table-striped"',
    caption.placement='bottom',
    include.rownames=FALSE,
    sanitize.text.function=function(x) { x }
)
Extract of 10 SonarQube blocker issues for tools.cdt .
Key Rule Severity Last update Message
01ba92be-945f-4e68-ad67-fe6f66041f38 findbugs:DMI_BLOCKING_METHODS_ON_URL BLOCKER 2017-09-14 Invocation of java.net.URL.equals(Object) which blocks to do domain name resolution in org.eclipse.equinox.launcher.Main.processConfiguration()
0a6fc12b-3766-45af-a27b-2d484b3f6d7d findbugs:DMI_COLLECTION_OF_URLS BLOCKER 2016-01-24 org.eclipse.pde.ui.tests.target.LocalTargetDefinitionTests.testVariableDirectoryBundleContainer() is or uses a map or set of URLs which can be a performance hog
0b158569-d2f5-4b0a-b7fa-9ac84ecb208e findbugs:NP_NULL_INSTANCEOF BLOCKER 2017-12-13 A known null value is checked to see if it is an instance of org.eclipse.emf.diffmerge.api.scopes.IPersistentModelScope in org.polarsys.kitalpha.model.attachment.ui.merge.MergeCommand.doExecute()
0c930952-b0e0-4dac-a3c6-d2871170d05a findbugs:NP_NULL_INSTANCEOF BLOCKER 2016-01-15 A known null value is checked to see if it is an instance of org.eclipse.emf.diffmerge.api.scopes.IPersistentModelScope in org.polarsys.kitalpha.model.attachment.ui.merge.MergeCommand.doExecute()
0e2c939f-15a7-4543-aedc-f139a3c0b02e findbugs:NP_GUARANTEED_DEREF BLOCKER 2017-04-04 newValue could be null and is guaranteed to be dereferenced in org.polarsys.capella.core.data.interaction.impl.ScenarioImpl.eSet(int Object)
0fdc935b-33b1-445a-ad2a-389d6fa9c37f findbugs:BC_IMPOSSIBLE_CAST BLOCKER 2016-11-16 Impossible cast from Integer to Boolean in org.eclipse.kura.internal.wire.publisher.CloudPublisherOptions.getPublishingRetain()
10a086df-f8b8-45f2-91fe-5ec6b2eee4a9 findbugs:DMI_BLOCKING_METHODS_ON_URL BLOCKER 2016-02-27 Invocation of java.net.URL.equals(Object) which blocks to do domain name resolution in org.eclipse.andmore.android.common.utilities.EclipseUtils.openedWebEditor(IWorkbenchPage URL)
18f035f0-9c7b-4fe5-9fcf-78ee13625d45 squid:S2583 BLOCKER 2019-02-18 Change this condition so that it does not always evaluate to true
194f5b55-4812-4654-98f9-ef6df651e302 findbugs:NP_GUARANTEED_DEREF BLOCKER 2017-04-04 newValue could be null and is guaranteed to be dereferenced in org.polarsys.capella.core.data.fa.impl.AbstractFunctionImpl.eSet(int Object)
1c0e67ca-a0e6-4a18-a548-6ad2d8e25435 findbugs:NP_GUARANTEED_DEREF BLOCKER 2016-02-05 e could be null and is guaranteed to be dereferenced in org.eclipse.dltk.xotcl.internal.core.parser.processors.xotcl.XOTclClassNewInstanceProcessor.process(TclStatement ITclParser ASTNode)

SonarQube critical issues

Download: sq_issues_critical.csv.gz

data <- read.csv(file=url_sq_issues_critical, header=T)

File is sq_issues_critical.csv, and has 5 columns for 500 issues.

SonarQube major issues

Download: sq_issues_major.csv.gz

data <- read.csv(file=url_sq_issues_major, header=T)

File is sq_issues_major.csv, and has 5 columns for 500 issues.

SonarQube metrics

Download: sq_metrics.csv.gz

data <- read.csv(file=url_sq_metrics, header=T)

File is sq_metrics.csv, and has 45 columns for 1 line.

# Transform from wide to long format.
data <- t(data)
data_ <- data.frame(rownames(data), data[,1])
names(data_) <- c('Metric', 'Value')
# Remove NAs
data_  <- data_[complete.cases(data_$Value),]

print(
    xtable(data_,
        caption = paste('SonarQube metrics for ', 
                        project_id, '.', sep=" "),
        digits=0, align="lll"), type="html",
    html.table.attributes='class="table table-striped"',
    caption.placement='bottom',
    include.rownames=FALSE,
    sanitize.text.function=function(x) { x }
)
SonarQube metrics for tools.cdt .
Metric Value
SQ_COMMENT_LINES 178184
SQ_CPX_FUNC_IDX 3
SQ_COVERAGE_LINE 37
SQ_PUBLIC_API 40672
SQ_DUPLICATED_LINES_DENSITY 8
SQ_DUPLICATED_LINES 113842
SQ_SQALE_INDEX 1758642
SQ_ISSUES_OPEN 94551
SQ_FILES 7833
SQ_VIOLATIONS_BLOCKER 6
SQ_RULES 35
SQ_PUBLIC_UNDOC_API 21919
SQ_SQALE_DEBT_RATIO 6
SQ_VIOLATIONS_MAJOR 62975
SQ_DUPLICATED_FILES 1240
SQ_STATEMENTS 428171
SQ_CPX_FILE_IDX 29
SQ_NCLOC 934471
SQ_CPX 229270
SQ_COVERAGE_BRANCH 36
SQ_COVERAGE 37
SQ_CPX_CLASS_IDX 22
SQ_PACKAGES_CYCLES 2130
SQ_TESTS 367
SQ_PUBLIC_API_DOC_DENSITY 46
SQ_FUNCS 72600
SQ_VIOLATIONS 94552
SQ_COMR 16
SQ_DUPLICATED_BLOCKS 4240
SQ_VIOLATIONS_CRITICAL 1643
SQ_VIOLATIONS_INFO 7063
SQ_VIOLATIONS_MINOR 22865
SQ_PACKAGES_TANGLE_IDX 18
SQ_TEST_SUCCESSFUL_DENSITY 100
SQ_SQALE_RATING 1