CubridCommandTest.php 3.04 KB
Newer Older
Carsten Brandt committed
1 2 3 4 5
<?php
namespace yiiunit\framework\db\cubrid;

use yiiunit\framework\db\CommandTest;

6 7 8 9
/**
 * @group db
 * @group cubrid
 */
Carsten Brandt committed
10 11
class CubridCommandTest extends CommandTest
{
12
    public $driverName = 'cubrid';
13

14 15 16
    public function testBindParamValue()
    {
        $db = $this->getConnection();
17

18
        // bindParam
19
        $sql = 'INSERT INTO customer(email, name, address) VALUES (:email, :name, :address)';
20 21 22 23 24 25 26 27
        $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();
28

29
        $sql = 'SELECT name FROM customer WHERE email=:email';
30 31 32
        $command = $db->createCommand($sql);
        $command->bindParam(':email', $email);
        $this->assertEquals($name, $command->queryScalar());
33

34
        $sql = "INSERT INTO type (int_col, char_col, char_col2, enum_col, float_col, blob_col, numeric_col, bool_col) VALUES (:int_col, '', :char_col, :enum_col, :float_col, CHAR_TO_BLOB(:blob_col), :numeric_col, :bool_col)";
35 36 37 38 39 40 41
        $command = $db->createCommand($sql);
        $intCol = 123;
        $charCol = 'abc';
        $enumCol = 'a';
        $floatCol = 1.23;
        $blobCol = "\x10\x11\x12";
        $numericCol = '1.23';
42
        $boolCol = true;
43 44 45 46 47 48
        $command->bindParam(':int_col', $intCol);
        $command->bindParam(':char_col', $charCol);
        $command->bindParam(':enum_col', $enumCol);
        $command->bindParam(':float_col', $floatCol);
        $command->bindParam(':blob_col', $blobCol);
        $command->bindParam(':numeric_col', $numericCol);
49
        $command->bindParam(':bool_col', $boolCol);
50
        $this->assertEquals(1, $command->execute());
51

52
        $sql = 'SELECT * FROM type';
53 54 55 56 57 58 59
        $row = $db->createCommand($sql)->queryOne();
        $this->assertEquals($intCol, $row['int_col']);
        $this->assertEquals($enumCol, $row['enum_col']);
        $this->assertEquals($charCol, $row['char_col2']);
        $this->assertEquals($floatCol, $row['float_col']);
        $this->assertEquals($blobCol, fread($row['blob_col'], 3));
        $this->assertEquals($numericCol, $row['numeric_col']);
60
        $this->assertEquals($boolCol, $row['bool_col']);
61

62
        // bindValue
63
        $sql = 'INSERT INTO customer(email, name, address) VALUES (:email, \'user5\', \'address5\')';
64 65 66
        $command = $db->createCommand($sql);
        $command->bindValue(':email', 'user5@example.com');
        $command->execute();
67

68
        $sql = 'SELECT email FROM customer WHERE name=:name';
69 70 71 72
        $command = $db->createCommand($sql);
        $command->bindValue(':name', 'user5');
        $this->assertEquals('user5@example.com', $command->queryScalar());
    }
73

74 75 76
    public function testAutoQuoting()
    {
        $db = $this->getConnection(false);
77

78
        $sql = 'SELECT [[id]], [[t.name]] FROM {{customer}} t';
79
        $command = $db->createCommand($sql);
80
        $this->assertEquals('SELECT "id", "t"."name" FROM "customer" t', $command->sql);
81
    }
Carsten Brandt committed
82
}