db_upgrade.php

Go to the documentation of this file.

<?php

require_once('sql.php');
require_once('error.php');
require_once('upload.php');

function main() {

$db1 = mysql_connect('localhost','semapp', 'Owtsgmi');
mysql_select_db('semapp', $db1);

$db2 = sql_init();

## step 1: users

$p = array( 'tables' => 'users' );
$users = sql_query('select', $p, $db1);

#print_r($users);


$new_state = array ( 1 => 1, 2 => 3, 3 => 5 );
$new_role = array ( 1 => 3, 2 => 2, 3 => 1 );
$new_degree = array ( 'Prof. Dr.' => 2, 'Dr.' => 4, 'PD Dr.' => 3, '' => 1);

$p = array( 'table' => 'user');
sql_query('delete', $p, $db2);

print "Users:\n";

foreach ($users as $u) {
        print($u['surname']) . ", " . $u['forename'] .   "\n" ;

        # translate state, role, etc.

        $u['degree_id'] = $new_degree[$u['title']];
        unset($u['title']);

        $u['state_id'] = $new_state[$u['state_id']];

        $u['role_id'] = $new_role[$u['group_id']];
        unset($u['group_id']);

        $u['use_alias'] = 0;

        $p = array( 'table' => 'user', 'data' => $u);
        sql_query('insert', $p, $db2);
}

## step 2 lectures (-> collections)

$p = array( 'tables' => 'lectures' );
$lectures = sql_query('select', $p, $db1);

$p = array( 'table' => 'collection');
sql_query('delete', $p, $db2);

$new_state = array ( 1 => 1, 2 => 3, 3 => 5 );

print "Lectures:\n";
foreach ($lectures as $l) {
        print $l['title'] . "\n";
        
        $l['state_id'] = $new_state[$l['state_id']];

        $l['expiry_date'] = '2006-10-01';
        $l['created'] = $l['last_modified'] = $l['last_state_change'] = '2006-01-01';

        $l['collection_no'] = $l['lecture_no'];
        unset($l['lecture_no']);

        $l['location_id'] = 1;

        $p = array( 'table' => 'collection', 'data' => $l);
        sql_query('insert', $p, $db2);
}

### documents

$p = array( 'table' => 'document');
sql_query('delete', $p, $db2);

## urls

$p = array( 'tables' => 'urls' );
$urls = sql_query('select', $p, $db1);

print "URLs:\n";

foreach ($urls as $d) {

        print $d['title'] . "\n";

        $d['collection_id'] =  $d['lecture_id'];
        unset($d['lecture_id']);

        $d['relevance'] =  $d['sort_prio'];
        unset($d['sort_prio']);

        unset($d['id']);

        $d['created'] = $d['last_modified'] = $d['last_state_change'] = '2006-01-01';

        $d['doc_type_id'] = 3; ## url

        $d['state_id'] = 3;    ## active 
        $d['url_type_id'] = 4; ## weblink 

        $p = array( 'table' => 'document', 'data' => $d);
        sql_query('insert', $p, $db2);
}

$p = array( 'tables' => 'articles' );
$articles = sql_query('select', $p, $db1);

print "Artikel:\n";

$new_state = array ( 1 => 1, 2 => 3, 3 => 5 );

foreach ($articles as $d) {

        print $d['title'] . "\n";

        $d['collection_id'] =  $d['lecture_id'];
        unset($d['lecture_id']);

        $d['relevance'] =  $d['sort_prio'];
        unset($d['sort_prio']);

        $d['state_id'] = $new_state[$d['state_id']];

        unset($d['id']);

        $contents = file_get_contents($d['url']);
        $fn = basename($d['url']);

        unset($d['url']);

        $d['created'] = $d['last_modified'] = $d['last_state_change'] = '2006-01-01';

        $d['doc_type_id'] = 4; ## article
        $d['url_type_id'] = 3; ## full text

        $p = array( 'table' => 'document', 'data' => $d);
        sql_query('insert', $p, $db2);
        
        $ans = sql_query('last_id', array(), $db2);
        $id = $ans[0]['last_id'];

        print "new_id: $id";

        put_file('article', $id, $fn, $contents);
}


$p = array( 'tables' => 'books' );
$books = sql_query('select', $p, $db1);

print "Buecher:\n";

$new_state = array ( 1 => 1, 2 => 3, 3 => 5 );

foreach ($books as $d) {

        print $d['title'] . "\n";

        unset($d['chapter']);

        $d['ppn'] = preg_replace("/^.*ppn\+/", "", $d['opac_url']);
        unset($d['opac_url']);

        $d['collection_id'] =  $d['lecture_id'];
        unset($d['lecture_id']);

        $d['relevance'] =  $d['sort_prio'];
        unset($d['sort_prio']);

        $d['state_id'] = $new_state[$d['state_id']];

        unset($d['id']);

        $contents = file_get_contents($d['url']);
        $fn = basename($d['url']);

        unset($d['url']);

        $d['created'] = $d['last_modified'] = $d['last_state_change'] = '2006-01-01';

        $d['doc_type_id'] = 1; ## book
        $d['url_type_id'] = 2; ## toc

        $p = array( 'table' => 'document', 'data' => $d);
        sql_query('insert', $p, $db2);
        
        $ans = sql_query('last_id', array(), $db2);
        $id = $ans[0]['last_id'];

        print "new_id: $id";

        if ($fn == '') {
                $fn = 'index.html';
        }

        if (!empty($contents)) {
                put_file('book', $id, $fn, $contents);
        }
}

}

main();
?>

---