<?php

// error_reporting(E_STRICT);
error_reporting(E_ALL);

use PHPOnCouch\CouchClient,
	PHPOnCouch\CouchDocument,
	PHPOnCouch\CouchAdmin,
	PHPOnCouch\Exceptions,
	PHPOnCouch\Replicator;

require_once join(DIRECTORY_SEPARATOR, [__DIR__, '_config', 'config.php']);

/**
 * @backupGlobals disabled
 * @backupStaticAttributes disabled
 */
class CouchClientViewTest extends PHPUnit_Framework_TestCase
{

	private $host = 'localhost';
	private $port = '5984';

	public function setUp()
	{
		$config = config::getInstance();
		$this->host = $config->getHost();
		$this->port = $config->getPort();
		$url = $config->getUrl($this->host, $this->port, $config->getFirstNormalUser());
		$aUrl = $config->getUrl($this->host, $this->port, $config->getFirstAdmin());
		$this->aclient = new CouchClient($url, 'couchclienttest');
		$this->aclient = new CouchClient($aUrl, 'couchclienttest');
		try {
			$this->aclient->deleteDatabase();
		} catch (Exceptions\CouchNotFoundException $e) {
			
		}
		$this->aclient->createDatabase();
	}

	public function tearDown()
	{
		try {
			$this->aclient->deleteDatabase();
		} catch (\Exception $e) {
			
		}
		$this->aclient = null;
	}

