dbmigrate_copyright-author.php

Go to the documentation of this file.

<?php
/*
 SPDX-FileCopyrightText: © 2017 Siemens AG
 
 SPDX-License-Identifier: GPL-2.0-only
*/
 
$countAuthorColumns = $dbManager->getSingleRow("SELECT count(*) FROM copyright WHERE type <> 'statement' AND content IS NOT NULL;",array(),'getCountAuthorColumns');
 
if($countAuthorColumns['count'] > 0){
 
  echo "Insert email/url/author data from copyright to author table... \nIt takes some time depending number of columns... \n";
 
  $dbManager->queryOnce("INSERT INTO author (agent_fk, pfile_fk, content, hash, type, copy_startbyte, copy_endbyte, is_enabled)
                         SELECT agent_fk, pfile_fk, content, hash, type, copy_startbyte, copy_endbyte, is_enabled
                         FROM copyright WHERE type <> 'statement' AND content IS NOT NULL;");
  $countInsertedAuthorColumns = $dbManager->getSingleRow("SELECT count(*) FROM author au INNER JOIN copyright co
                         ON au.pfile_fk = co.pfile_fk WHERE au.author_pk = co.copyright_pk AND au.content = co.content;",array(),'getCountInsertedAuthorColumns');
  if($countAuthorColumns['count'] == $countInsertedAuthorColumns['count']){
    echo "Deleting the email/url/author data from copyright table...\n";
    $dbManager->queryOnce("DELETE FROM copyright WHERE type <> 'statement' AND content IS NOT NULL;");
  } else {
    echo "Something went wrong please execute the postinstall again...\n";
  }
}