1 |
85ad3d82
|
Assos Assos
|
<?php
|
2 |
|
|
|
3 |
|
|
/**
|
4 |
|
|
* @addtogroup database
|
5 |
|
|
* @{
|
6 |
|
|
*/
|
7 |
|
|
|
8 |
|
|
/**
|
9 |
|
|
* @file
|
10 |
|
|
* Query code for MySQL embedded database engine.
|
11 |
|
|
*/
|
12 |
|
|
|
13 |
|
|
|
14 |
|
|
class InsertQuery_mysql extends InsertQuery {
|
15 |
|
|
|
16 |
|
|
public function execute() {
|
17 |
|
|
if (!$this->preExecute()) {
|
18 |
|
|
return NULL;
|
19 |
|
|
}
|
20 |
|
|
|
21 |
|
|
// If we're selecting from a SelectQuery, finish building the query and
|
22 |
|
|
// pass it back, as any remaining options are irrelevant.
|
23 |
|
|
if (empty($this->fromQuery)) {
|
24 |
|
|
$max_placeholder = 0;
|
25 |
|
|
$values = array();
|
26 |
|
|
foreach ($this->insertValues as $insert_values) {
|
27 |
|
|
foreach ($insert_values as $value) {
|
28 |
|
|
$values[':db_insert_placeholder_' . $max_placeholder++] = $value;
|
29 |
|
|
}
|
30 |
|
|
}
|
31 |
|
|
}
|
32 |
|
|
else {
|
33 |
|
|
$values = $this->fromQuery->getArguments();
|
34 |
|
|
}
|
35 |
|
|
|
36 |
|
|
$last_insert_id = $this->connection->query((string) $this, $values, $this->queryOptions);
|
37 |
|
|
|
38 |
|
|
// Re-initialize the values array so that we can re-use this query.
|
39 |
|
|
$this->insertValues = array();
|
40 |
|
|
|
41 |
|
|
return $last_insert_id;
|
42 |
|
|
}
|
43 |
|
|
|
44 |
|
|
public function __toString() {
|
45 |
|
|
// Create a sanitized comment string to prepend to the query.
|
46 |
|
|
$comments = $this->connection->makeComment($this->comments);
|
47 |
|
|
|
48 |
|
|
// Default fields are always placed first for consistency.
|
49 |
|
|
$insert_fields = array_merge($this->defaultFields, $this->insertFields);
|
50 |
|
|
|
51 |
|
|
// If we're selecting from a SelectQuery, finish building the query and
|
52 |
|
|
// pass it back, as any remaining options are irrelevant.
|
53 |
|
|
if (!empty($this->fromQuery)) {
|
54 |
|
|
$insert_fields_string = $insert_fields ? ' (' . implode(', ', $insert_fields) . ') ' : ' ';
|
55 |
|
|
return $comments . 'INSERT INTO {' . $this->table . '}' . $insert_fields_string . $this->fromQuery;
|
56 |
|
|
}
|
57 |
|
|
|
58 |
|
|
$query = $comments . 'INSERT INTO {' . $this->table . '} (' . implode(', ', $insert_fields) . ') VALUES ';
|
59 |
|
|
|
60 |
|
|
$max_placeholder = 0;
|
61 |
|
|
$values = array();
|
62 |
|
|
if (count($this->insertValues)) {
|
63 |
|
|
foreach ($this->insertValues as $insert_values) {
|
64 |
|
|
$placeholders = array();
|
65 |
|
|
|
66 |
|
|
// Default fields aren't really placeholders, but this is the most convenient
|
67 |
|
|
// way to handle them.
|
68 |
|
|
$placeholders = array_pad($placeholders, count($this->defaultFields), 'default');
|
69 |
|
|
|
70 |
|
|
$new_placeholder = $max_placeholder + count($insert_values);
|
71 |
|
|
for ($i = $max_placeholder; $i < $new_placeholder; ++$i) {
|
72 |
|
|
$placeholders[] = ':db_insert_placeholder_' . $i;
|
73 |
|
|
}
|
74 |
|
|
$max_placeholder = $new_placeholder;
|
75 |
|
|
$values[] = '(' . implode(', ', $placeholders) . ')';
|
76 |
|
|
}
|
77 |
|
|
}
|
78 |
|
|
else {
|
79 |
|
|
// If there are no values, then this is a default-only query. We still need to handle that.
|
80 |
|
|
$placeholders = array_fill(0, count($this->defaultFields), 'default');
|
81 |
|
|
$values[] = '(' . implode(', ', $placeholders) . ')';
|
82 |
|
|
}
|
83 |
|
|
|
84 |
|
|
$query .= implode(', ', $values);
|
85 |
|
|
|
86 |
|
|
return $query;
|
87 |
|
|
}
|
88 |
|
|
}
|
89 |
|
|
|
90 |
|
|
class TruncateQuery_mysql extends TruncateQuery { }
|
91 |
|
|
|
92 |
|
|
/**
|
93 |
|
|
* @} End of "addtogroup database".
|
94 |
|
|
*/ |