TeraWurflDatabase
[ class tree: TeraWurflDatabase ] [ index: TeraWurflDatabase ] [ all elements ]

Class: TeraWurflDatabase_MySQL5_Profiling

Source Location: /DatabaseConnectors/TeraWurflDatabase_MySQL5_Profiling.php

Class Overview

TeraWurflDatabase
   |
   --TeraWurflDatabase_MySQL5
      |
      --TeraWurflDatabase_MySQL5_Profiling

Provides connectivity from Tera-WURFL to MySQL 5


Variables

Methods


Inherited Variables

Inherited Methods

Class: TeraWurflDatabase_MySQL5

TeraWurflDatabase_MySQL5::__construct()
TeraWurflDatabase_MySQL5::atomicRenameAll()
TeraWurflDatabase_MySQL5::cleanConnection()
TeraWurflDatabase_MySQL5::clearMatcherTables()
Drops then creates all the UserAgentMatcher device tables
TeraWurflDatabase_MySQL5::clearTable()
TeraWurflDatabase_MySQL5::connect()
TeraWurflDatabase_MySQL5::createCacheTable()
TeraWurflDatabase_MySQL5::createGenericDeviceTable()
Drops and creates the given device table
TeraWurflDatabase_MySQL5::createIndexTable()
Drops and creates the index table
TeraWurflDatabase_MySQL5::createMergeTable()
Drops and creates the MERGE table
TeraWurflDatabase_MySQL5::createProcedures()
TeraWurflDatabase_MySQL5::createSettingsTable()
Creates the settings table if it does not already exist
TeraWurflDatabase_MySQL5::createTempCacheTable()
TeraWurflDatabase_MySQL5::extensionLoaded()
Returns true if the required extensions for this database connector are loaded
TeraWurflDatabase_MySQL5::getActualDeviceAncestor()
TeraWurflDatabase_MySQL5::getCachedUserAgents()
TeraWurflDatabase_MySQL5::getDeviceFallBackTree()
TeraWurflDatabase_MySQL5::getDeviceFallBackTree_NS()
Returns an Array containing the complete capabilities array for each
TeraWurflDatabase_MySQL5::getDeviceFromCache()
TeraWurflDatabase_MySQL5::getDeviceFromID()
TeraWurflDatabase_MySQL5::getDeviceFromUA()
TeraWurflDatabase_MySQL5::getDeviceFromUA_LD()
TeraWurflDatabase_MySQL5::getDeviceFromUA_RIS()
TeraWurflDatabase_MySQL5::getFullDeviceList()
TeraWurflDatabase_MySQL5::getMatcherTableList()
TeraWurflDatabase_MySQL5::getServerVersion()
TeraWurflDatabase_MySQL5::getSetting()
TeraWurflDatabase_MySQL5::getTableList()
TeraWurflDatabase_MySQL5::getTableStats()
TeraWurflDatabase_MySQL5::loadDevices()
TeraWurflDatabase_MySQL5::rebuildCacheTable()
TeraWurflDatabase_MySQL5::saveDeviceInCache()
TeraWurflDatabase_MySQL5::SQLPrep()
TeraWurflDatabase_MySQL5::updateSetting()
TeraWurflDatabase_MySQL5::verifyConfig()
TeraWurflDatabase_MySQL5::__destruct()
Destructor, disconnect from database

Class: TeraWurflDatabase

