PHP Classes

File: test/statementTest.php

Recommend this page to a friend!
  Classes of Eustaquio Rangel de Oliveira Jr.   PHP PDO OCI   test/statementTest.php   Download  
File: test/statementTest.php
Role: Unit test script
Content type: text/plain
Description: Unit test script
Class: PHP PDO OCI
Access Oracle databases using a PDO class wrapper
Author: By
Last change: Update of test/statementTest.php
Date: 2 months ago
Size: 28,880 bytes
 

Contents

Class file image Download
<?php /** * PDOCI * * PHP version 5.3 * * @category Tests * @package PDOOCI * @author Eustáquio Rangel <eustaquiorangel@gmail.com> * @license http://www.gnu.org/licenses/gpl-2.0.html GPLv2 * @link http://github.com/taq/pdooci */ require_once "../vendor/autoload.php"; /** * Class for use with fetch and \PDO::FETCH_CLASS option * * PHP version 5.3 * * @category Test * @package PDOOCI * @author Eustáquio Rangel <eustaquiorangel@gmail.com> * @license http://www.gnu.org/licenses/gpl-2.0.html GPLv2 * @link http://github.com/taq/pdooci */ class User { public $name; public $email; } /** * Print user name * * @param string $name user name * * @return null */ function user($name) { echo "name: $name\n"; } /** * Print user name and email * * @param string $name user name * @param string $email user email * * @return null */ function useremail($name, $email) { echo "name: $name email: $email\n"; } /** * Testing statement * * PHP version 5.3 * * @category Test * @package PDOOCI * @author Eustáquio Rangel <eustaquiorangel@gmail.com> * @license http://www.gnu.org/licenses/gpl-2.0.html GPLv2 * @link http://github.com/taq/pdooci */ class StatementTest extends PHPUnit\Framework\TestCase { protected static $con = null; /** * Set up a new object * * @return null */ protected function setUp() : void { parent::setUp(); $user = getenv("PDOOCI_user"); $pwd = getenv("PDOOCI_pwd"); $str = getenv("PDOOCI_str"); self::$con = new PDOOCI\PDO($str, $user, $pwd); self::$con->query("delete from people"); } /** * Test an INSERT * * @return null */ public function testInsert() { $stmt = $this->_insertValue(); $this->assertEquals(1, $stmt->rowCount()); } /** * Test a DELETE * * @return null */ public function testDelete() { $this->_insertValue(); $stmt = $this->_deleteValue(); $this->assertEquals(1, $stmt->rowCount()); } /** * Test an INSERT with exec() * * @return null */ public function testInsertWithExec() { $rows = $this->_insertValueWithExec(); $this->assertEquals(1, $rows); } /** * Test a DELETE with exec() * * @return null */ public function testDeleteWithExec() { $this->_insertValueWithExec(); $rows = $this->_deleteValueWithExec(); $this->assertEquals(1, $rows); } /** * Test a fetch with PDO::FETCH_BOTH * * @return null */ public function testFetchBoth() { $this->_insertValueWithExec(); $stmt = self::$con->query("select * from people"); $data = $stmt->fetch(); $stmt->closeCursor(); $this->assertTrue($this->_checkKeys(array(0,"NAME",1,"EMAIL"), array_keys($data))); $this->assertEquals(4, sizeof($data)); $this->assertEquals("eustaquio", $data[0]); $this->assertEquals("eustaquiorangel@gmail.com", $data[1]); $this->assertEquals("eustaquio", $data["NAME"]); $this->assertEquals("eustaquiorangel@gmail.com", $data["EMAIL"]); } /** * Test a fetch with PDO::FETCH_ASSOC * * @return null */ public function testFetchAssoc() { $this->_insertValueWithExec(); $stmt = self::$con->query("select * from people"); $data = $stmt->fetch(\PDO::FETCH_ASSOC); $stmt->closeCursor(); $this->assertTrue($this->_checkKeys(array("NAME","EMAIL"), array_keys($data))); $this->assertEquals(2, sizeof($data)); $this->assertEquals("eustaquio", $data["NAME"]); $this->assertEquals("eustaquiorangel@gmail.com", $data["EMAIL"]); } /** * Tests for case tests * * @param int $case case to convert * @param string $name user name * @param string $email user email * * @dataProvider fetchAssocWithCaseProvider * * @return null */ public function testFetchAssocWithCase($case, $name, $email) { $this->_insertValueWithExec(); self::$con->setAttribute(\PDO::ATTR_CASE, $case); $stmt = self::$con->query("select * from people"); $data = $stmt->fetch(\PDO::FETCH_ASSOC); $stmt->closeCursor(); $this->assertTrue($this->_checkKeys(array($name, $email), array_keys($data))); $this->assertEquals(2, sizeof($data)); $this->assertEquals("eustaquio", $data[$name]); $this->assertEquals("eustaquiorangel@gmail.com", $data[$email]); } /** * Data provider for key case tests * * @return mixed array with sample tests */ public function fetchAssocWithCaseProvider() { return array( array(\PDO::CASE_LOWER, 'name', 'email'), array(\PDO::CASE_UPPER, 'NAME', 'EMAIL'), array(\PDO::CASE_NATURAL, 'NAME', 'EMAIL'), ); } /** * Test a fetch with PDO::FETCH_NUM * * @return null */ public function testFetchNum() { $this->_insertValueWithExec(); $stmt = self::$con->query("select * from people"); $data = $stmt->fetch(\PDO::FETCH_NUM); $stmt->closeCursor(); $this->assertTrue($this->_checkKeys(array(0,1), array_keys($data))); $this->assertEquals(2, sizeof($data)); $this->assertEquals("eustaquio", $data[0]); $this->assertEquals("eustaquiorangel@gmail.com", $data[1]); } /** * Test a fetch with PDO::FETCH_OBJ * * @return null */ public function testFetchObj() { $this->_insertValueWithExec(); $stmt = self::$con->query("select * from people"); $data = $stmt->fetch(\PDO::FETCH_OBJ); $stmt->closeCursor(); $this->assertEquals("eustaquio", $data->NAME); $this->assertEquals("eustaquiorangel@gmail.com", $data->EMAIL); } /** * Test fetch all * * @return null */ public function testFetchAll() { $this->_insertValueWithExec(); $this->_insertValue(array("name"=>"johndoe","email"=>"johndoe@gmail.com")); $stmt = self::$con->query("select * from people"); $data = $stmt->fetchAll(); $stmt->closeCursor(); $this->assertEquals(2, sizeof($data)); $this->assertEquals("eustaquio", $data[0][0]); $this->assertEquals("eustaquiorangel@gmail.com", $data[0][1]); $this->assertEquals("johndoe", $data[1][0]); $this->assertEquals("johndoe@gmail.com", $data[1][1]); } /** * Test fetch all assoc * * @return null */ public function testFetchAllAssoc() { $this->_insertValueWithExec(); $this->_insertValue(array("name"=>"johndoe","email"=>"johndoe@gmail.com")); $stmt = self::$con->query("select * from people"); $data = $stmt->fetchAll(\PDO::FETCH_ASSOC); $stmt->closeCursor(); $this->assertEquals(2, sizeof($data)); $this->assertEquals("eustaquio", $data[0]["NAME"]); $this->assertEquals("eustaquiorangel@gmail.com", $data[0]["EMAIL"]); $this->assertEquals("johndoe", $data[1]["NAME"]); $this->assertEquals("johndoe@gmail.com", $data[1]["EMAIL"]); } /** * Test fetch all both * * @return null */ public function testFetchAllBoth() { $this->_insertValueWithExec(); $this->_insertValue(array("name"=>"johndoe","email"=>"johndoe@gmail.com")); $stmt = self::$con->query("select * from people"); $data = $stmt->fetchAll(\PDO::FETCH_BOTH); $stmt->closeCursor(); $this->assertEquals(2, sizeof($data)); // $this->assertEquals("eustaquio", $data[0]["NAME"]); $this->assertEquals("eustaquio", $data[0][0]); // $this->assertEquals("eustaquiorangel@gmail.com", $data[0]["EMAIL"]); $this->assertEquals("eustaquiorangel@gmail.com", $data[0][1]); // $this->assertEquals("johndoe", $data[1]["NAME"]); $this->assertEquals("johndoe", $data[1][0]); // $this->assertEquals("johndoe@gmail.com", $data[1]["EMAIL"]); $this->assertEquals("johndoe@gmail.com", $data[1][1]); } /** * Test fetch all with column * * @return null */ public function testFetchAllWithColumn() { $this->_insertValueWithExec(); $this->_insertValue(array("name"=>"johndoe","email"=>"johndoe@gmail.com")); $stmt = self::$con->query("select * from people"); $data = $stmt->fetchAll(\PDO::FETCH_COLUMN, 0); $stmt->closeCursor(); $this->assertEquals(2, sizeof($data)); $this->assertEquals(1, sizeof($data[0])); $this->assertEquals("eustaquio", $data[0]); $this->assertEquals(1, sizeof($data[1])); $this->assertEquals("johndoe", $data[1]); } /** * Test fetch all with column and group * * @return null */ public function testFetchAllWithColumnAndGroup() { $this->_insertValueWithExec(); $this->_insertValue(array("name"=>"johndoe","email"=>"johndoe@gmail.com")); $this->_insertValue(array("name"=>"johndoe","email"=>"johndoe@yahoo.com")); $stmt = self::$con->query("select * from people"); $data = $stmt->fetchAll(\PDO::FETCH_COLUMN|\PDO::FETCH_GROUP); $stmt->closeCursor(); $this->assertEquals(2, sizeof($data)); $this->assertEquals(1, sizeof($data["eustaquio"])); $this->assertEquals("eustaquiorangel@gmail.com", $data["eustaquio"][0]); $this->assertEquals(2, sizeof($data["johndoe"])); $this->assertEquals("johndoe@yahoo.com", $data["johndoe"][0]); $this->assertEquals("johndoe@gmail.com", $data["johndoe"][1]); } /** * Test fetch all with class * * @return null */ public function testFetchAllWithClass() { $this->_insertValueWithExec(); $this->_insertValue(array("name"=>"johndoe","email"=>"johndoe@gmail.com")); $stmt = self::$con->query("select * from people"); $data = $stmt->fetchAll(\PDO::FETCH_CLASS, "User"); $stmt->closeCursor(); $this->assertEquals(2, sizeof($data)); $cls = $data[0]; $this->assertTrue(is_object($cls)); $this->assertEquals("User", get_class($cls)); $this->assertEquals("eustaquio", $cls->name); $this->assertEquals("eustaquiorangel@gmail.com", $cls->email); $cls = $data[1]; $this->assertTrue(is_object($cls)); $this->assertEquals("User", get_class($cls)); $this->assertEquals("johndoe", $cls->name); $this->assertEquals("johndoe@gmail.com", $cls->email); } /** * Test fetch all with function * * @return null */ public function testFetchAllWithFunc() { $this->_insertValueWithExec(); $this->_insertValue(array("name"=>"johndoe","email"=>"johndoe@gmail.com")); $stmt = self::$con->query("select * from people"); ob_start(); $data = $stmt->fetchAll(\PDO::FETCH_FUNC, "user"); $stmt->closeCursor(); $rst = ob_get_clean(); $this->assertEquals("name: eustaquio\nname: johndoe\n", $rst); } /** * Test fetch all with function with more than one parameter * * @return null */ public function testFetchAllWithFuncWithMoreParameters() { $this->_insertValue(); $this->_insertValue(array("name"=>"johndoe","email"=>"johndoe@gmail.com")); $stmt = self::$con->prepare("select * from people"); $stmt->execute(); ob_start(); $data = $stmt->fetchAll(\PDO::FETCH_FUNC, "useremail"); $stmt->closeCursor(); $rst = ob_get_clean(); $this->assertEquals("name: eustaquio email: eustaquiorangel@gmail.com\nname: johndoe email: johndoe@gmail.com\n", $rst); } /** * Fetch column * * @return null */ public function testFetchColumn() { $this->_insertValue(); $this->_insertValue(array("name"=>"johndoe","email"=>"johndoe@gmail.com")); $stmt = self::$con->prepare("select * from people"); $stmt->execute(); $this->assertEquals("eustaquio", $stmt->fetchColumn()); $this->assertEquals("johndoe@gmail.com", $stmt->fetchColumn(1)); } /** * Test fetch object * * @return null */ public function testFetchObject() { $this->_insertValueWithExec(); $stmt = self::$con->query("select * from people"); $obj = $stmt->fetchObject("User"); $stmt->closeCursor(); $this->assertTrue(is_object($obj)); $this->assertEquals("User", get_class($obj)); $this->assertEquals("eustaquio", $obj->name); $this->assertEquals("eustaquiorangel@gmail.com", $obj->email); } /** * Test autocommit off and rollback * * @return null */ public function testAutocommitOff() { self::$con->setAttribute(\PDO::ATTR_AUTOCOMMIT, false); $this->_insertValueWithExec(); self::$con->rollBack(); $this->assertEquals(0, $this->_getRowCount()); } /** * Test autocommit off and commit * * @return null */ public function testAutocommitOn() { self::$con->setAttribute(\PDO::ATTR_AUTOCOMMIT, false); $this->_insertValueWithExec(); self::$con->commit(); $this->assertEquals(1, $this->_getRowCount()); } /** * Test beginTransaction and rollback * * @return null */ public function testBeginTransactionAndRollback() { self::$con->beginTransaction(); $this->_insertValueWithExec(); self::$con->rollBack(); $this->assertEquals(0, $this->_getRowCount()); } /** * Test beginTransaction and commit * * @return null */ public function testBeginTransactionAndCommit() { self::$con->setAttribute(\PDO::ATTR_AUTOCOMMIT, false); $this->_insertValueWithExec(); self::$con->commit(); $this->assertEquals(1, $this->_getRowCount()); } /** * Convert a query to use bind marks * * @return String query */ public function testCreateMarks() { $sql = "insert into people (name,email) values (?,?)"; $converted = "insert into people (name,email) values (:pdooci_m0,:pdooci_m1)"; $this->assertEquals($converted, PDOOCI\Statement::insertMarks($sql)); } /** * Convert a query to use bind marks, only when not inside quotes * * @return String query */ public function testCreateMarksNoQuotes() { $sql = "insert into people (name,email,key) values (?,?,'abc?')"; $converted = "insert into people (name,email,key) values (:pdooci_m0,:pdooci_m1,'abc?')"; $this->assertEquals($converted, PDOOCI\Statement::insertMarks($sql)); $sql = "insert into people (name,email,key) values (?,?,'?abc')"; $converted = "insert into people (name,email,key) values (:pdooci_m0,:pdooci_m1,'?abc')"; $this->assertEquals($converted, PDOOCI\Statement::insertMarks($sql)); $sql = "insert into people (name,email,key) values (?,?,'?abc?')"; $converted = "insert into people (name,email,key) values (:pdooci_m0,:pdooci_m1,'?abc?')"; $this->assertEquals($converted, PDOOCI\Statement::insertMarks($sql)); } /** * Don't change the query if is not needed * * @return String query */ public function testDontCreateMarks() { $sql = "insert into people (name,email) values (:name,:email)"; $this->assertEquals($sql, PDOOCI\Statement::insertMarks($sql)); } /** * Prepare a statement without values * * @return Statement statement */ public function testPreparedWithoutValues() { $sql = "insert into people (name,email) values ('eustaquio','eustaquiorangel@gmail.com')"; $stmt = self::$con->prepare($sql); $this->assertNotNull($stmt); $this->assertEquals($sql, $stmt->getStatement()); $this->assertTrue($stmt->execute()); $rows = $stmt->rowCount(); $stmt->closeCursor(); $this->assertEquals(1, $rows); $data = $this->_getValues(); $this->assertEquals("eustaquio", $data["NAME"]); $this->assertEquals("eustaquiorangel@gmail.com", $data["EMAIL"]); } /** * Prepare a statement with numeric index based values * * @return Statement statement */ public function testPreparedWithNumericIndexes() { $user = "u".mktime(); $email= "$user@gmail.com"; $sql = "insert into people (name,email) values (?,?)"; $exp = "insert into people (name,email) values (:pdooci_m0,:pdooci_m1)"; $stmt = self::$con->prepare($sql); $this->assertNotNull($stmt); $this->assertEquals($exp, $stmt->getStatement()); $this->assertTrue($stmt->execute(array($user,$email))); $rows = $stmt->rowCount(); $stmt->closeCursor(); $this->assertEquals(1, $rows); $data = $this->_getValues(); $this->assertEquals($user, $data["NAME"]); $this->assertEquals($email, $data["EMAIL"]); } /** * Prepare a statement with named based values * * @return Statement statement */ public function testPreparedWithNamedIndexes() { $user = "u".mktime(); $email= "$user@gmail.com"; $sql = "insert into people (name,email) values (:name,:email)"; $stmt = self::$con->prepare($sql); $this->assertEquals($sql, $stmt->getStatement()); $this->assertNotNull($stmt); $this->assertTrue($stmt->execute(array(":name"=>$user,":email"=>$email))); $rows = $stmt->rowCount(); $stmt->closeCursor(); $this->assertEquals(1, $rows); $data = $this->_getValues(); $this->assertEquals($user, $data["NAME"]); $this->assertEquals($email, $data["EMAIL"]); } /** * Prepare a crazy statement with indexes and named based values * What stupid crazy maniac will make something like that? * * @return Statement statement */ public function testPreparedWithCrazyIndexes() { $user = "u".mktime(); $email= "$user@gmail.com"; $sql = "insert into people (name,email) values (?,:email)"; $exp = "insert into people (name,email) values (:pdooci_m0,:email)"; $stmt = self::$con->prepare($sql); $this->assertEquals($exp, $stmt->getStatement()); $this->assertNotNull($stmt); $this->assertTrue($stmt->execute(array(0=>$user,":email"=>$email))); $rows = $stmt->rowCount(); $stmt->closeCursor(); $this->assertEquals(1, $rows); $data = $this->_getValues(); $this->assertEquals($user, $data["NAME"]); $this->assertEquals($email, $data["EMAIL"]); } /** * Return results on a foreach loop * * @return null */ public function testForeach() { $this->_insertValue(); $this->_insertValue(); $rst = array(); foreach (self::$con->query("select * from people") as $row) { array_push($rst, $row); } $this->assertEquals(2, sizeof($rst)); } /** * Fetch mode * * @return null */ public function testFetchMode() { $stmt = self::$con->prepare("select * from people"); $stmt->setFetchMode(\PDO::FETCH_ASSOC); $this->assertEquals(\PDO::FETCH_ASSOC, $stmt->getFetchMode()); $stmt->closeCursor(); } /** * Bind column * * @return null */ public function testBindColumn() { $this->_insertValue(); $stmt = self::$con->prepare("select * from people"); $stmt->execute(); $stmt->bindColumn(1, $name); $stmt->bindColumn("email", $email); $row = $stmt->fetch(\PDO::FETCH_BOUND); $this->assertEquals("eustaquio", $name); $this->assertEquals("eustaquiorangel@gmail.com", $email); } /** * Bind named value * * @return null */ public function testBindNamedValue() { $name = "eustaquio"; $this->_insertValue(); $stmt = self::$con->prepare("select * from people where name=:name"); $stmt->bindValue(":name", $name, \PDO::PARAM_STR); $name = "johndoe"; $stmt->execute(); $data = $stmt->fetch(\PDO::FETCH_ASSOC); $stmt->closeCursor(); $this->assertEquals("eustaquio", $data["NAME"]); } /** * Bind numeric value * * @return null */ public function testBindNumericValue() { $name = "eustaquio"; $this->_insertValue(); $stmt = self::$con->prepare("select * from people where name=?"); $stmt->bindValue(1, $name, \PDO::PARAM_STR); $name = "johndoe"; $stmt->execute(); $data = $stmt->fetch(\PDO::FETCH_ASSOC); $stmt->closeCursor(); $this->assertEquals("eustaquio", $data["NAME"]); } /** * Bind named param * * @return null */ public function testBindNamedParam() { $name = "eustaquio"; $this->_insertValue(array("name"=>"johndoe","email"=>"johndoe@gmail.com")); $stmt = self::$con->prepare("select * from people where name=:name"); $stmt->bindParam(":name", $name, \PDO::PARAM_STR); $name = "johndoe"; $stmt->execute(); $data = $stmt->fetch(\PDO::FETCH_ASSOC); $stmt->closeCursor(); $this->assertEquals($name, $data["NAME"]); } /** * Bind named param with length * * @return null */ public function testBindNamedParamWithLength() { $name = "eustaquio"; $this->_insertValue(array("name"=>"johndoe","email"=>"johndoe@gmail.com")); $stmt = self::$con->prepare("select * from people where name=:name"); $stmt->bindParam(":name", $name, \PDO::PARAM_STR, 7); $name = "johndoe"; $stmt->execute(); $data = $stmt->fetch(\PDO::FETCH_ASSOC); $stmt->closeCursor(); $this->assertEquals($name, $data["NAME"]); } /** * Bind numeric value * * @return null */ public function testBindNumericParam() { $name = "eustaquio"; $this->_insertValue(array("name"=>"johndoe","email"=>"johndoe@gmail.com")); $stmt = self::$con->prepare("select * from people where name=?"); $stmt->bindParam(1, $name, \PDO::PARAM_STR); $name = "johndoe"; $stmt->execute(); $data = $stmt->fetch(\PDO::FETCH_ASSOC); $stmt->closeCursor(); $this->assertEquals($name, $data["NAME"]); } /** * Column count * * @return null */ public function testColumnCount() { $this->_insertValue(); $stmt = self::$con->prepare("select * from people"); $this->assertEquals(0, $stmt->columnCount()); $stmt->execute(); $this->assertEquals(2, $stmt->columnCount()); $stmt->closeCursor(); } /** * Debug dump params * * @return null */ public function testDebugDumpParams() { $this->_insertValue(); $name = "eustaquio"; $email= "eustaquiorangel@gmail.com"; $stmt = self::$con->prepare("select * from people where name=:name and email=:email"); $stmt->bindParam(":name", $name); $stmt->bindParam(":email", $email); $stmt->execute(); $str =<<<END SQL: [54] select * from people where name=:name and email=:email Params: 2 Key: Name: [5] :name name=[5] ":name" is_param=1 Key: Name: [6] :email name=[6] ":email" is_param=1 END; ob_start(); $stmt->debugDumpParams(); $contents = ob_get_clean(); $this->assertEquals($str, $contents); $stmt->closeCursor(); } /** * Test column meta data * * @return null */ public function testMetaData() { $this->_insertValue(); $stmt = self::$con->prepare("select * from people"); $stmt->execute(); $data = $stmt->getColumnMeta(0); $this->assertEquals("NAME", $data["name"]); $this->assertEquals(50, $data["len"]); $this->assertEquals(0, $data["precision"]); $this->assertEquals("VARCHAR2", $data["driver:decl_type"]); $data = $stmt->getColumnMeta(1); $this->assertEquals("EMAIL", $data["name"]); $this->assertEquals(30, $data["len"]); $this->assertEquals(0, $data["precision"]); $this->assertEquals("VARCHAR2", $data["driver:decl_type"]); } /** * Fetch null values * * @return null */ public function testFetchNulls() { $this->_insertValue(array("name"=>"johndoe","email"=>null)); $stmt = self::$con->prepare("select * from people"); $stmt->execute(); $data = $stmt->fetch(\PDO::FETCH_ASSOC); $stmt->closeCursor(); $this->assertEquals(2, sizeof($data)); $this->assertEquals("johndoe", $data["NAME"]); $this->assertNull($data["EMAIL"]); } /** * Fetch all null values * * @return null */ public function testFetchAllNulls() { $this->_insertValue(array("name"=>"eustaquio" ,"email"=>null)); $this->_insertValue(array("name"=>"johndoe" ,"email"=>null)); $stmt = self::$con->prepare("select * from people"); $stmt->execute(); $data = $stmt->fetchAll(\PDO::FETCH_ASSOC); $stmt->closeCursor(); $this->assertEquals(2, sizeof($data)); $this->assertEquals("eustaquio", $data[0]["NAME"]); $this->assertNull($data[0]["EMAIL"]); $this->assertEquals("johndoe", $data[1]["NAME"]); $this->assertNull($data[1]["EMAIL"]); } /** * Get statement query string * * @return query string */ public function testQueryString() { $sql = "select count(*) as count from people"; $stmt = self::$con->query($sql); $this->assertEquals($sql, $stmt->queryString); } /**************************************************************************** * Helper functions * ***************************************************************************/ /** * Insert a row * * @param mixed $values optional values * * @return Statement statement */ private function _insertValue($values=null) { $name = "eustaquio"; $email = "eustaquiorangel@gmail.com"; if (!is_null($values)) { $name = $values["name"]; $email = $values["email"]; } return self::$con->query("insert into people (name,email) values ('$name','$email')"); } /** * Delete a row * * @return Statement statement */ private function _deleteValue() { return self::$con->query("delete from people where name='eustaquio'"); } /** * Insert a row with exec() * * @return Statement statement */ private function _insertValueWithExec() { return self::$con->exec("insert into people (name,email) values ('eustaquio','eustaquiorangel@gmail.com')"); } /** * Delete a row with exec() * * @return Statement statement */ private function _deleteValueWithExec() { return self::$con->exec("delete from people where name='eustaquio'"); } /** * Check the array keys * * @param array $expected keys expected * @param array $found keys found * * @return all keys ok */ private function _checkKeys($expected, $found) { $size = sizeof($expected); for ($i=0; $i<$size; $i++) { if ($expected[$i] != $found[$i]) { return false; } } return true; } /** * Get values from table * * @return array values */ private function _getValues() { $stmt = self::$con->query("select * from people"); $data = $stmt->fetch(\PDO::FETCH_ASSOC); return $data; } /** * Get the number of rows on the table * * @return int number of rows */ private function _getRowCount() { $stmt = self::$con->query("select count(*) as count from people"); $data = $stmt->fetch(\PDO::FETCH_ASSOC); $stmt->closeCursor(); return intval($data["COUNT"]); } }