add endpoint to count xtools usage

MusikAnimal · MusikAnimal · commit f9fad9020f78 · 2016-07-11T12:35:55.000-04:00
diff --git a/app.rb b/app.rb
@@ -90,6 +90,10 @@ class WikiTools < Sinatra::Application
     patch '/mv_uses/:project' do
       record_massviews_use(params['project'])
     end
+
+    patch '/xtools_uses/:project' do
+      record_xtools_use(params['project'])
+    end
   end
 
   not_found do
diff --git a/helpers.rb b/helpers.rb
@@ -156,6 +156,13 @@ def record_massviews_use(project)
     query('UPDATE massviews_projects SET count = count + 1 WHERE project = ?;', project)
   end
 
+  def record_xtools_use(project)
+    if query('SELECT * FROM xtools_projects WHERE project = ?', project).to_a.empty?
+      query('INSERT INTO xtools_projects VALUES(NULL, ?, 0)', project)
+    end
+    query('UPDATE xtools_projects SET count = count + 1 WHERE project = ?;', project)
+  end
+
   def query(sql, *values)
     statement = metadata_client.prepare(sql)
     statement.execute(*values)
