DB_Sqlite_Tools
[ class tree: DB_Sqlite_Tools ] [ index: DB_Sqlite_Tools ] [ all elements ]
Packages:
DB_Sqlite_Tools


Classes:
DB_Sqlite_Tools
DB_Sqlite_Tools_ArcFour
DB_Sqlite_Tools_DBC
DB_Sqlite_Tools_LogObject
DB_Sqlite_Tools_XMLParser
Files:
ArcFour.php
DBC.php
generate_package_xml.php
Tools.php
XMLParser.php

Element index for package DB_Sqlite_Tools

[ a ] [ c ] [ d ] [ e ] [ f ] [ g ] [ i ] [ k ] [ l ] [ m ] [ r ] [ s ] [ t ] [ x ] [ _ ]

_

__autoload
in file Tools.php, function __autoload()
__construct
in file Tools.php, method DB_Sqlite_Tools_LogObject::__construct()
    Constructor.
__construct
in file XMLParser.php, method DB_Sqlite_Tools_XMLParser::__construct()
    Construct.
__construct
in file DBC.php, method DB_Sqlite_Tools_DBC::__construct()
    Constructor.
__construct
in file Tools.php, method DB_Sqlite_Tools::__construct()
    Instantiate a new SQLite_Tools Object Expects a db location or an array of db locations for multiple checks
__construct
in file ArcFour.php, method DB_Sqlite_Tools_ArcFour::__construct()
    Constructor
__destruct
in file DBC.php, method DB_Sqlite_Tools_DBC::__destruct()
    Destructor.
__toString
in file Tools.php, method DB_Sqlite_Tools_LogObject::__toString()
    Magic function, to print this object.
top

a

ArcFour.php
procedural page ArcFour.php
top

c

cacheSize
in file Tools.php, method DB_Sqlite_Tools::cacheSize()
    Check or set the cacheSize of the database.
checkIntegrity
in file Tools.php, method DB_Sqlite_Tools::checkIntegrity()
    Checks the database integrity does an integrity check of the entire
copySafe
in file Tools.php, method DB_Sqlite_Tools::copySafe()
    Safely duplicates a database file. copySafe should be performed before a backup as transfering via ftp or rsync.
createDBFromXML
in file Tools.php, method DB_Sqlite_Tools::createDBFromXML()
    Converts an XML exported database back to an Sqlite database
createXMLDumps
in file Tools.php, method DB_Sqlite_Tools::createXMLDumps()
    For each of the databases in our contructor array creates an XML dump including all the tables of that database.
crypt
in file ArcFour.php, method DB_Sqlite_Tools_ArcFour::crypt()
    Encrypt function.
top

d

$data
in file Tools.php, variable DB_Sqlite_Tools_LogObject::$data
    Log data or message.
$database
in file Tools.php, variable DB_Sqlite_Tools::$database
    List of databases.
$debug
in file Tools.php, variable DB_Sqlite_Tools::$debug
    Debug mode.
$debug
in file DBC.php, variable DB_Sqlite_Tools_DBC::$debug
    Whether turn on debug mode or not.
dbFileInfo
in file Tools.php, method DB_Sqlite_Tools::dbFileInfo()
    Retrieve general information on the database files like filename, owner id, group, name, permissions, library encoding and version, the size of the database, last time it was modified, blocks and generally every possible information on the database files.
DB_AUTOQUERY_INSERT
in file DBC.php, class constant DB_Sqlite_Tools_DBC::DB_AUTOQUERY_INSERT
    Insert mode constant.
DB_AUTOQUERY_UPDATE
in file DBC.php, class constant DB_Sqlite_Tools_DBC::DB_AUTOQUERY_UPDATE
    Update mode constant.
DB_Sqlite_Tools
in file Tools.php, class DB_Sqlite_Tools
    Class to manage sqlite database. An object-oriented interface to sqlite integrity check, optimizations and backup and export. It curently supports pragma integrity checks, cache values to optimize performance, synchronisation values for an higher integrity protection.
DBC.php
procedural page DBC.php
DB_Sqlite_Tools_ArcFour
in file ArcFour.php, class DB_Sqlite_Tools_ArcFour
    ArcFour stream cipher routines class.
