hatwebtech/dal

hat dal (database abstraction layer) for PHP 5.3+

DAL (database abstraction layer)

, _(*1)

Description

dal is data abstraction library written in PHP. It's lightweight (half a dozen classes) and fast. It is inspired by Doctrine, _(*2)

//example
$q = \hatwebtech\dal\DAL::query()
        ->select('u.id, u.name')
        ->from('User u')
        ->where('u.id =?', 7)
;  

dal works with PHP 5.3 or later., _(*3)

Installation

The recommended way to install HATwebtech DAL is through Composer. Just create a composer.json file and run the php composer.phar install command to install it:, _(*4)

    {
        "require": {
            "hatwebtech/dal": "dev-master"
        }
    }

Information

Init

$dsn = 'pgsql:dbname=example_db;host=127.0.0.1';

$dbh = new PDO($dsn', 'postgres', 'pass123');

\hatwebtech\dal\DAL::setDbh($dbh);
\hatwebtech\dal\DAL::setTablePath(APPPATH . 'tables/');
\hatwebtech\dal\DAL::setTableNamespace('\\dal_test\\tables\\'); 

DAL query

coming soon..., _(*5)

Known Issues

If you discover any bugs, feel free to create an issue on GitHub fork and send us a pull request., _(*6)

• only Postgres DB is supported for now, MySQL coming soon
• implement groupBy() in Hat Dal Query class.
• implement having() in Hat Dal Query class.
• implement innerJoin() in Hat Dal Query class.
• implement validators (date, string leingth...).
• reduce memory footprint

Issues List., _(*7)

Authors

• Panajotis Zamos (https://github.com/panos-zamos)

Contributing

1. Fork it
2. Create your feature branch (git checkout -b my-new-feature)
3. Commit your changes (git commit -am 'Add some feature')
4. Push to the branch (git push origin my-new-feature)
5. Create new Pull Request

License

Apache 2.0, _(*8)