import duckdb
import json

# Conectar a la base de datos
conn = duckdb.connect(database='/home/data3/master_folder/duckdb/servidor.db')
conn.execute("INSTALL httpfs")
conn.execute("INSTALL postgres")

conn.execute("LOAD httpfs")
conn.execute("LOAD postgres")

crear_tabla = "CREATE TABLE discos_redireccion_nginx (URL VARCHAR, DISC VARCHAR, MOUNT VARCHAR, UNIQUE (URL))"
conn.execute(crear_tabla)

meter_valores = ["INSERT INTO discos_redireccion_nginx (URL, DISC, MOUNT) VALUES ('https://sd1.d1.ipsilum.com', 'data1', '/media/data1')",
                 "INSERT INTO discos_redireccion_nginx (URL, DISC, MOUNT) VALUES ('https://sd1.d2.ipsilum.com', 'data2', '/media/data2')",
                 "INSERT INTO discos_redireccion_nginx (URL, DISC, MOUNT) VALUES ('https://sd1.d3.ipsilum.com', 'data3', '/media/data3/master_folder')",
                 "INSERT INTO discos_redireccion_nginx (URL, DISC, MOUNT) VALUES ('https://sd1.d4.ipsilum.com', 'data4', '/media/data4')",
                 "INSERT INTO discos_redireccion_nginx (URL, DISC, MOUNT) VALUES ('https://sd1.d5.ipsilum.com', 'data5', '/media/data5')",
                 "INSERT INTO discos_redireccion_nginx (URL, DISC, MOUNT) VALUES ('https://sd1.d6.ipsilum.com', 'data6', '/media/data6')",
                 "INSERT INTO discos_redireccion_nginx (URL, DISC, MOUNT) VALUES ('https://sd1.d7.ipsilum.com', 'data7', '/media/data7')",
                 "INSERT INTO discos_redireccion_nginx (URL, DISC, MOUNT) VALUES ('https://sd1.d8.ipsilum.com', 'data8', '/media/data8')",
                 "INSERT INTO discos_redireccion_nginx (URL, DISC, MOUNT) VALUES ('https://sd1.d9.ipsilum.com', 'data9', '/media/data9')",
                 "INSERT INTO discos_redireccion_nginx (URL, DISC, MOUNT) VALUES ('https://sd1.d10.ipsilum.com', 'data10', '/media/data10')",
                 "INSERT INTO discos_redireccion_nginx (URL, DISC, MOUNT) VALUES ('https://sd1.d11.ipsilum.com', 'data11', '/media/data11')",
                 "INSERT INTO discos_redireccion_nginx (URL, DISC, MOUNT) VALUES ('https://sd1.d12.ipsilum.com', 'data12', '/media/data12')",
                 "INSERT INTO discos_redireccion_nginx (URL, DISC, MOUNT) VALUES ('https://sd1.d13.ipsilum.com', 'data13', '/media/data13')",
                 "INSERT INTO discos_redireccion_nginx (URL, DISC, MOUNT) VALUES ('https://sd1.d14.ipsilum.com', 'data14', '/media/data14')",
                 "INSERT INTO discos_redireccion_nginx (URL, DISC, MOUNT) VALUES ('https://sd1.d15.ipsilum.com', 'data15', '/media/data15')",
                 "INSERT INTO discos_redireccion_nginx (URL, DISC, MOUNT) VALUES ('https://sd1.d16.ipsilum.com', 'data16', '/media/data16')",
                 "INSERT INTO discos_redireccion_nginx (URL, DISC, MOUNT) VALUES ('https://sd1.d17.ipsilum.com', 'data17', '/media/data17')",
                 "INSERT INTO discos_redireccion_nginx (URL, DISC, MOUNT) VALUES ('https://sd1.d18.ipsilum.com', 'data18', '/media/data18')",
                 "INSERT INTO discos_redireccion_nginx (URL, DISC, MOUNT) VALUES ('https://sd1.d19.ipsilum.com', 'data19', '/media/data19')",
                 "INSERT INTO discos_redireccion_nginx (URL, DISC, MOUNT) VALUES ('https://sd1.d20.ipsilum.com', 'data20', '/media/data20')",
                 "INSERT INTO discos_redireccion_nginx (URL, DISC, MOUNT) VALUES ('https://sd1.d21.ipsilum.com', 'data21', '/media/data21')",
                 "INSERT INTO discos_redireccion_nginx (URL, DISC, MOUNT) VALUES ('https://sd1.d22.ipsilum.com', 'data22', '/media/data22')",
                 "INSERT INTO discos_redireccion_nginx (URL, DISC, MOUNT) VALUES ('https://sd1.d23.ipsilum.com', 'data23', '/media/data23')",
                 "INSERT INTO discos_redireccion_nginx (URL, DISC, MOUNT) VALUES ('https://sd1.d24.ipsilum.com', 'data24', '/media/data24/data24')"]

for query in meter_valores:
    print(query)
    conn.execute(query)