dabl/adapter

DABL database adapters

Maintainers

Details

github.com/ManifestWebDesign/dabl-adapter

Source

Issues

Installs: 563

Dependents: 3

Suggesters: 0

Security: 0

Stars: 1

Watchers: 3

Forks: 1

Open Issues: 0

v1.2.1 2017-04-16 16:22 UTC

Requires (Dev)

MIT 98579ed23bec832d764e762ee2f93f0a88ef9cd3

  • Manifest Web Design <dan.woop@manifestwebdesign.com>

databaseormabstractionpropeladapterdabl

This package is auto-updated.

Last update: 2024-11-04 09:39:59 UTC

README

Build Status

DABL Adapter

Subclasses of PHP PDO for various SQL dialects

Example

code:

use Dabl\Adapter\DABLPDO;

// get connection (parameters usually come from .ini file)
$pdo = DABLPDO::connect(array(
    'driver' => 'mysql',
    'host' => 'localhost',
    'dbname' => 'test',
    'user' => 'root',
    'password' => ''
));

// Get database schema
$schema = $pdo->getDatabaseSchema();
$tables = $schema->getTables();
$columns = $table[0]->getColumns();
$type = $columns[0]->getType();

Features

  • Normalized constructor
  • Read schema schemas (thanks to modified Propel libraries)
  • Date and time helper methods (getTimestampFormatter, hourStart, dayStart, weekStart, monthStart)
  • Helper methods for quoting arrays of parameters and identifier quoting
  • Helper methods for applying LIMIT behavior

Supported Dialects

  • Microsoft Access
  • Microsoft SQL Server
  • MySQL
  • Oracle
  • Postgres
  • Redshift
  • SQLite