xNightR00T File Manager

<?php

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

class DevbarDBHandler extends ZSComponentUpgrader
{

    protected function getSqliteDbName($version = "6.5.0") {
        return "devbar.db";
    }

    protected function getMysqlSqlFilenames() {
        return array("devbar_mysql_create_database.sql",
                     "devbar_fixtures.sql");
    }

    public function getSqliteSqlFilenames() {
        return array(
                   "devbar_sqlite_create_database.sql",
                   "devbar_fixtures.sql"
               );
    }

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

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

    public function getSqliteSchemaVersion() {
		$dbh = $this->getSqliteDbh();
        $res = $dbh->query("SELECT value FROM devbar_properties WHERE name = 'SCHEMA_VERSION'")->fetchAll();
        foreach ($res as $row) {
            return $this->getParsedVersionString($row['value']);
        }

        return false;
    }

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

        return false;
    }

    /**
     *
     * @param PDO $dbh
     * @param unknown $version
     * @return unknown|boolean
     */
    public function setSqliteSchemaVersion($dbh, $version) {
        $stmt = $dbh->prepare("INSERT OR REPLACE INTO devbar_properties VALUES('SCHEMA_VERSION', :version)");
        $stmt->bindValue(":version", $version);
        return $stmt->execute();
    }

    /**
     *
     * @param PDO $dbh
     * @param unknown $version
     * @return unknown|boolean
     */
    public function setMysqlSchemaVersion($dbh, $version) {
        $stmt = $dbh->prepare("update schema_properties SET property_value = :version WHERE property = 'DEVBAR_SCHEMA_VERSION'");
        $stmt->bindValue(":version", $version);
        return $stmt->execute();
    }

    protected function upgradeSqlite() {

		// we remove the devbar db and recreate it again
    	@unlink($this->getSqliteDbPath());
    	$this->createCleanSqliteDatabase();
    }

	public function upgradeTo920($dbh, $isSqlite) {

		if ($isSqlite) {
			$this->setSqliteSchemaVersion($dbh, '2018.0.0');
		} else {
			$this->setMysqlSchemaVersion($dbh, '2018.0.0');
		}
	}

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

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

    }

    /**
     * @brief upgrade devbar_* tables (MySQL)
     * @return void
     */
    protected function upgradeMysql() {

        // In this release, we have changed the token table
        // Drop the current tables and recreate the tables
		$dbh = $this->getMySqlDbh();
        if ($dbh) {
            $tables = $this->getCreatedMysqlTables($dbh, "devbar");
            foreach ($tables as $table) {
                message("Dropping table $table");
                $dbh->exec("DROP TABLE $table");
            }
            $this->createCleanMysqlDatabase();

			$this->setMysqlSchemaVersion($dbh, "2018.0.0");
        } else {
			$this->createCleanMysqlDatabase();
		}
    }
}

?>