|
@@ 135-143 (lines=9) @@
|
| 132 |
|
} |
| 133 |
|
$stubs = implode(',', $stubs); |
| 134 |
|
|
| 135 |
|
if(array_keys($values) === range(0, count($values) - 1)){ |
| 136 |
|
//VALUES(val0, val1, val2) |
| 137 |
|
$context->appendSql("VALUES($stubs)"); |
| 138 |
|
|
| 139 |
|
}else{ |
| 140 |
|
//(col0, col1, col2) VALUES(val0, val1, val2) |
| 141 |
|
$columns = implode(',', array_map(function($k){return DB::wrap($k);}, array_keys($values))); |
| 142 |
|
$context->appendSql("($columns) VALUES($stubs)",false); |
| 143 |
|
} |
| 144 |
|
$context->appendParams($params); |
| 145 |
|
} |
| 146 |
|
static public function batchValues(Context $context, array $values) |
|
@@ 154-161 (lines=8) @@
|
| 151 |
|
} |
| 152 |
|
$keys = array_keys($values[0]); |
| 153 |
|
$row = implode(',', self::toSql(array_values($values[0]))); |
| 154 |
|
if($keys === range(0, count($keys) - 1)){ |
| 155 |
|
//VALUES(val0, val1, val2) |
| 156 |
|
$context->appendSql("VALUES($row)"); |
| 157 |
|
}else{ |
| 158 |
|
//(col0, col1, col2) VALUES(val0, val1, val2) |
| 159 |
|
$columns = implode(',', array_map(function($k){return DB::wrap($k);}, $keys)); |
| 160 |
|
$context->appendSql("($columns) VALUES($row)",false); |
| 161 |
|
} |
| 162 |
|
for($i=1; $i<$count; $i++){ |
| 163 |
|
$value = self::pick($keys, $values[$i]); |
| 164 |
|
$row = implode(',', self::toSql($value)); |