TeraWurflDatabase
[ class tree: TeraWurflDatabase ] [ index: TeraWurflDatabase ] [ all elements ]
Packages:
default
HttpHeaderNormalizers
TeraWurfHttpRequest
TeraWurfl
TeraWurflDatabase
TeraWurflExceptions
TeraWurflRemoteClient
TeraWurflUserAgentMatchers
TeraWurflUtils
TeraWurflXMLParser
WURFL
WURFL_Database
WURFL_HttpHeaderNormalizers
WURFL_RemoteClient
WURFL_TeraWurflHttpRequest
WURFL_UserAgentMatcher
WURFL_XMLParser


Classes:
TeraWurflDatabase
TeraWurflDatabase_MongoDB
TeraWurflDatabase_MSSQL2005
TeraWurflDatabase_MySQL4
TeraWurflDatabase_MySQL5
TeraWurflDatabase_MySQL5_NestedSet
TeraWurflDatabase_MySQL5_Profiling
TeraWurflDatabase_PDO
TeraWurflDatabase_PDO_NestedSet
TeraWurflMySQLNestedSet
TeraWurflPDONestedSet

Class: TeraWurflDatabase

Source Location: /DatabaseConnectors/TeraWurflDatabase.php

Class Overview




Abstract class to provide a skeleton for the Tera-WURFL database connectors.




Author(s):


    
        





    

        




Variables







Methods















Child classes:






TeraWurflDatabase_MySQL4

	
Provides connectivity from Tera-WURFL to MySQL 4.  This connector is also compatible with MySQL 5.






TeraWurflDatabase_MySQL5

	
Provides connectivity from Tera-WURFL to MySQL 5






TeraWurflDatabase_PDO

	
Provides connectivity from Tera-WURFL to MySQL 5 using PDO_MySQL






TeraWurflDatabase_MSSQL2005

	
Provides connectivity from Tera-WURFL to Microsoft SQL Server 2005/2008






TeraWurflDatabase_MongoDB

	
Provides connectivity from Tera-WURFL to MongoDB

















Class Details



[line 28]

Abstract class to provide a skeleton for the Tera-WURFL database connectors.





Tags:





  

    abstract:  
  










[ Top ]







Class Variables



	
	

	
static $CONNECTION_CHARSET =  'utf8'

	
[line 86]

  The charset to use for the connection between PHP and the database





Tags:





  

    access:  public
  






  

	

  

    

      Type:  
      string
    

      

	



	
[ Top ]


	
	

	
static $DB_TEMP_EXT =  "_TEMP"

	
[line 81]

  Database table name extension for temporary tables





Tags:





  

    access:  public
  






  

	

  

    

      Type:  
      string
    

      

	



	
[ Top ]


	
	

	
$connected =  false

	
[line 71]

  True if connection to database is active





Tags:





  

    access:  public
  






  

	

  

    

      Type:  
      bool
    

      

	



	
[ Top ]


	
	

	
$dbcon = 

	
[line 76]

  Raw database connection





Tags:





  

    access:  protected
  






  

	

  

    

      Type:  
      database_object
    

      

	



	
[ Top ]


	
	

	
$db_implements_atomic_rename =  false

	
[line 56]

  Database connector can rename all tables in one transaction





Tags:





  

    access:  public
  






  

	

  

    

      Type:  
      bool
    

      

	



	
[ Top ]


	
	

	
$db_implements_fallback =  false

	
[line 51]

  Database connector implements the building of a fallback tree directly





Tags:





  

    access:  public
  






  

	

  

    

      Type:  
      bool
    

      

	



	
[ Top ]


	
	

	
$db_implements_ld =  false

	
[line 46]

  Database connector implements the LD search function directly





Tags:





  

    access:  public
  






  

	

  

    

      Type:  
      bool
    

      

	



	
[ Top ]


	
	

	
$db_implements_ris =  false

	
[line 41]

  Database connector implements the RIS search function directly





Tags:





  

    access:  public
  






  

	

  

    

      Type:  
      bool
    

      

	



	
[ Top ]


	
	

	
$errors = 

	
[line 36]

  Errors





Tags:





  

    access:  public
  






  

	

  

    

      Type:  
      array
    

      

	



	