	protected function _makeView()
	{
		$doc = new CouchDocument($this->aclient);
		$doc->_id = "_design/test";
		$views = array();
		$map = "function (doc) {
			if ( doc.type && doc.type == 'test' ) {
				emit(doc.type,1);
			}
		}";
		$reduce = "function (keys, values) {
			return sum(values);
		}";
		$map2 = "function (doc) {
			if ( doc.type ) {
				emit(doc.type,1);
			}
		}";
		$doc->views = array(
			"simple" => array(
				"map" => $map,
				"reduce" => $reduce
			),
			"complex" => array(
				"map" => $map2,
				"reduce" => $reduce
			)
		);
	}

	public function testSimpleViews()
	{
		$this->_makeView();
		$docs = array(
			array("_id" => "one", "type" => "test", "param" => null),
			array("_id" => "two", "type" => "test", "param" => null),
			array("_id" => "three", "type" => "test", "param" => null),
			array("_id" => "four", "type" => "test2", "param" => null),
			array("_id" => "five", "type" => "test", "param" => null)
		);
		$this->aclient->storeDocs($docs);
		$infos = $this->aclient->getDatabaseInfos();
		$this->assertEquals($infos->doc_count, 6);
		$test = $this->aclient->reduce(false)->getView("test", "simple");
		$this->assertInternalType("object", $test);
		$this->assertObjectHasAttribute("total_rows", $test);
		$this->assertEquals($test->total_rows, 4);
		$this->assertObjectHasAttribute("offset", $test);
		$this->assertEquals($test->offset, 0);
		$this->assertObjectHasAttribute("rows", $test);
		$this->assertInternalType("array", $test->rows);
		$this->assertEquals(count($test->rows), 4);
		foreach ($test->rows as $row) {
			$this->assertObjectHasAttribute("id", $row);
			$this->assertObjectHasAttribute("key", $row);
			$this->assertObjectHasAttribute("value", $row);
			$this->assertObjectNotHasAttribute("doc", $row);
		}
	}

	public function testSimpleReduceViews()
	{
		$this->_makeView();
		$docs = array(
			array("_id" => "one", "type" => "test", "param" => null),
			array("_id" => "two", "type" => "test", "param" => null),
			array("_id" => "three", "type" => "test", "param" => null),
			array("_id" => "four", "type" => "test2", "param" => null),
			array("_id" => "five", "type" => "test", "param" => null)
		);
		$this->aclient->storeDocs($docs);
		$infos = $this->aclient->getDatabaseInfos();
		$this->assertEquals($infos->doc_count, 6);
		$test = $this->aclient->getView("test", "simple");
// 		print_r($test);
		$this->assertInternalType("object", $test);
		$this->assertObjectHasAttribute("rows", $test);
		$this->assertInternalType("array", $test->rows);
		$this->assertEquals(count($test->rows), 1);
		$row = reset($test->rows);
		$this->assertInternalType("object", $row);
		$this->assertObjectHasAttribute("value", $row);
		$this->assertEquals($row->value, 4);
	}

	public function testIncludeDocs()
	{
		$this->_makeView();
		$docs = array(
			array("_id" => "one", "type" => "test", "param" => null),
			array("_id" => "two", "type" => "test", "param" => null),
			array("_id" => "three", "type" => "test", "param" => null),
			array("_id" => "four", "type" => "test2", "param" => null),
			array("_id" => "five", "type" => "test", "param" => null)
		);
		$this->aclient->storeDocs($docs);
		$infos = $this->aclient->getDatabaseInfos();
		$this->assertEquals($infos->doc_count, 6);
		$test = $this->aclient->reduce(false)->include_docs(true)->getView("test", "simple");
		$this->assertInternalType("object", $test);
		$this->assertObjectHasAttribute("total_rows", $test);
		$this->assertEquals($test->total_rows, 4);
		$this->assertObjectHasAttribute("offset", $test);
		$this->assertEquals($test->offset, 0);
		$this->assertObjectHasAttribute("rows", $test);
		$this->assertInternalType("array", $test->rows);
		$this->assertEquals(count($test->rows), 4);
		foreach ($test->rows as $row) {
			$this->assertObjectHasAttribute("id", $row);
			$this->assertObjectHasAttribute("key", $row);
			$this->assertObjectHasAttribute("value", $row);
			$this->assertObjectHasAttribute("doc", $row);
		}
	}

	public function testViewKey()
	{
		$this->_makeView();
		$docs = array(
			array("_id" => "one", "type" => "test", "param" => null),
			array("_id" => "two", "type" => "test2", "param" => null),
			array("_id" => "three", "type" => "test", "param" => null),
			array("_id" => "four", "type" => "test2", "param" => null),
			array("_id" => "five", "type" => "test2", "param" => null)
		);
		$this->aclient->storeDocs($docs);
		$infos = $this->aclient->getDatabaseInfos();
		$this->assertEquals($infos->doc_count, 6);
		$test = $this->aclient->reduce(false)->key("test")->getView("test", "complex");
// 		print_r($test);
		$this->assertInternalType("object", $test);
		$this->assertObjectHasAttribute("total_rows", $test);
		$this->assertEquals($test->total_rows, 5);
		$this->assertObjectHasAttribute("offset", $test);
		$this->assertEquals($test->offset, 0);
		$this->assertObjectHasAttribute("rows", $test);
		$this->assertInternalType("array", $test->rows);
		$this->assertEquals(count($test->rows), 2);
		foreach ($test->rows as $row) {
			$this->assertObjectHasAttribute("id", $row);
			$this->assertObjectHasAttribute("key", $row);
			$this->assertEquals($row->key, "test");
			$this->assertObjectHasAttribute("value", $row);
		}
	}

	public function testViewKeys()
	{
		$this->_makeView();
		$docs = array(
			array("_id" => "one", "type" => "test", "param" => null),
			array("_id" => "two", "type" => "test2", "param" => null),
			array("_id" => "three", "type" => "test", "param" => null),
			array("_id" => "four", "type" => "test3", "param" => null),
			array("_id" => "five", "type" => "test2", "param" => null)
		);
		$this->aclient->storeDocs($docs);
		$infos = $this->aclient->getDatabaseInfos();
		$this->assertEquals($infos->doc_count, 6);
		$test = $this->aclient->reduce(false)->keys(array("test", "test3"))->getView("test", "complex");
// 		print_r($test);	
		$this->assertInternalType("object", $test);
		$this->assertObjectHasAttribute("total_rows", $test);
		$this->assertEquals($test->total_rows, 5);
		$this->assertObjectHasAttribute("offset", $test);
		$this->assertEquals($test->offset, 2);
		$this->assertObjectHasAttribute("rows", $test);
		$this->assertInternalType("array", $test->rows);
		$this->assertEquals(count($test->rows), 3);
		foreach ($test->rows as $row) {
			$this->assertObjectHasAttribute("id", $row);
			$this->assertObjectHasAttribute("key", $row);
			$this->assertObjectHasAttribute("value", $row);
		}
	}

	public function testViewStartkey()
	{
		$this->_makeView();
		$docs = array(
			array("_id" => "one", "type" => "test", "param" => null),
			array("_id" => "two", "type" => "test2", "param" => null),
			array("_id" => "three", "type" => "test", "param" => null),
			array("_id" => "four", "type" => "test3", "param" => null),
			array("_id" => "five", "type" => "test2", "param" => null)
		);
		$this->aclient->storeDocs($docs);
		$infos = $this->aclient->getDatabaseInfos();
		$this->assertEquals($infos->doc_count, 6);
		$test = $this->aclient->reduce(false)->startkey("test3")->getView("test", "complex");
		$this->assertInternalType("object", $test);
		$this->assertObjectHasAttribute("total_rows", $test);
		$this->assertEquals($test->total_rows, 5);
		$this->assertObjectHasAttribute("offset", $test);
		$this->assertEquals($test->offset, 4);
		$this->assertObjectHasAttribute("rows", $test);
		$this->assertInternalType("array", $test->rows);
		$this->assertEquals(count($test->rows), 1);
		foreach ($test->rows as $row) {
			$this->assertObjectHasAttribute("id", $row);
			$this->assertObjectHasAttribute("key", $row);
			$this->assertObjectHasAttribute("value", $row);
		}
	}

	public function testViewEndkey()
	{
		$this->_makeView();
		$docs = array(
			array("_id" => "one", "type" => "test", "param" => null),
			array("_id" => "two", "type" => "test2", "param" => null),
			array("_id" => "three", "type" => "test", "param" => null),
			array("_id" => "four", "type" => "test3", "param" => null),
			array("_id" => "five", "type" => "test2", "param" => null)
		);
		$this->aclient->storeDocs($docs);
		$infos = $this->aclient->getDatabaseInfos();
		$this->assertEquals($infos->doc_count, 6);
		$test = $this->aclient->reduce(false)->endkey("test")->getView("test", "complex");
		$this->assertInternalType("object", $test);
		$this->assertObjectHasAttribute("total_rows", $test);
		$this->assertEquals($test->total_rows, 5);
		$this->assertObjectHasAttribute("offset", $test);
		$this->assertEquals($test->offset, 0);
		$this->assertObjectHasAttribute("rows", $test);
		$this->assertInternalType("array", $test->rows);
		$this->assertEquals(count($test->rows), 2);
		foreach ($test->rows as $row) {
			$this->assertObjectHasAttribute("id", $row);
			$this->assertObjectHasAttribute("key", $row);
			$this->assertObjectHasAttribute("value", $row);
		}

		$test = $this->aclient->reduce(false)->endkey("test")->inclusive_end(false)->getView("test", "complex");
		$this->assertInternalType("object", $test);
		$this->assertObjectHasAttribute("total_rows", $test);
		$this->assertEquals($test->total_rows, 5);
		$this->assertObjectHasAttribute("offset", $test);
		$this->assertEquals($test->offset, 0);
		$this->assertObjectHasAttribute("rows", $test);
		$this->assertInternalType("array", $test->rows);
		$this->assertEquals(count($test->rows), 0);
		foreach ($test->rows as $row) {
			$this->assertObjectHasAttribute("id", $row);
			$this->assertObjectHasAttribute("key", $row);
			$this->assertObjectHasAttribute("value", $row);
		}
	}

	public function testViewStartkeyDocid()
	{
		$this->_makeView();
		$docs = array(
			array("_id" => "one", "type" => "test", "param" => null),
			array("_id" => "two", "type" => "test2", "param" => null),
			array("_id" => "three", "type" => "test", "param" => null),
			array("_id" => "four", "type" => "test3", "param" => null),
			array("_id" => "five", "type" => "test2", "param" => null)
		);
		$this->aclient->storeDocs($docs);
		$infos = $this->aclient->getDatabaseInfos();
		$this->assertEquals($infos->doc_count, 6);
		$test = $this->aclient->reduce(false)->startkey("test")->startkey_docid("three")->getView("test", "complex");
// 		print_r($test);	
		$this->assertInternalType("object", $test);
		$this->assertObjectHasAttribute("total_rows", $test);
		$this->assertEquals($test->total_rows, 5);
		$this->assertObjectHasAttribute("offset", $test);
		$this->assertEquals($test->offset, 1);
		$this->assertObjectHasAttribute("rows", $test);
		$this->assertInternalType("array", $test->rows);
		$this->assertEquals(count($test->rows), 4);
		foreach ($test->rows as $row) {
			$this->assertObjectHasAttribute("id", $row);
			$this->assertObjectHasAttribute("key", $row);
			$this->assertObjectHasAttribute("value", $row);
		}
	}

	public function testViewEndkeyDocid()
	{
		$this->_makeView();
		$docs = array(
			array("_id" => "one", "type" => "test", "param" => null),
			array("_id" => "two", "type" => "test2", "param" => null),
			array("_id" => "three", "type" => "test", "param" => null),
			array("_id" => "four", "type" => "test3", "param" => null),
			array("_id" => "five", "type" => "test2", "param" => null)
		);
		$this->aclient->storeDocs($docs);
		$infos = $this->aclient->getDatabaseInfos();
		$this->assertEquals($infos->doc_count, 6);
		$test = $this->aclient->reduce(false)->endkey("test2")->endkey_docid("five")->getView("test", "complex");
// 		print_r($test);	
		$this->assertInternalType("object", $test);
		$this->assertObjectHasAttribute("total_rows", $test);
		$this->assertEquals($test->total_rows, 5);
		$this->assertObjectHasAttribute("offset", $test);
		$this->assertEquals($test->offset, 0);
		$this->assertObjectHasAttribute("rows", $test);
		$this->assertInternalType("array", $test->rows);
		$this->assertEquals(count($test->rows), 3);
		foreach ($test->rows as $row) {
			$this->assertObjectHasAttribute("id", $row);
			$this->assertObjectHasAttribute("key", $row);
			$this->assertObjectHasAttribute("value", $row);
		}
	}

	public function testViewLimit()
	{
		$this->_makeView();
		$docs = array(
			array("_id" => "one", "type" => "test", "param" => null),
			array("_id" => "two", "type" => "test2", "param" => null),
			array("_id" => "three", "type" => "test", "param" => null),
			array("_id" => "four", "type" => "test3", "param" => null),
			array("_id" => "five", "type" => "test2", "param" => null)
		);
		$this->aclient->storeDocs($docs);
		$infos = $this->aclient->getDatabaseInfos();
		$this->assertEquals($infos->doc_count, 6);
		$test = $this->aclient->reduce(false)->limit(2)->getView("test", "complex");
// 		print_r($test);	
		$this->assertInternalType("object", $test);
		$this->assertObjectHasAttribute("total_rows", $test);
		$this->assertEquals($test->total_rows, 5);
		$this->assertObjectHasAttribute("offset", $test);
		$this->assertEquals($test->offset, 0);
		$this->assertObjectHasAttribute("rows", $test);
		$this->assertInternalType("array", $test->rows);
		$this->assertEquals(count($test->rows), 2);
		foreach ($test->rows as $row) {
			$this->assertObjectHasAttribute("id", $row);
			$this->assertObjectHasAttribute("key", $row);
			$this->assertObjectHasAttribute("value", $row);
		}
	}

	public function testViewSkip()
	{
		$this->_makeView();
		$docs = array(
			array("_id" => "one", "type" => "test", "param" => null),
			array("_id" => "two", "type" => "test2", "param" => null),
			array("_id" => "three", "type" => "test", "param" => null),
			array("_id" => "four", "type" => "test3", "param" => null),
			array("_id" => "five", "type" => "test2", "param" => null)
		);
		$this->aclient->storeDocs($docs);
		$infos = $this->aclient->getDatabaseInfos();
		$this->assertEquals($infos->doc_count, 6);
		$test = $this->aclient->reduce(false)->skip(2)->getView("test", "complex");
// 		print_r($test);	
		$this->assertInternalType("object", $test);
		$this->assertObjectHasAttribute("total_rows", $test);
		$this->assertEquals($test->total_rows, 5);
		$this->assertObjectHasAttribute("offset", $test);
		$this->assertEquals($test->offset, 2);
		$this->assertObjectHasAttribute("rows", $test);
		$this->assertInternalType("array", $test->rows);
		$this->assertEquals(count($test->rows), 3);
		foreach ($test->rows as $row) {
			$this->assertObjectHasAttribute("id", $row);
			$this->assertObjectHasAttribute("key", $row);
			$this->assertObjectHasAttribute("value", $row);
		}
	}

	public function testViewDescending()
	{
		$this->_makeView();
		$docs = array(
			array("_id" => "one", "type" => "test", "param" => null),
			array("_id" => "two", "type" => "test2", "param" => null),
			array("_id" => "three", "type" => "test", "param" => null),
			array("_id" => "four", "type" => "test3", "param" => null),
			array("_id" => "five", "type" => "test2", "param" => null)
		);
		$this->aclient->storeDocs($docs);
		$infos = $this->aclient->getDatabaseInfos();
		$this->assertEquals($infos->doc_count, 6);
		$test = $this->aclient->reduce(false)->getView("test", "complex");
// 		print_r($test);	
		$this->assertInternalType("object", $test);
		$this->assertObjectHasAttribute("total_rows", $test);
		$this->assertEquals($test->total_rows, 5);
		$this->assertObjectHasAttribute("offset", $test);
		$this->assertEquals($test->offset, 0);
		$this->assertObjectHasAttribute("rows", $test);
		$this->assertInternalType("array", $test->rows);
		$this->assertEquals(count($test->rows), 5);
		$row = reset($test->rows);
		$this->assertObjectHasAttribute("key", $row);
		$this->assertEquals($row->key, "test");

		$test = $this->aclient->reduce(false)->descending(true)->getView("test", "complex");
// 		print_r($test);	
		$this->assertInternalType("object", $test);
		$this->assertObjectHasAttribute("total_rows", $test);
		$this->assertEquals($test->total_rows, 5);
		$this->assertObjectHasAttribute("offset", $test);
		$this->assertEquals($test->offset, 0);
		$this->assertObjectHasAttribute("rows", $test);
		$this->assertInternalType("array", $test->rows);
		$this->assertEquals(count($test->rows), 5);
		$row = reset($test->rows);
		$this->assertObjectHasAttribute("key", $row);
		$this->assertEquals($row->key, "test3");
	}

	public function testViewGroup()
	{
		$this->_makeView();
		$docs = array(
			array("_id" => "one", "type" => "test", "param" => 1),
			array("_id" => "two", "type" => "test2", "param" => 2),
			array("_id" => "three", "type" => "test", "param" => 2),
			array("_id" => "four", "type" => "test3", "param" => 1),
			array("_id" => "five", "type" => "test2", "param" => 1)
		);
		$this->aclient->storeDocs($docs);
		$infos = $this->aclient->getDatabaseInfos();
		$this->assertEquals($infos->doc_count, 6);

		$doc = CouchDocument::getInstance($this->aclient, "_design/test");
		$views = $doc->views;
		$views->multigroup = new stdClass();
		$views->multigroup->map = "function (doc) {
			if ( doc.type && doc.param ) {
				emit( [doc.type, doc.param], 1);
			}
		}";
		$views->multigroup->reduce = "function(keys,values) {
			return sum(values);
		}";
		$doc->views = $views;

		$test = $this->aclient->group(true)->getView("test", "multigroup");
		$this->assertInternalType("object", $test);
		$this->assertObjectHasAttribute("rows", $test);
		$this->assertInternalType("array", $test->rows);
		$this->assertEquals(count($test->rows), 5);

		$test = $this->aclient->group(true)->group_level(1)->getView("test", "multigroup");
		$this->assertInternalType("object", $test);
		$this->assertObjectHasAttribute("rows", $test);
		$this->assertInternalType("array", $test->rows);
		$this->assertEquals(count($test->rows), 3);
	}

	public function testViewAsArray()
	{
		$this->_makeView();
		$docs = array(
			array("_id" => "one", "type" => "test", "param" => null),
			array("_id" => "two", "type" => "test2", "param" => null),
			array("_id" => "three", "type" => "test", "param" => null),
			array("_id" => "four", "type" => "test3", "param" => null),
			array("_id" => "five", "type" => "test2", "param" => null)
		);
		$this->aclient->storeDocs($docs);
		$infos = $this->aclient->getDatabaseInfos();
		$this->assertEquals($infos->doc_count, 6);
		$test = $this->aclient->reduce(false)->asArray()->getView("test", "complex");
// 		print_r($test);	
		$this->assertInternalType("array", $test);
	}

}