Datasets generated for project tools.andmore

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.andmore"))

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 114 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 3065 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 135 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 76 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 87 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 8 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 3 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.andmore/eclipse_forums_posts.csv, and has 6 columns for 69 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.andmore forum.
ID Subject Post date Post author
1798372 Can’t install Eclipse 2018-11-16 10:49:22 223514
1798102 Re: Help…Eclipse on Mac won’t open 2018-11-12 15:33:38 222259
1798101 Re: Excel sheet problem(40 rows limited) 2018-11-12 15:29:40 222259
1796384 Eclipse photon window size larger than pixelbook screen 2018-10-12 09:54:49 223088
1795213 Re: How dead is Andmore? How to configure it to be usable? 2018-09-18 15:27:11 222259
1795212 Re: Vanilla Install Errors Creating Project 2018-09-18 15:22:54 222259
1795211 Re: Eclipse photon display problem 2018-09-18 15:18:29 222259
1794315 Eclipse photon display problem 2018-08-28 21:44:25 222576
1793846 Excel sheet problem(40 rows limited) 2018-08-17 09:25:00 222453
1793039 Re: WindowBuilder design show not working correctly 2018-07-29 14:30:43 222259

Forums threads

Download: eclipse_forums_threads.csv.gz

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

File is ../scripts/projects/tools.andmore/eclipse_forums_threads.csv, and has 8 columns for 36 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.andmore forum.
ID Subject Last post date Last post author Replies Views
1096224 Can’t install Eclipse 2018-11-16 10:49:22 1798372 0 1577
1095584 Eclipse photon window size larger than pixelbook screen 2018-10-12 09:54:49 1796384 0 756
1094883 Eclipse photon display problem 2018-09-18 15:18:29 1795211 1 4229
1094726 Excel sheet problem(40 rows limited) 2018-11-12 15:29:40 1798101 1 2023
1094215 How dead is Andmore? How to configure it to be usable? 2018-09-18 15:27:11 1795213 1 1980
1093452 Vanilla Install Errors Creating Project 2018-09-18 15:22:54 1795212 1 27150
1093342 Beginner layout android with Andmore 2018-05-22 10:27:14 1787217 0 1207
1091957 make sure that your IDE(ex:Netbeans, etc)is not adding extra dependenc 2018-02-27 05:05:30 1782600 0 2684
1091895 WindowBuilder design show not working correctly 2018-07-29 14:30:43 1793039 1 4082
1091528 Help…Eclipse on Mac won’t open 2018-11-12 15:33:38 1798102 2 3049

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.andmore .
Description Value Results
Checks if the URL can be fetched using a simple get query. https://bugs.eclipse.org/bugs/enter_bug.cgi?product=andmore 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=andmore 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). https://hudson.eclipse.org/andmore/job/Andmore-Develop/ OK. Fetched CI URL.\Failed: CI URL is not the root of a Hudson instance.
Checks if the Dev ML URL can be fetched using a simple get query. https://dev.eclipse.org/mailman/listinfo/andmore-dev OK: Dev ML URL could be successfully fetched.
Checks if the URL can be fetched using a simple get query. Failed: no URL defined for documentation_url.
Checks if the URL can be fetched using a simple get query. https://github.com/eclipse/andmore/releases OK: Download URL could be successfully fetched.
Checks if the Forums URL can be fetched using a simple get query. Failed: no forums defined.
Checks if the URL can be fetched using a simple get query. Failed: no URL defined for gettingstarted_url.
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. Failed: no URL defined for plan.

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.andmore .
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.andmore .
Metric Value
SQ_SQALE_DEBT_RATIO 6
SQ_VIOLATIONS_MAJOR 11516
SQ_NCLOC 236897
SQ_CPX 50297
SQ_DUPLICATED_FILES 222
SQ_CPX_FILE_IDX 31
SQ_STATEMENTS 112366
SQ_PACKAGES_CYCLES 588
SQ_COVERAGE_BRANCH 42
SQ_COVERAGE 66
SQ_CPX_CLASS_IDX 24
SQ_COMMENT_LINES 58960
SQ_CPX_FUNC_IDX 4
SQ_SQALE_INDEX 391640
SQ_ISSUES_OPEN 18734
SQ_DUPLICATED_LINES 10612
SQ_COVERAGE_LINE 69
SQ_DUPLICATED_LINES_DENSITY 3
SQ_PUBLIC_API 8832
SQ_VIOLATIONS_BLOCKER 6
SQ_FILES 1631
SQ_RULES 35
SQ_PUBLIC_UNDOC_API 4232
SQ_VIOLATIONS_INFO 493
SQ_VIOLATIONS_MINOR 6246
SQ_PACKAGES_TANGLE_IDX 20
SQ_TEST_SUCCESSFUL_DENSITY 98
SQ_SQALE_RATING 1
SQ_TESTS 613
SQ_PUBLIC_API_DOC_DENSITY 52
SQ_FUNCS 13992
SQ_VIOLATIONS 18734
SQ_COMR 20
SQ_DUPLICATED_BLOCKS 573
SQ_VIOLATIONS_CRITICAL 473