PHP Classes

File: CHANGELOG.md

Recommend this page to a friend!
  Classes of Josantonius   PHP Database   CHANGELOG.md   Download  
File: CHANGELOG.md
Role: Auxiliary data
Content type: text/markdown
Description: Auxiliary data
Class: PHP Database
Execute common SQL queries with a fluent interface
Author: By
Last change: Updated to 1.1.8 version
Updated to 1.1.7 version
Date: 6 years ago
Size: 18,846 bytes
 

Contents

Class file image Download

CHANGELOG

1.1.8 - 2017-11-08

  • Implemented `PHP Mess Detector` to detect inconsistencies in code styles.
  • Implemented `PHP Code Beautifier and Fixer` to fixing errors automatically.
  • Implemented `PHP Coding Standards Fixer` to organize PHP code automatically according to PSR standards.

1.1.7 - 2017-10-26

  • Implemented `PSR-4 autoloader standard` from all library files.
  • Implemented `PSR-2 coding standard` from all library PHP files.
  • Implemented `PHPCS` to ensure that PHP code complies with `PSR2` code standards.
  • Implemented `Codacy` to automates code reviews and monitors code quality over time.
  • Implemented `Codecov` to coverage reports.
  • Added `Database/phpcs.ruleset.xml` file.
  • Deleted `Database/src/bootstrap.php` file.
  • Deleted `Database/tests/bootstrap.php` file.
  • Deleted `Database/vendor` folder.
  • Changed `Josantonius\Database\Test\` namespace to `Josantonius\Database\` namespace .

1.1.6 - 2017-09-26

  • Unit tests supported by `PHPUnit` were added.
  • The repository was synchronized with `Travis CI` to implement continuous integration.
  • Type attributes were deleted from HTML tags. Since HTML5 doesn't longer necessary.
  • Added `Database/src/bootstrap.php` file
  • Added `Database/tests/bootstrap.php` file.
  • Added `Database/phpunit.xml.dist` file.
  • Added `Database/_config.yml` file.
  • Added `Database/.travis.yml` file.
  • Renamed `Josantonius\Provider\PDOprovider` class to `Josantonius\Provider\PDOprovider\PDOprovider` class.
  • Renamed `Josantonius\Provider\MSSQLprovider` class to `Josantonius\Provider\MSSQLprovider\MSSQLprovider` class.
  • Added `Josantonius\Database\Test\ConnectionTest` class
  • Added `Josantonius\Database\Test\ConnectionTest->testGetConnection()` method.
  • Added `Josantonius\Database\Test\ConnectionTest->testGetConnectionFromEliasis()` method.
  • Added `Josantonius\Database\Test\ConnectionTest->testCreateTableMethodExtra()` method.
  • Added `Josantonius\Database\Test\ConnectionTest->testExceptionWhenProviderNotExists()` method.
  • Added `Josantonius\Database\Test\ConnectionTest->testExceptionNameOrServiceNotKnown()` method.
  • Added `Josantonius\Database\Test\ConnectionTest->testExceptionAccessDeniedForUser()` method.
  • Added `Josantonius\Database\Test\ConnectionTest->testExceptionAccessDeniedForUserPassword()` method.
  • Added `Josantonius\Database\Test\ConnectionTest->testExceptionAccessDeniedForUserName()` method.
  • Added `Josantonius\Database\Test\CreateTest` class
  • Added `Josantonius\Database\Test\CreateTest->testGetConnection()` method.
  • Added `Josantonius\Database\Test\CreateTest->testCreateTableQuery()` method.
  • Added `Josantonius\Database\Test\CreateTest->testCreateTableQueryError()` method.
  • Added `Josantonius\Database\Test\CreateTest->testCreateTableMethod()` method.
  • Added `Josantonius\Database\Test\CreateTest->testCreateTableMethodError()` method.
  • Added `Josantonius\Database\Test\CreateTest->testCreateTableAdvancedMethod()` method.
  • Added `Josantonius\Database\Test\CreateTest->testCreateTableAdvancedMethodError()` method.
  • Added `Josantonius\Database\Test\InsertTest` class.
  • Added `Josantonius\Database\Test\InsertTest->testGetConnection()` method.
  • Added `Josantonius\Database\Test\InsertTest->testInsert_ReturnRows()` method.
  • Added `Josantonius\Database\Test\InsertTest->testInsert_ReturnID()` method.
  • Added `Josantonius\Database\Test\InsertTest->testInsert_Statements_ReturnRows()` method.
  • Added `Josantonius\Database\Test\InsertTest->testInsert_Statements_DataType_ReturnRows()` method.
  • Added `Josantonius\Database\Test\InsertTest->testInsertDuplicateEntryException()` method.
  • Added `Josantonius\Database\Test\InsertTest->testInsert_Statements_ReturnID()` method.
  • Added `Josantonius\Database\Test\InsertTest->testInsert_Statements_DataType_ReturnID()` method.
  • Added `Josantonius\Database\Test\InsertTest->testInsertTableNameErrorException()` method.
  • Added `Josantonius\Database\Test\InsertTest->testInsertColumnNameErrorException()` method.
  • Added `Josantonius\Database\Test\InsertTest->testInsertMethod_ReturnRows()` method.
  • Added `Josantonius\Database\Test\InsertTest->testInsertMethod_Statements_ReturnID()` method.
  • Added `Josantonius\Database\Test\InsertTest->testInsertMethod_Statements_DataType_ReturnID()` method.
  • Added `Josantonius\Database\Test\InsertTest->testInsertMethod_Marks_Statements_ReturnID()` method.
  • Added `Josantonius\Database\Test\InsertTest->testInsertMethod_Marks_DataType_ReturnRows()` method.
  • Added `Josantonius\Database\Test\InsertTest->testInsertMethodTableNameErrorException()` method.
  • Added `Josantonius\Database\Test\InsertTest->testInsertMethodColumnNameErrorException()` method.
  • Added `Josantonius\Database\Test\SelectTest` class.
  • Added `Josantonius\Database\Test\SelectTest->testGetConnection()` method.
  • Added `Josantonius\Database\Test\SelectTest->testQuery_Multiple_ReturnObject()` method.
  • Added `Josantonius\Database\Test\SelectTest->testQuery_SelectAll_Limit_ReturnArrayNumeric()` method.
  • Added `Josantonius\Database\Test\SelectTest->testQuery_Multiple_Where_Order_ReturnArrayAssoc()` method.
  • Added `Josantonius\Database\Test\SelectTest->testQuery_Multiple_ReturnRows()` method.
  • Added `Josantonius\Database\Test\SelectTest->testQuery_Multiple_Statements_Where_ReturnObject()` method.
  • Added `Josantonius\Database\Test\SelectTest->testQueryTableNamErrorException()` method.
  • Added `Josantonius\Database\Test\SelectTest->testQueryColumnNamErrorException()` method.
  • Added `Josantonius\Database\Test\SelectTest->testMethod_SelectAll_ReturnObject()` method.
  • Added `Josantonius\Database\Test\SelectTest->testMethod_SelectAll_Numeric()` method.
  • Added `Josantonius\Database\Test\SelectTest->testMethod_SelectAll_ReturnArrayAssoc()` method.
  • Added `Josantonius\Database\Test\SelectTest->testMethod_Limit_ReturnObject()` method.
  • Added `Josantonius\Database\Test\SelectTest->testMethod_Multiple_Where_ReturnArrayAssoc()` method.
  • Added `Josantonius\Database\Test\SelectTest->testMethod_Multiple_Where_Order_Limit_ReturnObject()` method.
  • Added `Josantonius\Database\Test\SelectTest->testMethod_Order_Where_Multiple_Limit_ReturnObject()` method.
  • Added `Josantonius\Database\Test\SelectTest->testMethod_Statements_Where_Multiple_ReturnObject()` method.
  • Added `Josantonius\Database\Test\SelectTest->testMethod_Statements_Where_Advanced_ReturnAssoc()` method.
  • Added `Josantonius\Database\Test\SelectTest->testMethodWhenThereAreNoResults()` method.
  • Added `Josantonius\Database\Test\SelectTest->testMethod_Where_ReturnRows()` method.
  • Added `Josantonius\Database\Test\SelectTest->testMethod_MarksStatements_Advanced_ReturnRows()` method.
  • Added `Josantonius\Database\Test\SelectTest->testMethod_Marks_DataType_Where_Advanced_ReturnRows()` method.
  • Added `Josantonius\Database\Test\SelectTest->testMethodTableNameErrorException()` method.
  • Added `Josantonius\Database\Test\SelectTest->testMethodColumnNameErrorException()` method.
  • Added `Josantonius\Database\Test\ReplaceTest` class.
  • Added `Josantonius\Database\Test\ReplaceTest->testGetConnection()` method.
  • Added `Josantonius\Database\Test\ReplaceTest->testMethod_ReturnRows()` method.
  • Added `Josantonius\Database\Test\ReplaceTest->testMethod_Statements_Advanced_ReturnID()` method.
  • Added `Josantonius\Database\Test\ReplaceTest->testMethod_Statements_DataType_Avanced_ReturnRows()` method.
  • Added `Josantonius\Database\Test\ReplaceTest->testMethod_MarksStatements_WhereAdvance_ReturnRows()` method.
  • Added `Josantonius\Database\Test\ReplaceTest->testMethod_MarksStatements_DataType_Where_ReturnID()` method.
  • Added `Josantonius\Database\Test\ReplaceTest->testMethodTableNameErrorException()` method.
  • Added `Josantonius\Database\Test\ReplaceTest->testMethodColumnNameErrorException()` method.
  • Added `Josantonius\Database\Test\UpdateTest` class.
  • Added `Josantonius\Database\Test\UpdateTest->testGetConnection()` method.
  • Added `Josantonius\Database\Test\UpdateTest->testQuery_ReturnRows()` method.
  • Added `Josantonius\Database\Test\UpdateTest->testQuery_Where_ReturnRows()` method.
  • Added `Josantonius\Database\Test\UpdateTest->testQuery_Statements_Where_ReturnRows()` method.
  • Added `Josantonius\Database\Test\UpdateTest->testQuery_Statements_DataType_WhereMultiple()` method.
  • Added `Josantonius\Database\Test\UpdateTest->testQuery_MarksStatements_Where_ReturnRows()` method.
  • Added `Josantonius\Database\Test\UpdateTest->testQuery_MarksStatements_DataType_Where_ReturnRows()` method.
  • Added `Josantonius\Database\Test\UpdateTest->testQueryTableNameErrorException()` method.
  • Added `Josantonius\Database\Test\UpdateTest->testQueryColumnNameErrorException()` method.
  • Added `Josantonius\Database\Test\UpdateTest->testMethod_ReturnRows()` method.
  • Added `Josantonius\Database\Test\UpdateTest->testMethod_Where_ReturnRows()` method.
  • Added `Josantonius\Database\Test\UpdateTest->testMethod_WhereMultiple_ReturnRows()` method.
  • Added `Josantonius\Database\Test\UpdateTest->testMethod_Statements_WhereAdvanced_ReturnRows()` method.
  • Added `Josantonius\Database\Test\UpdateTest->testMethod_Statements_DataType_Advanced_ReturnRows()` method.
  • Added `Josantonius\Database\Test\UpdateTest->testMethod_MarksStatements_WhereAdvance_ReturnRows()` method.
  • Added `Josantonius\Database\Test\UpdateTest->testMethod_MarksStatements_DataType_ReturnZero()` method.
  • Added `Josantonius\Database\Test\UpdateTest->testMethodTableNameErrorException()` method.
  • Added `Josantonius\Database\Test\UpdateTest->testMethodColumnNameErrorException()` method.
  • Added `Josantonius\Database\Test\DeleteTest` class.
  • Added `Josantonius\Database\Test\DeleteTest->testGetConnection()` method.
  • Added `Josantonius\Database\Test\DeleteTest->testQuery_ReturnRows()` method.
  • Added `Josantonius\Database\Test\DeleteTest->testQuery_Statements_Where_ReturnRows()` method.
  • Added `Josantonius\Database\Test\DeleteTest->testQuery_Statements_WhereMultiple_ReturnRows()` method.
  • Added `Josantonius\Database\Test\DeleteTest->testQuery_MarksStatements_Where_ReturnRows()` method.
  • Added `Josantonius\Database\Test\DeleteTest->testQuery_MarksStatements_Where_DataType_ReturnRows()` method.
  • Added `Josantonius\Database\Test\DeleteTest->testQueryTableNameErrorException()` method.
  • Added `Josantonius\Database\Test\DeleteTest->testQueryColumnNameErrorException()` method.
  • Added `Josantonius\Database\Test\DeleteTest->testMethod_Where_ReturnRows()` method.
  • Added `Josantonius\Database\Test\DeleteTest->testMethod_Where_ReturnsRows()` method.
  • Added `Josantonius\Database\Test\DeleteTest->testMethod_Statements_WhereAdvanced_ReturnRows()` method.
  • Added `Josantonius\Database\Test\DeleteTest->testMethod_Statements_DataType_WhereAdvanced_Rows()` method.
  • Added `Josantonius\Database\Test\DeleteTest->testMethod_MarksStatements_WhereAdvanced_ReturnRows()` method.
  • Added `Josantonius\Database\Test\DeleteTest->testMethod_MarksStatements_DataType_WhereAdvanced()` method.
  • Added `Josantonius\Database\Test\DeleteTest->testMethodTableNameErrorException()` method.
  • Added `Josantonius\Database\Test\DeleteTest->testMethodColumnNameErrorException()` method.
  • Added `Josantonius\Database\Test\DeleteTest->testDeleteAllMethod_ReturnRows()` method.
  • Added `Josantonius\Database\Test\DeleteTest->testDeleteAllQuery_ReturnRows()` method.
  • Added `Josantonius\Database\Test\TruncateTest` class.
  • Added `Josantonius\Database\Test\TruncateTest->testGetConnection()` method.
  • Added `Josantonius\Database\Test\TruncateTest->testTruncateTableQuery()` method.
  • Added `Josantonius\Database\Test\TruncateTest->testTruncateTableQueryTableNameError()` method.
  • Added `Josantonius\Database\Test\TruncateTest->testTruncateTableMethod()` method.
  • Added `Josantonius\Database\Test\TruncateTest->testTruncateTableMethodTableNameError()` method.
  • Added `Josantonius\Database\Test\DropTest` class.
  • Added `Josantonius\Database\Test\DropTest->testGetConnection()` method.
  • Added `Josantonius\Database\Test\DropTest->testDropTableQuery()` method.
  • Added `Josantonius\Database\Test\DropTest->testDropTableMethod()` method.
  • Added `Josantonius\Database\Test\DropTest->testDropTableMethodExtra()` method.

1.1.5 - 2017-07-03

  • Bug fix in replace method.

1.1.4 - 2017-05-16

  • Added `Eliasis\Model\Model->_getDatabaseInstance` method.
  • Added compatibility with Eliasis Framework library inside getConnection method. If it exists, it will get the connection to the database.
  • Will get the connection parameters from Eliasis Framework configuration files. It should have the following structure:

'db' => [

'identifier' => [
    'id'         => 'identifier',
    'prefix'     => 'identifier_',
    'provider'   => 'PDOprovider',
    'host'       => 'localhost',
    'user'       => 'db_user',
    'name'       => 'db_name',
    'password'   => 'db_password',
    'settings'   => ['charset' => 'utf8'],
],

]

  • Eliasis Framework url: https://github.com/Eliasis-Framework/Eliasis

1.1.3 - 2017-05-14

  • Singleton pattern was added to create a single connection per database.

1.1.2 - 2017-05-13

  • Added option for foreign key in creating tables.
  • Added `Josantonius\Database\Database->foreing()` method.
  • Added `Josantonius\Database\Database->references()` method.
  • Added `Josantonius\Database\Database->on()` method.
  • Added `Josantonius\Database\Database->actions()` method.
  • Added `Josantonius\Database\Database->engine()` method.
  • Added `Josantonius\Database\Database->charset()` method.
  • Some bugs were fixed.

1.1.1 - 2017-03-18

  • Some files were excluded from download and comments and readme files were updated.

1.1.0 - 2017-01-30

  • Compatible with PHP 5.6 or higher.

1.0.0 - 2017-01-30

  • Compatible only with PHP 7.0 or higher. In the next versions, the library will be modified to make it compatible with PHP 5.6 or higher.

1.0.0 - 2017-01-09

  • Added `Josantonius\Database\Database` class.
  • Added `Josantonius\Database\Database->__connstruct()` method.
  • Added `Josantonius\Database\Database::getConnection()` method.
  • Added `Josantonius\Database\Database->query()` method.
  • Added `Josantonius\Database\Database->_implement()` method.
  • Added `Josantonius\Database\Database->_implementPrepareStatements()` method.
  • Added `Josantonius\Database\Database->_implementQuery()` method.
  • Added `Josantonius\Database\Database->create()` method.
  • Added `Josantonius\Database\Database->select()` method.
  • Added `Josantonius\Database\Database->insert()` method.
  • Added `Josantonius\Database\Database->update()` method.
  • Added `Josantonius\Database\Database->replace()` method.
  • Added `Josantonius\Database\Database->delete()` method.
  • Added `Josantonius\Database\Database->truncate()` method.
  • Added `Josantonius\Database\Database->drop()` method.
  • Added `Josantonius\Database\Database->in()` method.
  • Added `Josantonius\Database\Database->table()` method.
  • Added `Josantonius\Database\Database->from()` method.
  • Added `Josantonius\Database\Database->where()` method.
  • Added `Josantonius\Database\Database->order()` method.
  • Added `Josantonius\Database\Database->limit()` method.
  • Added `Josantonius\Database\Database->_reset()` method.
  • Added `Josantonius\Database\Database->execute()` method.
  • Added `Josantonius\Database\Database->_getResponse()` method.
  • Added `Josantonius\Database\Database->_fetchResponse()` method.
  • Added `Josantonius\Database\Database->__destruct()` method.

1.0.0 - 2017-01-09

  • Added `Josantonius\Database\Exception\DatabaseException` class.
  • Added `Josantonius\Database\Exception\Exceptions` abstract class.
  • Added `Josantonius\Database\Exception\DatabaseException->__construct()` method.
  • Added `Josantonius\Provider\Provider` class.
  • Added `Josantonius\Provider\Provider->connect()` method.
  • Added `Josantonius\Provider\Provider->query()` method.
  • Added `Josantonius\Provider\Provider->statements()` method.
  • Added `Josantonius\Provider\Provider->create()` method.
  • Added `Josantonius\Provider\Provider->select()` method.
  • Added `Josantonius\Provider\Provider->insert()` method.
  • Added `Josantonius\Provider\Provider->update()` method.
  • Added `Josantonius\Provider\Provider->delete()` method.
  • Added `Josantonius\Provider\Provider->truncate()` method.
  • Added `Josantonius\Provider\Provider->drop()` method.
  • Added `Josantonius\Provider\Provider->fetchResponse()` method.
  • Added `Josantonius\Provider\Provider->lastInsertId()` method.
  • Added `Josantonius\Provider\Provider->rowCount()` method.
  • Added `Josantonius\Provider\Provider->getError()` method.
  • Added `Josantonius\Provider\Provider->isConnected()` method.
  • Added `Josantonius\Provider\Provider->kill()` method.
  • Added `Josantonius\Provider\PDOprovider` class.
  • Added `Josantonius\Provider\PDOprovider->connect()` method.
  • Added `Josantonius\Provider\PDOprovider->query()` method.
  • Added `Josantonius\Provider\PDOprovider->statements()` method.
  • Added `Josantonius\Provider\PDOprovider->create()` method.
  • Added `Josantonius\Provider\PDOprovider->select()` method.
  • Added `Josantonius\Provider\PDOprovider->insert()` method.
  • Added `Josantonius\Provider\PDOprovider->update()` method.
  • Added `Josantonius\Provider\PDOprovider->delete()` method.
  • Added `Josantonius\Provider\PDOprovider->truncate()` method.
  • Added `Josantonius\Provider\PDOprovider->drop()` method.
  • Added `Josantonius\Provider\PDOprovider->fetchResponse()` method.
  • Added `Josantonius\Provider\PDOprovider->lastInsertId()` method.
  • Added `Josantonius\Provider\PDOprovider->rowCount()` method.
  • Added `Josantonius\Provider\PDOprovider->getError()` method.
  • Added `Josantonius\Provider\PDOprovider->isConnected()` method.
  • Added `Josantonius\Provider\PDOprovider->kill()` method.
  • Added `Josantonius\Provider\MSSQLprovider` class.
  • Added `Josantonius\Provider\MSSQLprovider->connect()` method.
  • Added `Josantonius\Provider\MSSQLprovider->query()` method.
  • Added `Josantonius\Provider\MSSQLprovider->statements()` method.
  • Added `Josantonius\Provider\MSSQLprovider->create()` method.
  • Added `Josantonius\Provider\MSSQLprovider->select()` method.
  • Added `Josantonius\Provider\MSSQLprovider->insert()` method.
  • Added `Josantonius\Provider\MSSQLprovider->update()` method.
  • Added `Josantonius\Provider\MSSQLprovider->delete()` method.
  • Added `Josantonius\Provider\MSSQLprovider->truncate()` method.
  • Added `Josantonius\Provider\MSSQLprovider->drop()` method.
  • Added `Josantonius\Provider\MSSQLprovider->fetchResponse()` method.
  • Added `Josantonius\Provider\MSSQLprovider->lastInsertId()` method.
  • Added `Josantonius\Provider\MSSQLprovider->rowCount()` method.
  • Added `Josantonius\Provider\MSSQLprovider->getError()` method.
  • Added `Josantonius\Provider\MSSQLprovider->isConnected()` method.
  • Added `Josantonius\Provider\MSSQLprovider->kill()` method.