\LinHUniX\Pdo\DriversqliteDriver

Summary

Methods

Properties

Constants

__construct()
isLive()
real_escape_string()
table_exist()
intexec()
rawexec()
execute()
executeWithRollback()
queryReturnResultSet()
simpleQuery()
queryLabel()
queryNoLabel()
indexQuery()
simpleCount()
getTable()
data_table()
dataWalk()
firstRow()
firstRowField()
data_row()
delRow()
getRow()
getRows()
getLastError()
getLastRun()
getLastId()
setRow()
getSql()
getNames()
query()
lastData()
nextRow()
next_record()
seek()
freeresult()
numRows()
affectedRows()
num_rows()
getDependency()
run()

$PDO
$tables
$tabcount
$tmp
$cache
$debug
$database
$dburlcon
$lasterror
$lastrows

No constants found

listTable()
moduleCore()
moduleInit()
getMcp()
getRes()
getCfg()
getDriver()
getCommon()
setCommon()
setScopeOut()
callCmd()
callTag()
setReturn()
moduleSingleTon()
getArgIn()
getArgCtl()
getArgOut()
setArgOut()
debug()
info()
warning()
error()

$spacename
$classname
$require
$singleTon
$bootCtl
$bootData
$argCtl
$argIn
$argOut
$mcp

N/A

No private methods found

No private properties found

N/A

File: Pdo/Driver/sqliteDriver.php
Package: Default
Class hierarchy: \LinHUniX\Mcp\Model\mcpBaseModelClass

\LinHUniX\Pdo\Driver\pdoDriver

\LinHUniX\Pdo\Driver\sqliteDriver

Tags

None found

Properties

$PDO

$PDO : \PDO

Type

\PDO

$tables

$tables :

Type

$tabcount

$tabcount :

Type

$tmp

$tmp :

Type

$cache

$cache :

Type

$debug

$debug :

Type

$database

$database :

Type

$dburlcon

$dburlcon :

Type

$lasterror

$lasterror :

Type

$lastrows

$lastrows :

Type

$spacename

$spacename : string

Type

string — is the name of the class namespace

$classname

$classname : string

Type

string — is the name of the class

$require

$require : \LinHUniX\Mcp\Model\array;

on this class need to set the number of the dependency need to use to work with this class ant that information was stored on $scopeCtl and share when execute this specific modules.

Type

\LinHUniX\Mcp\Model\array;

Inherited from: \LinHUniX\Mcp\Model\mcpBaseModelClass

Tags

example

$singleTon

$singleTon : boolean

Type

boolean — run only on start

$bootCtl

$bootCtl : array

Type

array — contains the info of the data class control

$bootData

$bootData : array

class.

Type

array — contains the boot data informations

$argCtl

$argCtl : array

used this to set Control Argument during run of the moduleCore.

Type

array

$argIn

$argIn : array

used this to set Input argument during run of the moduleCore.

Type

array

$argOut

$argOut : array

used this to set output argument during run of the moduleCore is present on the scope auto as $scopeOut["return"];.

Type

array

$mcp

$mcp : \LinHUniX\Mcp\masterControlProgram

need for the call back.

Type

\LinHUniX\Mcp\masterControlProgram

Methods

__construct()

__construct(\LinHUniX\Mcp\masterControlProgram  $mcp, array  $scopeCtl, array  $scopeIn)

__construct.

Parameters

\LinHUniX\Mcp\masterControlProgram	$mcp
array	$scopeCtl
array	$scopeIn

isLive()

isLive() : boolean

Check if pdo is live.

Returns

boolean —

status

real_escape_string()

real_escape_string(  $value,   $oldmethod = true)

Parameters

	$value
	$oldmethod

table_exist()

table_exist(mixed  $tablename) : boolean

table_exist Check if the table exists in the database.

Parameters

mixed

$tablename

Returns

boolean

intexec()

intexec(mixed  $query, mixed  $noupdate = false) : \LinHUniX\Pdo\Driver\any

intexec Direct PDO execution.

Parameters

mixed	$query
mixed	$noupdate	error

Returns

\LinHUniX\Pdo\Driver\any

rawexec()

rawexec(  $sql,   $noupdate = false) : \LinHUniX\Pdo\Driver\any

intexec Direct PDO execution.

Parameters

	$sql
	$noupdate

Returns

\LinHUniX\Pdo\Driver\any

execute()

execute(mixed  $sql, mixed  $var = array(), mixed  $noupdate = false,   $noquot = true) : boolean

execute.

Parameters

mixed	$sql
mixed	$var
mixed	$noupdate	error
	$noquot

Returns

boolean

executeWithRollback()

executeWithRollback(mixed  $sql, mixed  $var = array()) : array

executeWithRollback use the conventional pdo transaction esectution.

Parameters

mixed	$sql
mixed	$var

Returns

array

queryReturnResultSet()

queryReturnResultSet(mixed  $sql, mixed  $logging = false) : \LinHUniX\Pdo\Driver\statement

