loadsql2postgres.bat

Java的框架

echo off
set OLDDIR=%CD%

set POSTGRESDIR="C:\Program Files\PostgreSQL\8.0\bin"
REM set POSTGRESDIR="D:\PostgreSQL\8.0\bin"
C:
cd %POSTGRESDIR%

REM IF NOT EXISTS %POSTGRESDIR%(
REM echo PostGres Installation Directory Not Found!!!!! Make sure the path in this batch file is correct.
REM GOTO :end
REM )

REM =======================================================================================================
REM ROAD
REM =======================================================================================================
:2
REM GOTO :3

set file=prrm_road.shp
set fileName="%OLDDIR%\%file%"
set sql=load_road.sql
set sqlFile="%OLDDIR%\%sql%"

IF EXIST %fileName% (
        echo Using %file%
	IF EXIST %sqlFile% (
		echo Using the exisiting %sql%
	) ELSE (
		echo File %sqlFile% does not exists. Generating %sql%. Please Wait...
		shp2pgsql -c %fileName% prrm_road singapore > %sqlFile%
	)	 
	echo Loading SQL %file% into PostGres DB. Please Wait...
	psql -f %sqlFile% -d singapore -U postgres -W postgres
    ) ELSE (
        echo ERROR Loading Road Data into PostGres DB!!!
    )

REM =======================================================================================================
REM ROAD DEFECT
REM =======================================================================================================
:4
REM GOTO :end

set file=prrm_roaddefect.shp
set fileName="%OLDDIR%\%file%"
set sql=load_road_defect.sql
set sqlFile="%OLDDIR%\%sql%"

IF EXIST %fileName% (
        echo Using %file%
	IF EXIST %sqlFile% (
		echo Using the exisiting %sql%
	) ELSE (
		echo File %sqlFile% does not exists. Generating %sql%. Please Wait...
		shp2pgsql -c %fileName% prrm_roaddefect singapore > %sqlFile%
	)	 
	echo Loading SQL %file% into PostGres DB. Please Wait...
	psql -f %sqlFile% -d singapore -U postgres -W postgres
    ) ELSE (
        echo ERROR Loading Road Defect Data into PostGres DB!!!
    )

:end
pause