[Mapbender_dev] PDO
Christoph Baudson
christoph at baudson.de
Fri Oct 1 15:14:29 EDT 2010
-----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
> Mapbender_dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapbender_dev
>>>
>
_______________________________________________
Mapbender_dev mailing list
Mapbender_dev at lists.osgeo.org
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-----
More information about the Mapbender_dev
mailing list