queryReturnResultSet Get Database Query Results.

Parameters

mixed	$sql
mixed	$logging

Returns

\LinHUniX\Pdo\Driver\statement

simpleQuery()

simpleQuery(mixed  $sql, mixed  $var = array(), mixed  $err = true, mixed  $fetchmode = null) : array

simpleQuery.

Parameters

mixed	$sql
mixed	$var
mixed	$err
mixed	$fetchmode

Returns

array

queryLabel()

queryLabel(mixed  $sql, mixed  $var = array(), mixed  $err = true) : array

simpleQuery.

Parameters

mixed	$sql
mixed	$var
mixed	$err

Returns

array

queryNoLabel()

queryNoLabel(mixed  $sql, mixed  $var = array(), mixed  $err = true) : array

simpleQuery.

Parameters

mixed	$sql
mixed	$var
mixed	$err

Returns

array

indexQuery()

indexQuery(string  $sql, string  $idfield = 'id', boolean  $sort = true) : array

indexed query function.

Parameters

string	$sql
string	$idfield	default = 'id'
boolean	$sort	default = true

Returns

array —

dataresult with index as $idfield

simpleCount()

simpleCount(mixed  $sql, mixed  $var = array(), mixed  $err = true) : \LinHUniX\Pdo\Driver\number

simpleCount.

Parameters

mixed	$sql
mixed	$var
mixed	$err

Returns

\LinHUniX\Pdo\Driver\number

getTable()

getTable(mixed  $sql,   $var = array(),   $err = true) : array

getTable simpleQuery alias.

Parameters

mixed	$sql
	$var
	$err

Returns

array

data_table()

data_table(mixed  $sql,   $var = array(),   $err = true) : array

getTable simpleQuery alias.

Parameters

mixed	$sql
	$var
	$err

Returns

array

dataWalk()

dataWalk(mixed  $sql, mixed  $callback, mixed  $var = array(), mixed  $funarr = array(), mixed  $err = true) : \LinHUniX\Pdo\Driver\any

dataWalk (use array_walk on result ).

Parameters

mixed	$sql
mixed	$callback
mixed	$var
mixed	$funarr
mixed	$err

Returns

\LinHUniX\Pdo\Driver\any

firstRow()

firstRow(mixed  $sql, mixed  $var = array(), mixed  $err = true) : array

firstRow show only the first record.

Parameters

mixed	$sql
mixed	$var
mixed	$err

Returns

array

firstRowField()

firstRowField(string  $sql, string  $idfield = 'id') : \LinHUniX\Pdo\Driver\string/null

function firstRowField reorder the result by the id.

Parameters

string	$sql
string	$idfield	default='id'

Returns

\LinHUniX\Pdo\Driver\string/null

data_row()

data_row(mixed  $sql, mixed  $var = array(), mixed  $err = true) : array

data_row (alias) firstRow show only the first record.

Parameters

mixed	$sql
mixed	$var
mixed	$err

Returns

array

delRow()

delRow(  $_table,   $_id)

Parameters

	$_table
	$_id

getRow()

getRow(  $fields,   $table,   $refid,   $idfield = 'id',   $compare = '=') : array

getRow.

Get Row from table

Parameters

	$fields
	$table
	$refid
	$idfield
	$compare

Returns

array

Inherited from: \LinHUniX\Pdo\Driver\pdoDriver

Tags

todo	need review

getRows()

getRows(mixed  $_fields, mixed  $_table, mixed  $_order_by, mixed  $_from, mixed  $_size, mixed  $_where_stmt = '', mixed  $id = 'id') : array

getRows.

Parameters

mixed	$_fields
mixed	$_table
mixed	$_order_by
mixed	$_from
mixed	$_size
mixed	$_where_stmt
mixed	$id

Returns

array

Inherited from: \LinHUniX\Pdo\Driver\pdoDriver

Tags

todo	need review

getLastError()

getLastError() : mixed

return the last error on pdo

Returns

mixed —

array/string

getLastRun()

getLastRun() : \LinHUniX\Pdo\Driver\any

getLastId.

Returns

\LinHUniX\Pdo\Driver\any

getLastId()

getLastId(mixed  $table, mixed  $id = 'id') : \LinHUniX\Pdo\Driver\any

getLastId.

Parameters

mixed	$table
mixed	$id

Returns

\LinHUniX\Pdo\Driver\any

setRow()

setRow(mixed  $_fields, mixed  $_table, mixed  $run = true,   $emptyval = false)

setRow Add/Update Row.

Parameters

mixed	$_fields
mixed	$_table
mixed	$run
	$emptyval

getSql()

getSql(  $_fields,   $_table,   $emptyval = false)

Parameters

	$_fields
	$_table
	$emptyval

getNames()

getNames(string  $dstname, string  $table, string  $srcname, string  $srcvalue) : \LinHUniX\Pdo\Driver\string/boolean

function getNames reorder the result by the id create 21/10/2019 - Andrea M. as ft compatibilty logic.

