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

---
 create-db.rb | 51 ---------------------------------------------------
 1 file changed, 51 deletions(-)
 delete mode 100755 create-db.rb

(limited to 'create-db.rb')

diff --git a/create-db.rb b/create-db.rb
deleted file mode 100755
index 2866b7b..0000000
--- a/create-db.rb
+++ /dev/null
@@ -1,51 +0,0 @@
-#!/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