[RFC PATCH v5 16/18] discord: Add save_discord_mail() in database insertion

[Muhammad Rizki <kiizuha@gnuweeb.org>]

Add save_discord_mail() to save lore email that has been sent in the
Discord guild channel for checking if this email has already been sent
to the channel and has a reply to the header then the bot replies to
that message if the reply id exists in the database.

Signed-off-by: Muhammad Rizki <kiizuha@gnuweeb.org>
---
 .../dscord/database/methods/insertion/__init__.py  |  4 +++-
 .../database/methods/insertion/insert_discord.py   | 14 ++++++++++++++
 2 files changed, 17 insertions(+), 1 deletion(-)
 create mode 100644 daemon/dscord/database/methods/insertion/insert_discord.py

diff --git a/daemon/dscord/database/methods/insertion/__init__.py b/daemon/dscord/database/methods/insertion/__init__.py
index 4192735..dd3ecf4 100644
--- a/daemon/dscord/database/methods/insertion/__init__.py
+++ b/daemon/dscord/database/methods/insertion/__init__.py
@@ -6,9 +6,11 @@
 
 from .insert_atom import InsertAtom
 from .insert_broadcast import InsertBroadcast
+from .insert_discord import InsertDiscord
 
 
 class Insertion(
 	InsertAtom,
-	InsertBroadcast
+	InsertBroadcast,
+	InsertDiscord
 ): pass
diff --git a/daemon/dscord/database/methods/insertion/insert_discord.py b/daemon/dscord/database/methods/insertion/insert_discord.py
new file mode 100644
index 0000000..0623188
--- /dev/null
+++ b/daemon/dscord/database/methods/insertion/insert_discord.py
@@ -0,0 +1,14 @@
+from datetime import datetime
+
+
+class InsertDiscord:
+
+	def save_discord_mail(self, email_id, channel_id, dc_msg_id):
+		q = """
+			INSERT INTO dc_mail_msg
+			(email_id, channel_id, dc_msg_id, created_at)
+			VALUES (%s, %s, %s, %s);
+		"""
+		self.cur.execute(q, (email_id, channel_id, dc_msg_id,
+				datetime.utcnow()))
+		return self.cur.lastrowid
-- 
Muhammad Rizki