Protoqol\Prequel\Classes\Database\SequelAdapter

Complexity

Total Complexity

12

Size/Duplication

Total Lines	73
Duplicated Lines	0 %

Importance

Changes

0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	3	1
A	showTables()	0	13	5
A	showDatabases()	0	9	3
A	showTablesFrom()	0	9	3

<?php


namespace Protoqol\Prequel\Classes\Database;

use Exception;

/**
 * Get queries based on chosen SQL driver.
 * Class SequelAdapter
 *
 * @package Protoqol\LaravelSequel\Classes\Database
 */
class SequelAdapter
{

    /**
     * Holds database type e.g. 'mysql', 'pgsql', 'sqlite' etc.
     *
     * @var string $databaseType
     */
    private $databaseType;

    /**
     * SequelAdapter constructor.
     *
     * @param  string  $databaseType
     */
    public function __construct(string $databaseType)
    {
        $this->databaseType = $databaseType;
    }

    /**
     * Get all tables
     *
     * @return string
     * @throws \Exception
     */
    public function showTables()
    {
        switch ($this->databaseType) {
            case 'mysql':
                return 'SHOW TABLES;';
            case 'pgsql':
                return 'SELECT * FROM pg_catalog.pg_tables;';
            case 'sqlite':
                return 'SELECT name FROM sqlite_master WHERE type="table";';
            case 'sqlsrv':
                return 'SELECT * FROM  INFORMATION_SCHEMA.TABLES; GO';
            default:
                throw new Exception('Selected invalid or unsupported database driver');
        }
    }

    /**
     * @return string
     * @throws \Exception
     */
    public function showDatabases()
    {
        switch ($this->databaseType) {
            case 'mysql':
                return 'SHOW DATABASES;';
            case 'pgsql':
                return 'SELECT datname FROM pg_database WHERE datistemplate = false;';
            default:
                throw new Exception('Selected invalid or unsupported database driver');
        }
    }

    /**
     * @param  string  $databaseName
     *
     * @return string
     * @throws \Exception
     */
    public function showTablesFrom(string $databaseName)
    {
        switch ($this->databaseType) {
            case 'mysql':
                return 'SHOW TABLES FROM `'.$databaseName.'`;';
            case 'pgsql':
                return 'SELECT * FROM pg_catalog.pg_tables;';
            default:
                throw new Exception('Selected invalid or unsupported database driver');
        }
    }
}