Class: DTableSQLExporter

Source Location: /DataBase/Shells/Exporters/DTableSQLExporter.php

Class Overview

DObject
   |
   --DDataBase
      |
      --DTableShell
         |
         --DTableSQLExporter

SQL exporter functionality

Methods

Inherited Constants

Inherited Variables

Class: DTableShell

DTableShell::$configurationVersion
DTableShell::$extraParameterDefaultValuesDelimiter
DTableShell::$extraParameterDefaultValuesEquals
DTableShell::$extraParameterPrefixSuffix
DTableShell::$set
DTableShell::$SHELL_CONFIG
DTableShell::$suppressFormats
DTableShell::$_datatypeAnalytic
DTableShell::$_DBDependency
DTableShell::$_extraParameters
DTableShell::$_fields
DTableShell::$_fieldTypes
DTableShell::$_requiredMisses
DTableShell::$_schema
DTableShell::$_shellConfigXML
DTableShell::$_table
DTableShell::$_typeProblems
DTableShell::$_uniqueDoubles

Class: DDataBase

DDataBase::$autoAddSlashes
DDataBase::$autoHtmlSpecialChars
DDataBase::$autoStripSlashes
DDataBase::$db
DDataBase::$encoding
DDataBase::$errorMsg
DDataBase::$host
DDataBase::$latestSQL
DDataBase::$pass
DDataBase::$SQLType
DDataBase::$user
DDataBase::$_DBConnection

Class: DObject

DObject::$PHP_CORE_LIB_CLASS

Inherited Methods

Class: DTableShell

DTableShell::__construct()

Class constructor

DTableShell::deleteFromDB()

Delete record(s) from the table that match a $condition

DTableShell::extendValidatePOSTArray()

Extend validation POST array

DTableShell::getConditionedCount()

Gets count of elements depending on specific condition

DTableShell::getExtraParameter()

Gets extra parameter

DTableShell::getFields()

Return data fields

DTableShell::getFieldTypeProperty()

Gets field type property value

DTableShell::getInstance()

Gets instance

DTableShell::getLastInsertID()

Return last insert id

DTableShell::getLatestInsertId()

Gets the latest insert id

DTableShell::getRequiredMisses()

Returns required misses

DTableShell::getSafeFields()

Gets safe fields

DTableShell::getSafeSingleRecord()

Gets safe single record

DTableShell::getSchemaName()

Gets schema name

DTableShell::getShellConfigXML()

Gets shell config xml name

DTableShell::getSingleRecord()

Returns single row query

DTableShell::getSQLExporterInstance()

Gets instance of DTableSQLExplorer class

DTableShell::getTableDetails()

Gets table details

DTableShell::getTableFieldValue()

Gets table field value

DTableShell::getTableName()

Gets table name

DTableShell::getTypeProblems()

Return type problems

DTableShell::getUniqueDoubles()

Return unique doubles

DTableShell::getValidatorErrors()

Return array of errors

DTableShell::initInstance()

Inits DB instance

DTableShell::loadDataFromArray()

Loads data to table fields from array data - multi record

DTableShell::loadDataFromDB()

Loads data to table fields from database

DTableShell::loadDataFromPOSTArray()

Loads data from $_POST like array - one record

DTableShell::resetExtraParameters()

Clears extra parameters

DTableShell::saveDataToDB()

Saves data to DB. If you want to zero a field add value "__NULL"

DTableShell::search()

Perform search

DTableShell::setExtraParameter()

Sets extra parameter

DTableShell::setFieldTypeProperty()

Sets field type property value

DTableShell::setRequiredStatus()

Sets required status

DTableShell::setTableName()

Sets table name

DTableShell::setType()

Sets type of filed

DTableShell::validatePOSTArray()

Checks the requirements, described in the table config before save to db

If there is a problem in required fields returns -1
If there is a problem in unique fields returns -2
If there is a problem in type fields returns -3
If everythig is OK returns 1

DTableShell::validatePOSTArraySpecific()

Validates POST array with specific validation method

DTableShell::_isDateTime()

Checks if the field is datetime

DTableShell::_isEmail()

Checks if the field is email

DTableShell::_isFloat()

Checks if the field is float

DTableShell::_isInt()

Checks if the field is int

DTableShell::_isNULLable()

Checks if the field can accept null or cannot

DTableShell::_isQuotable()

Checks if the field is quotable or non quotable

DTableShell::_isRegularColumn()

Checks if the field needs to be included in selects directly as a name of column

DTableShell::_isText()

Class: DDataBase

DDataBase::__construct(): Constructor
DDataBase::getDBInstance(): Gets IDSQLBase instance
DDataBase::getInstance(): Gets database instance
DDataBase::initializeSQLBase(): Initializes the DB Layber
DDataBase::query(): Execute a SQL Query and returns the data
DDataBase::setCurrentDB(): Sets the current db

Class: DObject

DObject::__construct(): Constructor
DObject::debug(): Debig
DObject::getClassMembers(): Gets member variables of the instance
DObject::getClassMemberType(): Gets class member type
DObject::getClassMethods(): Gets classes of the class
DObject::getClassName(): Gets class name
DObject::PHPSerialize(): Gets serialized string of the class
DObject::trace(): Trace
DObject::__destruct(): Descructor
DObject::__toString(): Returns String equivalent of the object.

Class Details

[line 16]
SQL exporter functionality

[ Top ]

Class Methods

constructor __construct [line 24]

DTableSQLExporter __construct(
string
$shellConfigXML)

Class constructor

Tags:

access:

public

Overrides DTableShell::__construct() (Class constructor)

Parameters:

string

$shellConfigXML

[ Top ]

method toArray [line 35]

array toArray(
)

Gets array with sql export queries

Tags:

access:

public

[ Top ]

method toFile [line 91]

void toFile(
string
$filePath, [string
$fileName = ""], [boolean
$setFilePrefix = true])

Writes sql export questies to file

Tags:

access:

public

Parameters:

string	$filePath
string	$fileName
boolean	$setFilePrefix

[ Top ]

method __toString [line 78]

string __toString(
[string
$EOLNSymbol = "\n"])

Gets string with sql export queries as a string, delimited with $EOLN symbol

Tags:

access:

public

Overrides DObject::__toString() (Returns String equivalent of the object.)

Parameters:

string

$EOLNSymbol

[ Top ]

Documentation generated on Sat, 17 Apr 2010 22:13:30 +0300 by phpDocumentor 1.4.3