source: trunk/scripts/textblock-creation-timestamp @ 1184

#! /usr/bin/env php
<?php
// This script is used to repair all text attachments that weren't in Linux format.

require_once(dirname($argv[0]) . "/utilities.php");
require_once(IA_ROOT_DIR."common/textblock.php");
require_once(IA_ROOT_DIR."common/db/textblock.php");

ini_set("memory_limit", "128M");

function add_datetime_column($table, $column, $after) {
    $query = sprintf("SHOW COLUMNS FROM %s LIKE '%s'", db_escape($table), db_escape($column));
    if (db_fetch($query) != null) {
        //FIXME: only for testing; remove this before commit 
        $query = sprintf("ALTER TABLE %s DROP %s", db_escape($table), db_escape($column));
        db_query($query);
        log_print(sprintf("Coloana %s exista deja in %s!", $column, $table));
    }
    $query = sprintf("ALTER TABLE %s ADD %s DATETIME NOT NULL AFTER %s", 
                     db_escape($table), db_escape($column), db_escape($after));
    db_query($query);
}

function update_table($table) {
    $query = sprintf("SELECT * FROM %s", db_escape($table));
    $textblocks = db_fetch_all($query);
    foreach ($textblocks as $textblock) {
        $name = $textblock['name'];

        // ignore junk pages
        if (!is_normal_page_name($name)) {
            continue;
        }

        $first_revision = textblock_get_revision($name, 1);
        $query = sprintf("UPDATE %s SET creation_timestamp = '%s' WHERE name = '%s'",
                         db_escape($table), db_escape($first_revision['timestamp']), db_escape($name));
        db_query($query);
    }
}


db_connect();
add_datetime_column("ia_textblock", "creation_timestamp", "title");
add_datetime_column("ia_textblock_revision", "creation_timestamp", "title");
update_table("ia_textblock");
update_table("ia_textblock_revision");