public function PHPExcel_CachedObjectStorage_SQLite::getCellList in Loft Data Grids 7.2

Same name and namespace in other branches

1. 6.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/CachedObjectStorage/SQLite.php \PHPExcel_CachedObjectStorage_SQLite::getCellList()

* Get a list of all cell addresses currently held in cache * *

Return value

string[]

Overrides PHPExcel_CachedObjectStorage_CacheBase::getCellList

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/CachedObjectStorage/SQLite.php, line 203

Class

PHPExcel_CachedObjectStorage_SQLite

PHPExcel_CachedObjectStorage_SQLite

Code

public function getCellList() {
  if ($this->_currentObjectID !== null) {
    $this
      ->_storeData();
  }
  $query = "SELECT id FROM kvp_" . $this->_TableName;
  $cellIdsResult = $this->_DBHandle
    ->unbufferedQuery($query, SQLITE_ASSOC);
  if ($cellIdsResult === false) {
    throw new PHPExcel_Exception(sqlite_error_string($this->_DBHandle
      ->lastError()));
  }
  $cellKeys = array();
  foreach ($cellIdsResult as $row) {
    $cellKeys[] = $row['id'];
  }
  return $cellKeys;
}