thecodingmachine /
magic-query
@@ -68,8 +68,8 @@ discard block |
||
| 68 | 68 | */ |
| 69 | 69 | public function setName($name) |
| 70 | 70 | { |
| 71 | - if (strrpos($name, '!') === strlen($name)-1) { |
|
| 72 | - $this->name = substr($name, 0, strlen($name)-1); |
|
| 71 | + if (strrpos($name, '!') === strlen($name) - 1) { |
|
| 72 | + $this->name = substr($name, 0, strlen($name) - 1); |
|
| 73 | 73 | $this->discardedOnNull = false; |
| 74 | 74 | } else { |
| 75 | 75 | $this->name = $name; |
@@ -164,22 +164,22 @@ discard block |
||
| 164 | 164 | { |
| 165 | 165 | if (isset($parameters[$this->name])) { |
| 166 | 166 | if ($dbConnection) { |
| 167 | - if(is_array($parameters[$this->name])){ |
|
| 168 | - return '('.implode(',',array_map(function($item) use ($dbConnection) { |
|
| 167 | + if (is_array($parameters[$this->name])) { |
|
| 168 | + return '('.implode(',', array_map(function($item) use ($dbConnection) { |
|
| 169 | 169 | return $dbConnection->quote($this->autoPrepend.$item.$this->autoAppend); |
| 170 | 170 | }, $parameters[$this->name])).')'; |
| 171 | - } else{ |
|
| 171 | + } else { |
|
| 172 | 172 | return $dbConnection->quote($this->autoPrepend.$parameters[$this->name].$this->autoAppend); |
| 173 | 173 | } |
| 174 | 174 | } else { |
| 175 | 175 | if ($parameters[$this->name] === null) { |
| 176 | 176 | return "null"; |
| 177 | 177 | } else { |
| 178 | - if(is_array($parameters[$this->name])){ |
|
| 179 | - return '('.implode(',',array_map(function($item) { |
|
| 178 | + if (is_array($parameters[$this->name])) { |
|
| 179 | + return '('.implode(',', array_map(function($item) { |
|
| 180 | 180 | return "'".addslashes($this->autoPrepend.$item.$this->autoAppend)."'"; |
| 181 | 181 | }, $parameters[$this->name])).')'; |
| 182 | - } else{ |
|
| 182 | + } else { |
|
| 183 | 183 | return "'".addslashes($this->autoPrepend.$parameters[$this->name].$this->autoAppend)."'"; |
| 184 | 184 | } |
| 185 | 185 | |
@@ -211,6 +211,6 @@ |
||
| 211 | 211 | * @return bool |
| 212 | 212 | */ |
| 213 | 213 | public function isDiscardedOnNull() { |
| 214 | - return $this->discardedOnNull; |
|
| 214 | + return $this->discardedOnNull; |
|
| 215 | 215 | } |
| 216 | 216 | } |
@@ -46,25 +46,25 @@ |
||
| 46 | 46 | $k = key($parsed); |
| 47 | 47 | switch ($k) { |
| 48 | 48 | |
| 49 | - case 'UNION': |
|
| 50 | - case 'UNION ALL': |
|
| 51 | - throw new UnsupportedFeatureException($k); |
|
| 52 | - break; |
|
| 53 | - case 'SELECT': |
|
| 54 | - $this->created = $this->processSelectStatement($parsed); |
|
| 55 | - break; |
|
| 56 | - case 'INSERT': |
|
| 57 | - $this->created = $this->processInsertStatement($parsed); |
|
| 58 | - break; |
|
| 59 | - case 'DELETE': |
|
| 60 | - $this->created = $this->processDeleteStatement($parsed); |
|
| 61 | - break; |
|
| 62 | - case 'UPDATE': |
|
| 63 | - $this->created = $this->processUpdateStatement($parsed); |
|
| 64 | - break; |
|
| 65 | - default: |
|
| 66 | - throw new UnsupportedFeatureException($k); |
|
| 67 | - break; |
|
| 49 | + case 'UNION': |
|
| 50 | + case 'UNION ALL': |
|
| 51 | + throw new UnsupportedFeatureException($k); |
|
| 52 | + break; |
|
| 53 | + case 'SELECT': |
|
| 54 | + $this->created = $this->processSelectStatement($parsed); |
|
| 55 | + break; |
|
| 56 | + case 'INSERT': |
|
| 57 | + $this->created = $this->processInsertStatement($parsed); |
|
| 58 | + break; |
|
| 59 | + case 'DELETE': |
|
| 60 | + $this->created = $this->processDeleteStatement($parsed); |
|
| 61 | + break; |
|
| 62 | + case 'UPDATE': |
|
| 63 | + $this->created = $this->processUpdateStatement($parsed); |
|
| 64 | + break; |
|
| 65 | + default: |
|
| 66 | + throw new UnsupportedFeatureException($k); |
|
| 67 | + break; |
|
| 68 | 68 | } |
| 69 | 69 | |
| 70 | 70 | return $this->created; |
@@ -36,102 +36,102 @@ discard block |
||
| 36 | 36 | class PHPSQLParserConstants |
| 37 | 37 | { |
| 38 | 38 | protected static $reserved = array('ABS', 'ACOS', 'ADDDATE', 'ADDTIME', 'AES_ENCRYPT', 'AES_DECRYPT', 'AGAINST', |
| 39 | - 'ASCII', 'ASIN', 'ATAN', 'AVG', 'BENCHMARK', 'BIN', 'BIT_AND', 'BIT_OR', |
|
| 40 | - 'BITCOUNT', 'BITLENGTH', 'CAST', 'CEILING', 'CHAR', 'CHAR_LENGTH', |
|
| 41 | - 'CHARACTER_LENGTH', 'CHARSET', 'COALESCE', 'COERCIBILITY', 'COLLATION', |
|
| 42 | - 'COMPRESS', 'CONCAT', 'CONCAT_WS', 'CONNECTION_ID', 'CONV', 'CONVERT', |
|
| 43 | - 'CONVERT_TZ', 'COS', 'COT', 'COUNT', 'CRC32', 'CURDATE', 'CURRENT_USER', |
|
| 44 | - 'CURRVAL', 'CURTIME', 'DATABASE', 'DATETIME', 'DATE_ADD', 'DATE_DIFF', |
|
| 45 | - 'DATE_FORMAT', 'DATE_SUB', 'DAY', 'DAYNAME', 'DAYOFMONTH', 'DAYOFWEEK', |
|
| 46 | - 'DAYOFYEAR', 'DECODE', 'DEFAULT', 'DEGREES', 'DES_DECRYPT', 'DES_ENCRYPT', |
|
| 47 | - 'ELT', 'ENCODE', 'ENCRYPT', 'EXP', 'EXPORT_SET', 'EXTRACT', 'FIELD', |
|
| 48 | - 'FIND_IN_SET', 'FLOOR', 'FORMAT', 'FOUND_ROWS', 'FROM_DAYS', 'FROM_UNIXTIME', |
|
| 49 | - 'GET_FORMAT', 'GET_LOCK', 'GROUP_CONCAT', 'GREATEST', 'HEX', 'HOUR', 'IF', |
|
| 50 | - 'IFNULL', 'IN', 'INET_ATON', 'INET_NTOA', 'INSERT', 'INSTR', 'INTERVAL', |
|
| 51 | - 'IS_FREE_LOCK', 'IS_USED_LOCK', 'LAST_DAY', 'LAST_INSERT_ID', 'LCASE', 'LEAST', |
|
| 52 | - 'LEFT', 'LENGTH', 'LN', 'LOAD_FILE', 'LOCALTIME', 'LOCALTIMESTAMP', 'LOCATE', |
|
| 53 | - 'LOG', 'LOG2', 'LOG10', 'LOWER', 'LPAD', 'LTRIM', 'MAKE_SET', 'MAKEDATE', |
|
| 54 | - 'MAKETIME', 'MASTER_POS_WAIT', 'MATCH', 'MAX', 'MD5', 'MICROSECOND', 'MID', |
|
| 55 | - 'MIN', 'MINUTE', 'MOD', 'MONTH', 'MONTHNAME', 'NEXTVAL', 'NOW', 'NULLIF', 'OCT', |
|
| 56 | - 'OCTET_LENGTH', 'OLD_PASSWORD', 'ORD', 'PASSWORD', 'PERIOD_ADD', 'PERIOD_DIFF', |
|
| 57 | - 'PI', 'POSITION', 'POW', 'POWER', 'QUARTER', 'QUOTE', 'RADIANS', 'RAND', |
|
| 58 | - 'RELEASE_LOCK', 'REPEAT', 'REPLACE', 'REVERSE', 'RIGHT', 'ROUND', 'ROW_COUNT', |
|
| 59 | - 'RPAD', 'RTRIM', 'SEC_TO_TIME', 'SECOND', 'SESSION_USER', 'SHA', 'SHA1', 'SIGN', |
|
| 60 | - 'SOUNDEX', 'SPACE', 'SQRT', 'STD', 'STDDEV', 'STDDEV_POP', 'STDDEV_SAMP', |
|
| 61 | - 'STRCMP', 'STR_TO_DATE', 'SUBDATE', 'SUBSTRING', 'SUBSTRING_INDEX', 'SUBTIME', |
|
| 62 | - 'SUM', 'SYSDATE', 'SYSTEM_USER', 'TAN', 'TIME', 'TIMEDIFF', 'TIMESTAMP', |
|
| 63 | - 'TIMESTAMPADD', 'TIMESTAMPDIFF', 'TIME_FORMAT', 'TIME_TO_SEC', 'TO_DAYS', |
|
| 64 | - 'TRIM', 'TRUNCATE', 'UCASE', 'UNCOMPRESS', 'UNCOMPRESSED_LENGTH', 'UNHEX', |
|
| 65 | - 'UNIX_TIMESTAMP', 'UPPER', 'USER', 'UTC_DATE', 'UTC_TIME', 'UTC_TIMESTAMP', |
|
| 66 | - 'UUID', 'VAR_POP', 'VAR_SAMP', 'VARIANCE', 'VERSION', 'WEEK', 'WEEKDAY', |
|
| 67 | - 'WEEKOFYEAR', 'YEAR', 'YEARWEEK', 'ADD', 'ALL', 'ALTER', 'ANALYZE', 'AND', 'AS', |
|
| 68 | - 'ASC', 'ASENSITIVE', 'AUTO_INCREMENT', 'BDB', 'BEFORE', 'BERKELEYDB', 'BETWEEN', |
|
| 69 | - 'BIGINT', 'BINARY', 'BLOB', 'BOTH', 'BY', 'CALL', 'CASCADE', 'CASE', 'CHANGE', |
|
| 70 | - 'CHAR', 'CHARACTER', 'CHECK', 'COLLATE', 'COLUMN', 'COLUMNS', 'CONDITION', |
|
| 71 | - 'CONNECTION', 'CONSTRAINT', 'CONTINUE', 'CREATE', 'CROSS', 'CURRENT_DATE', |
|
| 72 | - 'CURRENT_TIME', 'CURRENT_TIMESTAMP', 'CURSOR', 'DATABASE', 'DATABASES', |
|
| 73 | - 'DAY_HOUR', 'DAY_MICROSECOND', 'DAY_MINUTE', 'DAY_SECOND', 'DEC', 'DECIMAL', |
|
| 74 | - 'DECLARE', 'DEFAULT', 'DELAYED', 'DELETE', 'DESC', 'DESCRIBE', 'DETERMINISTIC', |
|
| 75 | - 'DISTINCT', 'DISTINCTROW', 'DIV', 'DOUBLE', 'DROP', 'ELSE', 'ELSEIF', 'END', |
|
| 76 | - 'ENCLOSED', 'ESCAPED', 'EXISTS', 'EXIT', 'EXPLAIN', 'FALSE', 'FETCH', 'FIELDS', |
|
| 77 | - 'FLOAT', 'FOR', 'FORCE', 'FOREIGN', 'FOUND', 'FRAC_SECOND', 'FROM', 'FULLTEXT', |
|
| 78 | - 'GRANT', 'GROUP', 'HAVING', 'HIGH_PRIORITY', 'HOUR_MICROSECOND', 'HOUR_MINUTE', |
|
| 79 | - 'HOUR_SECOND', 'IF', 'IGNORE', 'IN', 'INDEX', 'INFILE', 'INNER', 'INNODB', |
|
| 80 | - 'INOUT', 'INSENSITIVE', 'INSERT', 'INT', 'INTEGER', 'INTERVAL', 'INTO', |
|
| 81 | - 'IO_THREAD', 'IS', 'ITERATE', 'JOIN', 'KEY', 'KEYS', 'KILL', 'LEADING', 'LEAVE', |
|
| 82 | - 'LEFT', 'LIKE', 'LIMIT', 'LINES', 'LOAD', 'LOCALTIME', 'LOCALTIMESTAMP', 'LOCK', |
|
| 83 | - 'LONG', 'LONGBLOB', 'LONGTEXT', 'LOOP', 'LOW_PRIORITY', 'MASTER_SERVER_ID', |
|
| 84 | - 'MATCH', 'MEDIUMBLOB', 'MEDIUMINT', 'MEDIUMTEXT', 'MIDDLEINT', |
|
| 85 | - 'MINUTE_MICROSECOND', 'MINUTE_SECOND', 'MOD', 'NATURAL', 'NOT', |
|
| 86 | - 'NO_WRITE_TO_BINLOG', 'NULL', 'NUMERIC', 'ON', 'OPTIMIZE', 'OPTION', |
|
| 87 | - 'OPTIONALLY', 'OR', 'ORDER', 'OUT', 'OUTER', 'OUTFILE', 'PRECISION', 'PRIMARY', |
|
| 88 | - 'PRIVILEGES', 'PROCEDURE', 'PURGE', 'READ', 'REAL', 'REFERENCES', 'REGEXP', |
|
| 89 | - 'RENAME', 'REPEAT', 'REPLACE', 'REQUIRE', 'RESTRICT', 'RETURN', 'REVOKE', |
|
| 90 | - 'RIGHT', 'RLIKE', 'SECOND_MICROSECOND', 'SELECT', 'SENSITIVE', 'SEPARATOR', |
|
| 91 | - 'SET', 'SHOW', 'SMALLINT', 'SOME', 'SONAME', 'SPATIAL', 'SPECIFIC', 'SQL', |
|
| 92 | - 'SQLEXCEPTION', 'SQLSTATE', 'SQLWARNING', 'SQL_BIG_RESULT', |
|
| 93 | - 'SQL_CALC_FOUND_ROWS', 'SQL_SMALL_RESULT', 'SQL_TSI_DAY', 'SQL_TSI_FRAC_SECOND', |
|
| 94 | - 'SQL_TSI_HOUR', 'SQL_TSI_MINUTE', 'SQL_TSI_MONTH', 'SQL_TSI_QUARTER', |
|
| 95 | - 'SQL_TSI_SECOND', 'SQL_TSI_WEEK', 'SQL_TSI_YEAR', 'SSL', 'STARTING', |
|
| 96 | - 'STRAIGHT_JOIN', 'STRIPED', 'TABLE', 'TABLES', 'TERMINATED', 'THEN', |
|
| 97 | - 'TIMESTAMPADD', 'TIMESTAMPDIFF', 'TINYBLOB', 'TINYINT', 'TINYTEXT', 'TO', |
|
| 98 | - 'TRAILING', 'TRUE', 'UNDO', 'UNION', 'UNIQUE', 'UNLOCK', 'UNSIGNED', 'UPDATE', |
|
| 99 | - 'USAGE', 'USE', 'USER_RESOURCES', 'USING', 'UTC_DATE', 'UTC_TIME', |
|
| 100 | - 'UTC_TIMESTAMP', 'VALUES', 'VARBINARY', 'VARCHAR', 'VARCHARACTER', 'VARYING', |
|
| 101 | - 'WHEN', 'WHERE', 'WHILE', 'WITH', 'WRITE', 'XOR', 'YEAR_MONTH', 'ZEROFILL', ); |
|
| 39 | + 'ASCII', 'ASIN', 'ATAN', 'AVG', 'BENCHMARK', 'BIN', 'BIT_AND', 'BIT_OR', |
|
| 40 | + 'BITCOUNT', 'BITLENGTH', 'CAST', 'CEILING', 'CHAR', 'CHAR_LENGTH', |
|
| 41 | + 'CHARACTER_LENGTH', 'CHARSET', 'COALESCE', 'COERCIBILITY', 'COLLATION', |
|
| 42 | + 'COMPRESS', 'CONCAT', 'CONCAT_WS', 'CONNECTION_ID', 'CONV', 'CONVERT', |
|
| 43 | + 'CONVERT_TZ', 'COS', 'COT', 'COUNT', 'CRC32', 'CURDATE', 'CURRENT_USER', |
|
| 44 | + 'CURRVAL', 'CURTIME', 'DATABASE', 'DATETIME', 'DATE_ADD', 'DATE_DIFF', |
|
| 45 | + 'DATE_FORMAT', 'DATE_SUB', 'DAY', 'DAYNAME', 'DAYOFMONTH', 'DAYOFWEEK', |
|
| 46 | + 'DAYOFYEAR', 'DECODE', 'DEFAULT', 'DEGREES', 'DES_DECRYPT', 'DES_ENCRYPT', |
|
| 47 | + 'ELT', 'ENCODE', 'ENCRYPT', 'EXP', 'EXPORT_SET', 'EXTRACT', 'FIELD', |
|
| 48 | + 'FIND_IN_SET', 'FLOOR', 'FORMAT', 'FOUND_ROWS', 'FROM_DAYS', 'FROM_UNIXTIME', |
|
| 49 | + 'GET_FORMAT', 'GET_LOCK', 'GROUP_CONCAT', 'GREATEST', 'HEX', 'HOUR', 'IF', |
|
| 50 | + 'IFNULL', 'IN', 'INET_ATON', 'INET_NTOA', 'INSERT', 'INSTR', 'INTERVAL', |
|
| 51 | + 'IS_FREE_LOCK', 'IS_USED_LOCK', 'LAST_DAY', 'LAST_INSERT_ID', 'LCASE', 'LEAST', |
|
| 52 | + 'LEFT', 'LENGTH', 'LN', 'LOAD_FILE', 'LOCALTIME', 'LOCALTIMESTAMP', 'LOCATE', |
|
| 53 | + 'LOG', 'LOG2', 'LOG10', 'LOWER', 'LPAD', 'LTRIM', 'MAKE_SET', 'MAKEDATE', |
|
| 54 | + 'MAKETIME', 'MASTER_POS_WAIT', 'MATCH', 'MAX', 'MD5', 'MICROSECOND', 'MID', |
|
| 55 | + 'MIN', 'MINUTE', 'MOD', 'MONTH', 'MONTHNAME', 'NEXTVAL', 'NOW', 'NULLIF', 'OCT', |
|
| 56 | + 'OCTET_LENGTH', 'OLD_PASSWORD', 'ORD', 'PASSWORD', 'PERIOD_ADD', 'PERIOD_DIFF', |
|
| 57 | + 'PI', 'POSITION', 'POW', 'POWER', 'QUARTER', 'QUOTE', 'RADIANS', 'RAND', |
|
| 58 | + 'RELEASE_LOCK', 'REPEAT', 'REPLACE', 'REVERSE', 'RIGHT', 'ROUND', 'ROW_COUNT', |
|
| 59 | + 'RPAD', 'RTRIM', 'SEC_TO_TIME', 'SECOND', 'SESSION_USER', 'SHA', 'SHA1', 'SIGN', |
|
| 60 | + 'SOUNDEX', 'SPACE', 'SQRT', 'STD', 'STDDEV', 'STDDEV_POP', 'STDDEV_SAMP', |
|
| 61 | + 'STRCMP', 'STR_TO_DATE', 'SUBDATE', 'SUBSTRING', 'SUBSTRING_INDEX', 'SUBTIME', |
|
| 62 | + 'SUM', 'SYSDATE', 'SYSTEM_USER', 'TAN', 'TIME', 'TIMEDIFF', 'TIMESTAMP', |
|
| 63 | + 'TIMESTAMPADD', 'TIMESTAMPDIFF', 'TIME_FORMAT', 'TIME_TO_SEC', 'TO_DAYS', |
|
| 64 | + 'TRIM', 'TRUNCATE', 'UCASE', 'UNCOMPRESS', 'UNCOMPRESSED_LENGTH', 'UNHEX', |
|
| 65 | + 'UNIX_TIMESTAMP', 'UPPER', 'USER', 'UTC_DATE', 'UTC_TIME', 'UTC_TIMESTAMP', |
|
| 66 | + 'UUID', 'VAR_POP', 'VAR_SAMP', 'VARIANCE', 'VERSION', 'WEEK', 'WEEKDAY', |
|
| 67 | + 'WEEKOFYEAR', 'YEAR', 'YEARWEEK', 'ADD', 'ALL', 'ALTER', 'ANALYZE', 'AND', 'AS', |
|
| 68 | + 'ASC', 'ASENSITIVE', 'AUTO_INCREMENT', 'BDB', 'BEFORE', 'BERKELEYDB', 'BETWEEN', |
|
| 69 | + 'BIGINT', 'BINARY', 'BLOB', 'BOTH', 'BY', 'CALL', 'CASCADE', 'CASE', 'CHANGE', |
|
| 70 | + 'CHAR', 'CHARACTER', 'CHECK', 'COLLATE', 'COLUMN', 'COLUMNS', 'CONDITION', |
|
| 71 | + 'CONNECTION', 'CONSTRAINT', 'CONTINUE', 'CREATE', 'CROSS', 'CURRENT_DATE', |
|
| 72 | + 'CURRENT_TIME', 'CURRENT_TIMESTAMP', 'CURSOR', 'DATABASE', 'DATABASES', |
|
| 73 | + 'DAY_HOUR', 'DAY_MICROSECOND', 'DAY_MINUTE', 'DAY_SECOND', 'DEC', 'DECIMAL', |
|
| 74 | + 'DECLARE', 'DEFAULT', 'DELAYED', 'DELETE', 'DESC', 'DESCRIBE', 'DETERMINISTIC', |
|
| 75 | + 'DISTINCT', 'DISTINCTROW', 'DIV', 'DOUBLE', 'DROP', 'ELSE', 'ELSEIF', 'END', |
|
| 76 | + 'ENCLOSED', 'ESCAPED', 'EXISTS', 'EXIT', 'EXPLAIN', 'FALSE', 'FETCH', 'FIELDS', |
|
| 77 | + 'FLOAT', 'FOR', 'FORCE', 'FOREIGN', 'FOUND', 'FRAC_SECOND', 'FROM', 'FULLTEXT', |
|
| 78 | + 'GRANT', 'GROUP', 'HAVING', 'HIGH_PRIORITY', 'HOUR_MICROSECOND', 'HOUR_MINUTE', |
|
| 79 | + 'HOUR_SECOND', 'IF', 'IGNORE', 'IN', 'INDEX', 'INFILE', 'INNER', 'INNODB', |
|
| 80 | + 'INOUT', 'INSENSITIVE', 'INSERT', 'INT', 'INTEGER', 'INTERVAL', 'INTO', |
|
| 81 | + 'IO_THREAD', 'IS', 'ITERATE', 'JOIN', 'KEY', 'KEYS', 'KILL', 'LEADING', 'LEAVE', |
|
| 82 | + 'LEFT', 'LIKE', 'LIMIT', 'LINES', 'LOAD', 'LOCALTIME', 'LOCALTIMESTAMP', 'LOCK', |
|
| 83 | + 'LONG', 'LONGBLOB', 'LONGTEXT', 'LOOP', 'LOW_PRIORITY', 'MASTER_SERVER_ID', |
|
| 84 | + 'MATCH', 'MEDIUMBLOB', 'MEDIUMINT', 'MEDIUMTEXT', 'MIDDLEINT', |
|
| 85 | + 'MINUTE_MICROSECOND', 'MINUTE_SECOND', 'MOD', 'NATURAL', 'NOT', |
|
| 86 | + 'NO_WRITE_TO_BINLOG', 'NULL', 'NUMERIC', 'ON', 'OPTIMIZE', 'OPTION', |
|
| 87 | + 'OPTIONALLY', 'OR', 'ORDER', 'OUT', 'OUTER', 'OUTFILE', 'PRECISION', 'PRIMARY', |
|
| 88 | + 'PRIVILEGES', 'PROCEDURE', 'PURGE', 'READ', 'REAL', 'REFERENCES', 'REGEXP', |
|
| 89 | + 'RENAME', 'REPEAT', 'REPLACE', 'REQUIRE', 'RESTRICT', 'RETURN', 'REVOKE', |
|
| 90 | + 'RIGHT', 'RLIKE', 'SECOND_MICROSECOND', 'SELECT', 'SENSITIVE', 'SEPARATOR', |
|
| 91 | + 'SET', 'SHOW', 'SMALLINT', 'SOME', 'SONAME', 'SPATIAL', 'SPECIFIC', 'SQL', |
|
| 92 | + 'SQLEXCEPTION', 'SQLSTATE', 'SQLWARNING', 'SQL_BIG_RESULT', |
|
| 93 | + 'SQL_CALC_FOUND_ROWS', 'SQL_SMALL_RESULT', 'SQL_TSI_DAY', 'SQL_TSI_FRAC_SECOND', |
|
| 94 | + 'SQL_TSI_HOUR', 'SQL_TSI_MINUTE', 'SQL_TSI_MONTH', 'SQL_TSI_QUARTER', |
|
| 95 | + 'SQL_TSI_SECOND', 'SQL_TSI_WEEK', 'SQL_TSI_YEAR', 'SSL', 'STARTING', |
|
| 96 | + 'STRAIGHT_JOIN', 'STRIPED', 'TABLE', 'TABLES', 'TERMINATED', 'THEN', |
|
| 97 | + 'TIMESTAMPADD', 'TIMESTAMPDIFF', 'TINYBLOB', 'TINYINT', 'TINYTEXT', 'TO', |
|
| 98 | + 'TRAILING', 'TRUE', 'UNDO', 'UNION', 'UNIQUE', 'UNLOCK', 'UNSIGNED', 'UPDATE', |
|
| 99 | + 'USAGE', 'USE', 'USER_RESOURCES', 'USING', 'UTC_DATE', 'UTC_TIME', |
|
| 100 | + 'UTC_TIMESTAMP', 'VALUES', 'VARBINARY', 'VARCHAR', 'VARCHARACTER', 'VARYING', |
|
| 101 | + 'WHEN', 'WHERE', 'WHILE', 'WITH', 'WRITE', 'XOR', 'YEAR_MONTH', 'ZEROFILL', ); |
|
| 102 | 102 | |
| 103 | 103 | protected static $parameterizedFunctions = array('ABS', 'ACOS', 'ADDDATE', 'ADDTIME', 'AES_ENCRYPT', 'AES_DECRYPT', |
| 104 | - 'AGAINST', 'ASCII', 'ASIN', 'ATAN', 'AVG', 'BENCHMARK', 'BIN', |
|
| 105 | - 'BIT_AND', 'BIT_OR', 'BITCOUNT', 'BITLENGTH', 'CAST', 'CEILING', |
|
| 106 | - 'CHAR', 'CHAR_LENGTH', 'CHARACTER_LENGTH', 'CHARSET', 'COALESCE', |
|
| 107 | - 'COERCIBILITY', 'COLLATION', 'COMPRESS', 'CONCAT', 'CONCAT_WS', |
|
| 108 | - 'CONV', 'CONVERT', 'CONVERT_TZ', 'COS', 'COT', 'COUNT', 'CRC32', |
|
| 109 | - 'CURRVAL', 'DATE_ADD', 'DATE_DIFF', 'DATE_FORMAT', 'DATE_SUB', |
|
| 110 | - 'DAY', 'DAYNAME', 'DAYOFMONTH', 'DAYOFWEEK', 'DAYOFYEAR', |
|
| 111 | - 'DECODE', 'DEFAULT', 'DEGREES', 'DES_DECRYPT', 'DES_ENCRYPT', |
|
| 112 | - 'ELT', 'ENCODE', 'ENCRYPT', 'EXP', 'EXPORT_SET', 'EXTRACT', |
|
| 113 | - 'FIELD', 'FIND_IN_SET', 'FLOOR', 'FORMAT', 'FROM_DAYS', |
|
| 114 | - 'FROM_UNIXTIME', 'GET_FORMAT', 'GET_LOCK', 'GROUP_CONCAT', |
|
| 115 | - 'GREATEST', 'HEX', 'HOUR', 'IF', 'IFNULL', 'IN', 'INET_ATON', |
|
| 116 | - 'INET_NTOA', 'INSERT', 'INSTR', 'INTERVAL', 'IS_FREE_LOCK', |
|
| 117 | - 'IS_USED_LOCK', 'LAST_DAY', 'LCASE', 'LEAST', 'LEFT', 'LENGTH', |
|
| 118 | - 'LN', 'LOAD_FILE', 'LOCATE', 'LOG', 'LOG2', 'LOG10', 'LOWER', |
|
| 119 | - 'LPAD', 'LTRIM', 'MAKE_SET', 'MAKEDATE', 'MAKETIME', |
|
| 120 | - 'MASTER_POS_WAIT', 'MATCH', 'MAX', 'MD5', 'MICROSECOND', 'MID', |
|
| 121 | - 'MIN', 'MINUTE', 'MOD', 'MONTH', 'MONTHNAME', 'NEXTVAL', 'NULLIF', |
|
| 122 | - 'OCT', 'OCTET_LENGTH', 'OLD_PASSWORD', 'ORD', 'PASSWORD', |
|
| 123 | - 'PERIOD_ADD', 'PERIOD_DIFF', 'PI', 'POSITION', 'POW', 'POWER', |
|
| 124 | - 'QUARTER', 'QUOTE', 'RADIANS', 'RELEASE_LOCK', 'REPEAT', |
|
| 125 | - 'REPLACE', 'REVERSE', 'RIGHT', 'ROUND', 'RPAD', 'RTRIM', |
|
| 126 | - 'SEC_TO_TIME', 'SECOND', 'SHA', 'SHA1', 'SIGN', 'SOUNDEX', |
|
| 127 | - 'SPACE', 'SQRT', 'STD', 'STDDEV', 'STDDEV_POP', 'STDDEV_SAMP', |
|
| 128 | - 'STRCMP', 'STR_TO_DATE', 'SUBDATE', 'SUBSTRING', |
|
| 129 | - 'SUBSTRING_INDEX', 'SUBTIME', 'SUM', 'TAN', 'TIME', 'TIMEDIFF', |
|
| 130 | - 'TIMESTAMP', 'TIMESTAMPADD', 'TIMESTAMPDIFF', 'TIME_FORMAT', |
|
| 131 | - 'TIME_TO_SEC', 'TO_DAYS', 'TRIM', 'TRUNCATE', 'UCASE', |
|
| 132 | - 'UNCOMPRESS', 'UNCOMPRESSED_LENGTH', 'UNHEX', 'UPPER', 'VAR_POP', |
|
| 133 | - 'VAR_SAMP', 'VARIANCE', 'WEEK', 'WEEKDAY', 'WEEKOFYEAR', 'YEAR', |
|
| 134 | - 'YEARWEEK', ); |
|
| 104 | + 'AGAINST', 'ASCII', 'ASIN', 'ATAN', 'AVG', 'BENCHMARK', 'BIN', |
|
| 105 | + 'BIT_AND', 'BIT_OR', 'BITCOUNT', 'BITLENGTH', 'CAST', 'CEILING', |
|
| 106 | + 'CHAR', 'CHAR_LENGTH', 'CHARACTER_LENGTH', 'CHARSET', 'COALESCE', |
|
| 107 | + 'COERCIBILITY', 'COLLATION', 'COMPRESS', 'CONCAT', 'CONCAT_WS', |
|
| 108 | + 'CONV', 'CONVERT', 'CONVERT_TZ', 'COS', 'COT', 'COUNT', 'CRC32', |
|
| 109 | + 'CURRVAL', 'DATE_ADD', 'DATE_DIFF', 'DATE_FORMAT', 'DATE_SUB', |
|
| 110 | + 'DAY', 'DAYNAME', 'DAYOFMONTH', 'DAYOFWEEK', 'DAYOFYEAR', |
|
| 111 | + 'DECODE', 'DEFAULT', 'DEGREES', 'DES_DECRYPT', 'DES_ENCRYPT', |
|
| 112 | + 'ELT', 'ENCODE', 'ENCRYPT', 'EXP', 'EXPORT_SET', 'EXTRACT', |
|
| 113 | + 'FIELD', 'FIND_IN_SET', 'FLOOR', 'FORMAT', 'FROM_DAYS', |
|
| 114 | + 'FROM_UNIXTIME', 'GET_FORMAT', 'GET_LOCK', 'GROUP_CONCAT', |
|
| 115 | + 'GREATEST', 'HEX', 'HOUR', 'IF', 'IFNULL', 'IN', 'INET_ATON', |
|
| 116 | + 'INET_NTOA', 'INSERT', 'INSTR', 'INTERVAL', 'IS_FREE_LOCK', |
|
| 117 | + 'IS_USED_LOCK', 'LAST_DAY', 'LCASE', 'LEAST', 'LEFT', 'LENGTH', |
|
| 118 | + 'LN', 'LOAD_FILE', 'LOCATE', 'LOG', 'LOG2', 'LOG10', 'LOWER', |
|
| 119 | + 'LPAD', 'LTRIM', 'MAKE_SET', 'MAKEDATE', 'MAKETIME', |
|
| 120 | + 'MASTER_POS_WAIT', 'MATCH', 'MAX', 'MD5', 'MICROSECOND', 'MID', |
|
| 121 | + 'MIN', 'MINUTE', 'MOD', 'MONTH', 'MONTHNAME', 'NEXTVAL', 'NULLIF', |
|
| 122 | + 'OCT', 'OCTET_LENGTH', 'OLD_PASSWORD', 'ORD', 'PASSWORD', |
|
| 123 | + 'PERIOD_ADD', 'PERIOD_DIFF', 'PI', 'POSITION', 'POW', 'POWER', |
|
| 124 | + 'QUARTER', 'QUOTE', 'RADIANS', 'RELEASE_LOCK', 'REPEAT', |
|
| 125 | + 'REPLACE', 'REVERSE', 'RIGHT', 'ROUND', 'RPAD', 'RTRIM', |
|
| 126 | + 'SEC_TO_TIME', 'SECOND', 'SHA', 'SHA1', 'SIGN', 'SOUNDEX', |
|
| 127 | + 'SPACE', 'SQRT', 'STD', 'STDDEV', 'STDDEV_POP', 'STDDEV_SAMP', |
|
| 128 | + 'STRCMP', 'STR_TO_DATE', 'SUBDATE', 'SUBSTRING', |
|
| 129 | + 'SUBSTRING_INDEX', 'SUBTIME', 'SUM', 'TAN', 'TIME', 'TIMEDIFF', |
|
| 130 | + 'TIMESTAMP', 'TIMESTAMPADD', 'TIMESTAMPDIFF', 'TIME_FORMAT', |
|
| 131 | + 'TIME_TO_SEC', 'TO_DAYS', 'TRIM', 'TRUNCATE', 'UCASE', |
|
| 132 | + 'UNCOMPRESS', 'UNCOMPRESSED_LENGTH', 'UNHEX', 'UPPER', 'VAR_POP', |
|
| 133 | + 'VAR_SAMP', 'VARIANCE', 'WEEK', 'WEEKDAY', 'WEEKOFYEAR', 'YEAR', |
|
| 134 | + 'YEARWEEK', ); |
|
| 135 | 135 | |
| 136 | 136 | protected static $functions = array('ABS', 'ACOS', 'ADDDATE', 'ADDTIME', 'AES_ENCRYPT', 'AES_DECRYPT', 'AGAINST', |
| 137 | 137 | 'ASCII', 'ASIN', 'ATAN', 'AVG', 'BENCHMARK', 'BIN', 'BIT_AND', 'BIT_OR', |
@@ -165,6 +165,6 @@ discard block |
||
| 165 | 165 | 'VERSION', 'WEEK', 'WEEKDAY', 'WEEKOFYEAR', 'YEAR', 'YEARWEEK', ); |
| 166 | 166 | |
| 167 | 167 | protected static $aggregateFunctions = array('AVG', 'SUM', 'COUNT', 'MIN', 'MAX', 'STDDEV', 'STDDEV_SAMP', |
| 168 | - 'STDDEV_POP', 'VARIANCE', 'VAR_SAMP', 'VAR_POP', 'GROUP_CONCAT', |
|
| 169 | - 'BIT_AND', 'BIT_OR', 'BIT_XOR', ); |
|
| 168 | + 'STDDEV_POP', 'VARIANCE', 'VAR_SAMP', 'VAR_POP', 'GROUP_CONCAT', |
|
| 169 | + 'BIT_AND', 'BIT_OR', 'BIT_XOR', ); |
|
| 170 | 170 | } |
@@ -98,7 +98,7 @@ discard block |
||
| 98 | 98 | 'TRAILING', 'TRUE', 'UNDO', 'UNION', 'UNIQUE', 'UNLOCK', 'UNSIGNED', 'UPDATE', |
| 99 | 99 | 'USAGE', 'USE', 'USER_RESOURCES', 'USING', 'UTC_DATE', 'UTC_TIME', |
| 100 | 100 | 'UTC_TIMESTAMP', 'VALUES', 'VARBINARY', 'VARCHAR', 'VARCHARACTER', 'VARYING', |
| 101 | - 'WHEN', 'WHERE', 'WHILE', 'WITH', 'WRITE', 'XOR', 'YEAR_MONTH', 'ZEROFILL', ); |
|
| 101 | + 'WHEN', 'WHERE', 'WHILE', 'WITH', 'WRITE', 'XOR', 'YEAR_MONTH', 'ZEROFILL',); |
|
| 102 | 102 | |
| 103 | 103 | protected static $parameterizedFunctions = array('ABS', 'ACOS', 'ADDDATE', 'ADDTIME', 'AES_ENCRYPT', 'AES_DECRYPT', |
| 104 | 104 | 'AGAINST', 'ASCII', 'ASIN', 'ATAN', 'AVG', 'BENCHMARK', 'BIN', |
@@ -131,7 +131,7 @@ discard block |
||
| 131 | 131 | 'TIME_TO_SEC', 'TO_DAYS', 'TRIM', 'TRUNCATE', 'UCASE', |
| 132 | 132 | 'UNCOMPRESS', 'UNCOMPRESSED_LENGTH', 'UNHEX', 'UPPER', 'VAR_POP', |
| 133 | 133 | 'VAR_SAMP', 'VARIANCE', 'WEEK', 'WEEKDAY', 'WEEKOFYEAR', 'YEAR', |
| 134 | - 'YEARWEEK', ); |
|
| 134 | + 'YEARWEEK',); |
|
| 135 | 135 | |
| 136 | 136 | protected static $functions = array('ABS', 'ACOS', 'ADDDATE', 'ADDTIME', 'AES_ENCRYPT', 'AES_DECRYPT', 'AGAINST', |
| 137 | 137 | 'ASCII', 'ASIN', 'ATAN', 'AVG', 'BENCHMARK', 'BIN', 'BIT_AND', 'BIT_OR', |
@@ -162,9 +162,9 @@ discard block |
||
| 162 | 162 | 'TIME_TO_SEC', 'TO_DAYS', 'TRIM', 'TRUNCATE', 'UCASE', 'UNCOMPRESS', |
| 163 | 163 | 'UNCOMPRESSED_LENGTH', 'UNHEX', 'UNIX_TIMESTAMP', 'UPPER', 'USER', 'UTC_DATE', |
| 164 | 164 | 'UTC_TIME', 'UTC_TIMESTAMP', 'UUID', 'VAR_POP', 'VAR_SAMP', 'VARIANCE', |
| 165 | - 'VERSION', 'WEEK', 'WEEKDAY', 'WEEKOFYEAR', 'YEAR', 'YEARWEEK', ); |
|
| 165 | + 'VERSION', 'WEEK', 'WEEKDAY', 'WEEKOFYEAR', 'YEAR', 'YEARWEEK',); |
|
| 166 | 166 | |
| 167 | 167 | protected static $aggregateFunctions = array('AVG', 'SUM', 'COUNT', 'MIN', 'MAX', 'STDDEV', 'STDDEV_SAMP', |
| 168 | 168 | 'STDDEV_POP', 'VARIANCE', 'VAR_SAMP', 'VAR_POP', 'GROUP_CONCAT', |
| 169 | - 'BIT_AND', 'BIT_OR', 'BIT_XOR', ); |
|
| 169 | + 'BIT_AND', 'BIT_OR', 'BIT_XOR',); |
|
| 170 | 170 | } |
@@ -24,7 +24,6 @@ |
||
| 24 | 24 | } |
| 25 | 25 | |
| 26 | 26 | /** |
| 27 | - * @param string $caller |
|
| 28 | 27 | */ |
| 29 | 28 | public function isOk($parameters = null) |
| 30 | 29 | { |
@@ -24,7 +24,6 @@ |
||
| 24 | 24 | } |
| 25 | 25 | |
| 26 | 26 | /** |
| 27 | - * @param string $caller |
|
| 28 | 27 | */ |
| 29 | 28 | public function isOk($parameters = null) |
| 30 | 29 | { |
@@ -277,7 +277,7 @@ |
||
| 277 | 277 | * |
| 278 | 278 | * @param Connection $dbConnection |
| 279 | 279 | * @param array $parameters |
| 280 | - * @param number $indent |
|
| 280 | + * @param integer $indent |
|
| 281 | 281 | * @param int $conditionsMode |
| 282 | 282 | * |
| 283 | 283 | * @return string |
@@ -277,7 +277,7 @@ |
||
| 277 | 277 | * |
| 278 | 278 | * @param Connection $dbConnection |
| 279 | 279 | * @param array $parameters |
| 280 | - * @param number $indent |
|
| 280 | + * @param integer $indent |
|
| 281 | 281 | * @param int $conditionsMode |
| 282 | 282 | * |
| 283 | 283 | * @return string |
@@ -295,7 +295,7 @@ |
||
| 295 | 295 | * |
| 296 | 296 | * @param array $parameters |
| 297 | 297 | * @param Connection $dbConnection |
| 298 | - * @param int|number $indent |
|
| 298 | + * @param integer $indent |
|
| 299 | 299 | * @param int $conditionsMode |
| 300 | 300 | * @return string |
| 301 | 301 | */ |
@@ -388,7 +388,7 @@ discard block |
||
| 388 | 388 | throw new \Exception('There is no offset if no limit is provided. An error may have occurred during SQLParsing.'); |
| 389 | 389 | } |
| 390 | 390 | |
| 391 | - if($limit !== null) { |
|
| 391 | + if ($limit !== null) { |
|
| 392 | 392 | $sql .= "\nLIMIT "; |
| 393 | 393 | if ($offset !== null) { |
| 394 | 394 | $sql .= $offset.', '; |
@@ -426,7 +426,7 @@ discard block |
||
| 426 | 426 | if ($children) { |
| 427 | 427 | if (is_array($children)) { |
| 428 | 428 | foreach ($children as $key => $operand) { |
| 429 | - if($operand) { |
|
| 429 | + if ($operand) { |
|
| 430 | 430 | $result2 = $operand->walk($visitor); |
| 431 | 431 | if ($result2 === NodeTraverser::REMOVE_NODE) { |
| 432 | 432 | unset($children[$key]); |
@@ -96,7 +96,7 @@ |
||
| 96 | 96 | } |
| 97 | 97 | |
| 98 | 98 | if(is_numeric($this->value)) { |
| 99 | - return (int) $this->value; |
|
| 99 | + return (int) $this->value; |
|
| 100 | 100 | } else if ($dbConnection != null) { |
| 101 | 101 | return $dbConnection->quote($this->value); |
| 102 | 102 | } else { |
@@ -91,11 +91,11 @@ |
||
| 91 | 91 | */ |
| 92 | 92 | public function toSql(array $parameters = array(), Connection $dbConnection = null, $indent = 0, $conditionsMode = self::CONDITION_APPLY) |
| 93 | 93 | { |
| 94 | - if($this->value === null) { |
|
| 94 | + if ($this->value === null) { |
|
| 95 | 95 | throw new \Exception('A limit parameter must be an integer'); |
| 96 | 96 | } |
| 97 | 97 | |
| 98 | - if(is_numeric($this->value)) { |
|
| 98 | + if (is_numeric($this->value)) { |
|
| 99 | 99 | return (int) $this->value; |
| 100 | 100 | } else if ($dbConnection != null) { |
| 101 | 101 | return $dbConnection->quote($this->value); |