[ Top ]


	
	

	
$numQueries =  0

	
[line 61]

  Number of queries to database





Tags:





  

    access:  public
  






  

	

  

    

      Type:  
      int
    

      

	



	
[ Top ]


	
	

	
$tablename = 

	
[line 66]

  Full table name to use for the search functions





Tags:





  

    access:  public
  






  

	

  

    

      Type:  
      string
    

      

	



	
[ Top ]










Class Methods




  

	
	
constructor __construct [line 88]

	

    

    

		TeraWurflDatabase __construct(
)
    

    


	
		



Tags:





  

    access:  public
  









	
Overridden in child classes as:

		

	
TeraWurflDatabase_MySQL4::__construct()

		

	

		

	
TeraWurflDatabase_MySQL5::__construct()

		

	

		

	
TeraWurflDatabase_PDO::__construct()

		

	

		

	
TeraWurflDatabase_MSSQL2005::__construct()

		

	

		

	
TeraWurflDatabase_MongoDB::__construct()

		

	

	

	
        
[ Top ]

  

  

	
	
method atomicRenameAll [line 149]

	

    

    

		void atomicRenameAll(
string
$oldPrefix, string
$newPrefix)
    

    


	
		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.

NOTE: the Cache table is not renamed since it is converted at a later stage





Tags:





  

    access:  public
  









	
Overridden in child classes as:

		

	
TeraWurflDatabase_MySQL5::atomicRenameAll()

		

	

	

	
        
Parameters:

    

    

          

        string  
        $oldPrefix  
        
      

          

        string  
        $newPrefix  
        
      

        

    


        
[ Top ]

  

  

	
	
method clearTable [line 206]

	

    

    

		bool clearTable(
string
$tablename)
    

    


	
		Truncate or drop+create the given table





Tags:





  

    return:  Success
  

  

    abstract:  
  

  

    access:  public
  









	
Overridden in child classes as:

		

	
TeraWurflDatabase_MySQL4::clearTable()

		

	

		

	
TeraWurflDatabase_MySQL5::clearTable()

		

	

		

	
TeraWurflDatabase_PDO::clearTable()

		

	

		

	
TeraWurflDatabase_MSSQL2005::clearTable()

		

	

		

	
TeraWurflDatabase_MongoDB::clearTable()

		
Methods enforced by parent class, but not used for this connector

	

	

	
        
Parameters:

    

    

          

        string  
        $tablename  
        
      

        

    


        
[ Top ]

  

  

	
	
method connect [line 211]

	

    

    

		bool connect(
)
    

    


	
		Establishes a database connection and stores connection in $this->dbcon





Tags:





  

    return:  Success
  

  

    abstract:  
  

  

    access:  public
  









	
Overridden in child classes as:

		

	
TeraWurflDatabase_MySQL4::connect()

		

	

		

	
TeraWurflDatabase_MySQL5::connect()

		

	

		

	
TeraWurflDatabase_MySQL5_Profiling::connect()

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

	

		

	
TeraWurflDatabase_PDO::connect()

		

	

		

	
TeraWurflDatabase_MSSQL2005::connect()

		

	

		

	
TeraWurflDatabase_MongoDB::connect()

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

	

	

	
        
[ Top ]

  

  

	
	
method createCacheTable [line 183]

	

    

    

		bool createCacheTable(
)
    

    


	
		Creates the cache table





Tags:





  

    return:  Success
  

  

    abstract:  
  

  

    access:  public
  









	
Overridden in child classes as:

		

	
TeraWurflDatabase_MySQL4::createCacheTable()

		

	

		

	
TeraWurflDatabase_MySQL5::createCacheTable()

		

	

		

	
TeraWurflDatabase_PDO::createCacheTable()

		

	

		

	
TeraWurflDatabase_MSSQL2005::createCacheTable()

		

	

		

	
TeraWurflDatabase_MongoDB::createCacheTable()

		
Drops, creates and indexes the cache table

	

	

	
        
[ Top ]

  

  

	
	
method createGenericDeviceTable [line 161]

	

    

    

		bool createGenericDeviceTable(
string
$tablename)
    

    


	
		Creates a table capable of holding devices (WURFL ID, User Agent and Capabilities)





Tags:





  

    return:  Success
  

  

    abstract:  
  

  

    access:  public
  









	
