From 0cecee141d8b1a00d89967a1c9afa90839b23b98 Mon Sep 17 00:00:00 2001
From: Matthew Lemon <y@yulqen.org>
Date: Mon, 13 May 2024 07:30:30 +0100
Subject: Adds jobbly logger sqlite wrapper script

---
 jobblylogger.sh | 25 +++++++++++++++++++++++++
 1 file changed, 25 insertions(+)
 create mode 100755 jobblylogger.sh

(limited to 'jobblylogger.sh')

diff --git a/jobblylogger.sh b/jobblylogger.sh
new file mode 100755
index 0000000..b3e2b5c
--- /dev/null
+++ b/jobblylogger.sh
@@ -0,0 +1,25 @@
+#!/bin/bash
+
+# Check if both date and comment are provided
+if [ $# -lt 2 ]; then
+    echo "Usage: $0 <date> <comment>"
+    exit 1
+fi
+
+# Extract date and comment from command line arguments
+date="$1"
+comment="$2"
+
+# Format the date string to match SQLite's format (YYYY-MM-DD HH:MM:SS)
+formatted_date=$(date -d "$date" +"%Y-%m-%d %H:%M:%S")
+
+# SQLite command to insert the record
+sqlite3 ~/Documents/Notes/jobblylogger.db "INSERT INTO jobbies (date, comments) VALUES ('$formatted_date', '$comment');"
+
+# Check if the insertion was successful
+if [ $? -eq 0 ]; then
+    echo "Record inserted successfully."
+else
+    echo "Failed to insert record."
+fi
+
-- 
cgit v1.2.3