Mercurial > hgrepos > hgweb.cgi > skipweb
view event/oasis2017/idol/idol.cgi @ 3501:948cd5649dfd
edit cgi
author | mituyuki <c115107@g.koeki-u.ac.jp> |
---|---|
date | Sat, 29 Jul 2017 21:43:36 +0900 |
parents | 29a7293dbc21 |
children | 53e17b02d99a |
line wrap: on
line source
#!/usr/bin/env ruby22 # -*- coding: utf-8 -*- require 'cgi' require 'json' require 'sqlite3' dbfile = '../db/point.sq3' c = CGI.new({'accept_charset' => 'utf-8'}) #print "Content-type: application/json; charset=UTF-8\n\n" print "Content-type: text/plain; charset=UTF-8\n\n" value = c['value'].to_f #tag = c['tag'] #now = Time.now.to_s db = SQLite3::Database.new(dbfile) db.busy_timeout = 1000 #db.execute("CREATE TABLE IF NOT EXISTS foo(tag text, time text, val real);") db.execute("CREATE TABLE IF NOT EXISTS foo(time text, val real);") #db.execute("INSERT INTO foo VALUES(?, ?, ?);", tag, now, value) val = {} #val['合計'] = # db.execute("SELECT sum(val) FROM foo WHERE tag=?", tag)[0][0].to_f #val['平均'] = # db.execute("SELECT avg(val) FROM foo WHERE tag=?", tag)[0][0].to_f.round(2) #res = db.execute("SELECT val FROM foo WHERE tag=?", tag) #val['全件'] = res.collect{|row| row[0]} # 先頭カラムを集める val['差'] = value puts JSON.pretty_generate(val)