vphantom / php-pdb Goto Github PK

PHP's PDO supports $stmt->nextRowset() which switches to the next set of result rows in the result set, returning false on failure. This is necessary to use Sphinx's FACET extension to SQL.

A caller might want to use selectArrayIndexed() for the first set, selectSingleArray() for the second, etc. Therefore, all these methods should be seen as returning the first result set, and if invoked without any arguments should call PDO's $stmt->nextRowset() instead of executing a query.

Internal method _getColumns() helps safely ignore unknown columns in incoming data, however it is currently hard-coded for SQLite3's PRAGMA table_info(...).

• Somehow determine if we're in SQLite3, MySQL or SphinxQL. (Require it in constructor?)

• MySQL: SHOW COLUMNS FROM tableName returns column names in the first column of the result.

• SphinxQL: DESC indexName returns attribute names in the first column of the result.

• Look into abstracting away the differences between MySQL and SQLite3, maybe? Auto-increment index creation would be tough, but are there CRUD differences worth that?

• Import code from PyritePHP

• Import documentation from PHP-Library and create a Makefile to rebuild documentation from source

• Clean up any query builder issues

• Publish using Composer

Add testing and coverage reporting, including GitHub integration with Travis-CI and Coveralls, and build up the test suite to at least 90% coverage.