Posted by Roger Hunwicks (rhunwicks) on 2012-03-09T21:08:33.000+0000
The existing code uses a CASE statement to determine whether the entered value matches the stored credential (i.e. password). At the moment Zend\Db\Sql\Select quotes the individual words in the CASE statement and the query fails
Posted by Roger Hunwicks (rhunwicks) on 2012-03-09T21:18:07.000+0000
The existing test case to check whether the user can alter the database select query used to perform authentication using {{$dbAdapter->getProfiler()->getLastQueryProfile()}} to check that the WHERE clause has been amended successfully, but currently Zend\Db does not offer access to the profiler.
Posted by Roger Hunwicks (rhunwicks) on 2012-03-09T21:23:49.000+0000
I've got a branch ready to push once ZF2-195 is fixed. Ideally ZF2-210 will be fixed too, but it only breaks the test, not the actual class
Posted by Oscar Merida (omerida) on 2012-03-10T04:36:52.000+0000
Thanks You! When the fix is merged I will test it too.
Posted by Roger Hunwicks (rhunwicks) on 2012-03-20T06:05:13.000+0000
Comments
Posted by Roger Hunwicks (rhunwicks) on 2012-03-09T21:08:33.000+0000
The existing code uses a CASE statement to determine whether the entered value matches the stored credential (i.e. password). At the moment Zend\Db\Sql\Select quotes the individual words in the CASE statement and the query fails
Posted by Roger Hunwicks (rhunwicks) on 2012-03-09T21:18:07.000+0000
The existing test case to check whether the user can alter the database select query used to perform authentication using {{$dbAdapter->getProfiler()->getLastQueryProfile()}} to check that the WHERE clause has been amended successfully, but currently Zend\Db does not offer access to the profiler.
Posted by Roger Hunwicks (rhunwicks) on 2012-03-09T21:23:49.000+0000
I've got a branch ready to push once ZF2-195 is fixed. Ideally ZF2-210 will be fixed too, but it only breaks the test, not the actual class
Posted by Oscar Merida (omerida) on 2012-03-10T04:36:52.000+0000
Thanks You! When the fix is merged I will test it too.
Posted by Roger Hunwicks (rhunwicks) on 2012-03-20T06:05:13.000+0000
This is fixed in https://github.com/rhunwicks/zf2/…, which in turn contains merged changes from https://github.com/ralphschindler/zf2/….
All the tests work except testAdapterCanUseModifiedDbSelectObject() which depends on a Profiler, which is not available yet.
I will create a pull request once ralphschindler's changed are merged.
Posted by Roger Hunwicks (rhunwicks) on 2012-04-19T05:47:44.000+0000
Fix merged in Master