Fetch only specific fields instead of all

[jschreuder]

Should be possible in 2 ways:

$query->select('name', 'city'); // only select name & city
$query->select(array('last_name' => false)); // selects every column except "last_name"

When a model is gotten like this all other fields will not be available.

First thoughts:

• Primary key(s) must be gotten, won't be optional
• How to deal with foreign keys for BelongsTo? (probably not optional as well)
• Checking which properties are available in __set()/__get() can't use Model::properties() anymore
• Saving/updating should ignore fields that aren't there
• New objects should add all non defined fields though, maybe from the beginning.

[patie]

what about 'select' => array('name', 'city') in find?

example:

Model_User::find('first', array(
                'select' => array( 'name', 'city' ),
                'where' => array(
                    array( 'active', '=', 1 ),
                ),
            ));

its only idea.. is not necessarily

[jschreuder]

Everything Orm::Query::select() can do, can also be done by the array usage from the Model::find() method.

[patie]

wow!

[DregondRahl]

selecting specific fields, may make the code longer especially with relationships. maybe create a skip() method ?

->skip(array('user.password', 'list.content'));

[jschreuder]

Try reading the original proposal before suggesting something that's already there.