xNightR00T File Manager

<?php

require_once dirname(__FILE__) . "/zs_component_upgrader.php";

class PageCachePurgeDBHandler extends ZSComponentUpgrader {
	
		
	protected function getSqliteDbName($version = "6.0.0") {
		return "pagecache_purge.db";		
	}
	
	protected function getMysqlSqlFilenames() {
		return array();
	}
	
	protected function getSqliteSqlFilenames() {
		return array("pagecache_purge.sql");
	}
	
	public function getComponent() { return "Page Cache Purge"; }
	
	public function getSchemaVersion() { return "2019.0.0"; }
	
	public function getSqliteSchemaVersion() {
		$dbh = $this->getSqliteDbh();
		$res = $dbh->query("SELECT value FROM pagecache_purge_properties WHERE name = 'version'")->fetchAll();
		foreach ($res as $row) {
			return $row['value'];
		}
	
		return false;
	}
	
	public function getMysqlSchemaVersion() {
			
		return false;
	}
	
	/**
	 *
	 * @param PDO $dbh
	 * @param unknown $version
	 * @return unknown|boolean
	 */
	public function setSqliteSchemaVersion($dbh, $version) {
		$stmt = $dbh->prepare("INSERT OR REPLACE INTO pagecache_purge_properties  (name, value) VALUES ('version', :version)");
		$stmt->bindValue(":version", $version);
		return $stmt->execute();
	}
		
	/**
	 * 
	 * @param PDO $dbh
	 * @param unknown $version
	 * @return unknown|boolean
	 */
	public function setMysqlSchemaVersion($dbh, $version) {
		return false;
	}
	
	protected function upgradeSqlite() {		
		$this->createCleanSqliteDatabase(); 		
	}
	
	protected function upgradeMysql() {		
		
	}
	
	public function upgrade() {
		$this->upgradeSqlite();
		
		message("upgrade page ache purge db handler");
    }


}

?>