Tequilarapido\Database\Database

Complexity

Total Complexity

14

Size/Duplication

Total Lines	95
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	2

Importance

Changes

0

13 Methods

Rating	Name	Duplication	Size	Complexity
A	connect()	0	7	1
A	size()	0	15	2
A	select()	0	4	1
A	update()	0	4	1
A	statement()	0	4	1
A	enableQueryLog()	0	4	1
A	getLastQuery()	0	5	1
A	connection()	0	4	1
A	schema()	0	4	1
A	table()	0	4	1
A	beginTransaction()	0	4	1
A	commit()	0	4	1
A	rollback()	0	4	1

<?php namespace Tequilarapido\Database;

use Illuminate\Database\Capsule\Manager as Capsule;

class Database
{

    /**
     * Initialize Illuminate Database connection
     *
     * @param $dbConfig
     */
    public function connect($dbConfig)
    {
        $capsule = new Capsule;
        $capsule->addConnection($dbConfig);
        $capsule->bootEloquent();
        $capsule->setAsGlobal();
    }


    public function size($database)
    {
        $query = '';
        $query .= 'SELECT table_schema, Sum(data_length + index_length) as size ';
        $query .= 'FROM   information_schema.tables ';
        $query .= 'WHERE table_schema = ? ';
        $query .= 'GROUP BY table_schema';

        $res = static::select($query, array($database));
        if (!empty($res[0]['size'])) {
            return round($res[0]['size'] / 1024 / 1024);
        }

        return false;
    }

    //
    // Helpers
    //

    public static function select($query, $bindings = array())
    {
        return Capsule::connection()->select($query, $bindings);
    }

    public static function update($query, $bindings = array())
    {
        return Capsule::connection()->update($query, $bindings);
    }

    public static function statement($query, $bindings = array())
    {
        return Capsule::connection()->statement($query, $bindings);
    }

    public static function enableQueryLog()
    {
        Capsule::connection()->enableQueryLog();
    }

    public static function getLastQuery()
    {
        $queries = Capsule::connection()->getQueryLog();
        return end($queries);
    }

    public static function connection()
    {
        return Capsule::connection();
    }

    public static function schema()
    {
        return Capsule::schema();
    }

    public static function table($table)
    {
        return Capsule::table($table);
    }

    public static function beginTransaction()
    {
        return Capsule::connection()->beginTransaction();
    }

    public static function commit()
    {
        return Capsule::connection()->commit();
    }

    public static function rollback()
    {
        return Capsule::connection()->rollBack();
    }


}