public inbox for [email protected]
 help / color / mirror / Atom feed
From: Muhammad Rizki <[email protected]>
To: Ammar Faizi <[email protected]>
Cc: Muhammad Rizki <[email protected]>,
	Alviro Iskandar Setiawan <[email protected]>,
	GNU/Weeb Mailing List <[email protected]>
Subject: [RFC PATCH v3 17/17] discord: Add save_email() in database insertion
Date: Mon, 19 Sep 2022 14:26:41 +0700	[thread overview]
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>

Add save_email() to save raw lore emails to the database.

Explanation:
The functionality is like save_discord_mail() but it's still differ.
Save lore emails if it's not exist in database yet, if it does then
ignore.

Signed-off-by: Muhammad Rizki <[email protected]>
---
 .../database/methods/insertion/__init__.py    |  4 +++-
 .../methods/insertion/insert_email.py         | 20 +++++++++++++++++++
 2 files changed, 23 insertions(+), 1 deletion(-)
 create mode 100644 daemon/dscord/database/methods/insertion/insert_email.py

diff --git a/daemon/dscord/database/methods/insertion/__init__.py b/daemon/dscord/database/methods/insertion/__init__.py
index dd3ecf4..5137b84 100644
--- a/daemon/dscord/database/methods/insertion/__init__.py
+++ b/daemon/dscord/database/methods/insertion/__init__.py
@@ -7,10 +7,12 @@
 from .insert_atom import InsertAtom
 from .insert_broadcast import InsertBroadcast
 from .insert_discord import InsertDiscord
+from .insert_email import InsertEmail
 
 
 class Insertion(
 	InsertAtom,
 	InsertBroadcast,
-	InsertDiscord
+	InsertDiscord,
+	InsertEmail
 ): pass
diff --git a/daemon/dscord/database/methods/insertion/insert_email.py b/daemon/dscord/database/methods/insertion/insert_email.py
new file mode 100644
index 0000000..0fab378
--- /dev/null
+++ b/daemon/dscord/database/methods/insertion/insert_email.py
@@ -0,0 +1,20 @@
+from mysql.connector import errors
+from datetime import datetime
+
+
+class InsertEmail:
+
+	def save_email(self, email_msg_id):
+		try:
+			return self.__insert_email(email_msg_id)
+		except errors.IntegrityError:
+			#
+			# Duplicate data, skip!
+			#
+			return None
+
+
+	def __insert_email(self, email_msg_id):
+		q = "INSERT INTO dc_emails (message_id, created_at) VALUES (%s, %s)"
+		self.cur.execute(q, (email_msg_id, datetime.utcnow()))
+		return self.cur.lastrowid
-- 
Muhammad Rizki


      parent reply	other threads:[~2022-09-19  7:27 UTC|newest]

Thread overview: 20+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2022-09-19  7:26 [RFC PATCH v3 00/17] Refactor Telegram & initial work Discord Muhammad Rizki
2022-09-19  7:26 ` [RFC PATCH v3 01/17] telegram: Move the Telegram bot source code Muhammad Rizki
2022-09-19  7:26 ` [RFC PATCH v3 02/17] telegram: Refactor Telegram bot database method Muhammad Rizki
2022-09-19  7:26 ` [RFC PATCH v3 03/17] telegram: Renaming some functions in scraper/bot.py Muhammad Rizki
2022-09-19  7:26 ` [RFC PATCH v3 04/17] Add ignore file for .env Muhammad Rizki
2022-09-20  8:45   ` Ammar Faizi
2022-09-19  7:26 ` [RFC PATCH v3 05/17] telegram: Refactor the Telegram bot Muhammad Rizki
2022-09-19  7:26 ` [RFC PATCH v3 06/17] telegram: Renames in telegram mailer directory Muhammad Rizki
2022-09-19  7:26 ` [RFC PATCH v3 07/17] Move scraper and utility file Muhammad Rizki
2022-09-19  7:26 ` [RFC PATCH v3 08/17] discord: Initial work Discord bot Muhammad Rizki
2022-09-19  7:26 ` [RFC PATCH v3 09/17] discord: Add success run notice on_ready event Muhammad Rizki
2022-09-19  7:26 ` [RFC PATCH v3 10/17] discord: Add error handler on events Muhammad Rizki
2022-09-20  8:37   ` Ammar Faizi
2022-09-19  7:26 ` [RFC PATCH v3 11/17] Move db.sql to combine database with Discord and Telegram Muhammad Rizki
2022-09-19  7:26 ` [RFC PATCH v3 12/17] discord: Add database tables for Discord bot Muhammad Rizki
2022-09-19  7:26 ` [RFC PATCH v3 13/17] discord: Add initial Discord bot database instance Muhammad Rizki
2022-09-19  7:26 ` [RFC PATCH v3 14/17] discord: Add save_atom() in database insertion Muhammad Rizki
2022-09-19  7:26 ` [RFC PATCH v3 15/17] discord: Add save_broadcast() " Muhammad Rizki
2022-09-19  7:26 ` [RFC PATCH v3 16/17] discord: Add save_discord_mail() " Muhammad Rizki
2022-09-19  7:26 ` Muhammad Rizki [this message]

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    [email protected] \
    [email protected] \
    [email protected] \
    [email protected] \
    [email protected] \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox