import os
import shutil
import pathlib
import psycopg2

dataBase = {'host': '146.59.69.180', 'port': 30038, 'user': 'postgres', 'password': 'pg', 'database': 'lidarand', 'schema': 'fcc'}

#conn = psycopg2.connect(host=dataBase['host'], port=dataBase['port'], database=dataBase['database'], user=dataBase['user'], password=dataBase['password'])
#cursor = conn.cursor()

folder_to_list = '/home/data3/master_folder/demo/fcc/GIS'

folders = list((pathlib.Path(folder_to_list)).iterdir())

for order, item in enumerate(folders):
    item = str(item)
    archivo = pathlib.Path(item).suffix
    if archivo == '.shp':
        print(f'Vamos a poder subir el archivo: {item}')
        command = f"""ogr2ogr -f "PostgreSQL" PG:"host={dataBase['host']} port={dataBase['port']} user={dataBase['user']} dbname={dataBase['database']} password={dataBase['password']} schemas={dataBase['schema']}" {item} -nlt PROMOTE_TO_MULTI -explodecollections -skipfailures """
        print(command)
#        os.system(command)
#        print('HECHO')
        print('----------------------------------------------------------------------------')

#cursor.close()
#conn.close()