Datasets generated for project modeling.emf-parsley

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 = "modeling.emf-parsley"))

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 352 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 11084 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 174 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 19 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 123 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 1 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/modeling.emf-parsley/eclipse_forums_posts.csv, and has 6 columns for 182 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 modeling.emf-parsley forum.
ID Subject Post date Post author
1795042 Re: Can not change int attribute 2018-09-13 14:29:02 222471
1794868 Re: Can not change int attribute 2018-09-10 01:10:01 133893
1794265 Can not change int attribute 2018-08-28 11:25:45 222471
1785329 Re: Loading Resource via Filechooser 2018-04-12 16:58:34 31021
1785116 Re: Loading Resource via Filechooser 2018-04-09 18:34:26 220280
1784806 Re: Loading Resource via Filechooser 2018-04-04 12:14:21 31021
1784804 Re: Loading Resource via Filechooser 2018-04-04 12:10:20 31021
1784784 Re: Loading Resource via Filechooser 2018-04-04 09:42:59 31021
1784473 Re: Loading Resource via Filechooser 2018-03-28 13:17:54 220280
1783845 Re: Loading Resource via Filechooser 2018-03-19 11:21:20 31021

Forums threads

Download: eclipse_forums_threads.csv.gz

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

File is ../scripts/projects/modeling.emf-parsley/eclipse_forums_threads.csv, and has 8 columns for 46 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 modeling.emf-parsley forum.
ID Subject Last post date Last post author Replies Views
1094870 Can not change int attribute 2018-09-13 14:29:02 1795042 2 2485
1092310 Loading Resource via Filechooser 2018-04-12 16:58:34 1785329 7 3206
1091605 Calling a method on Button Push 2018-02-26 15:55:48 1782567 2 3377
1091604 EMF Parsley 1.2.2 Released 2018-02-08 14:56:59 1781557 0 2762
1090417 Standalone form? 2017-12-16 15:44:34 1778545 3 2496
1090343 actionAdd replaces context menus instead of adding 2017-12-14 22:52:04 1778492 4 1527
1089230 Oxygen with coming xtext 2.13 2017-10-09 09:22:26 1774011 1 5421
1089001 Creating a EMF Parsley standalone application 2017-09-26 23:45:45 1773371 3 3340
1088257 Tutorial on how to build web applications with EMF Parsley 2017-08-16 13:39:21 1770708 0 9835
1087131 Bug or Design? Cannot further extend an extended EmfParsleyJavaGuiceModule 2018-02-08 11:50:17 1781543 2 10778

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 modeling.emf-parsley .
Description Value Results
Checks if the URL can be fetched using a simple get query. https://bugs.eclipse.org/bugs/enter_bug.cgi?product=EMF.Parsley 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=EMF.Parsley 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/emfparsley-dev OK: Dev ML URL could be successfully fetched.
Checks if the URL can be fetched using a simple get query. https://www.eclipse.org/emf-parsley/documentation.html OK: Documentation URL could be successfully fetched.
Checks if the URL can be fetched using a simple get query. https://www.eclipse.org/emf-parsley/download.html 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.parsley OK. Forum [Emf Parsley Forum] correctly defined.\OK: Forum [Emf Parsley Forum] URL could be successfully fetched.
Checks if the URL can be fetched using a simple get query. https://www.eclipse.org/emf-parsley/documentation.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. 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 modeling.emf-parsley .
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 modeling.emf-parsley .
Metric Value
SQ_COVERAGE_BRANCH 86
SQ_COVERAGE 93
SQ_CPX_CLASS_IDX 10
SQ_NCLOC 11682
SQ_CPX 2032
SQ_CPX_FILE_IDX 11
SQ_STATEMENTS 4273
SQ_RULES 35
SQ_PUBLIC_UNDOC_API 328
SQ_FILES 190
SQ_COVERAGE_LINE 95
SQ_PUBLIC_API 612
SQ_COMMENT_LINES 1513
SQ_CPX_FUNC_IDX 2
SQ_SQALE_RATING 1
SQ_COMR 12
SQ_PUBLIC_API_DOC_DENSITY 46
SQ_FUNCS 1099