aboutsummaryrefslogtreecommitdiffstats
path: root/tests/cache
diff options
context:
space:
mode:
Diffstat (limited to 'tests/cache')
-rw-r--r--tests/cache/apc_driver_test.php38
-rw-r--r--tests/cache/common_test_case.php33
-rw-r--r--tests/cache/file_driver_test.php38
-rw-r--r--tests/cache/redis_driver_test.php42
4 files changed, 33 insertions, 118 deletions
diff --git a/tests/cache/apc_driver_test.php b/tests/cache/apc_driver_test.php
index c8b8f82b67..3380762878 100644
--- a/tests/cache/apc_driver_test.php
+++ b/tests/cache/apc_driver_test.php
@@ -50,42 +50,4 @@ class phpbb_cache_apc_driver_test extends phpbb_cache_common_test_case
$this->driver = new phpbb_cache_driver_apc;
$this->driver->purge();
}
-
- public function test_cache_sql()
- {
- global $db, $cache;
- $db = $this->new_dbal();
- $cache = new phpbb_cache_service($this->driver);
-
- $sql = "SELECT * FROM phpbb_config
- WHERE config_name = 'foo'";
-
- $key = $this->driver->key_prefix . 'sql_' . md5(preg_replace('/[\n\r\s\t]+/', ' ', $sql));
- $this->assertFalse(apc_fetch($key));
-
- $result = $db->sql_query($sql, 300);
- $first_result = $db->sql_fetchrow($result);
- $expected = array('config_name' => 'foo', 'config_value' => '23', 'is_dynamic' => 0);
- $this->assertEquals($expected, $first_result);
-
- $this->assertTrue((bool) apc_fetch($key));
-
- $sql = 'DELETE FROM phpbb_config';
- $result = $db->sql_query($sql);
-
- $sql = "SELECT * FROM phpbb_config
- WHERE config_name = 'foo'";
- $result = $db->sql_query($sql, 300);
-
- $this->assertEquals($expected, $db->sql_fetchrow($result));
-
- $sql = "SELECT * FROM phpbb_config
- WHERE config_name = 'foo'";
- $result = $db->sql_query($sql);
-
- $no_cache_result = $db->sql_fetchrow($result);
- $this->assertSame(false, $no_cache_result);
-
- $db->sql_close();
- }
}
diff --git a/tests/cache/common_test_case.php b/tests/cache/common_test_case.php
index 45cf80e424..fa298ec9ae 100644
--- a/tests/cache/common_test_case.php
+++ b/tests/cache/common_test_case.php
@@ -61,4 +61,37 @@ abstract class phpbb_cache_common_test_case extends phpbb_database_test_case
$this->driver->get('second_key')
);
}
+
+ public function test_cache_sql()
+ {
+ global $db, $cache;
+ $db = $this->new_dbal();
+ $cache = new phpbb_cache_service($this->driver);
+
+ $sql = "SELECT * FROM phpbb_config
+ WHERE config_name = 'foo'";
+
+ $result = $db->sql_query($sql, 300);
+ $first_result = $db->sql_fetchrow($result);
+ $expected = array('config_name' => 'foo', 'config_value' => '23', 'is_dynamic' => 0);
+ $this->assertEquals($expected, $first_result);
+
+ $sql = 'DELETE FROM phpbb_config';
+ $result = $db->sql_query($sql);
+
+ $sql = "SELECT * FROM phpbb_config
+ WHERE config_name = 'foo'";
+ $result = $db->sql_query($sql, 300);
+
+ $this->assertEquals($expected, $db->sql_fetchrow($result));
+
+ $sql = "SELECT * FROM phpbb_config
+ WHERE config_name = 'foo'";
+ $result = $db->sql_query($sql);
+
+ $no_cache_result = $db->sql_fetchrow($result);
+ $this->assertSame(false, $no_cache_result);
+
+ $db->sql_close();
+ }
}
diff --git a/tests/cache/file_driver_test.php b/tests/cache/file_driver_test.php
index 2353940277..745c6bb081 100644
--- a/tests/cache/file_driver_test.php
+++ b/tests/cache/file_driver_test.php
@@ -66,42 +66,4 @@ class phpbb_cache_file_driver_test extends phpbb_cache_common_test_case
}
rmdir($this->cache_dir);
}
-
- public function test_cache_sql()
- {
- global $db, $cache;
- $db = $this->new_dbal();
- $cache = new phpbb_cache_service($this->driver);
-
- $sql = "SELECT * FROM phpbb_config
- WHERE config_name = 'foo'";
-
- $cache_path = $this->cache_dir . 'sql_' . md5(preg_replace('/[\n\r\s\t]+/', ' ', $sql)) . '.php';
- $this->assertFileNotExists($cache_path);
-
- $result = $db->sql_query($sql, 300);
- $first_result = $db->sql_fetchrow($result);
- $expected = array('config_name' => 'foo', 'config_value' => '23', 'is_dynamic' => 0);
- $this->assertEquals($expected, $first_result);
-
- $this->assertFileExists($cache_path);
-
- $sql = 'DELETE FROM phpbb_config';
- $result = $db->sql_query($sql);
-
- $sql = "SELECT * FROM phpbb_config
- WHERE config_name = 'foo'";
- $result = $db->sql_query($sql, 300);
-
- $this->assertEquals($expected, $db->sql_fetchrow($result));
-
- $sql = "SELECT * FROM phpbb_config
- WHERE config_name = 'foo'";
- $result = $db->sql_query($sql);
-
- $no_cache_result = $db->sql_fetchrow($result);
- $this->assertSame(false, $no_cache_result);
-
- $db->sql_close();
- }
}
diff --git a/tests/cache/redis_driver_test.php b/tests/cache/redis_driver_test.php
index a90a750460..1308519a18 100644
--- a/tests/cache/redis_driver_test.php
+++ b/tests/cache/redis_driver_test.php
@@ -46,46 +46,4 @@ class phpbb_cache_redis_driver_test extends phpbb_cache_common_test_case
$this->driver = new phpbb_cache_driver_redis(self::$config['host'], self::$config['port']);
$this->driver->purge();
}
-
- public function test_cache_sql()
- {
- global $db, $cache;
- $db = $this->new_dbal();
- $cache = new phpbb_cache_service($this->driver);
-
- $redis = new Redis();
- $ok = $redis->connect(self::$config['host'], self::$config['port']);
- $this->assertTrue($ok);
-
- $sql = "SELECT * FROM phpbb_config
- WHERE config_name = 'foo'";
-
- $key = $this->driver->key_prefix . 'sql_' . md5(preg_replace('/[\n\r\s\t]+/', ' ', $sql));
- $this->assertFalse($redis->exists($key));
-
- $result = $db->sql_query($sql, 300);
- $first_result = $db->sql_fetchrow($result);
- $expected = array('config_name' => 'foo', 'config_value' => '23', 'is_dynamic' => 0);
- $this->assertEquals($expected, $first_result);
-
- $this->assertTrue($redis->exists($key));
-
- $sql = 'DELETE FROM phpbb_config';
- $result = $db->sql_query($sql);
-
- $sql = "SELECT * FROM phpbb_config
- WHERE config_name = 'foo'";
- $result = $db->sql_query($sql, 300);
-
- $this->assertEquals($expected, $db->sql_fetchrow($result));
-
- $sql = "SELECT * FROM phpbb_config
- WHERE config_name = 'foo'";
- $result = $db->sql_query($sql);
-
- $no_cache_result = $db->sql_fetchrow($result);
- $this->assertSame(false, $no_cache_result);
-
- $db->sql_close();
- }
}
generated by cgit v1.2.1 (git 2.21.0) at 2024-11-15 14:08:43 +0000