diff options
| author | Oleg Pudeyev <oleg@bsdpower.com> | 2012-11-30 12:18:33 -0500 |
|---|---|---|
| committer | Oleg Pudeyev <oleg@bsdpower.com> | 2012-11-30 12:18:33 -0500 |
| commit | 7bba09811c65acfd98ebf1e6626f59de7a16cbb3 (patch) | |
| tree | 9608dd23403593ba6a6c292826e379eba6de9d22 /tests/cache | |
| parent | 1ebc6eb68bedc4d6708cb6f23959d129030cf31e (diff) | |
| download | forums-7bba09811c65acfd98ebf1e6626f59de7a16cbb3.tar forums-7bba09811c65acfd98ebf1e6626f59de7a16cbb3.tar.gz forums-7bba09811c65acfd98ebf1e6626f59de7a16cbb3.tar.bz2 forums-7bba09811c65acfd98ebf1e6626f59de7a16cbb3.tar.xz forums-7bba09811c65acfd98ebf1e6626f59de7a16cbb3.zip | |
[ticket/10875] Revise sql cache test.
Delete data from database before retrieving it from cache,
ensuring results come from cache.
PHPBB3-10875
Diffstat (limited to 'tests/cache')
| -rw-r--r-- | tests/cache/cache_test.php | 14 |
1 files changed, 10 insertions, 4 deletions
diff --git a/tests/cache/cache_test.php b/tests/cache/cache_test.php index c5f5fac88c..40eef91d53 100644 --- a/tests/cache/cache_test.php +++ b/tests/cache/cache_test.php @@ -89,20 +89,26 @@ class phpbb_cache_test extends phpbb_database_test_case 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); $this->assertFileExists($this->cache_dir . 'sql_' . md5(preg_replace('/[\n\r\s\t]+/', ' ', $sql)) . '.php'); + $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($first_result, $db->sql_fetchrow($result)); + $this->assertEquals($expected, $db->sql_fetchrow($result)); $sql = "SELECT * FROM phpbb_config - WHERE config_name = 'bar'"; - $result = $db->sql_query($sql, 300); + WHERE config_name = 'foo'"; + $result = $db->sql_query($sql); - $this->assertNotEquals($first_result, $db->sql_fetchrow($result)); + $no_cache_result = $db->sql_fetchrow($result); + $this->assertSame(false, $no_cache_result); $db->sql_close(); } |