Database Updater

From 661135c742cc31bc0eece3bb669dad707d0aff66 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Tue, 9 Nov 2010 16:33:08 +0300 Subject: [PATCH] unify update_daemon, update_feeds and update_feedbrowser into update.php; move update.php to db-updater.php --- db-updater.php | 171 ++++++++++++++ digest.js | 2 +- errors.php | 2 +- functions.js | 2 +- update.php | 215 ++++++------------ update_daemon.php | 87 ------- update_daemon_loop.php | 76 ------- update_feedbrowser.php | 49 ---- update_feeds.php | 43 ---- .../update-translations.sh | 0 10 files changed, 245 insertions(+), 402 deletions(-) create mode 100644 db-updater.php mode change 100644 => 100755 update.php delete mode 100755 update_daemon.php delete mode 100755 update_daemon_loop.php delete mode 100755 update_feedbrowser.php delete mode 100755 update_feeds.php rename update-translations.sh => utils/update-translations.sh (100%) diff --git a/db-updater.php b/db-updater.php new file mode 100644 index 00000000..76e30885 --- /dev/null +++ b/db-updater.php @@ -0,0 +1,171 @@ + + + + +Database Updater + + + + + + + + +

+ +

+ +" . + __("Could not find necessary schema file, need version:") . + " " . SCHEMA_VERSION . __(", found: ") . $latest_version . "

"; + + } else { + print "

".__("Tiny Tiny RSS database is up to date.")."

"; + print ""; + } + + return; + } + + if (!$op) { + print_warning(__("Please backup your database before proceeding.")); + + print "

" . T_sprintf("Your Tiny Tiny RSS database needs update to the latest version (%d to %d).", $version, $latest_version) . "

"; + + /* print "

Available incremental updates:"; + + foreach (array_keys($update_versions) as $v) { + if ($v > $version) { + print " $v"; + } + } */ + + print "

"; + + print ""; + + } else if ($op == "do") { + + print "

".__("Performing updates...")."

"; + + $num_updates = 0; + + foreach (array_keys($update_versions) as $v) { + if ($v == $version + 1) { + print "

".T_sprintf("Updating to version %d...", $v)."

"; + $fp = fopen($update_versions[$v], "r"); + if ($fp) { + while (!feof($fp)) { + $query = trim(getline($fp, ";")); + if ($query != "") { + print "

$query

"; + db_query($link, $query); + } + } + } + fclose($fp); + + print "

".__("Checking version... "); + + $result = db_query($link, "SELECT schema_version FROM ttrss_version"); + $version = db_fetch_result($result, 0, "schema_version"); + + if ($version == $v) { + print __("OK!"); + } else { + print "".__("ERROR!").""; + return; + } + + $num_updates++; + } + } + + print "

".T_sprintf("Finished. Performed %d update(s) up to schema + version %d.", $num_updates, $version)."

"; + + print ""; + + } + +?> + + + + diff --git a/digest.js b/digest.js index 0bb1638a..50d5e311 100644 --- a/digest.js +++ b/digest.js @@ -719,7 +719,7 @@ function fatal_error(code, msg) { if (code == 6) { window.location.href = "digest.php"; } else if (code == 5) { - window.location.href = "update.php"; + window.location.href = "db-updater.php"; } else { if (msg == "") msg = "Unknown error"; diff --git a/errors.php b/errors.php index bd7b53fe..b2e0841a 100644 --- a/errors.php +++ b/errors.php @@ -12,7 +12,7 @@ $ERRORS[4] = __("Frontend sanity check failed."); - $ERRORS[5] = __("Incorrect database schema version. <a href='update.php'>Please update</a>."); + $ERRORS[5] = __("Incorrect database schema version. <a href='db-updater.php'>Please update</a>."); $ERRORS[6] = __("Request not authorized."); diff --git a/functions.js b/functions.js index 9e990c44..ae7ecee3 100644 --- a/functions.js +++ b/functions.js @@ -1375,7 +1375,7 @@ function fatalError(code, msg, ext_info) { if (code == 6) { window.location.href = "tt-rss.php"; } else if (code == 5) { - window.location.href = "update.php"; + window.location.href = "db-updater.php"; } else { if (msg == "") msg = "Unknown error"; diff --git a/update.php b/update.php old mode 100644 new mode 100755 index 76e30885..50b9fc41 --- a/update.php +++ b/update.php @@ -1,171 +1,98 @@ +#!/usr/bin/php + $lock_handle = make_lockfile($lock_filename); + $must_exit = false; - - -Database Updater - - - + // Try to lock a file in order to avoid concurrent update. + if (!$lock_handle) { + die("error: Can't create lockfile ($lock_filename). ". + "Maybe another update process is already running.\n"); + } - + // Create a database connection. + $link = db_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME); - + if (!$link) { + if (DB_TYPE == "mysql") { + print mysql_error(); + } + // PG seems to display its own errors just fine by default. + return; + } -