Parameters

string	$dstname
string	$table
string	$srcname
string	$srcvalue

Returns

\LinHUniX\Pdo\Driver\string/boolean

Inherited from: \LinHUniX\Pdo\Driver\pdoDriver

Tags

todo	need review

query()

query(mixed  $sql, mixed  $logging = false) : array

query simpleQuery alias.

Parameters

mixed	$sql
mixed	$logging

Returns

array

lastData()

lastData()

nextRow()

nextRow(  $statement = false)

Parameters

$statement

next_record()

next_record(  $statement = false)

Parameters

$statement

seek()

seek(  $position,   $statement = false)

Parameters

	$position
	$statement

freeresult()

freeresult(  $statement = false)

Parameters

$statement

numRows()

numRows(  $statement = false)

Parameters

$statement

affectedRows()

affectedRows(  $resultSet = false)

Parameters

$resultSet

num_rows()

num_rows(  $resultSet = false)

Parameters

$resultSet

getDependency()

getDependency() : array

Return a list of dependency need to used this class (cfg component).

Returns

array

run()

run(array  $scopeCtl, array  $scopeIn) : array

Model Base to caputer execute an elabotrations about this.

Parameters

array	$scopeCtl
array	$scopeIn

Returns

array —

response of code = like scope out;

listTable()

listTable()

SELECT name FROM sqlite_master WHERE type='table' ORDER BY name;

moduleCore()

moduleCore()

Ideally this method shuld be used to insert the model code and the other are to be used only as normal.

moduleInit()

moduleInit()

Pre init is a method to use on the new version.

getMcp()

getMcp() : \LinHUniX\Mcp\Model\lnxmcp

this a metod fo call the mcp class functions.

Returns

\LinHUniX\Mcp\Model\lnxmcp —

class

getRes()

getRes(string  $resname) : \LinHUniX\Mcp\Model\lnxmcp

this a metod fo call the mcp class functions.

Parameters

string

$resname

Returns

\LinHUniX\Mcp\Model\lnxmcp —

class

getCfg()

getCfg(  $cfgname) : \LinHUniX\Mcp\Model\lnxmcp

this a metod fo call the mcp class functions.

Parameters

$cfgname

Returns

\LinHUniX\Mcp\Model\lnxmcp —

class

getDriver()

getDriver(  $drvlabel) : \LinHUniX\Mcp\Model\lnxmcp

this a metod fo call the mcp class functions.

Parameters

$drvlabel

Returns

\LinHUniX\Mcp\Model\lnxmcp —

class

getCommon()

getCommon(  $name) : mixed

this a metod fo call the mcp class functions.

Parameters

$name

Returns

mixed

setCommon()

setCommon(  $name,   $value) : mixed

this a metod fo call the mcp class functions.

Parameters

	$name
	$value

Returns

mixed

setScopeOut()

setScopeOut(\LinHUniX\Mcp\Model\type  $name, \LinHUniX\Mcp\Model\type  $value)

Is a confortable method to set data on scope out.

Parameters

\LinHUniX\Mcp\Model\type	$name	of the tags
\LinHUniX\Mcp\Model\type	$value

callCmd()

callCmd(array  $scopeCtl, array  $scopeIn)

Parameters

array	$scopeCtl
array	$scopeIn

callTag()

callTag(  $action, array  $scopeIn,   $buffer = true)

Parameters

	$action
array	$scopeIn
	$buffer

setReturn()

setReturn(\LinHUniX\Mcp\Model\type  $return)

is a confortable method to set the return values.

Parameters

\LinHUniX\Mcp\Model\type

$return

moduleSingleTon()

moduleSingleTon()

Ideally this method shuld be used to insert the model code and the other are to be used only as normal.

getArgIn()

getArgIn(string  $name) : \LinHUniX\Mcp\Model\any

only to have a confortable solutions to get data.

Parameters

string

$name

Returns

\LinHUniX\Mcp\Model\any

getArgCtl()

getArgCtl(string  $name) : \LinHUniX\Mcp\Model\any

only to have a confortable solutions to get data.

Parameters

string

$name

Returns

\LinHUniX\Mcp\Model\any

getArgOut()

getArgOut(string  $name) : \LinHUniX\Mcp\Model\any

only to have a confortable solutions to get data.

Parameters

string

$name

Returns

\LinHUniX\Mcp\Model\any

setArgOut()

setArgOut(string  $name,   $value) : \LinHUniX\Mcp\Model\any

only to have a confortable solutions to set data.

Parameters

string	$name
	$value

Returns

\LinHUniX\Mcp\Model\any

debug()

debug(  $messge)

only to have a confortable solutions to debug data.

Parameters

$messge

info()

info(  $messge)

only to have a confortable solutions to debug data.

Parameters

$messge

warning()

warning(  $messge)

only to have a confortable solutions to debug data.

Parameters

$messge

error()

error(  $messge)

only to have a confortable solutions to debug data.

Parameters

$messge