MssqlCommandTest.php 2.74 KB
Newer Older
resurtm committed
1 2 3 4
<?php

namespace yiiunit\framework\db\mssql;

Alexander Makarov committed
5 6
use yiiunit\framework\db\CommandTest;

7 8 9 10
/**
 * @group db
 * @group mssql
 */
Alexander Makarov committed
11
class MssqlCommandTest extends CommandTest
resurtm committed
12
{
Carsten Brandt committed
13
	protected $driverName = 'sqlsrv';
resurtm committed
14

Alexander Makarov committed
15
	public function testAutoQuoting()
resurtm committed
16 17 18 19 20 21 22 23
	{
		$db = $this->getConnection(false);

		$sql = 'SELECT [[id]], [[t.name]] FROM {{tbl_customer}} t';
		$command = $db->createCommand($sql);
		$this->assertEquals("SELECT [id], [t].[name] FROM [tbl_customer] t", $command->sql);
	}

Alexander Makarov committed
24
	public function testPrepareCancel()
resurtm committed
25
	{
resurtm committed
26
		$this->markTestSkipped('MSSQL driver does not support this feature.');
resurtm committed
27 28
	}

Alexander Makarov committed
29
	public function testBindParamValue()
resurtm committed
30
	{
resurtm committed
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 59 60 61 62 63 64 65
		$db = $this->getConnection();

		// bindParam
		$sql = 'INSERT INTO tbl_customer(email, name, address) VALUES (:email, :name, :address)';
		$command = $db->createCommand($sql);
		$email = 'user4@example.com';
		$name = 'user4';
		$address = 'address4';
		$command->bindParam(':email', $email);
		$command->bindParam(':name', $name);
		$command->bindParam(':address', $address);
		$command->execute();

		$sql = 'SELECT name FROM tbl_customer WHERE email=:email';
		$command = $db->createCommand($sql);
		$command->bindParam(':email', $email);
		$this->assertEquals($name, $command->queryScalar());

		$sql = 'INSERT INTO tbl_type (int_col, char_col, float_col, blob_col, numeric_col, bool_col) VALUES (:int_col, :char_col, :float_col, CONVERT([varbinary], :blob_col), :numeric_col, :bool_col)';
		$command = $db->createCommand($sql);
		$intCol = 123;
		$charCol = 'abc';
		$floatCol = 1.23;
		$blobCol = "\x10\x11\x12";
		$numericCol = '1.23';
		$boolCol = false;
		$command->bindParam(':int_col', $intCol);
		$command->bindParam(':char_col', $charCol);
		$command->bindParam(':float_col', $floatCol);
		$command->bindParam(':blob_col', $blobCol);
		$command->bindParam(':numeric_col', $numericCol);
		$command->bindParam(':bool_col', $boolCol);
		$this->assertEquals(1, $command->execute());

		$sql = 'SELECT int_col, char_col, float_col, CONVERT([nvarchar], blob_col) AS blob_col, numeric_col FROM tbl_type';
66
		$row = $db->createCommand($sql)->queryOne();
resurtm committed
67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82
		$this->assertEquals($intCol, $row['int_col']);
		$this->assertEquals($charCol, trim($row['char_col']));
		$this->assertEquals($floatCol, $row['float_col']);
		$this->assertEquals($blobCol, $row['blob_col']);
		$this->assertEquals($numericCol, $row['numeric_col']);

		// bindValue
		$sql = 'INSERT INTO tbl_customer(email, name, address) VALUES (:email, \'user5\', \'address5\')';
		$command = $db->createCommand($sql);
		$command->bindValue(':email', 'user5@example.com');
		$command->execute();

		$sql = 'SELECT email FROM tbl_customer WHERE name=:name';
		$command = $db->createCommand($sql);
		$command->bindValue(':name', 'user5');
		$this->assertEquals('user5@example.com', $command->queryScalar());
resurtm committed
83 84
	}
}