packaged/dal

Data Access Layer

1.18.2 2024-03-19 17:43 UTC

Requires

• php: ^7.2||^8.0
• ext-json: *
• doctrine/inflector: ~1.0
• packaged/cassandrathrift: ^20.1.0
• packaged/config: ~1.1
• packaged/docblock: ~0.1||~1.0
• packaged/helpers: ~1.23||~2.5
• packaged/log: ~1.0
• packaged/querybuilder: ~0.21

Requires (Dev)

• phpunit/phpunit: ^9.6.8

Suggests

• ext-apcu: *

MIT

• Brooke Bryan

README

Getting Started

$connectionConfig = new \Packaged\Config\Provider\Ini\IniConfigProvider(
  build_path('config', 'connections.ini')
);
$datastoreConfig  = new \Packaged\Config\Provider\Ini\IniConfigProvider(
  build_path('config', 'datastores.ini')
);

$resolver = new \Packaged\Dal\DalResolver($connectionConfig,$datastoreConfig);
$resolver->boot();

connections.ini

[users]
construct_class = \Packaged\Dal\Ql\PdoConnection

datastores.ini

[users]
construct_class = \Packaged\Dal\Ql\QlDataStore
connection = users

users.php

class User extends QlDao
{
  protected $_dataStoreName = 'users';
  public $id;
  public $name;
}

Basic Usage

$user       = new User();
$user->name = 'Test';
$user->save();

$user->name = 'Testing';
$user->save();

$user->delete();

$user     = new User();
$user->id = 4;
$user->load();

$tbUsers = User::collection(['name' => ['Test','Testing']]);
foreach($tbUsers as $user)
{
echo "Located $user->name\n";
}

$users = User::collection();
var_dump($users->min('id'));
var_dump($users->max('id'));
var_dump($users->sum('id'));
var_dump($users->avg('id'));

var_dump_json($users->distinct('name'));

FYI

DAO = Data Access Object

SQL Translation

IDao A Single Row within the database

IDataStore The Table within the database

IDataConection The connection to the database server e.g. PDO