oops/static-object-query.php at master · amsify42/oops · 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
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
<?php
/*
static-object-query.php
*/

class QueryBuilder {

	static 		$comparisons = array('=', '>', '<');

	private 	$query;

	function __construct() {
		if(!isset($this->table)) {
			$this->table = strtolower(get_called_class());
		}
	}

	public function select($columnString) {
		$selectClause = 'SELECT '.$columnString;
		return QueryBuilder::findContext($selectClause, get_called_class());
	}

	public function find($value = NULL) {

		$calledClass 		= get_called_class();
		$calledClassObject 	= new $calledClass;

		$table 				= strtolower($calledClass);

		if(isset($calledClassObject->table)) {
				$table		= $calledClassObject->table;
		}

		$whereClause = 'SELECT * FROM '.$table.' WHERE id = '.QueryBuilder::createValue($value);

		return QueryBuilder::findContext($whereClause, get_called_class());
	}


	public function where($column, $operator = '=', $value = NULL) {

		$whereClause		= '';

		if(isset($this) && strpos($this->query, 'WHERE') !== false) {
			$whereClause 	= ' AND';
		}

		if(in_array($operator, QueryBuilder::$comparisons)) {
			$whereClause .= ' WHERE '.$column.' '.$operator.' '.QueryBuilder::createValue($value);
		} else {
			$whereClause .= ' WHERE '.$column.' = '.QueryBuilder::createValue($operator);
		}

		return QueryBuilder::findContext($whereClause, get_called_class());
	}


	public function orWhere($column, $operator = '=', $value = NULL) {

		if(in_array($operator, QueryBuilder::$comparisons)) {
			$whereClause = ' OR WHERE '.$column.' '.$operator.' '.QueryBuilder::createValue($value);
		} else {
			$whereClause = ' OR WHERE '.$column.' = '.QueryBuilder::createValue($operator);
		}

		return QueryBuilder::findContext($whereClause, get_called_class());
	}


	public function findContext($clauseToUpdate = '', $calledClass) {

		if(isset($this) && is_a($this, $calledClass)) {
			$this->query .= $clauseToUpdate;
	        return $this;
	    } else {
	        $queryBuilderObject 		= new $calledClass;
	        $queryBuilderObject->query 	= $clauseToUpdate.' FROM '.$queryBuilderObject->table;
	        return $queryBuilderObject;
	    }

	}

	public static function createValue($value) {

		if(is_int($value) || is_float($value)) {
			return $value;
		} else {
			return '"'.$value.'"';
		}

	}

	function __destruct() {

		if(isset($this->query)) {
			var_dump($this->query);
		}

	}

}


class DatabaseTable extends QueryBuilder {


}


class User extends DatabaseTable {

	protected $table = 'users';

}


User::select('id, name')->where('id', 1)->where('name', 'fasi')->orWhere('name', 'sami');
//User::find(1);