def query_materialize(c: Composition, ) -> int:
with c.sql_cursor() as cursor:
try:
cursor.execute("SELECT * FROM load_test_count")
row = cursor.fetchone()
if row is None or len(row) != 1 or row[0] is None:
return 0
return int(row[0])
except InterfaceError as e:
print(f"C> error while querying materialized: {e}")
return 0
def query_materialize(c: Composition, ) -> int:
with c.sql_cursor() as cursor:
try:
cursor.execute("SELECT * FROM load_test_materialization_frontier")
row = cursor.fetchone()
if row is None or len(row) != 1 or row[0] is None:
return 0
timestamp = int(row[0])
if timestamp == 0:
return 0
cursor.execute(f"SELECT * FROM records_ingested AS OF {timestamp}")
row = cursor.fetchone()
if row is None or len(row) != 1 or row[0] is None:
return 0
return int(row[0])
except InterfaceError as e:
print(f"C> error while querying materialized: {e}")
return 0
