#!/bin/bash
echo "Verificando ogr2ogr..."
if ! command -v ogr2ogr &> /dev/null
then
    echo "ogr2ogr no se encuentra. Intentando instalar gdal-bin..."
    echo "x25yvaga2023" | sudo -S DEBIAN_FRONTEND=noninteractive apt-get update
    echo "x25yvaga2023" | sudo -S DEBIAN_FRONTEND=noninteractive apt-get install -y gdal-bin
fi

echo "Iniciando Extraccion de PostGIS a GPKG (Carto Sanity Pass)..."
cd /home/cbareiro
rm -f sigem_export.gpkg
ogr2ogr -f "GPKG" sigem_export.gpkg PG:"dbname=cartodb_user_17b59d48-0892-47a7-a206-e1b3bb6fb6f8_db host=127.0.0.1 user=postgres password=x25yvaga2017" "e505_barloc" "e505_calles" "e505_distrito" "e505_lotes" "e505_lotes_conccc" "e505_lotes_sinccc" "e505_manzanas" "e505_medidores" "e505_mejoras" "e505_zonas_tributarias"

echo "Verificando exportacion final:"
ls -lh sigem_export.gpkg
echo "Extraccion Exitosa."