From 808116c88329954ce07280fb6caf12d60c5b59df Mon Sep 17 00:00:00 2001
From: emkael <emkael@tlen.pl>
Date: Sun, 30 Jul 2017 14:23:45 +0200
Subject: Sql.selectOne now can distinguish no value in result row from no
 result at all

---
 Aktywator/Sql.cs | 17 ++++++++++++++---
 1 file changed, 14 insertions(+), 3 deletions(-)

(limited to 'Aktywator/Sql.cs')

diff --git a/Aktywator/Sql.cs b/Aktywator/Sql.cs
index c35b0dd..cf0eb38 100644
--- a/Aktywator/Sql.cs
+++ b/Aktywator/Sql.cs
@@ -7,6 +7,10 @@ using data = System.Data.OleDb.OleDbDataReader;
 
 namespace Aktywator
 {
+    class OleDbRowMissingException : Exception
+    {
+    }
+
     class Sql
     {
         private OleDbConnection connection;
@@ -34,12 +38,19 @@ namespace Aktywator
             OleDbCommand cmd = new OleDbCommand(q, connection);
             return cmd.ExecuteNonQuery();
         }
-        public string selectOne(string q)
+        public string selectOne(string q, bool checkForRow = false)
         {
             OleDbCommand cmd = new OleDbCommand(q, connection);
             object o = cmd.ExecuteScalar();
-            if (o == null) return "";
-            else return o.ToString();
+            if (o == null) // it's null if the row does not exist, it'd be DBNull.Value if NULL was the value in existing row
+            {
+                if (!checkForRow)
+                {
+                    return "";
+                }
+                throw new OleDbRowMissingException();
+            }
+            return o.ToString();
         }
         public data select(string q)
         {
-- 
cgit v1.2.3


From c4c905362ccb9042ac1848938bf51ecaef00576a Mon Sep 17 00:00:00 2001
From: emkael <emkael@tlen.pl>
Date: Sat, 30 Sep 2017 20:10:22 +0200
Subject: Wrapper for INSERT OleDB queries

---
 Aktywator/Sql.cs | 26 ++++++++++++++++++++++++++
 1 file changed, 26 insertions(+)

(limited to 'Aktywator/Sql.cs')

diff --git a/Aktywator/Sql.cs b/Aktywator/Sql.cs
index cf0eb38..b3f2104 100644
--- a/Aktywator/Sql.cs
+++ b/Aktywator/Sql.cs
@@ -83,5 +83,31 @@ namespace Aktywator
             }
             return true;
         }
+
+        internal void insert(string table, Dictionary<string, object> columns)
+        {
+            StringBuilder query = new StringBuilder();
+            query.Append("INSERT INTO ");
+            query.Append(table);
+            query.Append(" (");
+            List<string> keys = new List<string>();
+            List<string> parameters = new List<string>();
+            foreach (string key in columns.Keys)
+            {
+                keys.Add("`" + key + "`");
+                parameters.Add("@" + key);
+            }
+            string[] fields = keys.ToArray();
+            query.Append(String.Join(", ", fields));
+            query.Append(") VALUES(");
+            query.Append(String.Join(", ", parameters.ToArray()));
+            query.Append(")");
+            OleDbCommand command = new OleDbCommand(query.ToString(), connection);
+            foreach (KeyValuePair<string, object> column in columns)
+            {
+                command.Parameters.AddWithValue("@" + column.Key, column.Value);
+            }
+            command.ExecuteScalar();
+        }
     }
 }
-- 
cgit v1.2.3