pdoDB Class Reference

Collaboration diagram for pdoDB:

Public Member Functions
	__construct ()
	nextId ($table_name)
	createTable ($table_name, $fields)
	experimental.... More...
	addPrimaryKey ($table_name, $primary_keys)
	createSequence ($table_name)
	tableExists ($table_name)
	tableColumnExists ($table_name, $column_name)
	addTableColumn ($table_name, $column_name, $attributes)
	dropTable ($table_name)
	query ($query)
	fetchAll ($query_result)
	dropSequence ($table_name)
	dropTableColumn ($table_name, $column_name)
	renameTableColumn ($table_name, $column_old_name, $column_new_name)
	insert ($table_name, $values)
	fetchObject ($query_result)
	update ($table_name, $values, $where)
	manipulate ($query)
	fetchAssoc ($query_result)
	numRows ($query_result)
	quote ($value, $type)
	addIndex ($table_name, $index_name)

Protected Member Functions
	createTableFields ($fields)

Protected Attributes
	$pdo
	$type_to_mysql_type

Static Protected Attributes
static	$staticPbo

Detailed Description

Definition at line 3 of file class.pdoDB.php.

Constructor & Destructor Documentation

__construct()

pdoDB::__construct

(

)

Definition at line 26 of file class.pdoDB.php.

    {
        $this->pdo = new PDO('mysql:host=localhost;dbname=test_db;charset=utf8', 'travis', '');
        $this->pdo->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true);
        $attr = PDO::MYSQL_ATTR_USE_BUFFERED_QUERY;
    }

Member Function Documentation

addIndex()

pdoDB::addIndex	(		$table_name,
			$index_name
	)

Parameters

$table_name
$index_name

Returns

null

Definition at line 334 of file class.pdoDB.php.

    {
        return null;
    }

addPrimaryKey()

pdoDB::addPrimaryKey	(		$table_name,
			$primary_keys
	)

Parameters

$table_name	string
$primary_keys	array

Definition at line 95 of file class.pdoDB.php.

References $keys.

    {
        $keys = implode($primary_keys);
        $this->pdo->exec("ALTER TABLE $table_name ADD PRIMARY KEY ($keys)");
    }

addTableColumn()

pdoDB::addTableColumn	(		$table_name,
			$column_name,
			$attributes
	)

Parameters

$table_name	string
$column_name	string
$attributes	array

Definition at line 147 of file class.pdoDB.php.

References $attributes, array, and createTableFields().

    {
        $col = array( $column_name => $attributes );
        $col_str = $this->createTableFields($col);
        $this->pdo->exec("ALTER TABLE $$table_name ADD $$col_str");
    }

Here is the call graph for this function:

createSequence()

pdoDB::createSequence

(

$table_name

)

Parameters

$table_name

string

Definition at line 105 of file class.pdoDB.php.

    {
        //TODO
    }

createTable()

pdoDB::createTable	(		$table_name,
			$fields
	)

experimental....

Parameters

$table_name	string
$fields	array

Definition at line 62 of file class.pdoDB.php.

References $query, and createTableFields().

    {
        $fields_query = $this->createTableFields($fields);
        $query = "CREATE TABLE $table_name ($fields_query);";
        $this->pdo->exec($query);
    }

Here is the call graph for this function:

createTableFields()

pdoDB::createTableFields (   $fields )

protected

Parameters

$fields

Returns

string

Definition at line 75 of file class.pdoDB.php.

References $name, $query, and $type.

Referenced by addTableColumn(), and createTable().

    {
        $query = "";
        foreach ($fields as $name => $field) {
            $type = $this->type_to_mysql_type[$field['type']];
            $length = $field['length'];
            $primary = isset($field['is_primary']) && $field['is_primary'] ? "PRIMARY KEY" : "";
            $notnull = isset($field['is_notnull']) && $field['is_notnull'] ? "NOT NULL" : "";
            $sequence = isset($field['sequence']) && $field['sequence'] ? "AUTO_INCREMENT" : "";
            $query .= "$name $type ($length) $sequence $primary $notnull,";
        }

        return substr($query, 0, -1);
    }

Here is the caller graph for this function:

dropSequence()

pdoDB::dropSequence

(

$table_name

)

Parameters

$table_name

string

Definition at line 192 of file class.pdoDB.php.

References tableExists().

    {
        $table_seq = $table_name . "_seq";
        if ($this->tableExists($table_seq)) {
            $this->pdo->exec("DROP TABLE $table_seq");
        }
    }

Here is the call graph for this function:

dropTable()

pdoDB::dropTable

(

$table_name

)

Parameters

$table_name

string

Definition at line 158 of file class.pdoDB.php.

    {
        $this->pdo->exec("DROP TABLE $table_name");
    }

dropTableColumn()

pdoDB::dropTableColumn	(		$table_name,
			$column_name
	)

Parameters

$table_name	string
$column_name	string

Definition at line 205 of file class.pdoDB.php.

    {
        $this->pdo->exec("ALTER TABLE $$table_name DROP COLUMN $column_name");
    }

fetchAll()

pdoDB::fetchAll

(

$query_result

)

Parameters

$query_result

PDOStatement

Returns

array

Definition at line 183 of file class.pdoDB.php.

    {
        return $query_result->fetchAll($query_result);
    }

fetchAssoc()

pdoDB::fetchAssoc

(

$query_result

)

Parameters

$query_result

PDOStatement

Returns

mixed

Definition at line 291 of file class.pdoDB.php.

