From 4d9b9f39ab2edebcdd19f807b0cbecbf11a61843 Mon Sep 17 00:00:00 2001 From: Mint <> Date: Sun, 7 Aug 2022 09:24:20 +0300 Subject: [PATCH] Fixing instance fetcher inserting duplicate rows --- fetch_instances.py | 3 +++ 1 file changed, 3 insertions(+) diff --git a/fetch_instances.py b/fetch_instances.py index c59d7fa..1433398 100644 --- a/fetch_instances.py +++ b/fetch_instances.py @@ -55,6 +55,9 @@ for instance in peerlist: instance = instance.lower() print(instance) try: + c.execute( + "select domain from instances where domain = ?", (instance,) + ) if c.fetchone() == None: c.execute( "insert into instances select ?, ?, ?", -- 2.39.2