Overridden in child classes as:

		

	
TeraWurflDatabase_MySQL4::createGenericDeviceTable()

		
Drops and creates the given device table

	

		

	
TeraWurflDatabase_MySQL5::createGenericDeviceTable()

		
Drops and creates the given device table

	

		

	
TeraWurflDatabase_PDO::createGenericDeviceTable()

		
Drops and creates the given device table

	

		

	
TeraWurflDatabase_MSSQL2005::createGenericDeviceTable()

		
Drops and creates the given device table

	

		

	
TeraWurflDatabase_MongoDB::createGenericDeviceTable()

		
Methods enforced by parent class, but not used for this connector

	

	

	
        
Parameters:

    

    

          

        string  
        $tablename  
        Name of the table
      

        

    


        
[ Top ]

  

  

	
	
method createIndexTable [line 195]

	

    

    

		bool createIndexTable(
)
    

    


	
		Creates the index table





Tags:





  

    return:  success
  

  

    abstract:  
  

  

    access:  public
  









	
Overridden in child classes as:

		

	
TeraWurflDatabase_MySQL4::createIndexTable()

		
Drops and creates the index table

	

		

	
TeraWurflDatabase_MySQL5::createIndexTable()

		
Drops and creates the index table

	

		

	
TeraWurflDatabase_PDO::createIndexTable()

		
Drops and creates the index table

	

		

	
TeraWurflDatabase_MSSQL2005::createIndexTable()

		
Drops and creates the index table

	

		

	
TeraWurflDatabase_MongoDB::createIndexTable()

		
Methods enforced by parent class, but not used for this connector

	

	

	
        
[ Top ]

  

  

	
	
method createProcedures [line 233]

	

    

    

		bool createProcedures(
)
    

    


	
		Creates supporting stored procedures





Tags:





  

    return:  Success
  

  

    access:  public
  









	
Overridden in child classes as:

		

	
TeraWurflDatabase_MySQL5::createProcedures()

		

	

		

	
TeraWurflDatabase_PDO::createProcedures()

		

	

		

	
TeraWurflDatabase_MSSQL2005::createProcedures()

		

	

		

	
TeraWurflDatabase_MongoDB::createProcedures()

		
Runs any stored procs needed to set up db

	

	

	
        
[ Top ]

  

  

	
	
method createSettingsTable [line 200]

	

    

    

		bool createSettingsTable(
)
    

    


	
		Creates the settings table





Tags:





  

    return:  success
  

  

    abstract:  
  

  

    access:  public
  









	
Overridden in child classes as:

		

	
TeraWurflDatabase_MySQL4::createSettingsTable()

		
Creates the settings table if it does not already exist

	

		

	
TeraWurflDatabase_MySQL5::createSettingsTable()

		
Creates the settings table if it does not already exist

	

		

	
TeraWurflDatabase_PDO::createSettingsTable()

		
Creates the settings table if it does not already exist

	

		

	
TeraWurflDatabase_MSSQL2005::createSettingsTable()

		
Creates the settings table if it does not already exist

	

		

	
TeraWurflDatabase_MongoDB::createSettingsTable()

		

	

	

	
        
[ Top ]

  

  

	
	
method getActualDeviceAncestor [line 106]

	

    

    

		string getActualDeviceAncestor(
string
$wurflID)
    

    


	
		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.





Tags:





  

    return:  WURFL ID
  

  

    abstract:  
  

  

    access:  public
  









	
Overridden in child classes as:

		

	
TeraWurflDatabase_MySQL4::getActualDeviceAncestor()

		

	

		

	
TeraWurflDatabase_MySQL5::getActualDeviceAncestor()

		

	

		

	
TeraWurflDatabase_PDO::getActualDeviceAncestor()

		

	

		

	
TeraWurflDatabase_MSSQL2005::getActualDeviceAncestor()

		

	

		

	
TeraWurflDatabase_MongoDB::getActualDeviceAncestor()

		
Methods enforced by parent class, but not used for this connector

	

	

	
        
Parameters:

    

    

          

        string  
        $wurflID  
        WURFL ID
      

        

    


        
[ Top ]

  

  

	
	
method getCachedUserAgents [line 260]

	

    

    

		array getCachedUserAgents(
)
    

    


	
		Returns an array of the cached User Agents





