Catrope has uploaded a new change for review. (
https://gerrit.wikimedia.org/r/343247 )
Change subject: Add stats for the "New wikitext mode" beta feature
......................................................................
Add stats for the "New wikitext mode" beta feature
Change-Id: Ib06a6434478c7adc90b5200193e0959e4b825569
---
A edit-beta-features/config.yaml
A edit-beta-features/nwe_beta.sql
A edit-beta-features/nwe_dbs.txt
3 files changed, 40 insertions(+), 0 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/limn-edit-data
refs/changes/47/343247/1
diff --git a/edit-beta-features/config.yaml b/edit-beta-features/config.yaml
new file mode 100644
index 0000000..dd2a436
--- /dev/null
+++ b/edit-beta-features/config.yaml
@@ -0,0 +1,16 @@
+databases:
+ mediawiki:
+ host: "analytics-store.eqiad.wmnet"
+ port: 3306
+ creds_file: /a/.my.cnf.research
+ db: enwiki # just a default, queries already specify it
+
+defaults:
+ db: mediawiki
+
+reports:
+ nwe_beta:
+ granularity: days
+ starts: 2017-03-17
+ explode_by:
+ wiki_db: nwe_dbs.txt
diff --git a/edit-beta-features/nwe_beta.sql b/edit-beta-features/nwe_beta.sql
new file mode 100644
index 0000000..2dca064
--- /dev/null
+++ b/edit-beta-features/nwe_beta.sql
@@ -0,0 +1,6 @@
+ select date('{from_timestamp}') as date,
+ count(*) as {wiki_db}
+ from {wiki_db}.user_properties
+ where up_property='visualeditor-newwikitext'
+ and up_value=1
+;
diff --git a/edit-beta-features/nwe_dbs.txt b/edit-beta-features/nwe_dbs.txt
new file mode 100644
index 0000000..7666a51
--- /dev/null
+++ b/edit-beta-features/nwe_dbs.txt
@@ -0,0 +1,18 @@
+enwiki
+dewiki
+frwiki
+eswiki
+jawiki
+ruwiki
+itwiki
+zhwiki
+ptwiki
+arwiki
+plwiki
+nlwiki
+trwiki
+svwiki
+hewiki
+commonswiki
+wikidatawiki
+enwiktionary
--
To view, visit https://gerrit.wikimedia.org/r/343247
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Ib06a6434478c7adc90b5200193e0959e4b825569
Gerrit-PatchSet: 1
Gerrit-Project: analytics/limn-edit-data
Gerrit-Branch: master
Gerrit-Owner: Catrope <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
