From 35513e4ed57986eb4123f6927cda151a246b1ae6 Mon Sep 17 00:00:00 2001
From: Sebastian Reichel <sre@ring0.de>
Date: Sun, 26 Feb 2012 20:25:01 +0100
Subject: add new logging utility

---
 logger.vala | 51 +++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 51 insertions(+)
 create mode 100644 logger.vala

(limited to 'logger.vala')

diff --git a/logger.vala b/logger.vala
new file mode 100644
index 0000000..73fea6d
--- /dev/null
+++ b/logger.vala
@@ -0,0 +1,51 @@
+/* logger.vala
+ * Copyright (c) 2012, Sebastian Reichel <sre@ring0.de>
+ *
+ * Permission to use, copy, modify, and/or distribute this software for any
+ * purpose with or without fee is hereby granted, provided that the above
+ * copyright notice and this permission notice appear in all copies.
+ *
+ * THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES
+ * WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF
+ * MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR
+ * ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES
+ * WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN
+ * ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF
+ * OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.
+ */
+
+static const string create_cmd = "CREATE TABLE log (id INTEGER PRIMARY KEY ASC, temperature_indoor INTEGER, temperature_outdoor INTEGER, humidity_indoor INTEGER, humidity_outdoor INTEGER, pressure INTEGER, wind_average INTEGER, wind_gust INTEGER, wind_direction INTEGER, rain INTEGER);";
+static const string insert_cmd = "INSERT INTO log (\"temperature_indoor\", \"temperature_outdoor\", \"humidity_indoor\", \"humidity_outdoor\", \"pressure\", \"wind_average\", \"wind_gust\", \"wind_direction\", \"rain\") VALUES (\"%u\", \"%u\", \"%u\", \"%u\", \"%u\", \"%u\", \"%u\", \"%u\", \"%u\");";
+
+public static int main(string[] args) {
+	Sqlite.Database db;
+	var station = new Weather.Station();
+
+	if(args.length < 2) {
+		stderr.printf("Usage: %s /path/to/database\n", args[0]);
+		return 1;
+	}
+
+	if(station == null) {
+		stderr.printf("weather station not found!\n");
+		return 1;
+	}
+
+	if (!FileUtils.test (args[1], FileTest.IS_REGULAR)) {
+		stderr.printf ("Database %s does not exist or is directory\n", args[1]);
+		return 1;
+	}
+
+	if(Sqlite.Database.open(args[1], out db) != Sqlite.OK) {
+		stderr.printf ("Can't open database: %s\n", db.errmsg ());
+		return 1;
+	}
+
+	var header = station.read_header();
+	var data = station.read_data(header.history_data_stack);
+
+	db.exec(create_cmd);
+	db.exec(insert_cmd.printf(data.temperature_indoor, data.temperature_outdoor, data.humidity_indoor, data.humidity_outdoor, data.pressure, data.avg_wind_speed, data.gust_wind_speed, data.wind_direction, data.rain));
+
+	return 0;
+}
-- 
cgit v1.2.3