SDS_SQL
extends SDS_DataStorage
in package
Provides base functionality for all SimplOn classes.
Table of Contents
- $db : mixed
- $operandsMap : mixed
- $typesMap : mixed
- __call() : mixed
- Auto Makes the Setters and Getters
- __construct() : mixed
- alterTable() : mixed
- clear() : mixed
- Clears the value of a property or attribute
- countElements() : mixed
- createDB() : mixed
- createElement() : mixed
- createTable() : mixed
- delete() : mixed
- deleteElement() : mixed
- ensureElementStorage() : mixed
- filterCriteria() : mixed
- getClass() : string
- Returns the object's class
- getDataType() : mixed
- getDataTypes() : mixed
- getElementsData() : mixed
- hasAttribute() : bool
- Checks if a an object has a specific method
- hasProperty() : bool
- Checks if a an object has a specific property
- instanceId() : mixed
- Run time id of the object used to creat ids to link things in the interface like Labels and Inputs
- isSetElementStorage() : mixed
- isValidElementStorage() : mixed
- ObjectId() : mixed
- Class and instance id
- obtainValues() : mixed
- processConditions() : mixed
- processRange() : mixed
- readElement() : mixed
- readElements() : mixed
- updateElement() : mixed
Properties
$db
public
mixed
$db
$operandsMap
public
static mixed
$operandsMap
= array('==' => '=')
$typesMap
public
static mixed
$typesMap
= array('SD_AutoIncrementId' => 'int(11) auto_increment', 'SD_StringId' => 'varchar(240)', 'SD_Integer' => 'int(11)', 'SD_Float' => 'float', 'SD_TimeStamp' => 'timestamp', 'SD_Date' => 'date', 'SD_DateTime' => 'timestamp', 'SD_String' => 'varchar(240)', 'SD_Text' => 'text', 'SD_DArray' => 'text', 'SD_ElementContainer' => '_ForeignKey_', 'SD_ElementsContainer' => '_ForeignKey_')
Methods
__call()
Auto Makes the Setters and Getters
public
__call( $name, $arguments) : mixed
Parameters
Return values
mixed —__construct()
public
abstract __construct(mixed $server, mixed $dataBase, mixed $user, mixed $password) : mixed
Parameters
- $server : mixed
- $dataBase : mixed
- $user : mixed
- $password : mixed
Return values
mixed —alterTable()
public
alterTable(SC_Element $element) : mixed
Parameters
- $element : SC_Element
Return values
mixed —clear()
Clears the value of a property or attribute
public
clear(string $name) : mixed
Parameters
- $name : string
Return values
mixed —countElements()
public
countElements(SC_Element &$element[, mixed $group = null ]) : mixed
Parameters
- $element : SC_Element
- $group : mixed = null
Return values
mixed —createDB()
public
abstract createDB(mixed $db_name) : mixed
Parameters
- $db_name : mixed
Return values
mixed —createElement()
public
createElement(SC_Element &$element) : mixed
Parameters
- $element : SC_Element
Return values
mixed —createTable()
public
createTable(SC_Element $element) : mixed
Parameters
- $element : SC_Element
Return values
mixed —delete()
public
delete(SC_Element &$element) : mixed
Parameters
- $element : SC_Element
Return values
mixed —deleteElement()
public
deleteElement(SC_Element &$element) : mixed
Parameters
- $element : SC_Element
Return values
mixed —ensureElementStorage()
public
ensureElementStorage(SC_Element &$element) : mixed
Parameters
- $element : SC_Element
Return values
mixed —filterCriteria()
public
filterCriteria(mixed $element_or_criteria) : mixed
Parameters
- $element_or_criteria : mixed
Return values
mixed —getClass()
Returns the object's class
public
getClass() : string
Return values
string —The short class name of the object instance.
getDataType()
public
getDataType(string $class) : mixed
Parameters
- $class : string
Return values
mixed —getDataTypes()
public
getDataTypes(SC_Element &$element) : mixed
Parameters
- $element : SC_Element
Return values
mixed —getElementsData()
public
getElementsData(mixed &$element[, mixed $filters = null ][, mixed $range = '0,500' ]) : mixed
Parameters
- $element : mixed
- $filters : mixed = null
- $range : mixed = '0,500'
Return values
mixed —hasAttribute()
Checks if a an object has a specific method
public
hasAttribute(mixed $attribute) : bool
Parameters
- $attribute : mixed
Return values
bool —hasProperty()
Checks if a an object has a specific property
public
hasProperty(string $propName) : bool
Parameters
- $propName : string
Return values
bool —instanceId()
Run time id of the object used to creat ids to link things in the interface like Labels and Inputs
public
instanceId() : mixed
Return values
mixed —isSetElementStorage()
public
isSetElementStorage(SC_Element &$element) : mixed
Parameters
- $element : SC_Element
Return values
mixed —isValidElementStorage()
public
isValidElementStorage(SC_Element &$element) : mixed
Parameters
- $element : SC_Element
Return values
mixed —ObjectId()
Class and instance id
public
ObjectId() : mixed
Return values
mixed —obtainValues()
public
obtainValues(SC_Element &$element, mixed $query_string) : mixed
Parameters
- $element : SC_Element
- $query_string : mixed
Return values
mixed —processConditions()
public
processConditions(mixed $conditions) : mixed
Parameters
- $conditions : mixed
Return values
mixed —processRange()
public
processRange(mixed $range) : mixed
Parameters
- $range : mixed
Return values
mixed —readElement()
public
readElement(mixed &$element) : mixed
Parameters
- $element : mixed
Return values
mixed —readElements()
public
readElements(SC_Element &$element[, mixed $returnAs = 'array' ][, mixed $position = null ][, mixed $limit = null ][, mixed $group = null ]) : mixed
Parameters
- $element : SC_Element
- $returnAs : mixed = 'array'
- $position : mixed = null
- $limit : mixed = null
- $group : mixed = null
Return values
mixed —updateElement()
public
updateElement(SC_Element &$element) : mixed
Parameters
- $element : SC_Element