1: <?php
2:
3: namespace PHPixie\Database\Driver\PDO\Adapter\Sqlite;
4:
5: class Parser extends \PHPixie\Database\Type\SQL\Parser
6: {
7: protected $supportedJoins = array(
8: 'inner' => 'INNER',
9: 'cross' => 'CROSS',
10: 'left' => 'LEFT',
11: 'left_outer' => 'LEFT OUTER',
12: 'natural' => 'NATURAL',
13: 'natural_inner' => 'NATURAL INNER',
14: 'natural_left' => 'NATURAL LEFT',
15: 'natural_left_outer' => 'NATURAL LEFT OUTER'
16: );
17:
18: protected function deleteQuery($query, $expr)
19: {
20: $joins = $query->getJoins();
21: if (!empty($joins))
22: throw new \PHPixie\Database\Exception\Parser("Sqlite doesn't support joins inside DELETE queries");
23:
24: return parent::deleteQuery($query, $expr);
25: }
26:
27: protected function appendLimitOffsetValues($expr, $limit, $offset)
28: {
29: if($offset !== NULL && $limit === NULL) {
30: $limit = -1;
31: }
32:
33: parent::appendLimitOffsetValues($expr, $limit, $offset);
34: }
35: }
36: