DatabaseHelper::createTable() - Code Metrics - andela-tolotin/Potato-ORM - Measure and Improve Code Quality continuously with Scrutinizer

DatabaseHelper::createTable() A
last analyzed 2016-04-02 23:31 UTC

↳ Parent: DatabaseHelper

Complexity

Conditions	2
Paths	2

Size

Total Lines	12
Code Lines	6

Duplication

Lines	0
Ratio	0 %

Importance

Changes	2
Bugs	1	Features	0

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

<?php

/**
 * @author   Temitope Olotin <[email protected]>
 * @license  <https://opensource.org/license/MIT> MIT
 */
namespace Laztopaz\PotatoORM;

class DatabaseHelper
{
    public $dbConn;

    /**
     * This is a constructor; a default method  that will be called automatically during class instantiation.
     */
    public function __construct($dbConnect)
    {
        $this->dbConn = $dbConnect;
    }

    /**
     * This method creates a particular table.
     *
     * @param tableName
     * $return boolean true or false
     */
    public function createTable($tableName, $conn = null)
    {
        if (is_null($conn)) {
            $conn = $this->dbConn;
        }

        $sql = 'CREATE TABLE IF NOT EXISTS '.$tableName.'(';
        $sql .= ' id INT( 11 ) AUTO_INCREMENT PRIMARY KEY, name VARCHAR( 100 ), gender VARCHAR( 10 ), alias VARCHAR( 150 ) NOT NULL, class VARCHAR( 150 ), stack VARCHAR( 50 ) )';

        return $conn->exec($sql);
        
    }
}


1			<?php
2
3			/**
4			* @author Temitope Olotin <[email protected]>
5			* @license <https://opensource.org/license/MIT> MIT
6			*/
7			namespace Laztopaz\PotatoORM;
8
9			class DatabaseHelper
10			{
11			public $dbConn;
12
13			/**
14			* This is a constructor; a default method that will be called automatically during class instantiation.
15			*/
16			public function __construct($dbConnect)
17			{
18			$this->dbConn = $dbConnect;
19			}
20
21			/**
22			* This method creates a particular table.
23			*
24			* @param tableName
25			* $return boolean true or false
26			*/
27			public function createTable($tableName, $conn = null)
28			{
29			if (is_null($conn)) {
30			$conn = $this->dbConn;
31			}
32
33			$sql = 'CREATE TABLE IF NOT EXISTS '.$tableName.'(';
34			$sql .= ' id INT( 11 ) AUTO_INCREMENT PRIMARY KEY, name VARCHAR( 100 ), gender VARCHAR( 10 ), alias VARCHAR( 150 ) NOT NULL, class VARCHAR( 150 ), stack VARCHAR( 50 ) )';
35
36			return $conn->exec($sql);
37
38			}
39			}
40

andela-tolotin / Potato-ORM

DatabaseHelper::createTable() A last analyzed 2016-04-02 23:31 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

DatabaseHelper::createTable() A
last analyzed 2016-04-02 23:31 UTC