References $res.

    {
        $res = $query_result->fetch(PDO::FETCH_ASSOC);
        if ($res == null) {
            $query_result->closeCursor();

            return null;
        }

        return $res;
    }

fetchObject()

pdoDB::fetchObject

(

$query_result

)

Parameters

$query_result

PDOStatement

Returns

mixed|null

Definition at line 242 of file class.pdoDB.php.

References $res.

    {
        $res = $query_result->fetchObject();
        if ($res == null) {
            $query_result->closeCursor();

            return null;
        }

        return $res;
    }

insert()

pdoDB::insert	(		$table_name,
			$values
	)

Parameters

$table_name	string
$values

Definition at line 226 of file class.pdoDB.php.

References array, and quote().

    {
        $real = array();
        foreach ($values as $val) {
            $real[] = $this->quote($val[1], $val[0]);
        }
        $values = implode(",", $real);
        $this->pdo->exec("INSERT INTO $table_name VALUES ($values)");
    }

Here is the call graph for this function:

manipulate()

pdoDB::manipulate

(

$query

)

Parameters

$query

string

Definition at line 280 of file class.pdoDB.php.

References $query.

    {
        $this->pdo->exec($query);
    }

nextId()

pdoDB::nextId

(

$table_name

)

Parameters

$table_name

string

Returns

int

Definition at line 39 of file class.pdoDB.php.

References $rows, and tableExists().

    {
        if ($this->tableExists($table_name . '_seq')) {
            $table_seq = $table_name . '_seq';
            $stmt = $this->pdo->prepare("SELECT * FROM $table_seq");
            $stmt->execute();
            $rows = $stmt->fetch(PDO::FETCH_ASSOC);
            $stmt->closeCursor();

            return count($rows) ? 0 : $rows['seq'];
        } else {
            //            return $this->pdo->lastInsertId($table_name) + 1;
            return 0;
        }
    }

Here is the call graph for this function:

numRows()

pdoDB::numRows

(

$query_result

)

Parameters

$query_result

PDOStatement

Returns

int

Definition at line 309 of file class.pdoDB.php.

    {
        return $query_result->rowCount();
    }

query()

pdoDB::query

(

$query

)

Parameters

$query

string

Returns

Definition at line 169 of file class.pdoDB.php.

References $query, and $res.

    {
        $res = $this->pdo->query($query);
        $err = $this->pdo->errorInfo();

        return $res;
    }

quote()

pdoDB::quote	(		$value,
			$type
	)

Parameters

$value
$type

Returns

string

Definition at line 321 of file class.pdoDB.php.

Referenced by insert(), and update().

    {
        //TODO TYPE SENSITIVE.
        return $this->pdo->quote($value);
    }

Here is the caller graph for this function:

renameTableColumn()

pdoDB::renameTableColumn	(		$table_name,
			$column_old_name,
			$column_new_name
	)

Parameters

$table_name	string
$column_old_name	string
$column_new_name	string

Definition at line 216 of file class.pdoDB.php.

    {
        $this->pdo->exec("alter table $table_name change $column_old_name $column_new_name");
    }

tableColumnExists()

pdoDB::tableColumnExists	(		$table_name,
			$column_name
	)

Parameters

$table_name	string
$column_name	string

Returns

bool

Definition at line 133 of file class.pdoDB.php.

    {
        $statement = $this->pdo->query("SHOW COLUMNS FROM $table_name WHERE Field = '$column_name'");
        $statement != null ? $statement->closeCursor() : "";

        return $statement != null && $statement->rowCount() != 0;
    }

tableExists()

pdoDB::tableExists

(

$table_name

)

Parameters

$table_name

string

Returns

bool

Definition at line 116 of file class.pdoDB.php.

References $result, and array.

Referenced by dropSequence(), and nextId().

    {
        $result = $this->pdo->prepare("SHOW TABLES LIKE :table_name");
        $result->execute(array( ':table_name' => $table_name ));
        $return = $result->rowCount();
        $result->closeCursor();

        return $return > 0;
    }

Here is the caller graph for this function:

update()

pdoDB::update	(		$table_name,
			$values,
			$where
	)

Parameters

$table_name	string
$values	array
$where	array

Definition at line 260 of file class.pdoDB.php.

References $key, $query, and quote().

    {
        $query = "UPDATE $table_name SET ";
        foreach ($values as $key => $val) {
            $qval = $this->quote($val[1], $val[0]);
            $query .= "$key=$qval,";
        }
        $query = substr($query, 0, -1) . " WHERE ";
        foreach ($where as $key => $val) {
            $qval = $this->quote($val[1], $val[0]);
            $query .= "$key=$qval,";
        }
        $query = substr($query, 0, -1);
        $this->pdo->exec($query);
    }

Here is the call graph for this function:

Field Documentation

$pdo

pdoDB::$pdo

protected

Definition at line 9 of file class.pdoDB.php.

$staticPbo

pdoDB::$staticPbo

staticprotected

Definition at line 10 of file class.pdoDB.php.

$type_to_mysql_type

pdoDB::$type_to_mysql_type

protected

Initial value:

= array(
        'text' => 'VARCHAR',
        'integer' => 'INT',
        'float' => 'DOUBLE',
        'date' => 'DATE',
        'time' => 'TIME',
        'datetime' => 'TIMESTAMP',
        'clob' => 'LONGTEXT',

    )

Definition at line 14 of file class.pdoDB.php.

---

The documentation for this class was generated from the following file:

• Services/ActiveRecord/Connector/DataBase/class.pdoDB.php