[MediaWiki-commits] [Gerrit] analytics/reportupdater-queries[master]: Add draft creation config and query

2017-09-25 Thread Nuria (Code Review) 
Nuria has submitted this change and it was merged. ( 
https://gerrit.wikimedia.org/r/379441 )

Change subject: Add draft creation config and query
..


Add draft creation config and query

SQL query to count the number of page creations in the Draft (118)
namespace on English Wikipedia, and updated configuration file.

Bug: T176375
Change-Id: I22f3fcb2945596228b1b5e3c61bcf70d1d50dc50
---
M page-creation/config.yaml
A page-creation/pagecreations_draft.sql
2 files changed, 14 insertions(+), 0 deletions(-)

Approvals:
  Nuria: Verified; Looks good to me, approved



diff --git a/page-creation/config.yaml b/page-creation/config.yaml
index dc14b73..b3e268c 100644
--- a/page-creation/config.yaml
+++ b/page-creation/config.yaml
@@ -62,3 +62,10 @@
 lag: 3600 # this can wait an hour
 explode_by:
 wiki_db: enwiki
+
+pagecreations_draft:
+granularity: days
+starts: 2017-07-21
+lag: 3600 # this can wait an hour
+explode_by:
+wiki_db: enwiki
diff --git a/page-creation/pagecreations_draft.sql 
b/page-creation/pagecreations_draft.sql
new file mode 100644
index 000..8367e3e
--- /dev/null
+++ b/page-creation/pagecreations_draft.sql
@@ -0,0 +1,7 @@
+SELECT DATE('{from_timestamp}') AS date,
+COUNT(*) AS {wiki_db}
+FROM mediawiki_page_create_2
+WHERE `database`='{wiki_db}'
+AND page_namespace = 118
+AND rev_timestamp >= STR_TO_DATE('{from_timestamp}', '%Y%m%d%H%i%s')
+AND rev_timestamp < STR_TO_DATE('{to_timestamp}', '%Y%m%d%H%i%s')

-- 
To view, visit https://gerrit.wikimedia.org/r/379441
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings

Gerrit-MessageType: merged
Gerrit-Change-Id: I22f3fcb2945596228b1b5e3c61bcf70d1d50dc50
Gerrit-PatchSet: 1
Gerrit-Project: analytics/reportupdater-queries
Gerrit-Branch: master
Gerrit-Owner: Nettrom 
Gerrit-Reviewer: Milimetric 
Gerrit-Reviewer: Nuria 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] analytics/reportupdater-queries[master]: Add draft creation config and query

2017-09-20 Thread Nettrom (Code Review) 
Nettrom has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/379441 )

Change subject: Add draft creation config and query
..

Add draft creation config and query

SQL query to count the number of page creations in the Draft (118)
namespace on English Wikipedia, and updated configuration file.

Bug: T176375
Change-Id: I22f3fcb2945596228b1b5e3c61bcf70d1d50dc50
---
M page-creation/config.yaml
A page-creation/pagecreations_draft.sql
2 files changed, 14 insertions(+), 0 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/analytics/reportupdater-queries 
refs/changes/41/379441/1

diff --git a/page-creation/config.yaml b/page-creation/config.yaml
index dc14b73..b3e268c 100644
--- a/page-creation/config.yaml
+++ b/page-creation/config.yaml
@@ -62,3 +62,10 @@
 lag: 3600 # this can wait an hour
 explode_by:
 wiki_db: enwiki
+
+pagecreations_draft:
+granularity: days
+starts: 2017-07-21
+lag: 3600 # this can wait an hour
+explode_by:
+wiki_db: enwiki
diff --git a/page-creation/pagecreations_draft.sql 
b/page-creation/pagecreations_draft.sql
new file mode 100644
index 000..8367e3e
--- /dev/null
+++ b/page-creation/pagecreations_draft.sql
@@ -0,0 +1,7 @@
+SELECT DATE('{from_timestamp}') AS date,
+COUNT(*) AS {wiki_db}
+FROM mediawiki_page_create_2
+WHERE `database`='{wiki_db}'
+AND page_namespace = 118
+AND rev_timestamp >= STR_TO_DATE('{from_timestamp}', '%Y%m%d%H%i%s')
+AND rev_timestamp < STR_TO_DATE('{to_timestamp}', '%Y%m%d%H%i%s')

-- 
To view, visit https://gerrit.wikimedia.org/r/379441
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings

Gerrit-MessageType: newchange
Gerrit-Change-Id: I22f3fcb2945596228b1b5e3c61bcf70d1d50dc50
Gerrit-PatchSet: 1
Gerrit-Project: analytics/reportupdater-queries
Gerrit-Branch: master
Gerrit-Owner: Nettrom 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits