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? Does the PDO usage has any negative impact? Or only positive ones? Whch are the rare functions? Astrid On Wed, September 29, 2010 6:54 pm, Christoph Baudson wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > > 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 -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.9 (GNU/Linux) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org > > > iEYEARECAAYFAkyji2YACgkQGtMIfbycMX6WYQCgmEfPPmddskXZaaE2nkgLCaDo > iLcAn2mhzFLKR6lMlnuu7LF30JTwvu56 =3wVJ > -----END PGP SIGNATURE----- > _______________________________________________ > Mapbender_dev mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapbender_dev > > -- Mit freundlichen Grüßen Astrid Emde ******************************************** INTERGEO 2010 05.-07. Oktober 2010 in Köln Halle 11.2, Stand 2C.121 www.intergeo.de ******************************************** ---------------------------------- Aufwind durch Wissen! Qualifizierte OpenSource-Schulungen bei der www.foss-academy.eu ---------------------------------- Astrid Emde WhereGroup GmbH & Co.KG Siemensstraße 8 53121 Bonn Germany Fon: +49(0)228 90 90 38 - 19 Fax: +49(0)228 90 90 38 - 11 [email protected] www.wheregroup.com Amtsgericht Bonn, HRA 6788 ------------------------------- Komplementärin: WhereGroup Verwaltungs GmbH vertreten durch: Olaf Knopp, Peter Stamm ------------------------------- _______________________________________________ Mapbender_dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapbender_dev
