summaryrefslogtreecommitdiff
path: root/v1/query-db.rb
diff options
context:
space:
mode:
authorpks <pks@pks.rocks>2021-05-01 06:17:55 +0200
committerpks <pks@pks.rocks>2021-05-01 06:17:55 +0200
commitf461190e22a97bde985b067ce01c4ed9c74f7e62 (patch)
tree0c2c48d1933765f83d083241df2dd74c6603f2bc /v1/query-db.rb
parent63fbf0f3aadb4b6d037a8164b501fe836d9c361d (diff)
v1
Diffstat (limited to 'v1/query-db.rb')
-rwxr-xr-xv1/query-db.rb19
1 files changed, 19 insertions, 0 deletions
diff --git a/v1/query-db.rb b/v1/query-db.rb
new file mode 100755
index 0000000..984a59d
--- /dev/null
+++ b/v1/query-db.rb
@@ -0,0 +1,19 @@
+#!/usr/bin/env ruby
+
+require 'sqlite3'
+
+db = SQLite3::Database.new("weather.db")
+
+#db.execute("select * from rain") do |result|
+# puts result.to_s
+#end
+
+#db.execute("select * from wind") do |result|
+# puts result.to_s
+#end
+
+db.execute("select * from temp") do |result|
+ puts result.to_s
+end
+
+db.close