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=-1.8 required=5.0 tests=ALL_TRUSTED,DKIM_SIGNED, DKIM_VALID,DKIM_VALID_AU,DKIM_VALID_EF,NICE_REPLY_A,NO_DNS_FOR_FROM, URIBL_BLOCKED autolearn=ham autolearn_force=no version=3.4.6 Received: from [192.168.88.254] (unknown [125.160.106.238]) by gnuweeb.org (Postfix) with ESMTPSA id 64BF07E257; Sat, 30 Jul 2022 01:23:44 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gnuweeb.org; s=default; t=1659144225; bh=Fz3oLZRdvhJSWlITKcI94UIjxgxVLO87qBho8g6/wG0=; h=Date:Subject:To:Cc:References:From:In-Reply-To:From; b=BVk5cBU7VgS2AoOhOQIxrTIKQDf5hnoiEukUdmM/NXlHqCE/AfUG0BVc8vNT5BHY3 5NsCP0IVhaOfKVRTGQRmbKaZQChJEhXEM8ZoCjYxWMGqPIO4esn4Pdfj2xbhy2q88n lhvHu3pp+AqmnYYWOQmhsfpwQqh+nqWvDorcuzw91qZFnuOlqwleWaRmYg9xrII9qh whOkVN0QDkmYF+PsjmW0XcADZr7ljtzuVgYYXf0/Itr9iejuNdaOC8tKXawkcM6Gpe t4DR/mQK7irc+HR9EDQQhhLLsSr0kbqpBKRiRNN+KGXL9C8+JUbDV40qCTG8XpUi4z kG+2Koo1xjbAw== Message-ID: Date: Sat, 30 Jul 2022 08:23:41 +0700 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101 Thunderbird/91.11.0 Subject: Re: [PATCH v3 14/18] Add delete_broadcast() in scraper/db.py Content-Language: en-US To: Muhammad Rizki Cc: GNU/Weeb Mailing List , Alviro Iskandar Setiawan References: <20220729014052.1547-1-kiizuha@gnuweeb.org> <20220729014052.1547-15-kiizuha@gnuweeb.org> From: Ammar Faizi In-Reply-To: <20220729014052.1547-15-kiizuha@gnuweeb.org> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: On 7/29/22 8:40 AM, Muhammad Rizki wrote: > + def delete_broadcast(self, chat_id: int): > + q = """ > + DELETE FROM broadcast_chats > + WHERE chat_id = %(chat_id)s > + """ > + self.cur.execute(q, {"chat_id": chat_id}) > + return self.cur.rowcount > 0 OK, this one looks better. Did you manage to test this? -- Ammar Faizi