Welcome Guest, Not a member yet? Register   Sign In
ActiveRecord - print query before run (CI 2.0.2)
#1

[eluser]Unknown[/eluser]
Hi everyone !

I need to get query string from active object before I run query,
I need it before run query to own cache library to check if cache file for this query exists and/or is non expired (cache file name == sha1($query_string) ).
It's necessary because in some models in my application some methods set active record parameters for other methods, so only way to create unique cache file name is get query before run it and check if
Code:
sha1($query)
file exists.

is it possible ?


only way I found is
Code:
$this->db->last_query()
but is little to late Smile

Example problem

Code:
$model->setParameter($param1);
$data = $model->getResult();
$model->setParameter($param2);
$data = $model->getResult();

Now if I set cache in
Code:
getResult()
I don't have foothold to set unique cache file name.

Thanks in advance and sorry for my English Smile


Messages In This Thread
ActiveRecord - print query before run (CI 2.0.2) - by El Forum - 08-10-2011, 02:18 PM
ActiveRecord - print query before run (CI 2.0.2) - by El Forum - 08-11-2011, 04:50 PM
ActiveRecord - print query before run (CI 2.0.2) - by El Forum - 08-11-2011, 05:35 PM
ActiveRecord - print query before run (CI 2.0.2) - by El Forum - 08-11-2011, 05:57 PM



Theme © iAndrew 2016 - Forum software by © MyBB