Taeluf.com

Database.php

<?php

namespace Tlf\User;

trait Database {

    public function getPdo(){
        $package = $this->package;
        $driver = $package->get('DB.driver');
        $host = $package->get('DB.host');
        $charset = $package->get('DB.charset');
        $collation = $package->get('DB.collation');
        $database = $package->get('DB.database');
        $username = $package->get('DB.user');
        $password = $package->get('DB.password');
        
        $dsn = "{$driver}:dbname={$database};host={$host};charset={$charset};";
        $pdo = new \PDO($dsn, $username, $password);
        return $pdo;
    }
    protected function emptyDB(){
//         return;
        $package = $this->package;

        $pdo = $this->getPdo();
        $createSql = file_get_contents($package->dir().'/files/empty-db.sql');
        $pdo->exec($createSql);
        
        unset($pdo);
    }
    protected function createDatabase(){
        $package = $this->package;
        
        $pdo = $this->getPdo();
        $createSql = $this->backend->getSqlCreate();
        $pdo->exec($createSql);
        
        unset($pdo);
    }

}