gds table has zero rows

[adammaikai]

After switching from the demo file to the full db, my code stopped working due to an empty gds table.

table_name = 'gds'
query = f"SELECT COUNT(*) FROM {table_name}"
conn = sqlite3.connect('GEOmetadb.sqlite')
cur = conn.cursor()
cur.execute(query)
result = cur.fetchone()
row_count = result[0]
print(row_count)
0

conn = sqlite3.connect('GEOmetadb_demo.sqlite')
cur = conn.cursor()
cur.execute(query)
result = cur.fetchone()
row_count = result[0]
print(row_count)
3566