vBulletin 5.6.5 API

vB_dB_Query_Insert_MYSQL extends vB_dB_Query_Insert

in package

• vBDatabase

This is the MySQL-Specific version of the Insert Query processor

Tags

version

$Revision: 99787 $

Table of Contents

BITFIELDS_KEY  = '#bitfields'

BITFIELDS_SET  = '#bitset'

BITFIELDS_UNSET  = '#bitunset'

COLUMNS_KEY  = '#columns'

CONDITION_ALL  = '#all'

CONDITIONS_KEY  = '#filters'

This class is called by the new vB_dB_Assertor database class It does the actual execution. See the vB_dB_Assertor class for more information

DEBUG_QUERY  = '#debug'

FIELDS_KEY  = '#fields'

OPERATOR_AND  = '#AND'

OPERATOR_BEGINS  = 'BEGINS'

OPERATOR_ENDS  = 'ENDS'

OPERATOR_EQ  = 'EQ'

OPERATOR_FALSE  = 'FALSE'

OPERATOR_GT  = 'GT'

OPERATOR_GTE  = 'GTE'

OPERATOR_INCLUDES  = 'INCLUDES'

OPERATOR_ISNOTNULL  = 'IS NOT NULL'

OPERATOR_ISNULL  = 'IS NULL'

OPERATOR_KEY  = 'operator'

OPERATOR_LT  = 'LT'

OPERATOR_LTE  = 'LTE'

OPERATOR_NAND  = '#NAND'

OPERATOR_NE  = 'NE'

OPERATOR_OR  = '#OR'

PARAM_LIMIT  = '#limit'

PARAM_LIMITPAGE  = '#limit_page'

PARAM_LIMITSTART  = '#limit_start'

PRIORITY_QUERY  = '#priority'

QUERY_ALTER  = 'a'

QUERY_COUNT  = 'co'

QUERY_CREATE  = 'cr'

QUERY_DELETE  = 'd'

QUERY_DROP  = 'dr'

QUERY_INSERT  = 'i'

QUERY_INSERTIGNORE  = 'ig'

QUERY_METHOD  = 'm'

QUERY_MULTIPLEINSERT  = 'mi'

QUERY_REPLACE  = 'r'

QUERY_SELECT  = 's'

QUERY_STORED  = 'st'

QUERY_TABLE  = 't'

QUERY_UPDATE  = 'u'

QUERYTYPE_KEY  = '#querytype'

SORT_ASC  = 'ASC'

SORT_DESC  = 'DESC'

TYPE_KEY  = '#type'

VALUE_ISNULL  = '#NULL'

VALUES_KEY  = '#values'

$class_name  : mixed

$configDebug  : mixed

$data_loaded  : mixed

are we ready to execute? *

$datafields  : mixed

are we ready to execute? *

$db  : mixed

$db_type  : mixed

$dbSlave  : mixed

$debugDisplayNextQuerySql  : bool

Causes the SQL for the next query that is exectuted to be displayed for debugging purposes. This only works if debug mode is turned on

$error  : mixed

The most recent error *

$errors  : mixed

All errors for this query *

$forcetext  : mixed

$method_name  : mixed

$params  : mixed

The parameters are are going to use to populate the query data

$primarykey  : mixed

What is the primary key of the table, if applicable?

$query_data  : mixed

$query_string  : mixed

What is the text of the stored query from the dictionary, if applicable?

$query_type  : mixed

$queryBuilders  : mixed

Holds the query builder object. We don't need a copy for every query so we store them here.

$querydef_object  : mixed

$querydefs  : mixed

$queryid  : mixed

The original query id *

$quotechar  : mixed

$replacements  : mixed

The replacement variables from a stored query*

$sortorder  : mixed

sortorder, for select queries only (obviously) *

$structure  : mixed

The array from a describe statement for database structure, if applicable?

$table_query  : mixed

$userinfo  : mixed

The user info **

__serialize()  : mixed

__sleep()  : mixed

__unserialize()  : mixed

__wakeup()  : mixed

debugDisplayNextQuerySql()  : mixed

Causes the SQL for the next query that is exectuted to be displayed for debugging purposes. This only works if debug mode is turned on

execSQL()  : mixed

This function is the public interface to actually execute the SQL.

getQuery()  : mixed

setQuery()  : mixed

This loads and validates the data- ensures we have all we need

setTableQuery()  : mixed

This loads and validates the data for a table. There's some extra work required

__construct()  : mixed

validates that we know what to do with this queryid

buildQuery()  : mixed

This function generates the query text against a table.

doInserts()  : mixed

This function does the inserts and returns (if applicable) the new keys

setQueryData()  : mixed

Sets the query Query definitions

setQueryDefs()  : mixed

Sets the querydef object