From ae7e8c67ce78fe520bb8dbf269dd73dca585739d Mon Sep 17 00:00:00 2001 From: =?utf8?q?Roland=20H=C3=A4der?= Date: Sat, 11 Jan 2025 23:02:33 +0100 Subject: [PATCH] Continued: - copy fetchall() result into local variable for counting total rows --- fba/commands.py | 6 +++++- fba/database.py | 1 + 2 files changed, 6 insertions(+), 1 deletion(-) diff --git a/fba/commands.py b/fba/commands.py index 87eaaeb..7f55ff5 100644 --- a/fba/commands.py +++ b/fba/commands.py @@ -67,6 +67,7 @@ logging.basicConfig(level=logging.INFO) logger = logging.getLogger(__name__) #logger.setLevel(logging.DEBUG) +# Default random number generator default_rng = numpy.random.default_rng() def check_instance(args: argparse.Namespace) -> int: @@ -98,7 +99,10 @@ WHERE nodeinfo_url IS NOT NULL \ ORDER BY domain ASC") cnt = 0 - for row in database.cursor.fetchall(): + rows = database.cursor.fetchall() + + logger.info("Checking %d row(s) ...", len(rows)) + for row in rows: logger.debug("Checking row[domain]='%s',row[software]='%s',row[nodeinfo_url]='%s' ...", row["domain"], row["software"], row["nodeinfo_url"]) punycode = domain_helper.encode_idna(row["domain"]) diff --git a/fba/database.py b/fba/database.py index 23bfab0..46432ef 100644 --- a/fba/database.py +++ b/fba/database.py @@ -18,6 +18,7 @@ import sqlite3 logging.basicConfig(level=logging.INFO) logger = logging.getLogger(__name__) +#logger.setLevel(logging.DEBUG) # Connect to database logger.debug("Opening database file blocks.db ...") -- 2.39.5