Le blog de Jean David TECHER, un Réunionnais à Saint-Priest/Lyon

Here is the patch I've used for dblatex.

You can download it at http://www.davidgis.fr/download/patch-dblatex.patch. Here is the content

--- postgis-svn/configure.ac	2008-09-11 14:18:37.000000000 +0200
+++ postgis-svn-new/configure.ac	2008-09-26 12:12:24.000000000 +0200
@@ -70,9 +70,9 @@
 dnl Search for db2pdf which is required for building PDF documentation
 dnl
 
-AC_PATH_PROG([DB2PDF], [db2pdf], [])
-if test "x$DB2PDF" = "x"; then
-	AC_MSG_WARN([db2pdf is not installed so PDF documentation cannot be built])
+AC_PATH_PROG([DBLATEX], [dblatex], [])
+if test "x$DBLATEX" = "x"; then
+	AC_MSG_WARN([dblatex is not installed so PDF documentation cannot be built])
 fi
 
 
--- postgis-svn/doc/Makefile.in	2008-09-11 14:18:37.000000000 +0200
+++ postgis-svn-new/doc/Makefile.in	2008-09-26 12:26:41.000000000 +0200
@@ -30,8 +30,8 @@
 HTML_DOCBOOK_XSL=$(XSLBASE)/html/docbook.xsl
 CHUNK_HTML_DOCBOOK_XSL=$(XSLBASE)/html/chunk.xsl
 
-# OpenJade's db2pdf script for PDF generation from DocBook
-DB2PDF = @DB2PDF@
+# DBLATEX for PDF generation from DocBook
+DBLATEX = @DBLATEX@
 
 # Directories for documentation and man pages
 PGSQL_DOCDIR=@PGSQL_DOCDIR@
@@ -66,12 +66,14 @@
 		$<
 
 postgis.pdf: postgis-out.xml
-	@if test x"$(DB2PDF)" = x; then \
-	   echo "Error: db2pdf not found, can't build posgis.pdf"; \
-	   echo "       try installing docbook-utils package and then re-run configure"; \
+	@if test x"$(DBLATEX)" = x; then \
+	   echo "Error: dblatex not found, can't build posgis.pdf"; \
+	   echo "       try installing dblatex package from dblatex.sourcegforge.net nd then re-run configure"; \
 	   false; \
 	else \
-	   $(DB2PDF) $< && mv postgis-out.pdf postgis.pdf; \
+	   cp reference.xml reference.xml.orig; cat reference.xml.orig |sed -e "s:term:listitem:g" > reference.xml;\
+	   $(DBLATEX) -T native -t pdf -o postgis.pdf -I "$(PWD)/html" $<; \
+	   rm -f reference.xml.orig;\
 	fi
 
 clean:

In order to patching

wget http://www.postgis.org/postgis-svn.tar.gz;
tar xzf postgis-svn.tar.gz;
wget http://www.davidgis.fr/download/patch-dblatex.patch;
patch -p0 < patch-dblatex.patch

Voilà un mail qui fait super plaisir de la part de Kevin Neufeld, l'un des développeurs de PostGIS......Ca a du bon parfois la reconnaissance de ses pères .!!!

Great! Thanx.  I'll see if I can incorporate this into the Makefile and autobuild process
at some point.

Cheers,
Kevin

Jean David TECHER wrote:
>Hi Kevin,
>
>Thanks for your comments.
>
>The instructions are available on my Web Site at
>
>http://www.davidgis.fr/blog/index.php?2008/09/25/387-building-pdf-for-postgis-using-dblatex I've tried to write in English...Hope this
>helps!
>
>Best regards.
>
>--david;
>
>
>Quoting Kevin Neufeld :
>
>>Hi David,
>>
>>Is there any chance you remember the syntax and parameters used to
>>generate your pdf?  It would be sweet if we could incorporate such a
>>doc in our automatic build system so it stays current.
>>
>>Cheers,
>>Kevin
>>
>>Kevin Neufeld wrote:
>>>Very nicely done David.
>>>
>>>PaulR - are you really set on producing a PDF via Apache's FOP?   This looks far
>>>better than anything I've been able to reproduce  with FOP or Docbook's db2pdf.
>>>
>>>David, what exactly is your command line for generating the doc  (maybe I can put it
>>>in the autobuild process that gets updated on  every SVN commit)?  Assuming of course
>>>that folks are ok with  adding a new dependency with the build process ...
>>>
>>>Cheers,
>>>Kevin
>>>
>>>Jean David TECHER wrote:
>>>>Dear all,
>>>>
>>>>I've tried to compil the postgis.pdf using the svn tarball.
>>>>
>>>>The output is available at
>>>>
>>>>http://www.davidgis.fr/postgis-out.pdf
>>>>
>>>>AFAIK, the output seems to be beautifull since you can see the images.
>>>>
>>>>Hope these help people for a printing solution for postgis doc  
>>>>
>>>>--david;
>>>>

