OpenIDStore for PEAR::MDB2

Ryan Patterson cgamesplay at cgamesplay.com
Thu Feb 21 07:19:02 PST 2008


I've created an Auth_OpenID_OpenIDStore implementation that utilizes
PEAR::MDB2 instead of PEAR::DB, called Auth_OpenID_MDB2Store. The
advantages to this store are that it supports all database back ends
that PEAR::MDB2 supports, and does not require the user to know which
database back end is being used when instantiating the store. Because
of the complete database abstraction, the entire store is
approximately 350 lines shorter than the SQLStore family.

As a note to users planning to test this store: the table schema is
incompatible with the other SQLStores. Specifically, the length of
server URLs has been shortened to 255 characters to allow cross-RDBMS
compatibility, and the field types have been changed to NOT NULL. You
may safely delete your associations and nonces tables with no
consequences.

A test case has been added that tests the MDB2 store with a MySQL
backend. I would appreciate it if someone capable could modify the
test case and test it using PostgreSQL, to ensure that the database
abstraction I've used is correct.

-- 
Regards,
Ryan Patterson <mailto:cgamesplay at cgamesplay.com>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: mdb2.patch
Type: application/octet-stream
Size: 15899 bytes
Desc: not available
Url : http://lists.openidenabled.com/pipermail/dev/attachments/20080221/463024da/attachment.obj 


More information about the Dev mailing list