Forum

<?php
/*##################################################
 *                             CookokSetup.class.php
 *                            -------------------
 *   begin                : November 13, 2015
 *   copyright            : (C) 2015 Alexandre NAVARO
 *   email                : alexnava@hotmail.fr
 *
 *
 ###################################################
 *
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 2 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
 *
 ###################################################*/
 
class CookokSetup extends DefaultModuleSetup
{
    private static $cookok_table;
 
    public static function __static()
    {
        self::$cookok_table = PREFIX . 'cookok';
    }
 
    public function install()
    {
        $this->drop_tables();
        $this->create_tables();
        $this->insert_data();
    }
 
    public function uninstall()
    {
        $this->drop_tables();
    }
 
    private function drop_tables()
    {
        PersistenceContext::get_dbms_utils()->drop(array(self::$cookok_table));
    }
 
    private function create_tables()
    {
        $fields = array(
            'id' => array('type' => 'integer', 'length' => 11, 'autoincrement' => true, 'notnull' => 1),
            'option' => array('type' => 'string', 'length' => 250, 'notnull' => 1, 'default' => "''"),
            'value' => array('type' => 'text', 'length' => 65000)
            );
        $options = array(
            'primary' => array('id')
            );
        PersistenceContext::get_dbms_utils()->create_table(self::$cookok_table, $fields, $options);
    }
 
    private function insert_data()
    {
        $this->insert_cookok_data('box_enable', 'true');
        $this->insert_cookok_data('box_title', 'Utilisation de cookies');
        $this->insert_cookok_data('box_content', 'Ce site utilises des cookies afin de vous assurer une expérience obtimale sur notre site web.');
        $this->insert_cookok_data('box_button', 'Compris');
        $this->insert_cookok_data('box_cookieTime', '365');
    }
 
    private function insert_cookok_data($option, $value) {
        PersistenceContext::get_querier()->insert(self::$cookok_table, array(
            'option' => $option,
            'value' => $value
        ));
    }
}
?>