Elimuswift\DbExporter\DbExporter

Complexity

Total Complexity

9

Size/Duplication

Total Lines	150
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	0

Importance

Changes

0

9 Methods

Rating	Name	Duplication	Size	Complexity
	write()	0	1	?
	convert()	0	1	?
	compile()	0	1	?
A	getTables()	0	6	1
A	getTableIndexes()	0	6	1
A	getTableDescribes()	0	7	1
A	getTableConstraints()	0	9	1
A	getTableData()	0	4	1
A	makePath()	0	15	4

<?php

namespace Elimuswift\DbExporter;

use DB;

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

    /**
     * Get all the tables.
     *
     * @return mixed
     */
    public $database;

    /**
     * Select fields.
     *
     * @var array
     **/
    protected $selects = [
                          'column_name as Field',
                          'column_type as Type',
                          'is_nullable as Nullable',
                          'column_key as Key',
                          'column_default as Default',
                          'extra as Extra',
                          'data_type as Data_Type',
                          'CHARACTER_MAXIMUM_LENGTH as Length',
                          'NUMERIC_PRECISION as Precision',
                          'NUMERIC_SCALE as Scale',
                         ];
    /**
     * Select fields from  constraints.
     *
     * @var array
     **/
    protected $constraints = [
                                'key_column_usage.table_name as Table',
                                'key_column_usage.column_name as Field',
                                'key_column_usage.referenced_table_name as ON',
                                'key_column_usage.referenced_column_name as References',
                                'REFERENTIAL_CONSTRAINTS.UPDATE_RULE as onUpdate',
                                'REFERENTIAL_CONSTRAINTS.DELETE_RULE as onDelete',
                            ];

    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 '.$this->database.'.'.$table.' WHERE Key_name != "PRIMARY"');
    }

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

    /**
     * Get all the foreign key constraints for a given table.
     *
     * @param $table
     *
     * @return array
     */
    protected function getTableConstraints($table)
    {
        return DB::table('information_schema.key_column_usage')
            ->distinct()
            ->join('information_schema.REFERENTIAL_CONSTRAINTS', 'REFERENTIAL_CONSTRAINTS.CONSTRAINT_NAME', '=', 'key_column_usage.CONSTRAINT_NAME')
            ->where('key_column_usage.table_schema', '=', $this->database)
            ->where('key_column_usage.table_name', '=', $table)
            ->get($this->constraints);
    }

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

    /**
     * Try to create directories if they dont exist.
     *
     * @param string $path
     **/
    protected function makePath($path)
    {
        $del = DIRECTORY_SEPARATOR;
        $dir = '';
        $directories = explode($del, $path);
        foreach ($directories as $directory) {
            if (!empty($directory)) {
                $dir .= $del.$directory;
            }

            if (!is_dir($dir)) {
                @mkdir($dir, 0775, true);

It seems like you do not handle an error condition here. This can introduce security issues, and is generally not recommended.

            }
        }
    }

    /**
     * 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($table);
}