The Bakery Everything CakePHP

I find the import pretty useful but is there a way to limit the no. of records imported? In this case, we might have too many records yet it'd be useful to just have some of them being used during tests.

The new version will cause certain statements with aggregate functions with no GROUP BY to fail because of the auto adding of primaryKey to the fields list.

E.g. If you wish to get the no. of posts a user have and the last ID of the post made, you might do something like:


SELECT COUNT(*), MAX(`id`) FROM `table` WHERE `user_id` = 1;

MySQL will throw a problem if there is no GROUP BY clause when the field added turns that query into:

SELECT COUNT(*), MAX(`id`), `Model`.`id` FROM `table` WHERE `user_id` = 1;

Will it be possible to include a toggle so we can optionally disable the auto adding?

This code is meant to be included in your app_model.php or particular model.



    function beforeSave() {
        /**
         * Checks table metadata for fields which allows NULL and set the value
         * to NULL when they are empty
         * 
         * TODO: probably make this a behavior?
         */
        $tableInfo = $this->_tableInfo->get();
        foreach ($tableInfo as $field) {
            if ($field['null']) {
                if (isset($this->data[$this->name][$field['name']]) && $this->data[$this->name][$field['name']] === '') {
                    $this->data[$this->name][$field['name']] = null;
                }
            }
        }
        
        return true;
    }