Re: New PDO-based DBAL/ORM for PEAR2
| From: | Michael J. I. Jackson | Date: | Wed, 21 Nov 2007 19:43:49 +0000 |
| Subject: | Re: New PDO-based DBAL/ORM for PEAR2 | ||
| References: | 1 2 3 4 5 6 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-48561@lists.php.net to get a copy of this message | ||
On Nov 20, 2007, at 6:13 PM, David Coallier wrote:
Anyways for PEAR2 you'll need to read this:http://wiki.pear.php.net/index.php/PEAR2_StandardsHmm...guess I'll just have to wait for namespaces...
For your mssql driver: - in listTables, you should use: EXEC sp_tables @table_type because sysobject is not compatible with all the versions.It's ok for listTableFields though. (Why is my name not there? From what I see it's code that I have written as well ;-) - just kidding) ref: (http://pdorm.googlecode.com/svn/trunk/PDORM/Connection/mssql.php) - PDORM_Function::concat() in the mssql function I would add a $separator variable that lets the user concat with their favorite separator. I can easily see someone querying firstname, lastname and concat'ing it to TRIM(FirstName) + ' ' + TRIM(LastName) or some might even want ,-+. ... who knows. ref: (http://pdorm.googlecode.com/svn/trunk/PDORM/Function/mssql.php) Actually if you have a mssql server online I could help you with that part (mine's been down for a while), I could even makes a few fixes and tests on MDB2 since I am just about good for a release soon ;-)I would love some help with the mssql driver, but I don't have a server online. I only tried that one because I was testing to see how long it would take to port over an MDB2 driver to my package (not very long), but I don't have any way to test it. If you would be so kind, I promise to put your name in the code. ; ) Michael