Queries.py File Reference

This file extends the basic query types, allowing them to represent queries and operations executed against a MySQL data source. More...

Classes
class	Plugins.DataSource.MySQL.Queries.AMySQLQuery
	A query executed against a MySQL data source. More...
class	Plugins.DataSource.MySQL.Queries.AMySQLSelectQuery
	A SELECT query executed against a MySQL data source. More...
class	Plugins.DataSource.MySQL.Queries.AMySQLFullTextQuery
	A full-text SELECT query. More...
class	Plugins.DataSource.MySQL.Queries.AMySQLSelectCountQuery
	A MySQL SELECT COUNT(*) query. More...
class	Plugins.DataSource.MySQL.Queries.AMySQLInsertQuery
	A MySQL INSERT query. More...
class	Plugins.DataSource.MySQL.Queries.AMySQLUpdateQuery
	A MySQL UPDATE query. More...
class	Plugins.DataSource.MySQL.Queries.AMySQLDeleteQuery
	A MySQL DELETE query. More...
class	Plugins.DataSource.MySQL.Queries.AMySQLSelectFunctionQuery
	A SELECT statement that returns the result of a function. More...
class	Plugins.DataSource.MySQL.Queries.AMySQLUseDatabaseQuery
	A USE query executed against a MySQL database. More...
class	Plugins.DataSource.MySQL.Queries.AMySQLShowTablesQuery
	A SHOW TABLES query executed against a MySQL database. More...

Variables
int	Plugins.DataSource.MySQL.Queries.MYSQL_OK = 0
	The status code that means success (OK)
string	Plugins.DataSource.MySQL.Queries.myqSelectStatement = "SELECT "
	A SELECT statement.
string	Plugins.DataSource.MySQL.Queries.myqSelectTablesClause = " FROM "
string	Plugins.DataSource.MySQL.Queries.myqCriteriaClause = " WHERE "
string	Plugins.DataSource.MySQL.Queries.myqGroupingClause = " GROUP BY "
string	Plugins.DataSource.MySQL.Queries.myqSortClause = " ORDER BY "
string	Plugins.DataSource.MySQL.Queries.myqLimitClause = " LIMIT "
string	Plugins.DataSource.MySQL.Queries.myqLimitMaximum = "18446744073709551615"
string	Plugins.DataSource.MySQL.Queries.myqDefaultSortOrder = 'asc'
	The default sort order.
dictionary	Plugins.DataSource.MySQL.Queries.myqSortOrderOperators = {'+': 'asc', '-': 'desc'}
	Sort order operators.
string	Plugins.DataSource.MySQL.Queries.myqMatchClause = " MATCH"
	A full-text SELECT statement.
string	Plugins.DataSource.MySQL.Queries.myqMatchCriteriaClause = " AGAINST"
string	Plugins.DataSource.MySQL.Queries.myqMatchModeClause = " IN BOOLEAN MODE"
string	Plugins.DataSource.MySQL.Queries.myqMatchRelevanceClause = "*100 AS "
string	Plugins.DataSource.MySQL.Queries.myqMatchRelevanceFieldName = "$relevance"
string	Plugins.DataSource.MySQL.Queries.myqSelectCountStatement = "SELECT COUNT"
	A SELECT COUNT(*) statement.
string	Plugins.DataSource.MySQL.Queries.myqInsertStatement = "INSERT INTO "
	An INSERT statement.
string	Plugins.DataSource.MySQL.Queries.myqValuesClause = " VALUES"
string	Plugins.DataSource.MySQL.Queries.msdfLastPrimaryKey = "LAST_INSERT_ID"
	The function to use when obtaining the last insert ID.
string	Plugins.DataSource.MySQL.Queries.myqUpdateStatement = "UPDATE "
	An UPDATE statement.
string	Plugins.DataSource.MySQL.Queries.myqSetClause = " SET "
string	Plugins.DataSource.MySQL.Queries.myqDeleteStatement = "DELETE "
	A DELETE statement.
string	Plugins.DataSource.MySQL.Queries.myqDeletePriority = " LOW_PRIORITY "
string	Plugins.DataSource.MySQL.Queries.myqDeleteAll = "TRUNCATE TABLE"
string	Plugins.DataSource.MySQL.Queries.myqSelectFoundRowsStatement = "SELECT FOUND_ROWS()"
	A SELECT FOUND_ROWS() statement.
string	Plugins.DataSource.MySQL.Queries.myqUseStatement = "USE"
	A USE statement.
string	Plugins.DataSource.MySQL.Queries.myqShowTablesStatement = "SELECT `table_name` AS `TableName`"
	A SHOW TABLES statement.
string	Plugins.DataSource.MySQL.Queries.myqShowFullTablesClause = ", `table_type` AS `TableType`"
string	Plugins.DataSource.MySQL.Queries.myqShowTablesSourceClause = " FROM INFORMATION_SCHEMA.TABLES"
string	Plugins.DataSource.MySQL.Queries.myqShowTablesCriteria = "table_schema = "
dictionary	Plugins.DataSource.MySQL.Queries.myqSpecialCharacters
	Special characters that must be escaped in MySQL query strings. More...
string	Plugins.DataSource.MySQL.Queries.myqQuoteCharacter = "\""
	The quote character to use when quoting string literals in MySQL queries.
string	Plugins.DataSource.MySQL.Queries.myqIdentifierQuoteCharacter = "`"
	The type of quote to use when marking identifiers in an SQL query string.
string	Plugins.DataSource.MySQL.Queries.myqListBeginCharacter = "("
	The type of "quotes" to use when marking lists in an SQL query string.
string	Plugins.DataSource.MySQL.Queries.myqListEndCharacter = ")"
string	Plugins.DataSource.MySQL.Queries.myqListDelimiter = ","
string	Plugins.DataSource.MySQL.Queries.myqDefaultMessage = "Okay"
	The default status message (Okay)

Detailed Description

This file extends the basic query types, allowing them to represent queries and operations executed against a MySQL data source.