morgan/kohana-paginate

Paginate abstraction supporting Database, ORM, ORM-REST and Dispatch.

kohana-paginate's Issues

Search needs separate aggregate count

This is in response to: #1

alternative to mysql_real_escape_string

Hi,

mysql_real_escape_string will be removed in future, please add alternative to mysql_real_escape_string in Kohana_Paginate_Database::_sort and Kohana_Paginate_Database::_search

source: http://www.php.net/mysql_real_escape_string

Paginate with collections

Hi,

This is a question rather than a bugs :)

With kohana-paginate, can I do something like this ( get all posts with 'news' tag)?

$tag = ORM::factory('tag', 5); // news tag
$articles = $tag->articles; // articles with news' tag

$paginate = Paginate::factory($articles);

I try the above code, but didn't work

Thanks.

GROUP BY CASE issue

Hi and sorry to bother you again :)

I'm trying to use paginate with this query :

$products = DB::query(Database::SELECT, '
            SELECT * FROM shop_products
            GROUP BY CASE configurable 
            WHEN 1 THEN configuration_id
            ELSE id 
            END
        ')->as_object('Model_Product');

I have to go through a manual query because ORM does not support the group by case condition.

The thing is, DB::query() returns a Database_Query object which (logically) does not implement the order_by() and the offset() functions, so I'm getting this error : Call to undefined method Database_Query::order_by() in /modules/paginate/classes/Kohana/Paginate/Database.php on line 64

Would you have an idea to work around this problem? Right now the only way I can see this working, is to actually write a group_by_case function for the database query builder class, but I thought you might have another idea...?

Adding a where condition

Hi,

Is it possible to add a ->where('col','=','something') ORM condition to a paginate object ?