{5} Assigned, Active Tickets by Owner (Full Description) (8 matches)

'conditions' part can't handle placeholders and arrays at all, ex.

  $id = 1; 
  $Class->count(array('conditions' => array('id = ?', $id))

is compiled as 'WHERE Array', while 'Where id = 1' is expected. Proposed patch is copy'n'paste from the &find () function, so it is a good candidate for refactoring

Index: lib/AkActiveRecord.php
===================================================================
--- lib/AkActiveRecord.php      (revision 505)
+++ lib/AkActiveRecord.php      (working copy)
@@ -5003,8 +5003,27 @@

         $sql .=  empty($options['joins']) ? '' : " {$options['joins']} ";

+        //$this->santizeSql(conditions);
+        if(!empty($options['conditions']) && is_array($options['conditions'])){
+            if (isset($options['conditions'][0]) && strstr($options['conditions'][0], '?') && count($options['conditions']) > 1){
+                //array('conditions' => array("name=?",$name))
+                $pattern = array_shift($options['conditions']);
+                $options['bind'] = array_values($options['conditions']);
+                $options['conditions'] = $pattern;
+            }elseif (isset($options['conditions'][0])){
+                //array('conditions' => array("user_name = :user_name", ':user_name' => 'hilario')
+                $pattern = array_shift($options['conditions']);
+                $options['conditions'] = str_replace(array_keys($options['conditions']), array_values($this->getSanitizedConditionsArray($options['conditions'])),$pattern);
+            }else{
+                //array('conditions' => array('user_name'=>'Hilario'))
+                $options['conditions'] = join(' AND ',(array)$this->getAttributesQuoted($options['conditions']));
+            }
+        }
+
+
         empty($options['conditions']) ? null : $this->addConditions($sql, $options['conditions']);

+
         if (!empty($options['group'])){
             $sql .=  " GROUP BY {$options['group_field']} ";
             $sql .= empty($options['having']) ? '' : " HAVING {$options['having']} ";
@@ -5013,6 +5032,11 @@
         $sql .= empty($options['order']) ? '' : " ORDER BY {$options['order']} ";
         $this->_db->addLimitAndOffset($sql, $options);
         $sql .= $use_workaround ? ')' : '';
+
+        if(!empty($options['bind']) && is_array($options['bind']) && strstr($sql,'?')){
+            $sql = array_merge(array($sql),$options['bind']);
+        }
+
         return $sql;
     }

Akelos uses PEAR Cache_Lite for caching blocks, but we can use Rails conventions for caching and implement:

Page Caching

This is the fastest way of caching.

Using mapped routes the cache for post/show/3 will be stored at public/cache/post/show/3.html. This methods requires sweepers to be implemented preferably at app/sweepers for cleaning up static pages.

Page caching should also offer the possibility of using public/cache/post/show/3.php and inserting custom code portions at the beginning of the file for sending the correct cache headers or running very fast PHP code without the overhead of starting the framework.

Action Caching

Same as before but starting Akelos and calling before filters. Mainly for authenticating before delivering the page.

Cache is stored at /tmp/cache/example.com/development/post/show/3.cache

Fragment Caching

Caches parts of the views.

ActiveRecord? Query Caching

We currently can do this using phpAdodb instance available at Model::_db, but making it easier would be great.

More details at the excellent Rails Caching tutorial at http://www.railsenvy.com/2007/3/20/ruby-on-rails-caching-tutorial-part-2, I really envy this guys for such a funny videos :P

follow up to #153

my suggestion is:

write an (php5) Autoloader; load in index.php.

then we could simply call

AkInflector::addIrregular(:singular,:plural)

inside config/config.php

using pagination_helper with include option, search for including model's column. at that time in PaginationHelper::_getOrderFromAssociations() uses AkActiveRecord::getAvailableAssociates(), it dones not implement.

and maybe it seems to have some problems. I make patches.

My environment is: WinXp?, Xampp1.5.5 apache2.2.3,PostgreSQL8.2, PHP5.2.0

Model: User

$this->createTable('users', "
  id,
  name text,
  kana text,
  login text,
  number text,
  email text,
  mobile text,
  enabled integer,
  user_type_id,
  created_at,
  updated_at
");

class User extends ActiveRecord
{
    var $belongsTo = 'user_type';
}

UserType:

{{{
$this->createTable('user_types', "
  id,
  name text,
  created_at,
  updated_at
");

}}}

user_controller:

    function listing()
    {
        $this->user_pages = $this->pagination_helper->getPaginator(
            $this->User, 
            array(
                'items_per_page' => 10,
                'include' => array('user_type'),
            )
        );
        $this->users = $this->User->find('all', $this->pagination_helper->getFindOptions($this->User));
        
    }