List of all SQL mentioned in the code..
| Value | Count | File:Line |
|---|---|---|
| 'INSERT INTO ' . $table . ' VALUES ()' | 1 |
|
| 'INSERT INTO %s (%s) VALUES (%s)' | 1 |
|
| 'INSERT INTO ' . $table . ' DEFAULT VALUES' | 1 |
|
| 'SELECT COUNT(*) AS ' | 1 |
|
| 'INSERT INTO ' . $table . ' (' . implode(', ', $keys) . ")\n{:_table_:}ON DUPLICATE KEY UPDATE\n" . implode(",\n", array_map(static fn ($key, $value) : string => $table . '.' . $key . ($value instanceof RawSql ? ' = ' . $value : ' = VALUES(' . $value . ')'), array_keys($updateFields), $updateFields, ), ) | 1 |
|
| 'SELECT * FROM (' . $sql . ') _u_ LIMIT 1' | 1 |
|
| 'INSERT ' . $this->compileIgnore('insert') . 'INTO ' . $table . ' (' . implode(', ', $keys) . ")\n{:_table_:}" | 1 |
|
| 'INSERT ' . $this->compileIgnore('insert') . 'INTO ' . $table . ' (' . implode(', ', $keys) . ') VALUES (' . implode(', ', $unescapedKeys) . ')' | 1 |
|
| 'UPDATE ' . $this->compileIgnore('update') . $table . ' SET ' . implode(', ', $valStr) . $this->compileWhereHaving('QBWhere') . $this->compileOrderBy( ) . ($this->QBLimit ? $this->_limit(' ', true) : '') | 1 |
|
| 'UPDATE ' . $this->compileIgnore('update') . $table . ' SET ' . implode(', ', $valStr) . $this->compileWhereHaving('QBWhere') . $this->compileOrderBy( ) . ($this->QBLimit !== false ? $this->_limit(' ', true) : '') | 1 |
|
| 'DELETE ' . $table . ' FROM ' . $table . "\n" | 1 |
|
| 'DELETE ' . $this->compileIgnore('delete') . 'FROM ' . $table . $this->compileWhereHaving('QBWhere') | 1 |
|
| 'SELECT * FROM (' . $sql . ') ' . ($this->db->protectIdentifiers ? $this->db->escapeIdentifiers('uwrp0') : 'uwrp0') . implode("\n", $this->QBUnion) | 1 |
|
| 'SELECT "table_name" FROM "information_schema"."tables" WHERE "table_schema" = \'' . $this->schema . "'" | 1 |
|
| 'SELECT "column_name" FROM "information_schema"."columns" WHERE LOWER("table_name") = ' . $tableName . ' ORDER BY "ordinal_position"' | 1 |
|
| 'SELECT "column_name", "data_type", "character_maximum_length", "numeric_precision", "column_default", "is_nullable" FROM "information_schema"."columns" WHERE LOWER("table_name") = ' . $this->escape(strtolower($table)) . ' ORDER BY "ordinal_position"' | 1 |
|
| 'SELECT "indexname", "indexdef" FROM "pg_indexes" WHERE LOWER("tablename") = ' . $this->escape(strtolower($table)) . ' AND "schemaname" = ' . $this->escape('public') | 1 |
|
| 'SELECT c.constraint_name, x.table_name, x.column_name, y.table_name as foreign_table_name, y.column_name as foreign_column_name, c.delete_rule, c.update_rule, c.match_option FROM information_schema.referential_constraints c JOIN information_schema.key_column_usage x on x.constraint_name = c.constraint_name JOIN information_schema.key_column_usage y on y.ordinal_position = x.position_in_unique_constraint and y.constraint_name = c.unique_constraint_name WHERE x.table_name = ' . $this->escape($table) . 'order by c.constraint_name, x.ordinal_position' | 1 |
|
| 'SELECT LASTVAL() AS ins_id' | 1 |
|
| "SELECT pg_get_serial_sequence('{$table}', '{$column}') AS seq" | 1 |
|
| "SELECT CURRVAL('{$seq}') AS ins_id" | 1 |
|
| 'INSERT INTO %s (%s) VALUES (%s) %s' | 1 |
|
| 'INSERT INTO ' . $table . '(' . implode(', ', $keys) . ")\n{:_table_:}\n" | 1 |
|
| 'SELECT 1 FROM pg_database WHERE datname = ?' | 1 |
|
| "SELECT con.conname FROM pg_catalog.pg_constraint con INNER JOIN pg_catalog.pg_class rel ON rel.oid = con.conrelid INNER JOIN pg_catalog.pg_namespace nsp ON nsp.oid = connamespace WHERE nsp.nspname = '{$this->db->schema}' AND rel.relname = '" . trim($table, '"') . "' AND con.conname = '" . trim($constraintName, '"') . "'" | 1 |
|
| 'SELECT datname FROM pg_database' | 1 |
|
| 'SELECT CASE WHEN (@@OPTIONS | 256) = @@OPTIONS THEN 1 ELSE 0 END AS qi' | 1 |
|
| 'SELECT SCOPE_IDENTITY() AS insert_id' | 1 |
|
| 'SELECT [TABLE_NAME] AS "name"' . ' FROM [INFORMATION_SCHEMA].[TABLES] ' . ' WHERE ' . " [TABLE_SCHEMA] = '" . $this->schema . "' " | 1 |
|
| 'SELECT [COLUMN_NAME] ' . ' FROM [INFORMATION_SCHEMA].[COLUMNS]' . ' WHERE [TABLE_NAME] = ' . $tableName . ' AND [TABLE_SCHEMA] = ' . $this->escape($this->schema) | 1 |
|
| 'INSERT INTO ' . $fullTableName . ' (' . implode(',', $keys) . ') VALUES (' . implode(', ', $unescapedKeys) . ')' | 1 |
|
| 'INSERT ' . $this->compileIgnore('insert') . 'INTO ' . $this->getFullName($table) . ' (' . implode(', ', $keys) . ")\n{:_table_:}" | 1 |
|
| 'UPDATE %s%s SET ' | 1 |
|
| "SELECT * \nFROM " . $this->_fromTables( ) . ' WHERE 1=0 ' | 1 |
|
| 'INSERT INTO %s (%s) VALUES (%s);' | 1 |
|
| "SELECT name from syscolumns where id = Object_ID('" . $table . "') and colstat = 1" | 1 |
|
| 'SELECT TOP 1 * FROM (' . $sql . ') _u_' | 1 |
|
| <<<SQL SELECT name FROM sys.default_constraints WHERE parent_object_id = OBJECT_ID('{$fullTable}') AND parent_column_id IN ( SELECT column_id FROM sys.columns WHERE name IN ({$fields}) AND object_id = OBJECT_ID(N'{$fullTable}') ) SQL | 1 |
|
| "SELECT CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE TABLE_NAME= '" . trim($table, '"') . "' AND CONSTRAINT_NAME = '" . trim($constraintName, '"') . "'" | 1 |
|
| 'SELECT "TABLE_NAME" FROM "USER_TABLES"' | 1 |
|
| 'SELECT COLUMN_NAME FROM ALL_TAB_COLUMNS WHERE UPPER(OWNER) = ' . $this->escape(strtoupper($owner)) . ' AND UPPER(TABLE_NAME) = ' . $tableName | 1 |
|
| 'SELECT COLUMN_NAME, DATA_TYPE, CHAR_LENGTH, DATA_PRECISION, DATA_LENGTH, DATA_DEFAULT, NULLABLE FROM ALL_TAB_COLUMNS WHERE UPPER(OWNER) = ' . $this->escape(strtoupper($owner)) . ' AND UPPER(TABLE_NAME) = ' . $this->escape(strtoupper($table)) | 1 |
|
| 'SELECT AIC.INDEX_NAME, UC.CONSTRAINT_TYPE, AIC.COLUMN_NAME ' . ' FROM ALL_IND_COLUMNS AIC ' . ' LEFT JOIN USER_CONSTRAINTS UC ON AIC.INDEX_NAME = UC.CONSTRAINT_NAME AND AIC.TABLE_NAME = UC.TABLE_NAME ' . 'WHERE AIC.TABLE_NAME = ' . $this->escape(strtolower($table)) . ' ' . 'AND AIC.TABLE_OWNER = ' . $this->escape(strtoupper($owner)) . ' ' . ' ORDER BY UC.CONSTRAINT_TYPE, AIC.COLUMN_POSITION' | 1 |
|
| 'SELECT DATA_DEFAULT FROM USER_TAB_COLUMNS WHERE TABLE_NAME = ? AND COLUMN_NAME = ?' | 1 |
|
| 'SELECT %s SEQ FROM DUAL' | 1 |
|
| 'SELECT DEFAULT_TABLESPACE FROM USER_USERS' | 1 |
|
| 'SELECT COUNT(1) ' | 1 |
|
| 'UPDATE ' . $this->compileIgnore('update') . $table . ' SET ' . implode(', ', $valStr) . $this->compileWhereHaving('QBWhere') . $this->compileOrderBy( ) | 1 |
|
| 'SELECT ' . implode(', ', array_map(static fn ($key, $index) : string => $index . ' ' . $key, $keys, $value, )) . ' FROM DUAL' | 1 |
|
| 'DELETE ' . $table . "\n" | 1 |
|
| 'SELECT * FROM (' . $sql . ') "_u_" WHERE ROWNUM = 1' | 1 |
|
| "SELECT constraint_name FROM all_constraints WHERE table_name = '" . trim($table, '"') . "' AND index_name = '" . trim($constraintName, '"') . "'" | 1 |
|
| 'SELECT TABLESPACE_NAME FROM USER_TABLESPACES' | 1 |
|
| 'SELECT "NAME" FROM "SQLITE_MASTER" WHERE "TYPE" = \'table\'' . ' AND "NAME" NOT LIKE \'sqlite!_%\' ESCAPE \'!\'' . ' AND "NAME" LIKE ' . $this->escape($tableName) | 1 |
|
| 'SELECT "NAME" FROM "SQLITE_MASTER" WHERE "TYPE" = \'table\'' . ' AND "NAME" NOT LIKE \'sqlite!_%\' ESCAPE \'!\'' . (($prefixLimit && $this->DBPrefix !== '') ? ' AND "NAME" LIKE \'' . $this->escapeLikeString($this->DBPrefix) . '%\' ' . sprintf($this->likeEscapeStr, $this->likeEscapeChar) : '') | 1 |
|
| "SELECT 'PRIMARY' as indexname, l.name as fieldname, 'PRIMARY' as indextype FROM pragma_table_info(" . $this->escape(strtolower($table)) . ") as l WHERE l.pk <> 0 UNION ALL SELECT sqlite_master.name as indexname, ii.name as fieldname, CASE WHEN ti.pk <> 0 AND sqlite_master.name LIKE 'sqlite_autoindex_%' THEN 'PRIMARY' WHEN sqlite_master.name LIKE 'sqlite_autoindex_%' THEN 'UNIQUE' WHEN sqlite_master.sql LIKE '% UNIQUE %' THEN 'UNIQUE' ELSE 'INDEX' END as indextype FROM sqlite_master INNER JOIN pragma_index_xinfo(sqlite_master.name) ii ON ii.name IS NOT NULL LEFT JOIN pragma_table_info(" . $this->escape(strtolower($table)) . ") ti ON ti.name = ii.name WHERE sqlite_master.type='index' AND sqlite_master.tbl_name = " . $this->escape(strtolower($table)) . ' COLLATE NOCASE' | 1 |
|
| 'INSERT OR ' . parent::_replace($table, $keys, $values) | 1 |
|
| 'DELETE FROM ' . $table | 1 |
|
| 'UPDATE ' . $this->compileIgnore('update') . $table . ' SET ' . substr($cases, 0, -2) . $this->compileWhereHaving('QBWhere') | 1 |
|
| "INSERT INTO {$this->prefixedTableName}({$newFields}) SELECT {$exFields} FROM {$this->db->DBPrefix}temp_{$this->tableName}" | 1 |
|
| "SHOW STATUS LIKE 'ssl_cipher'" | 1 |
|
| 'SHOW TABLES FROM ' . $this->escapeIdentifier($this->database) | 1 |
|
| 'SHOW COLUMNS FROM ' . $tableName | 1 |
|
| 'SHOW COLUMNS FROM ' . $table | 1 |
|
| 'SHOW INDEX FROM ' . $table | 1 |
|
| 'SHOW DATABASES' | 1 |
|
| "SELECT * FROM {$table}" | 1 |
|
| 'Show only new translations in table. Does not write to files.' | 1 |
|
| 'Show only CodeIgniter config namespaces.' | 1 |
|
| 'Show raw path strings.' | 1 |
|
| "SELECT pg_advisory_lock({$arg})" | 1 |
|
| "SELECT pg_advisory_unlock({$this->lock})" | 1 |
|
| "SELECT GET_LOCK('{$arg}', 300) AS ci_session_lock" | 1 |
|
| "SELECT RELEASE_LOCK('{$this->lock}') AS ci_session_lock" | 1 |
|
| 'SELECT `example_field` FROM `example_table`' | 1 |
|
| 'SELECT * FROM some_table WHERE id = :id: AND status = :status: AND author = :name:' | 1 |
|
| "INSERT INTO table (title) VALUES('" . $db->escapeString($title) . "')" | 1 |
|
| "SELECT id FROM table WHERE column LIKE '%" . $db->escapeLikeString($search) . "%' ESCAPE '!'" | 1 |
|
| 'SELECT * FROM some_table WHERE id IN ? AND status = ? AND author = ?' | 1 |
|
| 'SELECT * FROM some_table WHERE id = ? AND status = ? AND author = ?' | 1 |
|
| 'INSERT INTO table (title) VALUES(' . $db->escape($title) . ')' | 1 |
|
| 'SELECT user2.name, user2.email, user2.country FROM user2 LEFT JOIN user ON user.email = user2.email WHERE user.email IS NULL' | 1 |
|
| 'SELECT * FROM users;' | 1 |
|
| 'SELECT * FROM users LIMIT 1;' | 1 |
|
| 'SELECT title FROM my_table' | 1 |
|
| 'SELECT name FROM some_table' | 1 |
|
| 'SELECT `field_name` FROM `table_name`' | 1 |
|
| 'INSERT INTO mytable (title, name) VALUES (' . $db->escape($title) . ', ' . $db->escape($name) . ')' | 1 |
|
| 'SELECT * FROM some_table' | 1 |
|
| 'SELECT * FROM blog' | 1 |
|
| 'Select your hobbies:' | 1 |
|
| 'INSERT INTO users (username, email) VALUES(:username:, :email:)' | 1 |
|
| 'SELECT ' | 2 |
|
| 'SELECT DISTINCT ' | 2 |
|
| 'INSERT INTO ' . $table . ' (' | 2 |
|
| 'DELETE FROM ' . $table . "\n" | 2 |
|
| 'INSERT INTO user (name, email, country) VALUES (?, ?, ?)' | 2 |
|
| 'SELECT name, title, email FROM my_table' | 2 |
|
| 'SELECT name FROM my_table LIMIT 1' | 2 |
|
| 'UPDATE ' . $this->compileIgnore('update') . $table . "\n" | 3 |
|
| 'SELECT * FROM mytable' | 3 |
|
| 'SELECT * FROM my_table' | 4 |
|
| 'SELECT ' . implode(', ', array_map(static fn ($key, $index) : string => $index . ' ' . $key, $keys, $value, )) | 9 |
|