ride / lib-database
Ride library for database abstraction.
Installs: 4 686
Dependents: 5
Suggesters: 0
Security: 0
Stars: 0
Watchers: 8
Forks: 0
Open Issues: 0
Requires
- ride/lib-log: ^1.0.0
- ride/lib-validation: ^1.0.0
README
Database abstraction library of the PHP Ride framework.
Code Sample
Check this code sample to see some of the possibilities of this library:
<?php use ride\library\database\driver\Driver; use ride\library\database\exception\DatabaseException; use ride\library\database\manipulation\condition\SimpleCondition; use ride\library\database\manipulation\expression\FieldExpression; use ride\library\database\manipulation\expression\ScalarExpression; use ride\library\database\manipulation\expression\TableExpression; use ride\library\database\manipulation\statement\SelectStatement; use ride\library\database\DatabaseManager; use ride\library\database\Dsn; use ride\library\log\Log; function createDatabaseManager(Log $log) { $databaseManager = new DatabaseManager(); $databaseManager->setLog($log); $databaseManager->registerDriver('mysql', 'ride\\library\\database\\driver\\PdoDriver'); $databaseManager->registerDriver('sqlite', 'ride\\library\\database\\driver\\PdoDriver'); $databaseManager->registerDriver('postgres', 'ride\\library\\database\\driver\\PostgresPdoDriver'); $databaseManager->registerConnection('my-database', new Dsn('mysql://user:pass@host/database')); $databaseManager->registerConnection('my-2nd-database', new Dsn('sqlite:///path/to/file')); return $databaseManager; } function getConnection(DatabaseManager $databaseManager) { $connections = $databaseManager->getConnections(); // get the default connection $connection = $databaseManager->getConnection(); if ($databaseManager->hasConnection('my-database')) { // get my connection $connection = $databaseManager->getConnection('my-database'); // get my connection but don't connect just yet $connection = $databaseManager->getConnection('my-database', false); } if (!$connection->isConnected()) { $connection->connect(); } return $connection; } function executeSelectSql(Driver $connection) { $sql = 'SELECT ' . $connection->quoteIdentifier('id') . ' ' . 'FROM ' . $connection->quoteIdentifier('MyTable') . ' ' . 'WHERE ' . $connection->quoteIdentifier('name') . ' LIKE ' . $connection->quoteValue('%Ride%'); $result = $connection->execute($sql); // get the columns or the column count $columns = $result->getColumns(); $columnCount = $result->getColumnCount(); // same for rows $rows = $result->getRows(); $rowCount = $result->getRowCount(); // get the first or the last row $firstRow = $result->getFirst(); $lastRow = $result->getLast(); // you can loop the result straight foreach ($result as $row) { echo $row['id']; } } function executeInsertSql(Driver $connection) { try { $connection->beginTransaction(); $sql = 'INSERT INTO ' . $connection->quoteIdentifier('MyTable') . ' ' . 'VALUES (' . $connection->quoteValue('My name') . ')'; $result = $connection->execute($sql); if ($connection->isTransactionStarted()) { $connection->commitTransaction(); } $connection->getLastInsertId(); } catch (DatabaseException $exception) { $connection->rollback(); throw $exception; } } function executeStatement(Driver $connection) { $statement = new SelectStatement(new FieldExpression('id')); $statement->addField($field); $statement->addTable(new TableExpression('MyTable')); $statement->addCondition(new SimpleCondition(new FieldExpression('name'), new ScalarExpression('%Ride%'), '=')); $result = $connection->executeStatement($statement); }
Related Modules
Installation
You can use Composer to install this library.
composer require ride/lib-database