Changeset 433 for trunk/upgrade.php

Timestamp:

03/31/07 18:45:48 (20 months ago)

Author:

michiel

Message:

rewrote the upgrade routines.
removed test upgrade php file. Why the hell did I commit it the first place.

Re #124

Files:

• trunk/upgrade.php (modified) (1 diff)

trunk/upgrade.php

@@ -21 +21 @@
  * Uprade mvblog to the latest version
  */
-require_once("common/mvblog_common.php");
-$common = new Mvblog_common();
-$latest_patch = $common->settings["dbversion"];
-/**
- * Find out what patchfiles we need to commit.
- */
-function get_patchfiles($current_version = 0, $sqltype="mysql") {
-        /* read the db patchfiles into an array */
-        $patchfiles = array();
-        if ($dh = opendir(sprintf("upgrades/%s", $sqltype))) {
-                while (false !== ($v = readdir($dh))) {
-                        if (!is_dir($v)) {
-                                if (substr($v, 0, strpos($v, "to")) >= $current_version)
-                                        $patchfiles[] = $v;
-                        }
-                }
-        }
-        return $patchfiles;
-}
+if (array_key_exists("mode", $_REQUEST))
+        $mode = $_REQUEST["mode"];
+else
+        $mode = "";
 
-/**
- * Update/create dbversion setting in the database
- */
-function set_latest_version($version=0) {
-        /* check if the field is already in the database */
-        $sql = "SELECT COUNT(*) FROM settings WHERE settingname = 'dbversion'";
-        $res = $GLOBALS["common"]->db->query($sql);
-        $res->fetchInto($row);
-        if ($row[0]) {
-                /* update the entry */
-                $sql = sprintf("UPDATE settings SET settingvalue = '%s' WHERE settingname = 'dbversion'", $version);
-        } else {
-                /* create the entry */
-                $sql = sprintf("INSERT INTO settings (settingname, settingvalue) VALUES ('dbversion', '%s')", $version);
-        }
-        $res = $GLOBALS["common"]->db->query($sql);
-}
+require_once("common/mvblog_upgrade.php");
+$updater = new Mvblog_upgrade();
 
-echo "looking up files for db type <b>".$common->db->phptype."</b> starting at version <b>".$common->settings["dbversion"]."</b>...<br>";
-$patches = get_patchfiles($common->settings["dbversion"], $common->db->phptype);
+if (array_key_exists("dbversion", $updater->settings["dbversion"]) && $updater->settings["dbversion"])
+        $latest_version = $updater->settings["dbversion"];
+else
+        $latest_version = 0;
+
+echo "looking up files for db type <b>".$updater->db->phptype."</b> starting at version <b>".$latest_version."</b>...<br>";
+$patches = $updater->get_patchfiles($mode);
 if (!count($patches))
         die("nothing to do. Your mvblog is already up-to-date.");
 
 foreach ($patches as $patch) {
-        echo "applying patchfile $patch...";
-        require_once("upgrades/".$common->db->phptype."/$patch");
-        foreach ($sql as $query) {
-                $common->db->query($query);
-                if (PEAR::isError($res))
-                        die($res->getMessage());
-        }
-        echo "done.<br>";
+        if (!$updater->apply_dbpatch($patch, $mode))
+                die("something went wrong with patchfile $patch. Rollback to backup.");
+        echo "applied patchfile $patch. <br>";
         /* put last version in var so we can update settings table later */
-        $latest = substr($patch, strpos($patch, "to")+2, -4);
-        if ($latest > $latest_version)
-                $latest_version = $latest;
+        if ($updater->lastpatch > $latest_version)
+                $latest_version = $updater->lastpatch;
 }
-set_latest_version($latest_version);
+$updater->set_latest_version($latest_version);
 echo "Your MvBlog installation is updated. Have fun.";
 ?>