Subversion Repositories oidplus

<?php

/*

 * OIDplus 2.0

 * Copyright 2020 Daniel Marschall, ViaThinkSoft

 *

 * Licensed under the Apache License, Version 2.0 (the "License");

 * you may not use this file except in compliance with the License.

 * You may obtain a copy of the License at

 *

 *     http://www.apache.org/licenses/LICENSE-2.0

 *

 * Unless required by applicable law or agreed to in writing, software

 * distributed under the License is distributed on an "AS IS" BASIS,

 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

 * See the License for the specific language governing permissions and

 * limitations under the License.

 */

/**

 * This function will be called by OIDplusDatabaseConnection.class.php at method afterConnect().

 * @param OIDplusDatabaseConnection $db is the OIDplusDatabaseConnection class

 * @param string $version is the current version (this script MUST increase the number by 1 when it is done)

 * @throws OIDplusException

 */

function oidplus_dbupdate_201_202(OIDplusDatabaseConnection $db, string &$version) {

    if ($db->transaction_supported()) $db->transaction_begin();

    // Change bit(1) types to boolean/tinyint(1)

    if ($db->getSlang()::id() == 'pgsql') {

        $db->query("alter table ###config  alter protected    drop default");

        $db->query("alter table ###config  alter protected    type boolean using get_bit(protected   ,0)::boolean");

        $db->query("alter table ###config  alter protected    set default false");

        $db->query("alter table ###config  alter visible      drop default");

        $db->query("alter table ###config  alter visible      type boolean using get_bit(visible     ,0)::boolean");

        $db->query("alter table ###config  alter visible      set default false");

        $db->query("alter table ###asn1id  alter standardized drop default");

        $db->query("alter table ###asn1id  alter standardized type boolean using get_bit(standardized,0)::boolean");

        $db->query("alter table ###asn1id  alter standardized set default false");

        $db->query("alter table ###asn1id  alter well_known   drop default");

        $db->query("alter table ###asn1id  alter well_known   type boolean using get_bit(well_known  ,0)::boolean");

        $db->query("alter table ###asn1id  alter well_known   set default false");

        $db->query("alter table ###iri     alter longarc      drop default");

        $db->query("alter table ###iri     alter longarc      type boolean using get_bit(longarc     ,0)::boolean");

        $db->query("alter table ###iri     alter longarc      set default false");

        $db->query("alter table ###iri     alter well_known   drop default");

        $db->query("alter table ###iri     alter well_known   type boolean using get_bit(well_known  ,0)::boolean");

        $db->query("alter table ###iri     alter well_known   set default false");

        $db->query("alter table ###objects alter confidential type boolean using get_bit(confidential,0)::boolean");

        $db->query("alter table ###ra      alter privacy      drop default");

        $db->query("alter table ###ra      alter privacy      type boolean using get_bit(privacy     ,0)::boolean");

        $db->query("alter table ###ra      alter privacy      set default false");

    } else if ($db->getSlang()::id() == 'mysql') {

        $db->query("alter table ###config  modify protected    boolean");

        $db->query("alter table ###config  modify visible      boolean");

        $db->query("alter table ###asn1id  modify standardized boolean");

        $db->query("alter table ###asn1id  modify well_known   boolean");

        $db->query("alter table ###iri     modify longarc      boolean");

        $db->query("alter table ###iri     modify well_known   boolean");

        $db->query("alter table ###objects modify confidential boolean");

        $db->query("alter table ###ra      modify privacy      boolean");

    }

    // Rename log_user.user to log_user.username, since user is a keyword in PostgreSQL and MSSQL

    if ($db->getSlang()::id() == 'pgsql') {

        $db->query("alter table ###log_user rename column \"user\" to \"username\"");

    } else if ($db->getSlang()::id() == 'mysql') {

        $db->query("alter table ###log_user change `user` `username` varchar(255) NOT NULL");

    }

    $version = 202;

    $db->query("UPDATE ###config SET value = ? WHERE name = 'database_version'", array($version));

    if ($db->transaction_supported()) $db->transaction_commit();

}