TeraWurflDatabase::__construct()
TeraWurflDatabase::atomicRenameAll()
Rename all tables from $oldPrefix to $newPrefix in one transaction. This is used when loading the WURFL device data to atomically switch from the old data to the new data.
TeraWurflDatabase::clearTable()
Truncate or drop+create the given table
TeraWurflDatabase::connect()
Establishes a database connection and stores connection in $this->dbcon
TeraWurflDatabase::createCacheTable()
Creates the cache table
TeraWurflDatabase::createGenericDeviceTable()
Creates a table capable of holding devices (WURFL ID, User Agent and Capabilities)
TeraWurflDatabase::createIndexTable()
Creates the index table
TeraWurflDatabase::createProcedures()
Creates supporting stored procedures
TeraWurflDatabase::createSettingsTable()
Creates the settings table
TeraWurflDatabase::getActualDeviceAncestor()
Returns the WURFL ID for the Actual Device Root in the given device's fall back tree. This can be null if it does not exist.
TeraWurflDatabase::getCachedUserAgents()
Returns an array of the cached User Agents
TeraWurflDatabase::getDeviceFallBackTree()
Returns the Fallback tree directly from the database. If this is implemented, you must set TeraWurflDatabase::$db_implements_fallback = true for Tera-WURFL to use it.
TeraWurflDatabase::getDeviceFromCache()
Return capabilities array for the given User Agent, or null if not found
TeraWurflDatabase::getDeviceFromID()
Returns the capabilities array from a given WURFL Device ID. This is NOT the full device capabilities, just the capabilities that are defined on this device.
TeraWurflDatabase::getDeviceFromUA()
Returns the WURFL ID from a raw User Agent if an exact match is found
TeraWurflDatabase::getDeviceFromUA_LD()
Find the matching Device ID for a given User Agent using LD (Leveshtein Distance)
TeraWurflDatabase::getDeviceFromUA_RIS()
Find the matching Device ID for a given User Agent using RIS (Reduction in String)
TeraWurflDatabase::getFullDeviceList()
Returns an associative array of all the data from the given table in the form [WURFL ID] => [User Agent]
TeraWurflDatabase::getLastError()
Returns the most recent error message
TeraWurflDatabase::getMatcherTableList()
Returns an array of the User Agent Matcher tables in the database
TeraWurflDatabase::getServerVersion()
Returns the version string of the database server
TeraWurflDatabase::getSetting()
Get setting from settings table by a given key
TeraWurflDatabase::getTableList()
Returns an array of all the tables in the database
TeraWurflDatabase::getTableStats()
Returns an associative array of statistics from given table
TeraWurflDatabase::initializeDB()
Drops and recreates the current database and procedures
TeraWurflDatabase::isNumericSafe()
Returns true if the value is numeric. Unlike is_numeric, this functions returns
TeraWurflDatabase::loadDevices()
Loads the pre-processed WURFL tables into the database
TeraWurflDatabase::rebuildCacheTable()
Rebuilds the cache table by redetecting the cached devices against the loaded WURFL
TeraWurflDatabase::saveDeviceInCache()
Save the given User Agent and Device capabilities array to the database
TeraWurflDatabase::SQLPrep()
Prepares raw text for use in queries (adding quotes and escaping characters if necessary)
TeraWurflDatabase::updateSetting()
Adds/updates a key=>value pair in the settings table
TeraWurflDatabase::verifyConfig()
Checks if the database configuration is correct and that all required permissions

Class Details

[line 31]
Provides connectivity from Tera-WURFL to MySQL 5

This "Profiling" connector logs profile data from MySQL during its queries




[ Top ]


Class Variables

$profiler =

[line 36]



Tags:

access:  protected

Type:   phpMyProfiler


[ Top ]

$profile_log =  "/tmp/TeraWurflProfile-"

[line 41]

The path and file prefix to use for storing MySQL Query Profiles



Tags:

access:  protected

Type:   string


[ Top ]



Class Methods


method connect [line 45]

void connect( )

Establishes connection to database (does not check for DB sanity)



Tags:

access:  public


Overrides TeraWurflDatabase_MySQL5::connect() (parent method not documented)

[ Top ]

method getDeviceFromUA_RIS [line 49]

void getDeviceFromUA_RIS( $userAgent, $tolerance, UserAgentMatcher $matcher)



Tags:

access:  public


Overrides TeraWurflDatabase_MySQL5::getDeviceFromUA_RIS() (parent method not documented)

Parameters:

   $userAgent  
   $tolerance  
UserAgentMatcher   $matcher  

[ Top ]


Documentation generated on Thu, 03 Oct 2013 15:19:19 -0400 by phpDocumentor 1.4.4