DbExporter::getTableDescribes() - Code Metrics - nWidart/DbExporter - Measure and Improve Code Quality continuously with Scrutinizer

DbExporter::getTableDescribes() A
last analyzed 2016-07-23 06:26 UTC

↳ Parent: DbExporter

Complexity

Conditions	1
Paths	1

Size

Total Lines	7
Code Lines	5

Duplication

Lines	0
Ratio	0 %

Importance

Changes	2
Bugs	1	Features	0

Metric	Value
c	2
b	1
f	0
dl	0
loc	7
rs	9.4285
cc	1
eloc	5
nc	1
nop	1

<?php namespace Nwidart\DbExporter;

use DB;

abstract class DbExporter
{
    /**
     * Contains the ignore tables
     * @var array $ignore
     */
    public static $ignore = array('migrations');
    public static $remote;

    /**
     * Get all the tables
     * @return mixed
     */
    protected function getTables()
    {
        $pdo = DB::connection()->getPdo();
        return $pdo->query('SELECT table_name FROM information_schema.tables WHERE table_schema="' . $this->database . '"');
    }

    public function getTableIndexes($table)
    {
        $pdo = DB::connection()->getPdo();
        return $pdo->query('SHOW INDEX FROM ' . $table . ' WHERE Key_name != "PRIMARY"');
    }

    /**
     * Get all the columns for a given table
     * @param $table
     * @return mixed
     */
    protected function getTableDescribes($table)
    {
        return DB::table('information_schema.columns')
            ->where('table_schema', '=', $this->database)
            ->where('table_name', '=', $table)
            ->get($this->selects);
    }

    /**
     * Grab all the table data
     * @param $table
     * @return mixed
     */
    protected function getTableData($table)
    {
        return DB::table($table)->get();
    }

    /**
     * Write the file
     * @return mixed
     */
    abstract public function write();

    /**
     * Convert the database to a usefull format
     * @param null $database
     * @return mixed
     */
    abstract public function convert($database = null);

    /**
     * Put the converted stub into a template
     * @return mixed
     */
    abstract protected function compile();
}

1			<?php namespace Nwidart\DbExporter;
2
3			use DB;
4
5			abstract class DbExporter
6			{
7			/**
8			* Contains the ignore tables
9			* @var array $ignore
10			*/
11			public static $ignore = array('migrations');
12			public static $remote;
13
14			/**
15			* Get all the tables
16			* @return mixed
17			*/
18			protected function getTables()
19			{
20			$pdo = DB::connection()->getPdo();
21			return $pdo->query('SELECT table_name FROM information_schema.tables WHERE table_schema="' . $this->database . '"');
22			}
23
24			public function getTableIndexes($table)
25			{
26			$pdo = DB::connection()->getPdo();
27			return $pdo->query('SHOW INDEX FROM ' . $table . ' WHERE Key_name != "PRIMARY"');
28			}
29
30			/**
31			* Get all the columns for a given table
32			* @param $table
33			* @return mixed
34			*/
35			protected function getTableDescribes($table)
36			{
37			return DB::table('information_schema.columns')
38			->where('table_schema', '=', $this->database)
39			->where('table_name', '=', $table)
40			->get($this->selects);
41			}
42
43			/**
44			* Grab all the table data
45			* @param $table
46			* @return mixed
47			*/
48			protected function getTableData($table)
49			{
50			return DB::table($table)->get();
51			}
52
53			/**
54			* Write the file
55			* @return mixed
56			*/
57			abstract public function write();
58
59			/**
60			* Convert the database to a usefull format
61			* @param null $database
62			* @return mixed
63			*/
64			abstract public function convert($database = null);
65
66			/**
67			* Put the converted stub into a template
68			* @return mixed
69			*/
70			abstract protected function compile();
71			}

nWidart / DbExporter

DbExporter::getTableDescribes() A last analyzed 2016-07-23 06:26 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

DbExporter::getTableDescribes() A
last analyzed 2016-07-23 06:26 UTC