head 1.4; access; symbols pkgsrc-2026Q1:1.4.0.154 pkgsrc-2026Q1-base:1.4 pkgsrc-2025Q4:1.4.0.152 pkgsrc-2025Q4-base:1.4 pkgsrc-2025Q3:1.4.0.150 pkgsrc-2025Q3-base:1.4 pkgsrc-2025Q2:1.4.0.148 pkgsrc-2025Q2-base:1.4 pkgsrc-2025Q1:1.4.0.146 pkgsrc-2025Q1-base:1.4 pkgsrc-2024Q4:1.4.0.144 pkgsrc-2024Q4-base:1.4 pkgsrc-2024Q3:1.4.0.142 pkgsrc-2024Q3-base:1.4 pkgsrc-2024Q2:1.4.0.140 pkgsrc-2024Q2-base:1.4 pkgsrc-2024Q1:1.4.0.138 pkgsrc-2024Q1-base:1.4 pkgsrc-2023Q4:1.4.0.136 pkgsrc-2023Q4-base:1.4 pkgsrc-2023Q3:1.4.0.134 pkgsrc-2023Q3-base:1.4 pkgsrc-2023Q2:1.4.0.132 pkgsrc-2023Q2-base:1.4 pkgsrc-2023Q1:1.4.0.130 pkgsrc-2023Q1-base:1.4 pkgsrc-2022Q4:1.4.0.128 pkgsrc-2022Q4-base:1.4 pkgsrc-2022Q3:1.4.0.126 pkgsrc-2022Q3-base:1.4 pkgsrc-2022Q2:1.4.0.124 pkgsrc-2022Q2-base:1.4 pkgsrc-2022Q1:1.4.0.122 pkgsrc-2022Q1-base:1.4 pkgsrc-2021Q4:1.4.0.120 pkgsrc-2021Q4-base:1.4 pkgsrc-2021Q3:1.4.0.118 pkgsrc-2021Q3-base:1.4 pkgsrc-2021Q2:1.4.0.116 pkgsrc-2021Q2-base:1.4 pkgsrc-2021Q1:1.4.0.114 pkgsrc-2021Q1-base:1.4 pkgsrc-2020Q4:1.4.0.112 pkgsrc-2020Q4-base:1.4 pkgsrc-2020Q3:1.4.0.110 pkgsrc-2020Q3-base:1.4 pkgsrc-2020Q2:1.4.0.106 pkgsrc-2020Q2-base:1.4 pkgsrc-2020Q1:1.4.0.86 pkgsrc-2020Q1-base:1.4 pkgsrc-2019Q4:1.4.0.108 pkgsrc-2019Q4-base:1.4 pkgsrc-2019Q3:1.4.0.104 pkgsrc-2019Q3-base:1.4 pkgsrc-2019Q2:1.4.0.102 pkgsrc-2019Q2-base:1.4 pkgsrc-2019Q1:1.4.0.100 pkgsrc-2019Q1-base:1.4 pkgsrc-2018Q4:1.4.0.98 pkgsrc-2018Q4-base:1.4 pkgsrc-2018Q3:1.4.0.96 pkgsrc-2018Q3-base:1.4 pkgsrc-2018Q2:1.4.0.94 pkgsrc-2018Q2-base:1.4 pkgsrc-2018Q1:1.4.0.92 pkgsrc-2018Q1-base:1.4 pkgsrc-2017Q4:1.4.0.90 pkgsrc-2017Q4-base:1.4 pkgsrc-2017Q3:1.4.0.88 pkgsrc-2017Q3-base:1.4 pkgsrc-2017Q2:1.4.0.84 pkgsrc-2017Q2-base:1.4 pkgsrc-2017Q1:1.4.0.82 pkgsrc-2017Q1-base:1.4 pkgsrc-2016Q4:1.4.0.80 pkgsrc-2016Q4-base:1.4 pkgsrc-2016Q3:1.4.0.78 pkgsrc-2016Q3-base:1.4 pkgsrc-2016Q2:1.4.0.76 pkgsrc-2016Q2-base:1.4 pkgsrc-2016Q1:1.4.0.74 pkgsrc-2016Q1-base:1.4 pkgsrc-2015Q4:1.4.0.72 pkgsrc-2015Q4-base:1.4 pkgsrc-2015Q3:1.4.0.70 pkgsrc-2015Q3-base:1.4 pkgsrc-2015Q2:1.4.0.68 pkgsrc-2015Q2-base:1.4 pkgsrc-2015Q1:1.4.0.66 pkgsrc-2015Q1-base:1.4 pkgsrc-2014Q4:1.4.0.64 pkgsrc-2014Q4-base:1.4 pkgsrc-2014Q3:1.4.0.62 pkgsrc-2014Q3-base:1.4 pkgsrc-2014Q2:1.4.0.60 pkgsrc-2014Q2-base:1.4 pkgsrc-2014Q1:1.4.0.58 pkgsrc-2014Q1-base:1.4 pkgsrc-2013Q4:1.4.0.56 pkgsrc-2013Q4-base:1.4 pkgsrc-2013Q3:1.4.0.54 pkgsrc-2013Q3-base:1.4 pkgsrc-2013Q2:1.4.0.52 pkgsrc-2013Q2-base:1.4 pkgsrc-2013Q1:1.4.0.50 pkgsrc-2013Q1-base:1.4 pkgsrc-2012Q4:1.4.0.48 pkgsrc-2012Q4-base:1.4 pkgsrc-2012Q3:1.4.0.46 pkgsrc-2012Q3-base:1.4 pkgsrc-2012Q2:1.4.0.44 pkgsrc-2012Q2-base:1.4 pkgsrc-2012Q1:1.4.0.42 pkgsrc-2012Q1-base:1.4 pkgsrc-2011Q4:1.4.0.40 pkgsrc-2011Q4-base:1.4 pkgsrc-2011Q3:1.4.0.38 pkgsrc-2011Q3-base:1.4 pkgsrc-2011Q2:1.4.0.36 pkgsrc-2011Q2-base:1.4 pkgsrc-2011Q1:1.4.0.34 pkgsrc-2011Q1-base:1.4 pkgsrc-2010Q4:1.4.0.32 pkgsrc-2010Q4-base:1.4 pkgsrc-2010Q3:1.4.0.30 pkgsrc-2010Q3-base:1.4 pkgsrc-2010Q2:1.4.0.28 pkgsrc-2010Q2-base:1.4 pkgsrc-2010Q1:1.4.0.26 pkgsrc-2010Q1-base:1.4 pkgsrc-2009Q4:1.4.0.24 pkgsrc-2009Q4-base:1.4 pkgsrc-2009Q3:1.4.0.22 pkgsrc-2009Q3-base:1.4 pkgsrc-2009Q2:1.4.0.20 pkgsrc-2009Q2-base:1.4 pkgsrc-2009Q1:1.4.0.18 pkgsrc-2009Q1-base:1.4 pkgsrc-2008Q4:1.4.0.16 pkgsrc-2008Q4-base:1.4 pkgsrc-2008Q3:1.4.0.14 pkgsrc-2008Q3-base:1.4 cube-native-xorg:1.4.0.12 cube-native-xorg-base:1.4 pkgsrc-2008Q2:1.4.0.10 pkgsrc-2008Q2-base:1.4 cwrapper:1.4.0.8 pkgsrc-2008Q1:1.4.0.6 pkgsrc-2008Q1-base:1.4 pkgsrc-2007Q4:1.4.0.4 pkgsrc-2007Q4-base:1.4 pkgsrc-2007Q3:1.4.0.2 pkgsrc-2007Q3-base:1.4 pkgsrc-2007Q2:1.2.0.6 pkgsrc-2007Q2-base:1.2 pkgsrc-2007Q1:1.2.0.4 pkgsrc-2007Q1-base:1.2 pkgsrc-2006Q4:1.2.0.2 pkgsrc-2006Q4-base:1.2; locks; strict; comment @# @; 1.4 date 2007.08.14.17.19.20; author joerg; state Exp; branches; next 1.3; 1.3 date 2007.07.28.11.06.36; author gdt; state Exp; branches; next 1.2; 1.2 date 2006.10.12.22.56.08; author wiz; state Exp; branches; next 1.1; 1.1 date 2006.10.04.14.25.57; author gdt; state Exp; branches; next ; desc @@ 1.4 log @Add DESTDIR support and bail-out in epsg-load when errors happened, e.g. because psql or mysql failed. Bump revision. Patch from Brook Milligan in private mail. @ text @#!/bin/sh # $NetBSD: epsg-load,v 1.3 2007/07/28 11:06:36 gdt Exp $ # epsg - import EPSG data into a relational database # Copyright (c) 2006,2007 Brook Milligan # All rights reserved. # # Redistribution and use in source and binary forms, with or without # modification, are permitted provided that the following conditions # are met: # # 1. Redistributions of source code must retain the above copyright # notice, this list of conditions and the following disclaimer. # 2. Redistributions in binary form must reproduce the above # copyright notice, this list of conditions and the following # disclaimer in the documentation and/or other materials provided # with the distribution. # 3. The name of the author may not be used to endorse or promote # products derived from this software without specific prior # written permission. # # THIS SOFTWARE IS PROVIDED BY THE AUTHOR ``AS IS'' AND ANY EXPRESS # OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED # WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE # ARE DISCLAIMED. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY # DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL # DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE # GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS # INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, # WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING # NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS # SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. set -e # exit on error HOST= PORT= DB=epsg USERNAME=$USER HELP=0 USE_PGSQL=0 USE_MYSQL=0 VERS=@@VERS@@ SRCDIR=@@EPSGDIR@@ PSQL=@@PREFIX@@/bin/psql MYSQL=@@PREFIX@@/bin/mysql if [ $# = 0 ]; then HELP=1 fi while [ $# -gt 0 ]; do case $1 in --help) HELP=1;; --dbname) DB=$2; shift;; --host) HOST=$2; shift;; --mysql) USE_MYSQL=1;; --port) PORT=$2; shift;; --pgsql) USE_PGSQL=1;; --srcdir) SRCDIR=$2; shift;; --username) USERNAME=$2; shift;; *) HELP=1; echo "epsg: unrecognized option: $1";; esac shift; done if [ $HELP -eq 1 ]; then echo "epsg -- load the EPSG dataset into a database" echo "usage: epsg [options]" echo "options:" echo " --help [ print a help message ]" echo " --pgsql [ connect to a PostgreSQL database ]" echo " --mysql [ connect to a mySQL database ]" echo " --host hostname [ connect to a specific host ]" echo " --port port [ connect to a specific port ]" echo " --dbname database [ connect to a specific database ]" echo " --username user [ connect as user ]" exit 1 fi echo "epsg - importing EPSG data ..." if [ "$HOST" != "" ]; then echo " host: $HOST" PSQL_FLAGS="$PSQL_FLAGS --host $HOST" MYSQL_FLAGS="$MYSQL_FLAGS --host=$HOST" fi if [ "$PORT" != "" ]; then echo " port: $PORT" PSQL_FLAGS="$PSQL_FLAGS --port $PORT" MYSQL_FLAGS="$MYSQL_FLAGS --port=$PORT" fi if [ "$DB" != "" ]; then echo " database: $DB" PSQL_FLAGS="$PSQL_FLAGS --dbname $DB" MYSQL_FLAGS="$MYSQL_FLAGS --database=$DB" fi if [ "$USERNAME" != "" ]; then echo " username: $USERNAME" PSQL_FLAGS="$PSQL_FLAGS --username $USERNAME" MYSQL_FLAGS="$MYSQL_FLAGS --user=$USERNAME" fi if [ $USE_PGSQL -eq 1 ]; then echo "importing into a PostgreSQL database ..." $PSQL -f $SRCDIR/EPSG_v$VERS.mdb_Tables_PostgreSQL.sql $PSQL_FLAGS $PSQL -f $SRCDIR/EPSG_v$VERS.mdb_Data_PostgreSQL.sql $PSQL_FLAGS $PSQL -f $SRCDIR/EPSG_v$VERS.mdb_FKeys_PostgreSQL.sql $PSQL_FLAGS fi if [ $USE_MYSQL -eq 1 ]; then echo "importing into a mySQL database ..." $MYSQL $MYSQL_FLAGS < $SRCDIR/EPSG_v$VERS.mdb_Tables_MySQL.sql $MYSQL $MYSQL_FLAGS < $SRCDIR/EPSG_v$VERS.mdb_Data_MySQL.sql $MYSQL $MYSQL_FLAGS < $SRCDIR/EPSG_v$VERS.mdb_FKeys_MySQL.sql fi @ 1.3 log @Update to 6.13, provided by Brook Milligan. Update license, and unset RESTRICTED. Documentation is lo longer included; see epsg-docs. The new version has updated parameters and has rationalized the use of terms "supersede", "retire" and "replace". @ text @d2 1 a2 1 # $NetBSD: epsg-load,v 1.2 2006/10/12 22:56:08 wiz Exp $ d35 2 @ 1.2 log @Update to 6.11.1 (old distfiles disappeared). Ok brook. Version 6.11.1 is the current release of the EPSG dataset, distributed in an MS Access 97 database and/or as SQL scripts. It incorporates data received and verified since the release of Version 6.11 in August 2006. pkgsrc fixes: SUBST_* improvements (was patching nonexistent file) @ text @d2 1 a2 1 # $NetBSD: epsg-load,v 1.1 2006/10/04 14:25:57 gdt Exp $ d6 1 a6 1 # Copyright (c) 2006 Brook Milligan d44 1 d107 3 a109 3 $PSQL -f $SRCDIR/EPSG_v6_11.mdb_Tables_PostgreSQL.sql $PSQL_FLAGS $PSQL -f $SRCDIR/EPSG_v6_11.mdb_Data_PostgreSQL.sql $PSQL_FLAGS $PSQL -f $SRCDIR/EPSG_v6_11.mdb_FKeys_PostgreSQL.sql $PSQL_FLAGS d114 3 a116 3 $MYSQL $MYSQL_FLAGS < $SRCDIR/EPSG_v6_11.mdb_Tables_MySQL.sql $MYSQL $MYSQL_FLAGS < $SRCDIR/EPSG_v6_11.mdb_Data_MySQL.sql $MYSQL $MYSQL_FLAGS < $SRCDIR/EPSG_v6_11.mdb_FKeys_MySQL.sql @ 1.1 log @rename loader script to epsg-load, and install in ${PREFIX}/bin PKGREVISION++ @ text @d2 1 a2 1 # $NetBSD: epsg.sh,v 1.2 2006/10/03 12:55:47 gdt Exp $ d44 1 a44 1 SRCDIR=${EPSGDIR} d46 2 a47 2 PSQL=${PREFIX}/bin/psql MYSQL=${PREFIX}/bin/mysql @