fix(): admin stats and postgres

torkelo · torkelo · commit 9c14b9672f9c · 2016-04-11T18:16:35.000-04:00
diff --git a/packaging/publish/publish.sh b/packaging/publish/publish.sh
@@ -1,7 +1,7 @@
 #! /usr/bin/env bash
 
-deb_ver=3.0.0-beta21459801392
-rpm_ver=3.0.0-beta21459801392
+deb_ver=3.0.0-beta31460381868
+rpm_ver=3.0.0-beta31460381868
 
 #rpm_ver=3.0.0-1
 
@@ -15,7 +15,7 @@ rpm_ver=3.0.0-beta21459801392
 
 #wget https://grafanarel.s3.amazonaws.com/builds/grafana-${rpm_ver}.x86_64.rpm
 
-package_cloud push grafana/testing/el/6 grafana-${rpm_ver}.x86_64.rpm
+#package_cloud push grafana/testing/el/6 grafana-${rpm_ver}.x86_64.rpm
 #package_cloud push grafana/testing/el/7 grafana-${rpm_ver}.x86_64.rpm
 
 # package_cloud push grafana/stable/el/7 grafana-${version}-1.x86_64.rpm
diff --git a/pkg/models/stats.go b/pkg/models/stats.go
@@ -21,15 +21,14 @@ type GetDataSourceStatsQuery struct {
 }
 
 type AdminStats struct {
-	UserCount         int `json:"user_count"`
-	OrgCount          int `json:"org_count"`
-	DashboardCount    int `json:"dashboard_count"`
-	DbSnapshotCount   int `json:"db_snapshot_count"`
-	DbTagCount        int `json:"db_tag_count"`
-	DataSourceCount   int `json:"data_source_count"`
-	PlaylistCount     int `json:"playlist_count"`
-	StarredDbCount    int `json:"starred_db_count"`
-	GrafanaAdminCount int `json:"grafana_admin_count"`
+	UserCount       int `json:"user_count"`
+	OrgCount        int `json:"org_count"`
+	DashboardCount  int `json:"dashboard_count"`
+	DbSnapshotCount int `json:"db_snapshot_count"`
+	DbTagCount      int `json:"db_tag_count"`
+	DataSourceCount int `json:"data_source_count"`
+	PlaylistCount   int `json:"playlist_count"`
+	StarredDbCount  int `json:"starred_db_count"`
 }
 
 type GetAdminStatsQuery struct {
diff --git a/pkg/services/sqlstore/stats.go b/pkg/services/sqlstore/stats.go
@@ -85,12 +85,7 @@ func GetAdminStats(query *m.GetAdminStatsQuery) error {
       (
         SELECT COUNT(DISTINCT ` + dialect.Quote("dashboard_id") + ` )
         FROM ` + dialect.Quote("star") + `
-      ) AS starred_db_count,
-      (
-        SELECT COUNT(*)
-        FROM ` + dialect.Quote("user") + `
-        WHERE ` + dialect.Quote("is_admin") + ` = 1
-      ) AS grafana_admin_count
+      ) AS starred_db_count
       `
 
 	var stats m.AdminStats
diff --git a/public/app/features/admin/partials/stats.html b/public/app/features/admin/partials/stats.html
@@ -22,10 +22,6 @@ <h1>Stats</h1>
 				<td>Total users</td>
 				<td>{{ctrl.stats.user_count}}</td>
 			</tr>
-			<tr>
-				<td>Total grafana admins</td>
-				<td>{{ctrl.stats.grafana_admin_count}}</td>
-			</tr>
 			<tr>
 				<td>Total organizations</td>
 				<td>{{ctrl.stats.org_count}}</td>

Original file line number	Diff line number	Diff line change
`@@ -85,12 +85,7 @@ func GetAdminStats(query *m.GetAdminStatsQuery) error {`
`85`	`85`	`(`
`86`	`86`	SELECT COUNT(DISTINCT ` + dialect.Quote("dashboard_id") + ` )
`87`	`87`	FROM ` + dialect.Quote("star") + `
`88`		`- ) AS starred_db_count,`
`89`		`- (`
`90`		`- SELECT COUNT(*)`
`91`		- FROM ` + dialect.Quote("user") + `
`92`		- WHERE ` + dialect.Quote("is_admin") + ` = 1
`93`		`- ) AS grafana_admin_count`
	`88`	`+ ) AS starred_db_count`
`94`	`89`	`
`95`	`90`
`96`	`91`	`var stats m.AdminStats`