Addshore has submitted this change and it was merged.
Change subject: Add properties_by_datatype script
......................................................................
Add properties_by_datatype script
Bug:T119603
Change-Id: I31237e5c2c1d9c9965429a29638f6343892b9325
---
M daily_datamodel.sh
A graphite/datamodel/properties_by_datatype.php
A graphite/datamodel/sql/properties_by_datatype.sql
3 files changed, 44 insertions(+), 0 deletions(-)
Approvals:
Addshore: Verified; Looks good to me, approved
jenkins-bot: Verified
diff --git a/daily_datamodel.sh b/daily_datamodel.sh
index 177ba89..61b4653 100755
--- a/daily_datamodel.sh
+++ b/daily_datamodel.sh
@@ -1,3 +1,4 @@
#!/bin/bash
+php ~/wikidata-data/graphite/datamodel/properties_by_datatype.php
php ~/wikidata-data/graphite/datamodel/terms_by_language.php
\ No newline at end of file
diff --git a/graphite/datamodel/properties_by_datatype.php
b/graphite/datamodel/properties_by_datatype.php
new file mode 100644
index 0000000..272cf1e
--- /dev/null
+++ b/graphite/datamodel/properties_by_datatype.php
@@ -0,0 +1,38 @@
+<?php
+
+/**
+ * @author Addshore
+ */
+
+require_once( __DIR__ . '/../../src/WikimediaDb.php' );
+$metrics = new WikidataPropertiesByDataType();
+$metrics->execute();
+
+class WikidataPropertiesByDataType{
+
+ public function execute() {
+ $pdo = WikimediaDb::getPdo();
+ $queryResult = $pdo->query( file_get_contents( __DIR__ .
'/sql/properties_by_datatype.sql' ) );
+
+ if( $queryResult === false ) {
+ throw new RuntimeException( "Something went wrong with
the db query" );
+ }
+
+ $rows = $queryResult->fetchAll();
+
+ foreach( $rows as $row ) {
+ $type = $row['type'];
+
+ $this->sendMetric(
+
"daily.wikidata.datamodel.property.datatype.$type",
+ $row['count']
+ );
+ }
+ }
+
+
+ private function sendMetric( $name, $value ) {
+ exec( "echo \"$name $value `date +%s`\" | nc -q0
graphite.eqiad.wmnet 2003" );
+ }
+
+}
diff --git a/graphite/datamodel/sql/properties_by_datatype.sql
b/graphite/datamodel/sql/properties_by_datatype.sql
new file mode 100644
index 0000000..e30ee2b
--- /dev/null
+++ b/graphite/datamodel/sql/properties_by_datatype.sql
@@ -0,0 +1,5 @@
+SELECT
+ COUNT(*) AS count,
+ pi_type AS type
+FROM wikidatawiki.wb_property_info
+GROUP BY pi_type
\ No newline at end of file
--
To view, visit https://gerrit.wikimedia.org/r/255368
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: I31237e5c2c1d9c9965429a29638f6343892b9325
Gerrit-PatchSet: 2
Gerrit-Project: analytics/limn-wikidata-data
Gerrit-Branch: master
Gerrit-Owner: Addshore <[email protected]>
Gerrit-Reviewer: Addshore <[email protected]>
Gerrit-Reviewer: Springle <[email protected]>
Gerrit-Reviewer: jenkins-bot <>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
