diff options
author | Nathan Guse <nathaniel.guse@gmail.com> | 2012-08-06 16:26:55 -0500 |
---|---|---|
committer | Nathan Guse <nathaniel.guse@gmail.com> | 2012-08-06 16:26:55 -0500 |
commit | dcefa16318f6dc1058595a7ba221b75ed6a2504b (patch) | |
tree | 4949582266a91adb9fa5ea210dc7c811953ee393 /tests/cache | |
parent | 01bc818d465ab168288e260745a045ff2794648d (diff) | |
download | forums-dcefa16318f6dc1058595a7ba221b75ed6a2504b.tar forums-dcefa16318f6dc1058595a7ba221b75ed6a2504b.tar.gz forums-dcefa16318f6dc1058595a7ba221b75ed6a2504b.tar.bz2 forums-dcefa16318f6dc1058595a7ba221b75ed6a2504b.tar.xz forums-dcefa16318f6dc1058595a7ba221b75ed6a2504b.zip |
[ticket/10875] Return $query_id from sql_save
Have to return the $query_id from sql_save so that the results can be pulled
Updated cache test to do some basic sql cache testing.
PHPBB3-10875
Diffstat (limited to 'tests/cache')
-rw-r--r-- | tests/cache/cache_test.php | 32 |
1 files changed, 31 insertions, 1 deletions
diff --git a/tests/cache/cache_test.php b/tests/cache/cache_test.php index 564bd35863..81ce9ac1aa 100644 --- a/tests/cache/cache_test.php +++ b/tests/cache/cache_test.php @@ -9,7 +9,7 @@ require_once dirname(__FILE__) . '/../../phpBB/includes/functions.php'; -class phpbb_cache_test extends phpbb_test_case +class phpbb_cache_test extends phpbb_database_test_case { private $cache_dir; @@ -18,6 +18,11 @@ class phpbb_cache_test extends phpbb_test_case $this->cache_dir = dirname(__FILE__) . '/../tmp/cache/'; } + public function getDataSet() + { + return array(); + } + protected function setUp() { if (file_exists($this->cache_dir)) @@ -67,4 +72,29 @@ class phpbb_cache_test extends phpbb_test_case 'File ACM put and get' ); } + + public function test_cache_sql() + { + $driver = new phpbb_cache_driver_file($this->cache_dir); + + global $db, $cache; + $db = $this->new_dbal(); + $cache = new phpbb_cache_service($driver); + + $sql = 'SELECT * FROM phpbb_config WHERE config_name = \'board_disable\''; + $result = $db->sql_query($sql, 300); + $first_result = $db->sql_fetchrow($result); + + $this->assertFileExists($this->cache_dir . 'sql_' . md5($sql) . '.php'); + + $sql = 'SELECT * FROM phpbb_config WHERE config_name = \'board_disable\''; + $result = $db->sql_query($sql, 300); + + $this->assertEquals($first_result, $db->sql_fetchrow($result)); + + $sql = 'SELECT * FROM phpbb_config WHERE config_name = \'version\''; + $result = $db->sql_query($sql, 300); + + $this->assertNotEquals($first_result, $db->sql_fetchrow($result)); + } } |