Retrieving uncomplete objects...

jey | 11 months ago

... or just choosing columns to retrieve using a SqlBuilder object.
The only way I found to do this was to change some recess variables' identifiers to "public" (the $select variable in SqlBuilder and the $sqlBuilder variable in PdoDataSet) in order to be able to change the select default value (*) to the columns'names I wanted to retrieve (only the ids of result objects for example). Is there any "official" way to do this?

KevBurnsJr | 11 months ago

I noticed this as well. PDODataSet has a distinct() method, but it's useless w/o being able to modify the select clause.

There's a selectAs, but that doesn't keep the model from also selecting *

I started writing a setSelect() method for ModelSet, but found that I could achieve the behavior I was looking for at that moment with a GROUP BY clause instead.

So I added a method to all named 'groupBy' method to PDODataSet.

http://github.com/KevBurnsJr/recess/commit/c6c5cc5fc6f1884fdc80985230a5a35123ea876e

Sent a pull request but haven't heard back. I'll resend it now.

Hope this helps,
- Kev