All Orno packages are now deprecated! The decision was made to concentrate purely on the Dependency Injection Container and the Route package. They have been moved to The League of Extraordinary Packages under League\Container and League\Route.
If you would like to take on development of any of the other packages, please create an issue and we will discuss a possible transfer.
Orno\Db by @philipobenito
A simple database abstraction layer. It provides a unified API to enable you to write ANSI/ISO SQL that will be handled in the same way, regardless of your database driver.
Support
- Oracle OCI8
- PDO
Planned
- MySQLi
- SQLite
- MSSQL
- PostgreSQL
Basic Usage
Simple Statements
<?php
$config = [
'database' => 'mysql:dbname=database;host=localhost;charset=utf8',
'username' => 'root',
'password' => 'password'
];
$driver = new Orno\Db\Driver\Pdo($config);
$query = new Orno\Db\Query($driver);
$query->prepare('SELECT field_name, field_name2, field_name3 FROM some_table');
$query->execute();
while ($row = $query->fetch()) {
echo $row['field_name'] . '<br>';
echo $row['field_name2'] . '<br>';
echo $row['field_name3'] . '<br>';
}Binding Parameters
Binding parameters handles all sanitisation for you and guards against any SQL injection.
<?php
$config = [
'database' => 'ORACLE_CONNECTION_STRING',
'username' => 'username',
'password' => 'password'
];
$driver = new Orno\Db\Driver\Oci8($config);
$query = new Orno\Db\Query($driver);
$query->prepare('SELECT field_name, field_name2, field_name3
FROM some_table
WHERE field_name = :some_value
AND field_name2 = :some_other_value');
$query->bind(':some_value', 'some_value')
->bind(':some_other_value', 88, Orno\Db\Query::PARAM_INT);
$query->execute();
while ($row = $query->fetchObject()) {
echo $row->field_name . '<br>';
echo $row->field_name2 . '<br>';
echo $row->field_name3 . '<br>';
}Transactions
To start a transaction, call the transaction method, run multiple queries and executes, then either commit or rollback your transaction.
Commiting
$query->transaction();
$query->prepare('INSERT ...');
// bind any parameters
$query->execute();
$query->prepare('UPDATE ...');
// bind any parameters
$query->execute();
$query->commit();Rolling Back
$query->transaction();
$query->prepare('INSERT ...');
// bind some parameters
$query->execute();
$query->prepare('UPDATE ...');
// bind some parameters
$query->execute();
$query->prepare('SELECT ...');
$query->execute();
$query->fetchAll();
// if some conditions are met then commit
// else rollback to the point before the transaction began
if (/* .. */) {
$query->commit();
} else {
$query->rollback();
}Testing Notes
Orno\Db is well unit tested but also has integration tests, the integration tests require the ability to touch the database and therefore need connection credentials to do so. Below are instructions on how to run the integration tests.
Oracle Integration Tests
Add the following to the phpunit.xml.dist configuration file to enable Oracle integration testing.
<php>
<var name="OCI8_DATABASE" value="CONNECTION_STRING" />
<var name="OCI8_USERNAME" value="username" />
<var name="OCI8_PASSWORD" value="password" />
</php>
PDO Integration Tests
Add the following to the phpunit.xml.dist configuration file to enable PDO integration testing.
<php>
<var name="PDO_DATABASE" value="CONNECTION_STRING" />
<var name="PDO_USERNAME" value="username" />
<var name="PDO_PASSWORD" value="password" />
</php>
