[development] how to restore devel.module query log in HEAD

Gerhard Killesreiter gerhard at killesreiter.de
Fri Aug 22 17:51:28 UTC 2008


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Moshe Weitzman schrieb:
> I'd appreciate suggestions on how to implement the query log for
> devel.module now that the new DB layer has landed. I've already
> submitted a patch to add timing info: http://drupal.org/node/298669
> 
> But, it seems that PDO will not show us the SQL that was executed for
> any given prepared statement. We have access to the statement with
> placeholders, but that can be verbose as sin, and can't be copy/pasted
> into a console. Here is a statement for cache_set():
> 
> INSERT INTO {cache_registry} (serialized, created, expire, headers,
> DATA, cid) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1,
> :db_insert_placeholder_2, :db_insert_placeholder_3,
> :db_insert_placeholder_4, :db_insert_placeholder_5) ON DUPLICATE KEY
> UPDATE serialized=:db_update_placeholder_0,
> created=:db_update_placeholder_1, expire=:db_update_placeholder_2,
> headers=:db_update_placeholder_3, DATA=:db_update_placeholder_4
> 
> Not so readable, eh?


If you just replace db_update_placeholder by something shorter, it
wouldn't be a problem, I think.

Cheers,
	Gerhard
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFIrvyffg6TFvELooQRAqBJAJ9nCCW04gAfgFExBAjzC9yB5/O+qQCfWMRC
sEPoBQkhK2BqocOW7vhmVmU=
=9Ymo
-----END PGP SIGNATURE-----


More information about the development mailing list