<?php

// get the config file
include_once("../public/config.php");


//here the db files that include in the file
// GOES HERE ....................
include("../public/include_dao.php");

//Bank
require_once('../models/dao/BankDAO.class.php');
require_once('../models/dto/Bank.class.php');
require_once('../models/mysql/BankMySqlDAO.class.php');
require_once('../models/mysql/ext/BankMySqlExtDAO.class.php');


//Bank
$myBank = new Bank();
$myBankRecord = new BankMySqlDAO();
$myBankEx = new BankMySqlExtDAO();


//get the do the action
$do = $_GET['do'];

try {
    $dbname = ConnectionProperty::getDatabase();
    if ($_SESSION['dbname'] != "" && isset($_SESSION['dbname'])) {
        $dbname = $_SESSION['dbname'];
    }

    $sql = "SELECT CONCAT('ALTER TABLE `', TABLE_SCHEMA, '`.`', TABLE_NAME,'` ENGINE=InnoDB;') as bankname
FROM Information_schema.TABLES WHERE TABLE_SCHEMA = '" . $dbname . "' AND ENGINE = 'MyISAM' AND TABLE_TYPE = 'BASE TABLE'";
    $MyISAMTables = $myBankEx->queryStringSelect($sql);
    foreach ($MyISAMTables as $query) {
        $myBankEx->queryStringUpdate($query->bankname);
    }
    echo "Done";
} catch (Exception $exc) {
    echo "ERROR<br/>";
    echo $exc->getTraceAsString();
}
?>