From 281fa36a24f81d87543a7791252954414e161565 Mon Sep 17 00:00:00 2001
From: pks <pks@pks.rocks>
Date: Mon, 10 May 2021 13:23:21 +0200
Subject: rm v0 v1

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

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

diff --git a/v1/create-db.rb b/v1/create-db.rb
deleted file mode 100755
index 2866b7b..0000000
--- a/v1/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