MaxSem has uploaded a new change for review. (
https://gerrit.wikimedia.org/r/327373 )
Change subject: Count number of pages with tabular data on Commons
......................................................................
Count number of pages with tabular data on Commons
Change-Id: I4ac2ade9a951aa6deb0c898d6297935ff31b21ab
---
M interactive/config.yaml
A interactive/tabular-repo.sql
2 files changed, 26 insertions(+), 0 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/discovery-stats
refs/changes/73/327373/1
diff --git a/interactive/config.yaml b/interactive/config.yaml
index 990f388..e05b320 100644
--- a/interactive/config.yaml
+++ b/interactive/config.yaml
@@ -9,6 +9,11 @@
port: 3307
creds_file: ~/.my.cnf.research
db: log
+ commons:
+ host: "analytics-store.eqiad.wmnet"
+ port: 3306
+ creds_file: /a/.my.cnf.research
+ db: commonswiki
graphite:
host: graphite.eqiad.wmnet
@@ -40,3 +45,13 @@
path: "{_metric}.{action}.{feature}"
metrics:
"daily.kartographer.events-all": events
+
+ tabular-repo:
+ granularity: days
+ funnel: true
+ starts: 2016-12-13
+ db: commons
+ graphite:
+ path: "{_metric}"
+ metrics:
+ "daily.tabular.repo.pagecount": num
diff --git a/interactive/tabular-repo.sql b/interactive/tabular-repo.sql
new file mode 100644
index 0000000..9598bf0
--- /dev/null
+++ b/interactive/tabular-repo.sql
@@ -0,0 +1,11 @@
+SELECT
+ DATE(NOW()) AS day,
+ COUNT(*) AS num
+ FROM page
+ WHERE
+ page_namespace = 486
+ AND (
+ page_title LIKE '%.tab'
+ OR page_title LIKE '%.map'
+ )
+;
--
To view, visit https://gerrit.wikimedia.org/r/327373
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I4ac2ade9a951aa6deb0c898d6297935ff31b21ab
Gerrit-PatchSet: 1
Gerrit-Project: analytics/discovery-stats
Gerrit-Branch: master
Gerrit-Owner: MaxSem <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
