File modules/cms/update/version/DBVersion000016.class.php

Last commit: Sun Oct 1 02:58:08 2023 +0200	Jan Dankert	Refactoring: No it is possible to use 8 byte integers in the database


     1 <?php
     2 
     3 namespace cms\update\version;
     4 
     5 use database\DbVersion;
     6 use database\Column;
     7 
     8 /**
     9  * Converting element types from string to number.
    10  *
    11  * @author dankert
    12  *
    13  */
    14 class DBVersion000016 extends DbVersion
    15 {
    16     /**
    17      *
    18      */
    19     public function update()
    20     {
    21     	$table = $this->table('element');
    22 
    23         // Type 3 = Text is the default.
    24         $table->column('typeid')->type(Column::TYPE_INT)->defaultValue(3)->add();
    25 
    26         $db = $this->getDb();
    27         $tableProject = $table->getSqlName();
    28 
    29         // Update the types
    30         $conversionTable = array(
    31           1 => 'date',
    32           2 => 'number',
    33           3 => 'text',
    34           4 => 'info' ,
    35           5 => 'infodate',
    36           6 => 'link'    ,
    37           7 => 'longtext',
    38           8 => 'code'    ,
    39           9 => 'dynamic' ,
    40          10 => 'select'  ,
    41          11 => 'copy'    ,
    42          12 => 'linkinfo',
    43          13 => 'linkdate',
    44          14 => 'insert'
    45         );
    46 
    47         foreach ($conversionTable as $typeid => $typename )
    48         {
    49             $updateStmt = $db->sql(<<<SQL
    50 UPDATE $tableProject
    51    SET typeid=$typeid WHERE type = '$typename'
    52 SQL
    53             );
    54             $updateStmt->execute();
    55         }
    56 
    57 		$table->column('type')->drop();
    58 
    59 
    60 
    61         $table->column('flags')->type(Column::TYPE_INT)->defaultValue(0)->add();
    62 
    63         $updateStmt = $db->sql(<<<SQL
    64 UPDATE $tableProject
    65    SET flags=flags+1 WHERE html = 1
    66 SQL
    67         );
    68         $updateStmt->execute();
    69 
    70         $updateStmt = $db->sql(<<<SQL
    71 UPDATE $tableProject
    72    SET flags=flags+2 WHERE all_languages = 1
    73 SQL
    74         );
    75         $updateStmt->execute();
    76 
    77         $updateStmt = $db->sql(<<<SQL
    78 UPDATE $tableProject
    79    SET flags=flags+4 WHERE writable = 1
    80 SQL
    81         );
    82         $updateStmt->execute();
    83 
    84         $updateStmt = $db->sql(<<<SQL
    85 UPDATE $tableProject
    86    SET flags=flags+8 WHERE with_icon = 1
    87 SQL
    88         );
    89         $updateStmt->execute();
    90 
    91 
    92 
    93         $table->column('format')->type(Column::TYPE_INT)->defaultValue(0)->add();
    94 
    95         // Format = HTML
    96         $updateStmt = $db->sql(<<<SQL
    97 UPDATE $tableProject
    98    SET format=1 WHERE html = 1 and wiki = 0
    99 SQL
   100         );
   101         $updateStmt->execute();
   102 
   103         // Format = Wiki
   104         $updateStmt = $db->sql(<<<SQL
   105 UPDATE $tableProject
   106    SET format=2 WHERE wiki = 1
   107 SQL
   108         );
   109         $updateStmt->execute();
   110 
   111         // Other formats were not supported up to this version.
   112 
   113         // Cleanup
   114 		$table->column('wiki'         )->drop();
   115 		$table->column('html'         )->drop();
   116 		$table->column('all_languages')->drop();
   117 		$table->column('writable'     )->drop();
   118 		$table->column('with_icon'    )->drop();
   119 
   120     }
   121 
   122 
   123 }
   124 
   125 ?>



Download modules/cms/update/version/DBVersion000016.class.php


History
Sun, 1 Oct 2023 02:58:08 +0200	Jan Dankert	Refactoring: No it is possible to use 8 byte integers in the database
Sun, 7 Mar 2021 00:10:20 +0100	Jan Dankert	Refactoring: Hopefully more performance while accessing the database resultsets.
Fri, 25 Sep 2020 01:00:58 +0200	Jan Dankert	Refactoring: More OO in the database updater :)
Sun, 23 Feb 2020 00:30:10 +0100	Jan Dankert	Refactoring: Namespacing for module 'database-update', now called 'cms\update'.