List of all SQL mentioned in the code..
| Value | Count | File:Line |
|---|---|---|
| 'SHOW COLUMNS FROM ' . $this->parseKey($tableName) | 1 |
|
| 'select b.rdb$field_name as field_name from rdb$relation_constraints a join rdb$index_segments b on a.rdb$index_name=b.rdb$index_name where a.rdb$constraint_type=\'PRIMARY KEY\' and a.rdb$relation_name=UPPER(\'' . $tableName . '\')' | 1 |
|
| 'INSERT INTO ' . $this->parseTable($table) . ' (' . implode(',', $fields) . ') ' | 1 |
|
| 'UPDATE ' . $table . $this->parseSet($data) | 1 |
|
| 'DELETE FROM ' . $table | 1 |
|
| 'SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER (%ORDER%) AS ROW_NUMBER FROM (SELECT %DISTINCT% %FIELD% FROM %TABLE%%JOIN%%WHERE%%GROUP%%HAVING%) AS thinkphp) AS T1 %LIMIT%%COMMENT%' | 1 |
|
| "SELECT value FROM kvp_" . $this->_TableName . " WHERE id = :id" | 1 |
|
| 'SHOW COLUMNS FROM `' . $dbName . '`.`' . $tableName . '`' | 1 |
|
| 'SHOW COLUMNS FROM `' . $tableName . '`' | 1 |
|
| "SELECT {$sequenceName}.currval currval FROM dual" | 1 |
|
| "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'" | 1 |
|
| 'SELECT table_name FROM user_tables' | 1 |
|
| 'SELECT RF.RDB$FIELD_NAME AS FIELD,RF.RDB$DEFAULT_VALUE AS DEFAULT1,RF.RDB$NULL_FLAG AS NULL1,TRIM(T.RDB$TYPE_NAME) || \'(\' || F.RDB$FIELD_LENGTH || \')\' as TYPE FROM RDB$RELATION_FIELDS RF LEFT JOIN RDB$FIELDS F ON (F.RDB$FIELD_NAME = RF.RDB$FIELD_SOURCE) LEFT JOIN RDB$TYPES T ON (T.RDB$TYPE = F.RDB$FIELD_TYPE) WHERE RDB$RELATION_NAME=UPPER(\'' . $tableName . '\') AND T.RDB$FIELD_NAME = \'RDB$FIELD_TYPE\' ORDER By RDB$FIELD_POSITION' | 1 |
|
| 'select fields_name as "Name",fields_type as "Type",fields_not_null as "Null",fields_key_name as "Key",fields_default as "Default",fields_default as "Extra" from table_msg(' . $tableName . ');' | 1 |
|
| 'SELECT ' . implode(',', $value) | 1 |
|
| 'SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER (%ORDER%) AS ROW_NUMBER FROM (SELECT %DISTINCT% %FIELD% FROM %TABLE%%JOIN%%WHERE%%GROUP%%HAVING% %UNION%) AS thinkphp) AS T1 %LIMIT%%COMMENT%' | 1 |
|
| "SELECT a.column_name \"Name\",data_type \"Type\",decode(nullable,'Y',0,1) notnull,data_default \"Default\",decode(a.column_name,b.column_name,1,0) \"pk\" " . "FROM user_tab_columns a,(SELECT column_name FROM user_constraints c,user_cons_columns col " . "WHERE c.constraint_name=col.constraint_name AND c.constraint_type='P' and c.table_name='" . strtoupper($tableName) . "') b where table_name='" . strtoupper($tableName) . "' and a.column_name=b.column_name(+)" | 1 |
|
| "SELECT column_name as 'Name', data_type as 'Type', column_default as 'Default', is_nullable as 'Null' FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = '$tableName'" | 1 |
|
| 'select b.rdb$field_name as FIELD_NAME from rdb$relation_constraints a join rdb$index_segments b on a.rdb$index_name=b.rdb$index_name where a.rdb$constraint_type=\'PRIMARY KEY\' and a.rdb$relation_name=UPPER(\'' . $tableName . '\')' | 1 |
|
| 'select first 1 * from ' . $tableName | 1 |
|
| 'SELECT * FROM (SELECT thinkphp.*, rownum AS numrow FROM (SELECT %DISTINCT% %FIELD% FROM %TABLE%%JOIN%%WHERE%%GROUP%%HAVING%%ORDER%) thinkphp ) %LIMIT%%COMMENT%' | 1 |
|
| 'SELECT RDB$FIELD_NAME AS FIELD, RDB$DEFAULT_VALUE AS DEFAULT1, RDB$NULL_FLAG AS NULL1 FROM RDB$RELATION_FIELDS WHERE RDB$RELATION_NAME=UPPER(\'' . $tableName . '\') ORDER By RDB$FIELD_POSITION' | 1 |
|
| "select a.column_name,data_type,decode(nullable,'Y',0,1) notnull,data_default,decode(a.column_name,b.column_name,1,0) pk " . "from user_tab_columns a,(select column_name from user_constraints c,user_cons_columns col " . "where c.constraint_name=col.constraint_name and c.constraint_type='P'and c.table_name='" . strtoupper($tableName) . "') b where table_name='" . strtoupper($tableName) . "' and a.column_name=b.column_name(+)" | 1 |
|
| "select table_name from user_tables" | 1 |
|
| 'DELETE FROM ' . $this->sessionTable . ' WHERE session_expire < ' . time( ) | 1 |
|
| 'SELECT * FROM ' . $this->getTableName( ) . '_' . ($i + 1) | 1 |
|
| "SELECT b.{$mappingFields} FROM {$mappingRelationTable} AS a, " . $model->getTableName( ) . " AS b WHERE a.{$mappingRelationFk} = b.{$model->getPk( )} AND a.{$mappingCondition}" | 1 |
|
| 'INSERT INTO ' . $this->parseTable($options['table']) . ' (' . implode(',', $fields) . ') ' . implode(' UNION ALL ', $values) | 1 |
|
| 'DELETE FROM ' . $this->options['table'] | 1 |
|
| 'SELECT session_data AS data FROM ' . $this->sessionTable . " WHERE session_id = '$sessID' AND session_expire >" . time( ) | 1 |
|
| "select access.node_id from " . $table['role'] . " as role," . $table['user'] . " as user," . $table['access'] . " as access " . "where user.user_id='{$authId}' and user.role_id=role.id and ( access.role_id=role.id or (access.role_id=role.pid and role.pid!=0 ) ) and role.status=1 and access.module='{$module}' and access.status=1" | 1 |
|
| "INSERT OR REPLACE INTO kvp_" . $this->_TableName . " VALUES(:id,:data)" | 1 |
|
| "UPDATE kvp_" . $this->_TableName . " SET id=:toId WHERE id=:fromId" | 1 |
|
| "DELETE FROM kvp_" . $this->_TableName . " WHERE id = :id" | 1 |
|
| "INSERT OR REPLACE INTO kvp_" . $this->_TableName . " VALUES('" . $this->_currentObjectID . "','" . sqlite_escape_string(serialize($this->_currentObject)) . "')" | 1 |
|
| "SELECT value FROM kvp_" . $this->_TableName . " WHERE id='" . $pCoord . "'" | 1 |
|
| "SELECT id FROM kvp_" . $this->_TableName . " WHERE id='" . $pCoord . "'" | 1 |
|
| "DELETE FROM kvp_" . $this->_TableName . " WHERE id='" . $pCoord . "'" | 1 |
|
| "DELETE FROM kvp_" . $this->_TableName . " WHERE id='" . $toAddress . "'" | 1 |
|
| "UPDATE kvp_" . $this->_TableName . " SET id='" . $toAddress . "' WHERE id='" . $fromAddress . "'" | 1 |
|
| "select node.id,node.name from " . $table['role'] . " as role," . $table['user'] . " as user," . $table['access'] . " as access ," . $table['node'] . " as node " . "where user.user_id='{$authId}' and user.role_id=role.id and ( access.role_id=role.id or (access.role_id=role.pid and role.pid!=0 ) ) and role.status=1 and access.node_id=node.id and node.level=1 and node.status=1" | 1 |
|
| "select node.id,node.name from " . $table['role'] . " as role," . $table['user'] . " as user," . $table['access'] . " as access ," . $table['node'] . " as node " . "where user.user_id='{$authId}' and user.role_id=role.id and ( access.role_id=role.id or (access.role_id=role.pid and role.pid!=0 ) ) and role.status=1 and access.node_id=node.id and node.level=2 and node.pid={$appId} and node.status=1" | 1 |
|
| "SELECT @@IDENTITY as last_insert_id" | 1 |
|
| "SELECT session_data AS data FROM " . $this->sessionTable . " WHERE session_id = '$sessID' AND session_expire >" . time( ) | 1 |
|
| 'DELETE FROM ' . $this->options['table'] . ' WHERE var=\'' . $name . '\'' | 1 |
|
| "DELETE FROM " . $this->sessionTable . " WHERE session_id = '$sessID'" | 1 |
|
| "DELETE FROM " . $this->sessionTable . " WHERE session_expire < " . time( ) | 1 |
|
| "Delete bucket success!" | 1 |
|
| "Delete bucket failed! Response: [" . $response->body . "]" | 1 |
|
| "Delete object success!" | 1 |
|
| "Delete object failed! Response: [" . $response->body . "]" | 1 |
|
| 'SELECT `data`,`datacrc` FROM `' . $this->options['table'] . '` WHERE `cachekey`=\'' . $name . '\' AND (`expire` =0 OR `expire`>' . time( ) . ') LIMIT 0,1' | 1 |
|
| 'select `cachekey` from `' . $this->options['table'] . '` where `cachekey`=\'' . $name . '\' limit 0,1' | 1 |
|
| 'UPDATE ' . $this->options['table'] . ' SET data=\'' . $data . '\' ,datacrc=\'' . $crc . '\',expire=' . $expire . ' WHERE `cachekey`=\'' . $name . '\'' | 1 |
|
| 'INSERT INTO ' . $this->options['table'] . ' (`cachekey`,`data`,`datacrc`,`expire`) VALUES (\'' . $name . '\',\'' . $data . '\',\'' . $crc . '\',' . $expire . ')' | 1 |
|
| 'DELETE FROM `' . $this->options['table'] . '` WHERE `cachekey`=\'' . $name . '\'' | 1 |
|
| 'SELECT value FROM ' . $this->options['table'] . ' WHERE var=\'' . $name . '\' AND (expire=0 OR expire >' . time( ) . ') LIMIT 1' | 1 |
|
| 'DELETE FROM ' . $this->sessionTable . " WHERE session_id = '$sessID'" | 1 |
|
| "SELECT id FROM kvp_" . $this->_TableName | 2 |
|
| 'INSERT INTO ' . $mappingRelationTable . ' (' . $mappingFk . ',' . $mappingRelationFk . ') SELECT a.' . $this->getPk( ) . ',b.' . $model->getPk( ) . ' FROM ' . $this->getTableName( ) . ' AS a ,' . $model->getTableName( ) . " AS b where a." . $this->getPk( ) . ' =' . $pk . ' AND b.' . $model->getPk( ) . ' IN (' . $relationId . ") " | 2 |
|
| "SELECT name FROM sqlite_master WHERE type='table' " . "UNION ALL SELECT name FROM sqlite_temp_master " . "WHERE type='table' ORDER BY name" | 2 |
|
| "SELECT * FROM user_sequences WHERE sequence_name='" . strtoupper($this->table) . "'" | 2 |
|
| 'DELETE FROM ' . $this->parseTable($options['table']) . $this->parseWhere(!empty($options['where']) ? $options['where'] : '') . $this->parseLock(isset($options['lock']) ? $options['lock'] : false) . $this->parseComment(!empty($options['comment']) ? $options['comment'] : '') | 2 |
|
| 'UPDATE ' . $this->parseTable($options['table']) . $this->parseSet($data) . $this->parseWhere(!empty($options['where']) ? $options['where'] : '') . $this->parseLock(isset($options['lock']) ? $options['lock'] : false) . $this->parseComment(!empty($options['comment']) ? $options['comment'] : '') | 2 |
|
| "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' " | 2 |
|
| "SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = '$tableName'" | 2 |
|
| 'SELECT DISTINCT RDB$RELATION_NAME FROM RDB$RELATION_FIELDS WHERE RDB$SYSTEM_FLAG=0' | 2 |
|
| 'SELECT %LIMIT% %DISTINCT% %FIELD% FROM %TABLE%%JOIN%%WHERE%%GROUP%%HAVING%%ORDER%' | 2 |
|
| 'select fields_name as "field",fields_type as "type",fields_not_null as "null",fields_key_name as "key",fields_default as "default",fields_default as "extra" from table_msg(' . $tableName . ');' | 2 |
|
| "select node.id,node.name from " . $table['role'] . " as role," . $table['user'] . " as user," . $table['access'] . " as access ," . $table['node'] . " as node " . "where user.user_id='{$authId}' and user.role_id=role.id and ( access.role_id=role.id or (access.role_id=role.pid and role.pid!=0 ) ) and role.status=1 and access.node_id=node.id and node.level=3 and node.pid={$moduleId} and node.status=1" | 2 |
|
| 'SHOW TABLES ' | 3 |
|
| 'SHOW TABLES FROM ' . $dbName | 3 |
|
| "select tablename as Tables_in_test from pg_tables where schemaname ='public'" | 3 |
|