Datasets generated for project modeling.sirius

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

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 20 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 586 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 2422 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 836 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 993 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 30 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 9 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.sirius/eclipse_forums_posts.csv, and has 6 columns for 6465 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.sirius forum.
ID Subject Post date Post author
1803868 Re: how to drag the palette to left side on opening of representation in eclipse emf sirius programa 2019-03-12 17:45:17 202525
1803867 Re: How to apply fill color programatically on selected EObject 2019-03-12 17:20:04 202525
1803848 SYNC Between SIRIUS AND Xtext editor 2019-03-12 13:20:01 221836
1803821 Re: Sirius on the Web 2019-03-11 15:27:28 224701
1803798 how to drag the palette to left side on opening of representation in eclipse emf sirius programatic 2019-03-11 06:02:11 221836
1803797 How to apply fill color programatically on selected EObject 2019-03-11 05:55:03 221836
1803728 Re: Problem defining some design requiriments 2019-03-07 18:42:06 223512
1803711 Re: Creation of two labels 2019-03-07 12:38:14 224545
1803681 Re: How to create a reference to an element in another model? 2019-03-06 18:06:29 203580
1803675 Re: Sirius Model - OPC UA Connection 2019-03-06 16:16:46 27297

Forums threads

Download: eclipse_forums_threads.csv.gz

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

File is ../scripts/projects/modeling.sirius/eclipse_forums_threads.csv, and has 8 columns for 1934 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.sirius forum.
ID Subject Last post date Last post author Replies Views
1097994 SYNC Between SIRIUS AND Xtext editor 2019-03-12 13:20:01 1803848 0 830
1097969 how to drag the palette to left side on opening of representation in eclipse emf sirius programatic 2019-03-12 17:45:17 1803868 1 6295
1097968 How to apply fill color programatically on selected EObject 2019-03-12 17:20:04 1803867 1 6249
1097927 How to migrate from existing ecore to Version Sirius 2019-03-06 15:50:07 1803674 1 1317
1097890 How to create a reference to an element in another model? 2019-03-06 18:06:29 1803681 3 14832
1097874 Is it possible to do live validation of property view text widgets? 2019-03-06 15:07:08 1803669 1 56038
1097855 Creating diagram for transient EObject 2019-03-01 07:22:11 1803462 0 70254
1097828 Creating dynamic representation for a container in Sirius 2019-02-27 13:49:27 1803368 0 62157
1097827 Creating dynamic representation for a container 2019-02-27 13:30:48 1803367 0 62028
1097802 Sirius Model - OPC UA Connection 2019-03-06 16:16:46 1803675 1 56665

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.sirius .
Description Value Results
Checks if the URL can be fetched using a simple get query. https://bugs.eclipse.org/bugs/enter_bug.cgi?product=Sirius 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=Sirius 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://ci.eclipse.org/sirius/ OK. Fetched CI URL.\OK. CI URL is a Hudson instance. Title is [master]
Checks if the Dev ML URL can be fetched using a simple get query. https://dev.eclipse.org/mailman/listinfo/sirius-dev OK: Dev ML URL could be successfully fetched.
Checks if the URL can be fetched using a simple get query. http://www.eclipse.org/sirius/doc OK: Documentation URL could be successfully fetched.
Checks if the URL can be fetched using a simple get query. http://www.eclipse.org/sirius/download.html OK: Download URL could be successfully fetched.
Checks if the Forums URL can be fetched using a simple get query. http://eclipse.org/forums/eclipse.sirius OK. Forum [Sirius Forum] correctly defined.\OK: Forum [Sirius Forum] URL could be successfully fetched.
Checks if the URL can be fetched using a simple get query. http://wiki.eclipse.org/Sirius/Getting_Started OK: Documentation URL could be successfully fetched.
Checks if the Mailing lists URL can be fetched using a simple get query. https://dev.eclipse.org/mailman/listinfo/sirius-dev OK. [sirius-dev] ML correctly defined with email.\OK: [sirius-dev] ML URL could be successfully fetched.
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.sirius .
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.sirius .
Metric Value
SQ_VIOLATIONS_INFO 91
SQ_VIOLATIONS_MINOR 1768
SQ_SQALE_RATING 1
SQ_TEST_SUCCESSFUL_DENSITY 100
SQ_TESTS 5395
SQ_PUBLIC_API_DOC_DENSITY 80
SQ_FUNCS 35343
SQ_COMR 23
SQ_VIOLATIONS 11438
SQ_VIOLATIONS_CRITICAL 337
SQ_DUPLICATED_BLOCKS 3711
SQ_SQALE_DEBT_RATIO 2
SQ_VIOLATIONS_MAJOR 9242
SQ_STATEMENTS 224957
SQ_DUPLICATED_FILES 810
SQ_CPX_FILE_IDX 18
SQ_CPX 86227
SQ_NCLOC 457810
SQ_COVERAGE 65
SQ_COVERAGE_BRANCH 58
SQ_CPX_CLASS_IDX 15
SQ_COMMENT_LINES 135964
SQ_CPX_FUNC_IDX 2
SQ_COVERAGE_LINE 68
SQ_PUBLIC_API 21936
SQ_DUPLICATED_LINES_DENSITY 6
SQ_SQALE_INDEX 205788
SQ_DUPLICATED_LINES 51016
SQ_ISSUES_OPEN 11438
SQ_FILES 4874
SQ_RULES 35
SQ_PUBLIC_UNDOC_API 4303