From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: X-Spam-Checker-Version: SpamAssassin 3.4.6 (2021-04-09) on gnuweeb.org X-Spam-Level: X-Spam-Status: No, score=-0.8 required=5.0 tests=ALL_TRUSTED,DKIM_SIGNED, DKIM_VALID,DKIM_VALID_AU,DKIM_VALID_EF,NO_DNS_FOR_FROM,URIBL_BLOCKED autolearn=no autolearn_force=no version=3.4.6 Received: from localhost.localdomain (unknown [101.128.125.94]) by gnuweeb.org (Postfix) with ESMTPSA id 6BC9E806E2; Fri, 29 Jul 2022 00:41:51 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gnuweeb.org; s=default; t=1659055312; bh=DFPehYbN/yr5oRWnePXG8hVXb/O2QE4m7IirMsVzEAw=; h=From:To:Cc:Subject:Date:In-Reply-To:References:From; b=mqI+BoNY2hL5qM0c0W3y5/U/XV8qxleo6rM+tatodZI1Ya42lioH1d20Yx1451Vv0 xnz8B13uiZNXPHfJ/pU8gxYrpIBDR/BieZbLgEbkiugMza1jr0Lb2WIpdgs8mnb9// Ws7Pu8OCqsL7hZ8g+FZa3qpx5WjjrZDB1Zncxudj5aJ6VOdj0Z86Tz7URyGTOnHe1Y YjLMcnddq/YYJ8fHMFY/9DIqfP1DkZ9rs9ABANyyNI8+YUdoS7J8b3qghAnFnfb1Dz DjL6StmSgdBv5585h7r7ODhoNTyOHDVMYMW22zVSGFEp0rR9vGpUhq0Qb5DWVLm0Xs Se8gJzajmzhqg== From: Muhammad Rizki To: Ammar Faizi Cc: Muhammad Rizki , GNU/Weeb Mailing List Subject: [PATCH v1 14/18] Add delete_broadcast() in scraper/db.py Date: Fri, 29 Jul 2022 07:40:23 +0700 Message-Id: <20220729004046.1890-15-kiizuha@gnuweeb.org> X-Mailer: git-send-email 2.34.1.windows.1 In-Reply-To: <20220729004046.1890-1-kiizuha@gnuweeb.org> References: <20220729004046.1890-1-kiizuha@gnuweeb.org> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit List-Id: Add delete_broadcast() for delete a chat in the database from receiving email messages. Signed-off-by: Muhammad Rizki --- daemon/scraper/db.py | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) diff --git a/daemon/scraper/db.py b/daemon/scraper/db.py index 805b591..6faedb6 100644 --- a/daemon/scraper/db.py +++ b/daemon/scraper/db.py @@ -199,6 +199,24 @@ class Db(): return self.cur.lastrowid + def delete_broadcast(self, chat_id: Union[int, str]): + get_query = """ + SELECT id FROM broadcast_chats + WHERE chat_id = %(chat_id)s + """ + delete_query = """ + DELETE FROM broadcast_chats + WHERE chat_id = %(chat_id)s + """ + self.cur.execute(get_query, {"chat_id": chat_id}) + exist = self.cur.fetchone() + if bool(exist): + self.cur.execute(delete_query, {"chat_id": chat_id}) + return True + + return False + + def get_broadcast_chats(self): q = """ SELECT * -- Muhammad Rizki