Tags:





  

    abstract:  
  

  

    access:  public
  









	
Overridden in child classes as:

		

	
TeraWurflDatabase_MySQL4::getCachedUserAgents()

		

	

		

	
TeraWurflDatabase_MySQL5::getCachedUserAgents()

		

	

		

	
TeraWurflDatabase_PDO::getCachedUserAgents()

		

	

		

	
TeraWurflDatabase_MSSQL2005::getCachedUserAgents()

		

	

		

	
TeraWurflDatabase_MongoDB::getCachedUserAgents()

		

	

	

	
        
[ Top ]

  

  

	
	
method getDeviceFallBackTree [line 141]

	

    

    

		array getDeviceFallBackTree(
string
$wurflID)
    

    


	
		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.





Tags:





  

    return:  Each device's partial capabilities that the given device falls back on, in order
  

  

    access:  public
  









	
Overridden in child classes as:

		

	
TeraWurflDatabase_MySQL5::getDeviceFallBackTree()

		

	

		

	
TeraWurflDatabase_PDO::getDeviceFallBackTree()

		

	

		

	
TeraWurflDatabase_MongoDB::getDeviceFallBackTree()

		

	

	

	
        
Parameters:

    

    

          

        string  
        $wurflID  
        WURFL ID
      

        

    


        
[ Top ]

  

  

	
	
method getDeviceFromCache [line 171]

	

    

    

		array getDeviceFromCache(
string
$userAgent)
    

    


	
		Return capabilities array for the given User Agent, or null if not found





Tags:





  

    return:  Capabilities
  

  

    abstract:  
  

  

    access:  public
  









	
Overridden in child classes as:

		

	
TeraWurflDatabase_MySQL4::getDeviceFromCache()

		

	

		

	
TeraWurflDatabase_MySQL5::getDeviceFromCache()

		

	

		

	
TeraWurflDatabase_PDO::getDeviceFromCache()

		

	

		

	
TeraWurflDatabase_MSSQL2005::getDeviceFromCache()

		

	

		

	
TeraWurflDatabase_MongoDB::getDeviceFromCache()

		

	

	

	
        
Parameters:

    

    

          

        string  
        $userAgent  
        
      

        

    


        
[ Top ]

  

  

	
	
method getDeviceFromID [line 100]

	

    

    

		array getDeviceFromID(
string
$wurflID)
    

    


	
		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.





Tags:





  

    return:  Device capabilities
  

  

    abstract:  
  

  

    access:  public
  









	
Overridden in child classes as:

		

	
TeraWurflDatabase_MySQL4::getDeviceFromID()

		

	

		

	
TeraWurflDatabase_MySQL5::getDeviceFromID()

		

	

		

	
TeraWurflDatabase_PDO::getDeviceFromID()

		

	

		

	
TeraWurflDatabase_MSSQL2005::getDeviceFromID()

		

	

		

	
TeraWurflDatabase_MongoDB::getDeviceFromID()

		

	

	

	
        
Parameters:

    

    

          

        string  
        $wurflID  
        WURFL ID
      

        

    


        
[ Top ]

  

  

	
	
method getDeviceFromUA [line 118]

	

    

    

		string getDeviceFromUA(
string
$userAgent)
    

    


	
		Returns the WURFL ID from a raw User Agent if an exact match is found





Tags:





  

    return:  WURFL ID
  

  

    abstract:  
  

  

    access:  public
  









	
Overridden in child classes as:

		

	
TeraWurflDatabase_MySQL4::getDeviceFromUA()

		

	

		

	
TeraWurflDatabase_MySQL5::getDeviceFromUA()

		

	

		

	
TeraWurflDatabase_PDO::getDeviceFromUA()

		

	

		

	
TeraWurflDatabase_MSSQL2005::getDeviceFromUA()

		

	

		

	
TeraWurflDatabase_MongoDB::getDeviceFromUA()

		

	

	

	
        
Parameters:

    

    

          

        string  
        $userAgent  
        
      

        

    


        
[ Top ]

  

  

	
	
method getDeviceFromUA_LD [line 134]

	

    

    

		string getDeviceFromUA_LD(
string
$userAgent, integer
$tolerance, UserAgentMatcher
&$matcher, UserAgentMatcher
$matcher)
    

    


	
		Find the matching Device ID for a given User Agent using LD (Leveshtein Distance)





