@@ 71-97 (lines=27) @@ | ||
68 | * |
|
69 | * @return bool |
|
70 | */ |
|
71 | public function insert(array $values) |
|
72 | { |
|
73 | if (empty($values)) { |
|
74 | return true; |
|
75 | } |
|
76 | ||
77 | if (!is_array(reset($values))) { |
|
78 | $values = [$values]; |
|
79 | } else { |
|
80 | foreach ($values as $key => $value) { |
|
81 | ksort($value); |
|
82 | $values[$key] = $value; |
|
83 | } |
|
84 | } |
|
85 | ||
86 | $bindings = []; |
|
87 | ||
88 | foreach ($values as $record) { |
|
89 | foreach ($record as $key => $value) { |
|
90 | $bindings[$key] = $value; |
|
91 | } |
|
92 | } |
|
93 | ||
94 | $sql = $this->grammar->compileInsert($this, $values); |
|
95 | ||
96 | return $this->connection->insert($sql, $bindings); |
|
97 | } |
|
98 | ||
99 | /** |
|
100 | * supported N1QL upsert query. |
|
@@ 106-132 (lines=27) @@ | ||
103 | * |
|
104 | * @return bool|mixed |
|
105 | */ |
|
106 | public function upsert(array $values) |
|
107 | { |
|
108 | if (empty($values)) { |
|
109 | return true; |
|
110 | } |
|
111 | ||
112 | if (!is_array(reset($values))) { |
|
113 | $values = [$values]; |
|
114 | } else { |
|
115 | foreach ($values as $key => $value) { |
|
116 | ksort($value); |
|
117 | $values[$key] = $value; |
|
118 | } |
|
119 | } |
|
120 | ||
121 | $bindings = []; |
|
122 | ||
123 | foreach ($values as $record) { |
|
124 | foreach ($record as $key => $value) { |
|
125 | $bindings[$key] = $value; |
|
126 | } |
|
127 | } |
|
128 | ||
129 | $sql = $this->grammar->compileUpsert($this, $values); |
|
130 | ||
131 | return $this->connection->upsert($sql, $bindings); |
|
132 | } |
|
133 | } |
|
134 |