|
@@ 134-151 (lines=18) @@
|
| 131 |
|
$this->assertSame(array(null, \PDO::PARAM_BOOL), $query->getParameterTypes()); |
| 132 |
|
} |
| 133 |
|
|
| 134 |
|
public function testSingleInsertWithColumnSpecificationAndNamedTypeValues() |
| 135 |
|
{ |
| 136 |
|
$query = new BulkInsertQuery($this->connection, 'foo', array('bar', 'baz')); |
| 137 |
|
|
| 138 |
|
$query->addValues(array('baz' => 'baz', 'bar' => 'bar')); |
| 139 |
|
|
| 140 |
|
$this->assertSame("INSERT INTO foo (bar, baz) VALUES (?, ?)", $query->getSQL()); |
| 141 |
|
$this->assertSame(array('bar', 'baz'), $query->getParameters()); |
| 142 |
|
$this->assertSame(array(null, null), $query->getParameterTypes()); |
| 143 |
|
|
| 144 |
|
$query = new BulkInsertQuery($this->connection, 'foo', array('bar', 'baz')); |
| 145 |
|
|
| 146 |
|
$query->addValues(array('baz' => 'baz', 'bar' => 'bar'), array(null, \PDO::PARAM_INT)); |
| 147 |
|
|
| 148 |
|
$this->assertSame("INSERT INTO foo (bar, baz) VALUES (?, ?)", $query->getSQL()); |
| 149 |
|
$this->assertSame(array('bar', 'baz'), $query->getParameters()); |
| 150 |
|
$this->assertSame(array(null, \PDO::PARAM_INT), $query->getParameterTypes()); |
| 151 |
|
} |
| 152 |
|
|
| 153 |
|
public function testSingleInsertWithColumnSpecificationAndMixedTypeValues() |
| 154 |
|
{ |
|
@@ 153-170 (lines=18) @@
|
| 150 |
|
$this->assertSame(array(null, \PDO::PARAM_INT), $query->getParameterTypes()); |
| 151 |
|
} |
| 152 |
|
|
| 153 |
|
public function testSingleInsertWithColumnSpecificationAndMixedTypeValues() |
| 154 |
|
{ |
| 155 |
|
$query = new BulkInsertQuery($this->connection, 'foo', array('bar', 'baz')); |
| 156 |
|
|
| 157 |
|
$query->addValues(array(1 => 'baz', 'bar' => 'bar')); |
| 158 |
|
|
| 159 |
|
$this->assertSame("INSERT INTO foo (bar, baz) VALUES (?, ?)", $query->getSQL()); |
| 160 |
|
$this->assertSame(array('bar', 'baz'), $query->getParameters()); |
| 161 |
|
$this->assertSame(array(null, null), $query->getParameterTypes()); |
| 162 |
|
|
| 163 |
|
$query = new BulkInsertQuery($this->connection, 'foo', array('bar', 'baz')); |
| 164 |
|
|
| 165 |
|
$query->addValues(array(1 => 'baz', 'bar' => 'bar'), array(\PDO::PARAM_INT, \PDO::PARAM_BOOL)); |
| 166 |
|
|
| 167 |
|
$this->assertSame("INSERT INTO foo (bar, baz) VALUES (?, ?)", $query->getSQL()); |
| 168 |
|
$this->assertSame(array('bar', 'baz'), $query->getParameters()); |
| 169 |
|
$this->assertSame(array(\PDO::PARAM_INT, \PDO::PARAM_BOOL), $query->getParameterTypes()); |
| 170 |
|
} |
| 171 |
|
|
| 172 |
|
public function testMultiInsertWithColumnSpecification() |
| 173 |
|
{ |