Tags:





  

    return:  WURFL ID
  

  

    access:  public
  









	
Overridden in child classes as:

		

	
TeraWurflDatabase_MySQL5::getDeviceFromUA_LD()

		

	

		

	
TeraWurflDatabase_PDO::getDeviceFromUA_LD()

		

	

		

	
TeraWurflDatabase_MSSQL2005::getDeviceFromUA_LD()

		

	

		

	
TeraWurflDatabase_MongoDB::getDeviceFromUA_LD()

		

	

	

	
        
Parameters:

    

    

          

        string  
        $userAgent  
        User Agent
      

          

        integer  
        $tolerance  
        Tolerance that is still considered a match
      

          

        UserAgentMatcher  
        $matcher  
        The UserAgentMatcherInstance that is matching the User Agent
      

          

        UserAgentMatcher  
        &$matcher  
        
      

        

    


        
[ Top ]

  

  

	
	
method getDeviceFromUA_RIS [line 126]

	

    

    

		string getDeviceFromUA_RIS(
string
$userAgent, integer
$tolerance, UserAgentMatcher
&$matcher, UserAgentMatcher
$matcher)
    

    


	
		Find the matching Device ID for a given User Agent using RIS (Reduction in String)





Tags:





  

    return:  WURFL ID
  

  

    access:  public
  









	
Overridden in child classes as:

		

	
TeraWurflDatabase_MySQL5::getDeviceFromUA_RIS()

		

	

		

	
TeraWurflDatabase_MySQL5_Profiling::getDeviceFromUA_RIS()

		

	

		

	
TeraWurflDatabase_MySQL5_Debug::getDeviceFromUA_RIS()

		

	

		

	
TeraWurflDatabase_PDO::getDeviceFromUA_RIS()

		

	

		

	
TeraWurflDatabase_MSSQL2005::getDeviceFromUA_RIS()

		

	

		

	
TeraWurflDatabase_MongoDB::getDeviceFromUA_RIS()

		
RIS == Reduction in String (reduce string one char at a time)

	

	

	
        
Parameters:

    

    

          

        string  
        $userAgent  
        User Agent
      

          

        integer  
        $tolerance  
        How short the strings are allowed to get before a match is abandoned
      

          

        UserAgentMatcher  
        $matcher  
        The UserAgentMatcherInstance that is matching the User Agent
      

          

        UserAgentMatcher  
        &$matcher  
        
      

        

    


        
[ Top ]

  

  

	
	
method getFullDeviceList [line 112]

	

    

    

		array getFullDeviceList(
string
$tablename)
    

    


	
		Returns an associative array of all the data from the given table in the form [WURFL ID] => [User Agent]





Tags:





  

    abstract:  
  

  

    access:  public
  









	
Overridden in child classes as:

		

	
TeraWurflDatabase_MySQL4::getFullDeviceList()

		

	

		

	
TeraWurflDatabase_MySQL5::getFullDeviceList()

		

	

		

	
TeraWurflDatabase_PDO::getFullDeviceList()

		

	

		

	
TeraWurflDatabase_MSSQL2005::getFullDeviceList()

		

	

		

	
TeraWurflDatabase_MongoDB::getFullDeviceList()

		

	

	

	
        
Parameters:

    

    

          

        string  
        $tablename  
        
      

        

    


        
[ Top ]

  

  

	
	
method getLastError [line 288]

	

    

    

		string getLastError(
)
    

    


	
		Returns the most recent error message





Tags:





  

    return:  Error message
  

  

    access:  public
  









	
        
[ Top ]

  

  

	
	
method getMatcherTableList [line 249]

	

    

    

		array getMatcherTableList(
)
    

    


	
		Returns an array of the User Agent Matcher tables in the database





Tags:





  

    abstract:  
  

  

    access:  public
  









	
Overridden in child classes as:

		

	
TeraWurflDatabase_MySQL4::getMatcherTableList()

		

	

		

	
TeraWurflDatabase_MySQL5::getMatcherTableList()

		

	

		

	
TeraWurflDatabase_PDO::getMatcherTableList()

		

	

		

	
TeraWurflDatabase_MSSQL2005::getMatcherTableList()

		

	

		

	
TeraWurflDatabase_MongoDB::getMatcherTableList()

		
Methods enforced by parent class, but not used for this connector

	

	

	
        
