xNightR00T File Manager

<?php

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

class CodeTracingDBHandler extends ZSComponentUpgrader {


	protected function getSqliteDbName($version = "6.0.0") {
		if ($version == "5.6.0") {
			return "monitor_codetracing";
		} else {
			return "codetracing.db";
		}
	}

	protected function getMysqlSqlFilenames() {
		return array("mysql_create_monitor_db.sql");
	}

	protected function getSqliteSqlFilenames() {
		return array("create_monitor_tracing_db.sql");
	}

	public function getComponent() { return "tracing"; }

	public function getSchemaVersion() { return "2019.0.0"; }

	public function getMysqlSchemaVersion() {
		$dbh = $this->getMySqlDbh();
		 $res = $dbh->query("SELECT property_value FROM schema_properties WHERE property = 'TRACING_SCHEMA_VERSION'")->fetchAll();
		foreach ($res as $row) {
			return $row['property_value'];
		}

		return false;
	}

	public function getSqliteSchemaVersion() {
		$dbCurrentVersion = "";
		try {
			$dbh = $this->getSqliteDbh();
			$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
			foreach ($dbh->query("SELECT value FROM tracing_properties where name='version'") as $row) {
				$dbCurrentVersion = $row['value'];
			}
		}
		catch (Exception $ex) {

		}
		message("Found sqlite current version $dbCurrentVersion");

		return $this->getParsedVersionString($dbCurrentVersion);
	}

	public function setSqliteSchemaVersion($dbh, $version) {
		$dbh->exec("UPDATE tracing_properties set value='{$version}' where name='version'");
		message("Setting sqlite current version $version");
	}

	public function setMysqlSchemaVersion($dbh, $version) {
		$dbh->exec("REPLACE INTO schema_properties (property, property_value) VALUES('TRACING_SCHEMA_VERSION', '{$version}')");
	}

	/**
	 * @param \PDO $dbh
	 * @param boolean $isSqlite
	 */
	protected function upgradeTo91($dbh, $isSqlite) {
		message("Upgrading CodeTracing Database to 9.1");
		try {
			$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
			message("upgrade detected " . ($isSqlite ? "SQLite" : "MySQL") .  ", fixing `trace_type` table");
			$dbh->exec("ALTER TABLE trace_files ADD COLUMN `trace_type` INTEGER NOT NULL DEFAULT 0");
		} catch(\Exception $e) {
			message("Nothing to be done");
		}
	}

	protected function upgradeSqlite() {

		$this->copySqliteFromPreviousVersions();

		$dbh = $this->getSqliteDbh();
		$this->upgradeTo91($dbh, true);
	}

	protected function upgradeMysql() {
		message("Upgrading CodeTracing Database to (MySQL)...");
		$dbh = $this->getMySqlDbh();
		$this->upgradeTo91($dbh, false);
	}

	public function upgrade() {
		$this->upgradeSqlite();

		if ($this->isClusterUpgrade()) {
			$this->upgradeMysql();
		}
	}
}


class TracingDbCreator_2019_0_0 extends CodeTracingDBHandler
{
	const SCHEMA_VERSION = "2019.0.0";

	public function getSchemaVersion() { return self::SCHEMA_VERSION; }

	public function upgrade() {
		$this->upgradeSqlite();

		if ($this->isClusterUpgrade()) {
			$this->upgradeMysql();
		}
	}

	public function upgradeSqlite() {

		$this->copySqliteFromPreviousVersions();

		message("Upgrading CodeTracing SQLITE schema to " . self::SCHEMA_VERSION);
		$dbh = $this->getSqliteDbh();
		$dbh->exec('
		CREATE TABLE IF NOT EXISTS tracing_properties (
				name VARCHAR(100) NOT NULL PRIMARY KEY,
				value VARCHAR(1024) UNIQUE
				);
		');
		$this->setSqliteSchemaVersion($dbh, self::SCHEMA_VERSION );
	}

	public function upgradeMysql() {
		message("Upgrading CodeTracing MYSQL schema to " . self::SCHEMA_VERSION);
		$dbh = $this->getMySqlDbh();
		$this->setMysqlSchemaVersion($dbh, self::SCHEMA_VERSION);
	}
}
?>