aboutsummaryrefslogtreecommitdiffstats
path: root/tests/cache/cache_memory_test.php
diff options
context:
space:
mode:
Diffstat (limited to 'tests/cache/cache_memory_test.php')
-rw-r--r--tests/cache/cache_memory_test.php125
1 files changed, 0 insertions, 125 deletions
diff --git a/tests/cache/cache_memory_test.php b/tests/cache/cache_memory_test.php
deleted file mode 100644
index 7a529c1d04..0000000000
--- a/tests/cache/cache_memory_test.php
+++ /dev/null
@@ -1,125 +0,0 @@
-<?php
-/**
-*
-* @package testing
-* @copyright (c) 2014 phpBB Group
-* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2
-*
-*/
-
-require_once dirname(__FILE__) . '/cache_memory.php';
-
-class phpbb_cache_memory_test extends phpbb_database_test_case
-{
- protected $cache;
-
- public function getDataSet()
- {
- return $this->createXMLDataSet(dirname(__FILE__).'/fixtures/cache_memory.xml');
- }
-
- protected function setUp()
- {
- global $db;
- parent::setUp();
-
- $this->cache = new phpbb_cache_memory();
- $db = $this->new_dbal();
- }
-
- static public function cache_single_query_data()
- {
- return array(
- array(
- array(
- array(
- 'SELECT * FROM ' . POSTS_TABLE,
- 3,
- ),
- ),
- POSTS_TABLE,
- ),
- array(
- array(
- array(
- 'SELECT * FROM ' . POSTS_TABLE,
- 3,
- ),
- array(
- 'SELECT * FROM ' . POSTS_TABLE . ' p
- LEFT JOIN ' . TOPICS_TABLE . ' t ON p.topic_id = t.topic_id',
- 3,
- ),
- ),
- POSTS_TABLE,
- ),
- array(
- array(
- array(
- 'SELECT * FROM ' . POSTS_TABLE,
- 3,
- ),
- array(
- 'SELECT * FROM ' . POSTS_TABLE . ' p
- LEFT JOIN ' . TOPICS_TABLE . ' t ON p.topic_id = t.topic_id',
- 3,
- ),
- array(
- 'SELECT * FROM ' . POSTS_TABLE . ' p
- LEFT JOIN ' . TOPICS_TABLE . ' t ON p.topic_id = t.topic_id
- LEFT JOIN ' . USERS_TABLE . ' u ON p.poster_id = u.user_id',
- 3,
- ),
- ),
- POSTS_TABLE,
- ),
- array(
- array(
- array(
- 'SELECT * FROM ' . POSTS_TABLE . ' p
- LEFT JOIN ' . TOPICS_TABLE . ' t ON p.topic_id = t.topic_id',
- 3,
- ),
- array(
- 'SELECT * FROM ' . POSTS_TABLE . ' p
- LEFT JOIN ' . TOPICS_TABLE . ' t ON p.topic_id = t.topic_id
- LEFT JOIN ' . USERS_TABLE . ' u ON p.poster_id = u.user_id',
- 3,
- ),
- ),
- TOPICS_TABLE,
- ),
- );
- }
-
- /**
- * @dataProvider cache_single_query_data
- */
- public function test_cache_single_query($sql_queries, $table)
- {
- global $db;
-
- foreach ($sql_queries as $query)
- {
- $sql_request_res = $db->sql_query($query[0]);
-
- $this->cache->sql_save($query[0], $sql_request_res, 1);
-
- $results = array();
- $query_id = $this->cache->sql_load($query[0]);
- while ($row = $this->cache->sql_fetchrow($query_id))
- {
- $results[] = $row;
- }
- $this->cache->sql_freeresult($query_id);
- $this->assertEquals($query[1], sizeof($results));
- }
-
- $this->cache->destroy('sql', $table);
-
- foreach ($sql_queries as $query)
- {
- $this->assertNotEquals(false, $this->cache->sql_load($query[0]));
- }
- }
-}