[ Top ]

  

  

	
	
method getServerVersion [line 283]

	

    

    

		string getServerVersion(
)
    

    


	
		Returns the version string of the database server





Tags:





  

    abstract:  
  

  

    access:  public
  









	
Overridden in child classes as:

		

	
TeraWurflDatabase_MySQL4::getServerVersion()

		

	

		

	
TeraWurflDatabase_MySQL5::getServerVersion()

		

	

		

	
TeraWurflDatabase_PDO::getServerVersion()

		

	

		

	
TeraWurflDatabase_MSSQL2005::getServerVersion()

		

	

		

	
TeraWurflDatabase_MongoDB::getServerVersion()

		

	

	

	
        
[ Top ]

  

  

	
	
method getSetting [line 226]

	

    

    

		string getSetting(
string
$key)
    

    


	
		Get setting from settings table by a given key





Tags:





  

    return:  value or NULL if not found
  

  

    abstract:  
  

  

    access:  public
  









	
Overridden in child classes as:

		

	
TeraWurflDatabase_MySQL4::getSetting()

		

	

		

	
TeraWurflDatabase_MySQL5::getSetting()

		

	

		

	
TeraWurflDatabase_PDO::getSetting()

		

	

		

	
TeraWurflDatabase_MSSQL2005::getSetting()

		

	

		

	
TeraWurflDatabase_MongoDB::getSetting()

		

	

	

	
        
Parameters:

    

    

          

        string  
        $key  
        setting name (key)
      

        

    


        
[ Top ]

  

  

	
	
method getTableList [line 244]

	

    

    

		array getTableList(
)
    

    


	
		Returns an array of all the tables in the database





Tags:





  

    abstract:  
  

  

    access:  public
  









	
Overridden in child classes as:

		

	
TeraWurflDatabase_MySQL4::getTableList()

		

	

		

	
TeraWurflDatabase_MySQL5::getTableList()

		

	

		

	
TeraWurflDatabase_PDO::getTableList()

		

	

		

	
TeraWurflDatabase_MSSQL2005::getTableList()

		

	

		

	
TeraWurflDatabase_MongoDB::getTableList()

		

	

	

	
        
[ Top ]

  

  

	
	
method getTableStats [line 255]

	

    

    

		array getTableStats(
string
$table)
    

    


	
		Returns an associative array of statistics from given table





Tags:





  

    abstract:  
  

  

    access:  public
  









	
Overridden in child classes as:

		

	
TeraWurflDatabase_MySQL4::getTableStats()

		

	

		

	
TeraWurflDatabase_MySQL5::getTableStats()

		

	

		

	
TeraWurflDatabase_PDO::getTableStats()

		

	

		

	
TeraWurflDatabase_MSSQL2005::getTableStats()

		

	

		

	
TeraWurflDatabase_MongoDB::getTableStats()

		

	

	

	
        
Parameters:

    

    

          

        string  
        $table  
        
      

        

    


        
[ Top ]

  

  

	
	
method initializeDB [line 265]

	

    

    

		void initializeDB(
)
    

    


	
		Drops and recreates the current database and procedures





Tags:





  

    access:  public
  









	
        
[ Top ]

  

  

	
	
method loadDevices [line 155]

	

    

    

		array loadDevices(

&$tables, array
$tables)
    

    


	
		Loads the pre-processed WURFL tables into the database





Tags:





  

    return:  Array of devices in fallback tree
  

  

    abstract:  
  

  

    access:  public
  









	
Overridden in child classes as:

		

	
TeraWurflDatabase_MySQL4::loadDevices()

		

	

		

	
TeraWurflDatabase_MySQL5::loadDevices()

		

	

		

	
TeraWurflDatabase_PDO::loadDevices()

		

	

		

	
TeraWurflDatabase_MSSQL2005::loadDevices()

		

	

		

	
TeraWurflDatabase_MongoDB::loadDevices()

		

	

	

	
        
Parameters:

    

    

          

        array  
        $tables  
        Device tables
      

          

          
        &$tables  
        
      

        

    


        
[ Top ]

  

  

	
	