By default when you want to have the postgis.pdf taken from the source, you have to install fo or db2pdf. However, you can use a tool like dblatex. The solution is available at http://dblatex.sourceforge.net/. This project is maintaned by Benoît Guillon (a French guy too like me ).

The main goal is as followed

Install dblatex >=0.2.7

First of all you need dblatex. Please read the instructions taken from the dblatex's site. You need to have python, latex and so on..

When you're ready. It is time to install

./setup.py install

Building the pdf doc from PostGIS

1. Download the sources from svn

   wget http://www.postgis.org/postgis-svn.tar.gz

2. Untar the sources

   tar xvf postgis-svn.tar.gz

3. Go to postgis directory, run configure and go to doc directory

   ./configure && cd doc && make

4. The file reference.xml must be change. We have to replace the term entry by listitem before using dbaltex

   cp reference.xml reference.xml.orig; cat reference.xml.orig |sed -e "s:term:listitem:g" > reference.xml

5. It's time to use dblatex. Here is the command and the output

   root@olivia:/mnt/sources/tmp/postgis-svn/doc# dblatex -T native -t pdf -o postgis-svn-1.4.0.pdf -I "$PWD/html" postgis-out.xml 
   Build the listings...
   XSLT stylesheets DocBook -  LaTeX 2e (0.2.9)
   ===================================================
   convert "/mnt/sources/tmp/postgis-svn/doc/html/images/st_crosses-math.gif" fig0.pdf
   convert "/mnt/sources/tmp/postgis-svn/doc/html/images/st_crosses01.gif" fig1.pdf
   convert "/mnt/sources/tmp/postgis-svn/doc/html/images/st_crosses02.gif" fig2.pdf
   convert "/mnt/sources/tmp/postgis-svn/doc/html/images/st_crosses03.gif" fig3.pdf
   convert "/mnt/sources/tmp/postgis-svn/doc/html/images/st_crosses04.gif" fig4.pdf
   convert "/mnt/sources/tmp/postgis-svn/doc/html/images/st_touches-math.gif" fig5.pdf
   Build postgis-out.pdf
   This is pdfeTeX, Version 3.141592-1.30.5-2.2 (Web2C 7.5.5)
   entering extended mode
   This is pdfeTeX, Version 3.141592-1.30.5-2.2 (Web2C 7.5.5)
   entering extended mode
   'postgis-svn-1.4.0.pdf' successfully built

Here is the final PDF http://www.davidgis.fr/download/postgis-svn-1.4.0.pdf...Beautifull isn't it ???

On a la table suivante

www_log=# create table test(id integer,name text);
CREATE TABLE
www_log=# insert into test select generate_series(1,10),'toto';
INSERT 0 10
www_log=# select * from test ;
 id | name 
----+------
  1 | toto
  2 | toto
  3 | toto
  4 | toto
  5 | toto
  6 | toto
  7 | toto
  8 | toto
  9 | toto
 10 | toto
(10 lignes)

On va mettre tout ça à jour. Quand id est pair name vaut tata ,yoyo sinon.

www_log=# UPDATE test set name=(case when id%2=0 then 'tata' else 'yoyo' end);
UPDATE 10
www_log=# select * from test ;
 id | name 
----+------
  1 | yoyo
  2 | tata
  3 | yoyo
  4 | tata
  5 | yoyo
  6 | tata
  7 | yoyo
  8 | tata
  9 | yoyo
 10 | tata
(10 lignes)