DB_SQLITE_TOOLS_CCFL
in file Tools.php, class constant DB_Sqlite_Tools::DB_SQLITE_TOOLS_CCFL
DB_SQLITE_TOOLS_CCFS
in file Tools.php, class constant DB_Sqlite_Tools::DB_SQLITE_TOOLS_CCFS
DB_SQLITE_TOOLS_CCLXML
in file Tools.php, class constant DB_Sqlite_Tools::DB_SQLITE_TOOLS_CCLXML
DB_SQLITE_TOOLS_CCXML
in file Tools.php, class constant DB_Sqlite_Tools::DB_SQLITE_TOOLS_CCXML
DB_SQLITE_TOOLS_CLF
in file Tools.php, class constant DB_Sqlite_Tools::DB_SQLITE_TOOLS_CLF
DB_SQLITE_TOOLS_CLFS
in file Tools.php, class constant DB_Sqlite_Tools::DB_SQLITE_TOOLS_CLFS
DB_SQLITE_TOOLS_COD
in file Tools.php, class constant DB_Sqlite_Tools::DB_SQLITE_TOOLS_COD
    Error handling related Constants
DB_SQLITE_TOOLS_COFL
in file Tools.php, class constant DB_Sqlite_Tools::DB_SQLITE_TOOLS_COFL
DB_SQLITE_TOOLS_CSD
in file Tools.php, class constant DB_Sqlite_Tools::DB_SQLITE_TOOLS_CSD
DB_SQLITE_TOOLS_CSF
in file Tools.php, class constant DB_Sqlite_Tools::DB_SQLITE_TOOLS_CSF
DB_SQLITE_TOOLS_CUFS
in file Tools.php, class constant DB_Sqlite_Tools::DB_SQLITE_TOOLS_CUFS
DB_Sqlite_Tools_DBC
in file DBC.php, class DB_Sqlite_Tools_DBC
    This class, part of DB_Sqlite_Tools allows to insert on an sqlite database
DB_SQLITE_TOOLS_INSC
in file Tools.php, class constant DB_Sqlite_Tools::DB_SQLITE_TOOLS_INSC
DB_Sqlite_Tools_LogObject
in file Tools.php, class DB_Sqlite_Tools_LogObject
    A class provides few function for working with the event log.
DB_SQLITE_TOOLS_NAR
in file Tools.php, class constant DB_Sqlite_Tools::DB_SQLITE_TOOLS_NAR
DB_SQLITE_TOOLS_NAV
in file Tools.php, class constant DB_Sqlite_Tools::DB_SQLITE_TOOLS_NAV
DB_SQLITE_TOOLS_NNU
in file Tools.php, class constant DB_Sqlite_Tools::DB_SQLITE_TOOLS_NNU
DB_SQLITE_TOOLS_QNR
in file Tools.php, class constant DB_Sqlite_Tools::DB_SQLITE_TOOLS_QNR
DB_SQLITE_TOOLS_QRS
in file Tools.php, class constant DB_Sqlite_Tools::DB_SQLITE_TOOLS_QRS
DB_SQLITE_TOOLS_RSE
in file Tools.php, class constant DB_Sqlite_Tools::DB_SQLITE_TOOLS_RSE
DB_Sqlite_Tools_XMLParser
in file XMLParser.php, class DB_Sqlite_Tools_XMLParser
    Alpha version of the XML parser to be possibly replaced by a proper parse or extension as suggested by Stephan Schimdt.
DB_STRING_DELIMITER
in file DBC.php, class constant DB_Sqlite_Tools_DBC::DB_STRING_DELIMITER
    Delimiter for autoExec.
decrypt
in file ArcFour.php, method DB_Sqlite_Tools_ArcFour::decrypt()
    Decrypt function.
top

e

$element
in file XMLParser.php, variable DB_Sqlite_Tools_XMLParser::$element
    Current parse element.
$email
in file Tools.php, variable DB_Sqlite_Tools::$email
$enclosed
in file XMLParser.php, variable DB_Sqlite_Tools_XMLParser::$enclosed
    Enclosed element.
top

f

$fh
in file XMLParser.php, variable DB_Sqlite_Tools_XMLParser::$fh
    File resource handler.
ftpBackup
in file Tools.php, method DB_Sqlite_Tools::ftpBackup()
    Safely copy the backup db to a remote ftp server. this function can be called only after a copySafe operation is performed.
top

g

