Inheritance diagram for LGV_TZ_Lookup_Database:

Public Member Functions
	__construct ( $inDatabase, $inUser=NULL, $inPassword=NULL, $inDriver='mysql', $inHost='127.0.0.1', $inPort=NULL)
	get_tz_entities ( $in_id_list)
	get_tz_ids ( $in_lng, $in_lat)
	get_tz_polygons ($in_id_list)
	reset_database ()
	store_entity ( $inEntity)

Static Public Member Functions
static	_array_flatten ( $inArray)

Public Attributes
	$pdo_instance

Protected Attributes
	$_load_table
	Destination for schema creation and polygon inserts; updater subclasses can stage a new load.

Static Private Member Functions
static	_sort_by_domainSize ($in_A, $in_B)

Private Attributes
	$_init_sql

Detailed Description

This class manages interactions between the server and the database.

Definition at line 37 of file LGV_TZ_Lookup_Database.class.php.

Constructor & Destructor Documentation

◆ __construct()

LGV_TZ_Lookup_Database::__construct	(	$inDatabase,
		$inUser = NULL,
		$inPassword = NULL,
		$inDriver = 'mysql',
		$inHost = '127.0.0.1',
		$inPort = NULL )

The constructor.

Parameters

$inDatabase	database name (required)
$inUser	database user, optional
$inPassword	database password, optional
$inDriver	database server type (optional, default is 'mysql')
$inHost	database server host (optional, default is 127.0.0.1)
$inPort	database TCP port (optional, defaults to 3306 for mysql, 5432 for pgsql)

Definition at line 57 of file LGV_TZ_Lookup_Database.class.php.

References pdo_instance.

Member Function Documentation

◆ _array_flatten()

LGV_TZ_Lookup_Database::_array_flatten ( $inArray )

static

This is a simple "brute force" array flattener. It rounds the values to six significant digits, as well.

Parameters

$inArray The multi-dimensional array to be squished.

Definition at line 138 of file LGV_TZ_Lookup_Database.class.php.

Referenced by store_entity().

Here is the caller graph for this function:

◆ _sort_by_domainSize()

LGV_TZ_Lookup_Database::_sort_by_domainSize	(		$in_A,
			$in_B )

staticprivate

This is a sort callback that sorts, so the smaller domain gets put first.

Returns: : True, if $in_A < $inB

Parameters

$in_A	The first entity
$in_B	The second entity

Definition at line 113 of file LGV_TZ_Lookup_Database.class.php.

◆ get_tz_entities()

LGV_TZ_Lookup_Database::get_tz_entities ( $in_id_list )

Returns: : An array of simple arrays ([tzname, polygon]), which are the database entities of table rows that correspond to the IDs passed in.

Parameters

$in_id_list A list of IDs for the rows we want to check.

Definition at line 183 of file LGV_TZ_Lookup_Database.class.php.

References pdo_instance.

◆ get_tz_ids()

LGV_TZ_Lookup_Database::get_tz_ids	(		$in_lng,
			$in_lat )

This queries the database, and returns the TZ IDs.

Returns: : An array of integers, which are the database IDs of table rows that have the long/lat in their domainRects.

Parameters

$in_lng	The longitude
$in_lat	The latitude

Definition at line 166 of file LGV_TZ_Lookup_Database.class.php.

References pdo_instance.

◆ get_tz_polygons()

LGV_TZ_Lookup_Database::get_tz_polygons ( $in_id_list )

Yield the existing binary polygons without unpacking them. Primary-key order makes first-match precedence explicit, matching the existing MySQL primary-key candidate scan.

Reimplemented in DemoTrackedDatabase, and TrackingDatabase.

Definition at line 220 of file LGV_TZ_Lookup_Database.class.php.

References pdo_instance.