framework/src/Dever/Store/Pdo.php

<?php namespace Dever\Store;
use Dever\Debug;
use Dever\Output;
use Dever\Sql;
class Pdo extends Base
{
    protected function connect($setting)
    {
        $this->type = $setting['type'];
        $handle = false;
        if (strpos($setting['host'], ':') !== false) {
            list($setting['host'], $setting['port']) = explode(':', $setting['host']);
        }
        if (empty($setting['pdo_type'])) {
            $setting['pdo_type'] = 'mysql';
        }
        if (empty($setting['charset'])) {
            $setting['charset'] = 'utf8mb4';
        }
        if (empty($setting['collation'])) {
            $setting['collation'] = 'utf8mb4_general_ci';
        }
        $dsn = $setting['pdo_type'] . ':type='.$setting['type'].';host='.$setting['host'].';port='.$setting['port'].';dbname='.$setting['name'].';collation='.$setting['collation'];
        try {
            if (empty($setting['persistent'])) {
                $persistent = false;
            }
            $handle = new \PDO($dsn, $setting['user'], $setting['pwd'], array(\PDO::ATTR_PERSISTENT => $persistent));
            $handle->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
            $handle->setAttribute(\PDO::ATTR_CASE, \PDO::CASE_NATURAL);
            $handle->setAttribute(\PDO::ATTR_DEFAULT_FETCH_MODE, \PDO::FETCH_ASSOC);
            //$handle->setAttribute(\PDO::ATTR_EMULATE_PREPARES, false);
            //handle->setAttribute(\PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, false);
            Debug::add('db ' . $setting['host'] . ' connected', $setting['type']);
            return $handle;
        } catch (\PDOException $e) {
            if (strstr($e->getMessage(), 'Unknown database')) {
                $this->create($setting);
                $this->connect($setting);
            } else {
                Output::error($e->getMessage());
            }
        }
    }
    private function create($setting)
    {
        $method = 'mysql';
        if (function_exists('mysqli_connect')) {
            $method = 'mysqli';
        }
        $connect = $method . '_connect';
        $query = $method . '_query';
        $close = $method . '_close';
        $link = $connect($setting['host'] . ':' . $setting['port'], $setting['user'], $setting['pwd']);
        if ($link) {
            $sql = 'CREATE DATABASE `' . $setting['name'] . '` DEFAULT CHARACTER SET ' . $setting['charset'] . ' COLLATE ' . $setting['collation'];
            if ($method == 'mysql') {
                $query($sql, $link);
            } else {
                $query($link, $sql);
            }
            $close($link);
        }
    }
    public function struct($config, $state = 0)
    {
        if ($state) {
            $sql = Sql::alter($config['table'], $config['struct'], $this->query(Sql::desc($config['table'])));
            if ($sql) {
                $this->query($sql);
            }
        } else {
            $this->query(Sql::create($config));
        }
        if (isset($config['default']) && $config['default']) {
            $count = $this->count($config['table'], array(), $config['struct']);
            if (!$count) {
                $this->query(Sql::inserts($config['table'], $config['default']));
            }
        }
    }
    public function index($config, $state = 0)
    {
        $this->query(Sql::index($config['table'], $config['index'], $this->query(Sql::showIndex($config['table']))));
    }
    public function partition($config, $partition)
    {
        $this->query(Sql::partition($config['table'], $partition, $this->query(Sql::showIndex($config['table']))));
    }
    public function query($sql, $bind = array(), $method = 'read')
    {
        try {
            if ($bind) {
                $handle = $this->$method->prepare($sql);
                $handle->execute($bind);
            } else {
                $handle = $this->$method->query($sql);
            }
        } catch (\PDOException $exception) {
            $this->error(array('sql' => $sql, 'msg' => $exception->getMessage()));
        }
        if (Debug::$shell) {
            $this->sql($sql, $bind);
            $this->log(array('sql' => $sql, 'count' => $handle->rowCount()));
        }
        return $handle;
    }
    public function load($table, $param, $set, $field, $lock)
    {
        $bind = array();
        $sql = Sql::select($table, $param, $bind, $set, $field, $lock);
        return $this->query($sql, $bind);
    }
    public function select($table, $param, $set, $field, $lock)
    {
        return $this->load($table, $param, $set, $field, $lock)->fetchAll();
    }
    public function find($table, $param, $set, $field, $lock)
    {
        return $this->load($table, $param, $set, $field, $lock)->fetch();
    }
    public function count($table, $param, $field)
    {
        return $this->load($table, $param, array('col'=>'count(*)'), $field, false)->fetch(\PDO::FETCH_NUM)[0];
    }
    public function insert($table, $data, $field)
    {
        $bind = array();
        $sql = Sql::insert($table, $data, $bind, $field);
        $this->query($sql, $bind, 'update');
        return $this->update->lastInsertId();
    }
    public function update($table, $param, $data, $field)
    {
        $bind = array();
        $sql = Sql::update($table, $param, $data, $bind, $field);
        return $this->query($sql, $bind, 'update')->rowCount();
    }
    public function delete($table, $param, $field)
    {
        $bind = array();
        $sql = Sql::delete($table, $param, $bind, $field);
        return $this->query($sql, $bind, 'update')->rowCount();
    }
    public function begin()
    {
        $this->update->beginTransaction();
    }
    public function commit()
    {
        $this->update->commit();
    }
    public function rollback()
    {
        $this->update->rollback();
    }
    public function transaction($class, $param, $msg)
    {
        if (\Dever::$commit) {
            try {
                \Dever::$commit = false;
                $this->begin();
                $result = call_user_func_array($class, $param);
                $this->commit();
                return $result;
            } catch (\Exception $e) {
                $this->rollBack();
                Output::error($msg);
            }
        } else {
            return call_user_func_array($class, $param);
        }
    }
}