List of all SQL mentioned in the code..
| Value | Count | File:Line |
|---|---|---|
| 'SELECT 1' | 1 |
|
| 'DELETE FROM "%s"' | 1 |
|
| 'Delete action is invalid. Must be one of %s' | 1 |
|
| 'Update action is invalid. Must be one of %s' | 1 |
|
| 'DELETE FROM %s' | 1 |
|
| 'SELECT FK.[name] AS [foreign_key_name], FK.[delete_referential_action_desc] AS [delete_type], FK.[update_referential_action_desc] AS [update_type], C.name AS [column], RT.name AS [reference_table], RC.name AS [reference_column] FROM sys.foreign_keys FK INNER JOIN sys.foreign_key_columns FKC ON FKC.constraint_object_id = FK.object_id INNER JOIN sys.tables T ON T.object_id = FKC.parent_object_id INNER JOIN sys.tables RT ON RT.object_id = FKC.referenced_object_id INNER JOIN sys.schemas S ON S.schema_id = T.schema_id AND S.schema_id = RT.schema_id INNER JOIN sys.columns C ON C.column_id = FKC.parent_column_id AND C.object_id = FKC.parent_object_id INNER JOIN sys.columns RC ON RC.column_id = FKC.referenced_column_id AND RC.object_id = FKC.referenced_object_id WHERE FK.is_ms_shipped = 0 AND T.name = ? AND S.name = ?' | 1 |
|
| 'SELECT DISTINCT AC.column_id AS [column_id], AC.name AS [name], TY.name AS [type], AC.max_length AS [char_length], AC.precision AS [precision], AC.scale AS [scale], AC.is_identity AS [autoincrement], AC.is_nullable AS [null], OBJECT_DEFINITION(AC.default_object_id) AS [default], AC.collation_name AS [collation_name] FROM sys.[objects] T INNER JOIN sys.[schemas] S ON S.[schema_id] = T.[schema_id] INNER JOIN sys.[all_columns] AC ON T.[object_id] = AC.[object_id] INNER JOIN sys.[types] TY ON TY.[user_type_id] = AC.[user_type_id] WHERE T.[name] = ? AND S.[name] = ? ORDER BY column_id' | 1 |
|
| "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = ? AND (TABLE_TYPE = 'BASE TABLE' OR TABLE_TYPE = 'VIEW') ORDER BY TABLE_NAME" | 1 |
|
| 'SELECT 1 FROM sqlite_master WHERE name = "sqlite_sequence"' | 1 |
|
| 'DELETE FROM sqlite_sequence WHERE name="%s"' | 1 |
|
| 'SELECT CHANGES()' | 1 |
|
| 'SELECT name FROM sqlite_master WHERE type="table" ' . 'AND name != "sqlite_sequence" ORDER BY name' | 1 |
|
| 'SELECT * FROM information_schema.key_column_usage AS kcu INNER JOIN information_schema.referential_constraints AS rc ON ( kcu.CONSTRAINT_NAME = rc.CONSTRAINT_NAME AND kcu.CONSTRAINT_SCHEMA = rc.CONSTRAINT_SCHEMA ) WHERE kcu.TABLE_SCHEMA = ? AND kcu.TABLE_NAME = ? AND rc.TABLE_NAME = ? ORDER BY kcu.ORDINAL_POSITION ASC' | 1 |
|
| 'SHOW TABLE STATUS WHERE Name = ?' | 1 |
|
| 'SHOW INDEXES FROM ' . $this->_driver->quoteIdentifier($tableName) | 1 |
|
| 'SHOW FULL COLUMNS FROM ' . $this->_driver->quoteIdentifier($tableName) | 1 |
|
| 'SHOW TABLES FROM ' . $this->_driver->quoteIdentifier($config['database']) | 1 |
|
| 'SELECT DISTINCT table_schema AS schema, column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, character_maximum_length AS char_length, c.collation_name, d.description as comment, ordinal_position, c.datetime_precision, c.numeric_precision as column_precision, c.numeric_scale as column_scale, pg_get_serial_sequence(attr.attrelid::regclass::text, attr.attname) IS NOT NULL AS has_serial FROM information_schema.columns c INNER JOIN pg_catalog.pg_namespace ns ON (ns.nspname = table_schema) INNER JOIN pg_catalog.pg_class cl ON (cl.relnamespace = ns.oid AND cl.relname = table_name) LEFT JOIN pg_catalog.pg_index i ON (i.indrelid = cl.oid AND i.indkey[0] = c.ordinal_position) LEFT JOIN pg_catalog.pg_description d on (cl.oid = d.objoid AND d.objsubid = c.ordinal_position) LEFT JOIN pg_catalog.pg_attribute attr ON (cl.oid = attr.attrelid AND column_name = attr.attname) WHERE table_name = ? AND table_schema = ? AND table_catalog = ? ORDER BY ordinal_position' | 1 |
|
| 'SELECT table_name as name FROM information_schema.tables WHERE table_schema = ? ORDER BY name' | 1 |
|
| 'Show a list of configured caches.' | 1 |
|