yentu\tests\schema_info\SqliteInfo

Complexity

Total Complexity

11

Size/Duplication

Total Lines	53
Duplicated Lines	0 %

Importance

Changes

0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	columnExists()	0	8	3
A	schemaExists()	0	1	1
A	tableExists()	0	4	1
A	foreignKeyExists()	0	12	2
A	columnNulable()	0	11	4

<?php

/* 
 * The MIT License
 *
 * Copyright 2015 ekow.
 *
 * Permission is hereby granted, free of charge, to any person obtaining a copy
 * of this software and associated documentation files (the "Software"), to deal
 * in the Software without restriction, including without limitation the rights
 * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
 * copies of the Software, and to permit persons to whom the Software is
 * furnished to do so, subject to the following conditions:
 *
 * The above copyright notice and this permission notice shall be included in
 * all copies or substantial portions of the Software.
 *
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
 * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
 * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
 * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
 * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
 * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
 * THE SOFTWARE.
 */

namespace yentu\tests\schema_info;

class SqliteInfo extends \yentu\tests\SchemaInfo
{
    /**
     * 
     * @param type $table

The type yentu\tests\schema_info\type was not found. Maybe you did not declare it correctly or list all dependencies?

     * @return boolean
     */
    public function foreignKeyExists($table) 
    {
        $tableQuery = $this->getPDO()->query(
            "SELECT sql FROM sqlite_master WHERE name = '{$table['table']}'"
        )->fetchAll(\PDO::FETCH_ASSOC);
        if(preg_match("/CONSTRAINT\s+`{$table['name']}`\s+FOREIGN KEY/", $tableQuery[0]['sql']))
        {
            return true;
        }
        else
        {
            return false;
        }
    }

    public function columnExists($column) 
    {
        $columns = $this->getPDO()->query("PRAGMA table_info({$this->table['table']})")->fetchAll(\PDO::FETCH_ASSOC);
        foreach($columns as $tableColumn)
        {
            if($column === $tableColumn['name']) return true;
        }
        return false;
    }

    public function schemaExists($table) {
        
    }

    public function tableExists($table) 
    {
        $count = $this->getPDO()->query("SELECT count(*) as c FROM sqlite_master WHERE name = '$table'")->fetchAll(\PDO::FETCH_ASSOC);
        return $count[0]['c'] == '1';
    }

    public function columnNulable($column, $nullability) 
    {
        $columns = $this->getPDO()->query("PRAGMA table_info({$this->table['table']})")->fetchAll(\PDO::FETCH_ASSOC);
        foreach($columns as $tableColumn)
        {
            if($column == $tableColumn['name'])
            {
                return ($tableColumn['notnull'] == '1' ? false : true) === $nullability;
            }
        }
        return false;        
    }

}