From f461190e22a97bde985b067ce01c4ed9c74f7e62 Mon Sep 17 00:00:00 2001
From: pks <pks@pks.rocks>
Date: Sat, 1 May 2021 06:17:55 +0200
Subject: v1

---
 v1/create-db.rb | 51 +++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 51 insertions(+)
 create mode 100755 v1/create-db.rb

(limited to 'v1/create-db.rb')

diff --git a/v1/create-db.rb b/v1/create-db.rb
new file mode 100755
index 0000000..2866b7b
--- /dev/null
+++ b/v1/create-db.rb
@@ -0,0 +1,51 @@
+#!/usr/bin/env ruby
+
+require 'sqlite3'
+
+db = SQLite3::Database.new("weather.db")
+
+db.execute <<-SQL
+          create table rain(
+           id INTEGER PRIMARY KEY,
+           timestamp DATETIME DEFAULT CURRENT_TIMESTAMP,
+           device_type TEXT,
+           device_id TEXT,
+           battery INTEGER,
+           rssi INTEGER,
+           rain_rate FLOAT,
+           rain_total FLOAT
+         );
+        SQL
+db.execute <<-SQL
+          create table wind(
+           id INTEGER PRIMARY KEY,
+           timestamp DATETIME DEFAULT CURRENT_TIMESTAMP,
+           device_type TEXT,
+           device_id TEXT,
+           battery INTEGER,
+           rssi INTEGER,
+           chill FLOAT,
+           temperature FLOAT,
+           average_speed FLOAT,
+           direction INTEGER,
+           gust FLOAT
+         );
+        SQL
+db.execute <<-SQL
+          create table temp(
+           id INTEGER PRIMARY KEY,
+           timestamp DATETIME DEFAULT CURRENT_TIMESTAMP,
+           device_type TEXT,
+           device_id TEXT,
+           battery INTEGER,
+           rssi INTEGER,
+           humidity FLOAT,
+           humidity_status TEXT,
+           humidity_status_numeric INTEGER,
+           temperature FLOAT,
+           forecast TEXT,
+           forecast_numeric INTEGER
+         );
+        SQL
+
+db.close
-- 
cgit v1.2.3