+ init_connection($link); -

+ if ($op == "-feeds") { + // Update all feeds needing a update. + update_daemon_common($link); + } -" . - __("Could not find necessary schema file, need version:") . - " " . SCHEMA_VERSION . __(", found: ") . $latest_version . "

"; + // Call to the feed batch update function + // or regenerate feedbrowser cache + if (rand(0,100) > 30) { + update_daemon_common($link); } else { - print "

".__("Tiny Tiny RSS database is up to date.")."

"; - print ""; + $count = update_feedbrowser_cache($link); + _debug("Finished, $count feeds processed."); } - return; - } - - if (!$op) { - print_warning(__("Please backup your database before proceeding.")); - - print "

" . T_sprintf("Your Tiny Tiny RSS database needs update to the latest version (%d to %d).", $version, $latest_version) . "

"; - - /* print "

Available incremental updates:"; - - foreach (array_keys($update_versions) as $v) { - if ($v > $version) { - print " $v"; - } - } */ - - print "

"; - - print ""; - - } else if ($op == "do") { - - print "

".__("Performing updates...")."

"; - - $num_updates = 0; - - foreach (array_keys($update_versions) as $v) { - if ($v == $version + 1) { - print "

".T_sprintf("Updating to version %d...", $v)."

"; - $fp = fopen($update_versions[$v], "r"); - if ($fp) { - while (!feof($fp)) { - $query = trim(getline($fp, ";")); - if ($query != "") { - print "

$query

"; - db_query($link, $query); - } - } - } - fclose($fp); - - print "

".__("Checking version... "); - - $result = db_query($link, "SELECT schema_version FROM ttrss_version"); - $version = db_fetch_result($result, 0, "schema_version"); - - if ($version == $v) { - print __("OK!"); - } else { - print "".__("ERROR!").""; - return; - } - - $num_updates++; - } - } - - print "

".T_sprintf("Finished. Performed %d update(s) up to schema - version %d.", $num_updates, $version)."

"; - - print ""; - } - -?> - - + db_close($link); + unlink(LOCK_DIRECTORY . "/$lock_filename"); +?> diff --git a/update_daemon.php b/update_daemon.php deleted file mode 100755 index 03d366b5..00000000 --- a/update_daemon.php +++ /dev/null @@ -1,87 +0,0 @@ -#!/usr/bin/php - diff --git a/update_daemon_loop.php b/update_daemon_loop.php deleted file mode 100755 index 7fa22d19..00000000 --- a/update_daemon_loop.php +++ /dev/null @@ -1,76 +0,0 @@ -#!/usr/bin/php - 50) { - update_daemon_common($link); - } else { - $count = update_feedbrowser_cache($link); - _debug("Finished, $count feeds processed."); - } - - db_close($link); - -?> diff --git a/update_feedbrowser.php b/update_feedbrowser.php deleted file mode 100755 index 0031ff31..00000000 --- a/update_feedbrowser.php +++ /dev/null @@ -1,49 +0,0 @@ -#!/usr/bin/php - diff --git a/update_feeds.php b/update_feeds.php deleted file mode 100755 index 6a4aa2a1..00000000 --- a/update_feeds.php +++ /dev/null @@ -1,43 +0,0 @@ -#!/usr/bin/php - diff --git a/update-translations.sh b/utils/update-translations.sh similarity index 100% rename from update-translations.sh rename to utils/update-translations.sh -- 2.39.5