devtools/SqlStatement.php at master · seagoj/devtools · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
<?php namespace Devtools;

class SqlStatement
{
    public $verb    = 'SELECT';
    public $columns = '*';
    public $values  = array();
    public $table   = '';
    public $join    = array();
    public $where   = array();
    public $order   = array();
    public $limit   = '';

    public function build()
    {
        $join = implode('', $this->join);

        $where = !empty($this->where)
            ? implode('', $this->where)
            : '';

        $order = !empty($this->order)
            ? implode(',', $this->order)
            : '';

        $limit = !empty($this->limit)
            ? $this->limit
            : '';

        switch ($this->verb) {
        case 'SELECT':
            return trim(
                Format::stripWhitespace(
                    "SELECT * FROM {$this->table} {$join} {$where} {$order} {$limit}"
                )
            );
        }
    }
}