generate_package_xml.php
procedural page generate_package_xml.php
getElement
in file XMLParser.php, method DB_Sqlite_Tools_XMLParser::getElement()
    Get the element.
getElementAttribute
in file XMLParser.php, method DB_Sqlite_Tools_XMLParser::getElementAttribute()
getElementName
in file XMLParser.php, method DB_Sqlite_Tools_XMLParser::getElementName()
getEnclosed
in file XMLParser.php, method DB_Sqlite_Tools_XMLParser::getEnclosed()
getNextElement
in file XMLParser.php, method DB_Sqlite_Tools_XMLParser::getNextElement()
top

i

$ignoreList
in file XMLParser.php, variable DB_Sqlite_Tools_XMLParser::$ignoreList
    List of elements to ignore.
ignore
in file XMLParser.php, method DB_Sqlite_Tools_XMLParser::ignore()
    Add $str to ignore list.
top

k

$key
in file DBC.php, variable DB_Sqlite_Tools_DBC::$key
    An encryption key.
top

l

liteAll
in file DBC.php, method DB_Sqlite_Tools_DBC::liteAll()
    Executes the query and return the decrypted results ALL the objects in an array.
liteautoExec
in file DBC.php, method DB_Sqlite_Tools_DBC::liteautoExec()
    Auto Execute an insert or update query.
liteAutoFetch
in file DBC.php, method DB_Sqlite_Tools_DBC::liteAutoFetch()
    Executes the query and return the decrypted results single object if available.
liteConnect
in file DBC.php, method DB_Sqlite_Tools_DBC::liteConnect()
    Connects to the Sqlite DB.
liteLastError
in file DBC.php, method DB_Sqlite_Tools_DBC::liteLastError()
    returns the last DB error string.
liteLastID
in file DBC.php, method DB_Sqlite_Tools_DBC::liteLastID()
    Returns the last inserted row id.
liteQuery
in file DBC.php, method DB_Sqlite_Tools_DBC::liteQuery()
    Executes the query and return the results objects if available.
localBackup
in file Tools.php, method DB_Sqlite_Tools::localBackup()
    Creates a local backup of the database file and checks for its integrity.
localRsync
in file Tools.php, method DB_Sqlite_Tools::localRsync()
    Initiaties a local rsync of a given database path requires rsync installed locally.
top

m

$matrix
in file DBC.php, variable DB_Sqlite_Tools_DBC::$matrix
    ArcFour crypt object.
top

r

$result
in file DBC.php, variable DB_Sqlite_Tools_DBC::$result
    The results object.
remoteRsync
in file Tools.php, method DB_Sqlite_Tools::remoteRsync()
    remoteRsync prepared the server where this package is running to receive read connections over rsync for the purpose of remote synchronisation.
top

s

$showLogs
in file Tools.php, variable DB_Sqlite_Tools::$showLogs
    If true, shows logs as they are added to DB.
safeQuote
in file DBC.php, method DB_Sqlite_Tools_DBC::safeQuote()
    Safety value(s) for query execution.
setKey
in file ArcFour.php, method DB_Sqlite_Tools_ArcFour::setKey()
    Set the encryption key.
sqliteLogs
in file Tools.php, method DB_Sqlite_Tools::sqliteLogs()
    Logs all the perfomed action in a database log this includes backups, integrity checks each of the integrity queries. Verbose XML style output for each of the actions.
sync
in file Tools.php, method DB_Sqlite_Tools::sync()
    Check or set the synchronous value for the database.
top

t

Tools.php
procedural page Tools.php
toHTML
in file Tools.php, method DB_Sqlite_Tools_LogObject::toHTML()
    Creates a HTML representation of event log.
toText
in file Tools.php, method DB_Sqlite_Tools_LogObject::toText()
    Creates a plain-text representation of event log.
toXML
in file Tools.php, method DB_Sqlite_Tools_LogObject::toXML()
    Creates an XML representation of event log.
top

x

XMLParser.php
procedural page XMLParser.php
XMLDecode
in file Tools.php, method DB_Sqlite_Tools::XMLDecode()
    Decodes the XML content.
XMLEncode
in file Tools.php, method DB_Sqlite_Tools::XMLEncode()
    Encodes the XML content.
top
Documentation generated on Mon, 11 Mar 2019 15:39:04 -0400 by phpDocumentor 1.4.4. PEAR Logo Copyright © PHP Group 2004.