summaryrefslogtreecommitdiff
path: root/tests/unit/Data/DbCommon/MssqlColumnTest.php
blob: 2f7119acbed22f6d8c608cc714fd4d9a52bb6863 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
<?php

Prado::using('System.Data.*');
Prado::using('System.Data.Common.Mssql.TMssqlMetaData');
Prado::using('System.Data.DataGateway.TTableGateway');

/**
 * @package System.Data.DbCommon
 */
class MssqlColumnTest extends PHPUnit_Framework_TestCase
{
    protected function setUp()
    {
        if (!extension_loaded('mssql')) {
            $this->markTestSkipped(
              'The pgsql extension is not available.'
            );
        }
    }

	function get_conn()
	{
		return new TDbConnection('mssql:host=localhost\\sqlexpress', 'test', 'test01');
	}

	/**
	 * @return TMssqlMetaData
	 */
	function meta_data()
	{
		return new TMssqlMetaData($this->get_conn());
	}

	function test_insert()
	{
		$table = new TTableGateway('table1', $this->get_conn());
		$this->assertTrue(is_int($table->insert(array('name'=>'cool'))));
	}

/*	function test_meta()
	{
		$result = $this->meta_data()->getTableInfo("bar");
		var_dump($result);
	}
*/
	/*function test_insert()
	{
		$table = new TTableGateway('table1', $this->get_conn());
		//var_dump($table->insert(array('name'=>'cool')));
		//var_dump($table->getLastInsertId());
		$criteria = new TSqlCriteria();
		$criteria->Limit = 5;
		$criteria->Offset = 2;

		$result = $table->findAll($criteria)->readAll();
		var_dump($result);
	}*/
}