method rebuildCacheTable [line 188]

	

    

    

		bool rebuildCacheTable(
)
    

    


	
		Rebuilds the cache table by redetecting the cached devices against the loaded WURFL





Tags:





  

    return:  Success
  

  

    abstract:  
  

  

    access:  public
  









	
Overridden in child classes as:

		

	
TeraWurflDatabase_MySQL4::rebuildCacheTable()

		

	

		

	
TeraWurflDatabase_MySQL5::rebuildCacheTable()

		

	

		

	
TeraWurflDatabase_PDO::rebuildCacheTable()

		

	

		

	
TeraWurflDatabase_MSSQL2005::rebuildCacheTable()

		

	

		

	
TeraWurflDatabase_MongoDB::rebuildCacheTable()

		

	

	

	
        
[ Top ]

  

  

	
	
method saveDeviceInCache [line 178]

	

    

    

		bool saveDeviceInCache(
string
$userAgent, 
&$device, array
$device)
    

    


	
		Save the given User Agent and Device capabilities array to the database





Tags:





  

    return:  Success
  

  

    abstract:  
  

  

    access:  public
  









	
Overridden in child classes as:

		

	
TeraWurflDatabase_MySQL4::saveDeviceInCache()

		

	

		

	
TeraWurflDatabase_MySQL5::saveDeviceInCache()

		

	

		

	
TeraWurflDatabase_PDO::saveDeviceInCache()

		

	

		

	
TeraWurflDatabase_MSSQL2005::saveDeviceInCache()

		

	

		

	
TeraWurflDatabase_MongoDB::saveDeviceInCache()

		

	

	

	
        
Parameters:

    

    

          

        string  
        $userAgent  
        User Agent
      

          

        array  
        $device  
        Device capabilities array
      

          

          
        &$device  
        
      

        

    


        
[ Top ]

  

  

	
	
method SQLPrep [line 239]

	

    

    

		string SQLPrep(
mixed
$raw_text)
    

    


	
		Prepares raw text for use in queries (adding quotes and escaping characters if necessary)





Tags:





  

    return:  SQL-Safe text
  

  

    abstract:  
  

  

    access:  public
  









	
Overridden in child classes as:

		

	
TeraWurflDatabase_MySQL4::SQLPrep()

		

	

		

	
TeraWurflDatabase_MySQL5::SQLPrep()

		

	

		

	
TeraWurflDatabase_PDO::SQLPrep()

		

	

		

	
TeraWurflDatabase_MSSQL2005::SQLPrep()

		

	

		

	
TeraWurflDatabase_MongoDB::SQLPrep()

		
Prepare raw text for use in queries (adding quotes if necessary)

	

	

	
        
Parameters:

    

    

          

        mixed  
        $raw_text  
        
      

        

    


        
[ Top ]

  

  

	
	
method updateSetting [line 220]

	

    

    

		void updateSetting(
string
$key, string
$value)
    

    


	
		Adds/updates a key=>value pair in the settings table





Tags:





  

    abstract:  
  

  

    access:  public
  









	
Overridden in child classes as:

		

	
TeraWurflDatabase_MySQL4::updateSetting()

		

	

		

	
TeraWurflDatabase_MySQL5::updateSetting()

		

	

		

	
TeraWurflDatabase_PDO::updateSetting()

		

	

		

	
TeraWurflDatabase_MSSQL2005::updateSetting()

		

	

		

	
TeraWurflDatabase_MongoDB::updateSetting()

		

	

	

	
        
Parameters:

    

    

          

        string  
        $key  
        setting name (key)
      

          

        string  
        $value  
        setting value
      

        

    


        
[ Top ]

  

  

	
	
method verifyConfig [line 276]

	

    

    

		array verifyConfig(
)
    

    


	
		Checks if the database configuration is correct and that all required permissions

are properly configured





Tags:





  

    return:  list of errors
  

  

    access:  public
  









	
Overridden in child classes as:

		

	
TeraWurflDatabase_MySQL5::verifyConfig()

		

	

		

	
TeraWurflDatabase_PDO::verifyConfig()

		

	

	

	
        
[ Top ]

  






        

		    

		    Documentation generated on Sat, 31 Mar 2012 15:45:09 -0400 by phpDocumentor 1.4.4