<?php

/**
 * test setup ~ /tests/Tests.php
 */
require_once dirname(__FILE__) . '/../../bootstrap.php';

/**
 * @see Asra.Db
 */
require_once 'Asra/Db/Connect.php';
require_once 'Asra/Db/MySQL.php';

/**
 * @see PHPUnit_Framework
 */
require_once 'PHPUnit/Framework.php';

/**
 * MySQLTest.php
 */
class Asra_Db_MySQLTest extends PHPUnit_Framework_TestCase
{
	private $config = array(
		"default" => array(
			"database.adapter" => "mysqli",
			"database.params.host" => "localhost", 
			"database.params.dbname" => "database_test", 
			"database.params.username" => "root", 
			"database.params.password" => "root",
		)
	);
	
	private $connect;
	private $database;
	private $db;
	
	public function setUp()
	{		
		$this->connect = new Asra_Db_Connect($this->config);
		$this->database = $this->connect->getDb(); //echo $this->database;
		// -- should auto connect
		$this->db = new Asra_Db_MySQL($this->connect, true);
		// -- should ignore connect but test
		$this->db->connect();
	}
	
	public function testClose()
	{
		$this->assertTrue($this->db->connected);
		$this->db->close();
		$this->assertFalse($this->db->connected);
	}
	
	public function testGetDb()
	{
		$database = $this->db->getDb();
		$this->assertEquals('database_test', $database);
	}
	
	public function testGetHost()
	{
		$host = $this->db->getHost();
		$this->assertEquals('localhost', $host);
	}
	
	public function testGetObj()
	{
		$result = $this->db->obj("SELECT * FROM `table_name`");
		$this->assertNotNull($result);
	}
	
	public function testGetUser()
	{
		$user = $this->db->getUser();
		$this->assertEquals('root', $user);
	}
	
	public function testExists()
	{
		$test = $this->db->exists('i_dont_exist');
		$this->assertFalse($test);
		
		$test = $this->db->exists('table_name');
		$this->assertTrue($test);
	}
	
	public function testQuery()
	{
		$result = $this->db->row("SELECT id FROM `table_name` WHERE id = 10000000");
		$this->assertFalse($result);
	}
	
	public function testRow()
	{
		$result = $this->db->row("SELECT id FROM `table_name`");
		$this->assertNotNull($result);
		$this->assertType('array', $result);
		$this->assertArrayHasKey('id', $result);
	}
	
	public function testRun()
	{
		$result = $this->db->run("SELECT * FROM `table_name`", true);
		$this->assertType('integer', $result);
		
		$result = $this->db->run("SELECT * FROM `table_name`", false);
		$this->assertType('boolean', $result);
		$this->assertTrue($result);
	}
	
	public function testSearch()
	{
		$this->markTestIncomplete();
	}
	
	public function testSelectDb()
	{
		$this->db->selectDb();
		$this->db->selectDb('database_test');
	}
}