-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Christoph Baudson wrote: > Hello Astrid, > > Astrid Emde wrote: >> Hello Christoph, > >> good idea to use PDO for database access. > >> I only have some questions. > >> Are the spatial queries (area, transform, length ...) still running with >> the PDO solution? > > I guess it works, as spatial operations via PostGIS are only database > functions. Of course some old scripts, like mod_evalArea.php, contain > legacy code from the MySQL days. These would need refactoring (or even > better rewriting). I have refactored mod_evalArea.php [1] as a start. > >> Does the PDO usage has any negative impact? Or only positive ones? > > The upside is, that we can still keep the old DB wrapper. So we could > use the old wrapper database-pgsql.php for production use, and > database-pgsql-pdo.php for testing. I have added this right > now...changeset 6999 [2].
You just have to change the SYS_DBTYPE in mapbender.conf from "pgsql" to "pgsql-pdo" in order to work with PDO. Christoph > >> Whch are the rare functions? > > For example, db_result. I have made a replacement in editElementVars > [3]. We could try to create a workaround for db_result as well...feel > free to make a suggestion. > > Christoph > > [1] http://trac.osgeo.org/mapbender/changeset/7002/branches > [2] http://trac.osgeo.org/mapbender/changeset/6999/branches > [3] http://trac.osgeo.org/mapbender/changeset/7001/branches > >> Astrid > >> On Wed, September 29, 2010 6:54 pm, Christoph Baudson wrote: > >> Hi list, > > >> yesterday Karim taught me what he knew about database unit testing in PHP, >> where PDO [1] is apparently required. As database unit testing is quite >> essential in Mapbender, I experimented a little with PDO. > >> I used database-pgsql.php [2] as a wrapper for PDO, and also created a >> singleton for the database handle [3]. > >> At the moment I have trunk running with PDO. An open problem are rarely >> used db functions which can't be mapped to PDO. I will have to address >> these later on, but this should not take long. > >> When this is done I can merge my changes back to trunk and we can start >> building database unit tests. > >> Christoph > > >> [1] http://php.net/manual/de/book.pdo.php >> [2] >> http://trac.osgeo.org/mapbender/browser/branches/mapbender/lib/database-pg >> sql.php [3] >> http://trac.osgeo.org/mapbender/browser/branches/mapbender/lib/class_Mapbe >> nder_database.php > > _______________________________________________ > Mapbender_dev mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapbender_dev >>> > _______________________________________________ Mapbender_dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapbender_dev -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkymMxUACgkQGtMIfbycMX60HwCfbozt5RepI4DF1yHM6dYTckbG lxYAn1xL0B3371UPawbc6HQ/4aXfbtAK =n2U4 -----END PGP SIGNATURE----- _______________________________________________ Mapbender_dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapbender_dev
