[RFC PATCH v3 16/17] 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 already been sent to
the channel and has reply to header then the bot reply to that message
if the reply id is exist 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..bb423fd
--- /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