import os
import json
import duckdb

EXTENSIONS = ['httpfs', 'spatial', 'postgres']

path_db = '/home/data3/master_folder/isl/repositorios/isl_debug.db'
TABLE_NAME = 'functions_udf_debug'


conn = duckdb.connect(database=path_db)
for extension in EXTENSIONS:
    conn.sql(f'INSTALL {extension}')
    conn.sql(f'LOAD {extension}')

consulta_leer_tabla = f"SELECT * FROM {TABLE_NAME}"
read_table = conn.sql(consulta_leer_tabla).fetchall()

for index,item in enumerate(read_table):
    print(f'Vamos a ver el item {index}')
    print(item[5])
    print(json.loads(item[5]))
    print(item[6])
    print(json.loads(item[6]))
    print(item[6])
    print(json.loads(item[7]))

#    for element in item:
#        print(element)
    print('#################################################3')