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

Last commit: Sun Mar 7 00:10:20 2021 +0100	Jan Dankert	Refactoring: Hopefully more performance while accessing the database resultsets.


     1 <?php
     2 
     3 namespace cms\update\version;
     4 
     5 use database\DbVersion;
     6 use database\Column;
     7 use security\Password;
     8 
     9 /**
    10  * The permission flags are now stored in 1 bitmask-column.
    11  *
    12  * @author dankert
    13  *
    14  */
    15 class DBVersion000028 extends DbVersion
    16 {
    17     /**
    18      *
    19      */
    20     public function update()
    21     {
    22     	$table = $this->table('acl');
    23     	$table->addIndex( ['type'] );
    24 
    25         $table->column('flags'  )->type(Column::TYPE_INT)->defaultValue(1)->add();
    26 
    27         // Initial Value: Copy from element.
    28         $tableSqlName = $table->getSqlName();
    29 
    30         $updateStmt = $this->getDb()->sql(<<<SQL
    31 UPDATE $tableSqlName
    32    SET flags=1;
    33 SQL
    34         );
    35         $updateStmt->execute();
    36 
    37         $updateStmt = $this->getDb()->sql(<<<SQL
    38 UPDATE $tableSqlName
    39    SET flags=flags+2 WHERE is_write=1;
    40 SQL
    41         );
    42         $updateStmt->execute();
    43 
    44         $updateStmt = $this->getDb()->sql(<<<SQL
    45 UPDATE $tableSqlName
    46    SET flags=flags+4 WHERE is_prop=1;
    47 SQL
    48         );
    49         $updateStmt->execute();
    50 
    51         $updateStmt = $this->getDb()->sql(<<<SQL
    52 UPDATE $tableSqlName
    53    SET flags=flags+64 WHERE is_create_folder=1;
    54 SQL
    55         );
    56         $updateStmt->execute();
    57 
    58         $updateStmt = $this->getDb()->sql(<<<SQL
    59 UPDATE $tableSqlName
    60    SET flags=flags+128 WHERE is_create_file=1;
    61 SQL
    62         );
    63         $updateStmt->execute();
    64 
    65         $updateStmt = $this->getDb()->sql(<<<SQL
    66 UPDATE $tableSqlName
    67    SET flags=flags+256 WHERE is_create_link=1;
    68 SQL
    69         );
    70         $updateStmt->execute();
    71 
    72         $updateStmt = $this->getDb()->sql(<<<SQL
    73 UPDATE $tableSqlName
    74    SET flags=flags+512 WHERE is_create_page=1;
    75 SQL
    76         );
    77         $updateStmt->execute();
    78 
    79         $updateStmt = $this->getDb()->sql(<<<SQL
    80 UPDATE $tableSqlName
    81    SET flags=flags+8 WHERE is_delete=1;
    82 SQL
    83         );
    84         $updateStmt->execute();
    85 
    86         $updateStmt = $this->getDb()->sql(<<<SQL
    87 UPDATE $tableSqlName
    88    SET flags=flags+16 WHERE is_release=1;
    89 SQL
    90         );
    91         $updateStmt->execute();
    92 
    93         $updateStmt = $this->getDb()->sql(<<<SQL
    94 UPDATE $tableSqlName
    95    SET flags=flags+32 WHERE is_publish=1;
    96 SQL
    97         );
    98         $updateStmt->execute();
    99 
   100         $updateStmt = $this->getDb()->sql(<<<SQL
   101 UPDATE $tableSqlName
   102    SET flags=flags+1024 WHERE is_grant=1;
   103 SQL
   104         );
   105         $updateStmt->execute();
   106 
   107         $updateStmt = $this->getDb()->sql(<<<SQL
   108 UPDATE $tableSqlName
   109    SET flags=flags+2048 WHERE is_transmit=1;
   110 SQL
   111         );
   112         $updateStmt->execute();
   113 
   114 		$table->column('is_write'        )->drop();
   115 		$table->column('is_prop'         )->drop();
   116 		$table->column('is_create_folder')->drop();
   117 		$table->column('is_create_file'  )->drop();
   118 		$table->column('is_create_page'  )->drop();
   119 		$table->column('is_create_link'  )->drop();
   120 		$table->column('is_delete'       )->drop();
   121 		$table->column('is_release'      )->drop();
   122 		$table->column('is_publish'      )->drop();
   123 		$table->column('is_grant'        )->drop();
   124 		$table->column('is_transmit'     )->drop();
   125 	}
   126 }
   127 



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


History
Sun, 7 Mar 2021 00:10:20 +0100	Jan Dankert	Refactoring: Hopefully more performance while accessing the database resultsets.
Sat, 6 Mar 2021 21:45:42 +0100	Jan Dankert	Refactoring: Storing all permission bits in a bitmask value