lib360

lib360 lib360 is a spoof library of classes and components that aim for extensibility and ease of use.

lib360 database

overview setup basic use advanced use diagram reference

overview abstracted components: connection, driver, storage (table, view), language, execution every component is fully extensible programatically define reusable storage components (e.g. tables and views) create new languages, drivers

include lib360 Place lib360 anywhere within your includes. This will be the only require statement you'll use with lib360.

<?php

require_once('lib360/initialize.php');

?>

connection Create a PDO connection and add to connection pool with alias 'test'.

<?php

use \lib360\db\connection as conn;

$conn = new conn\PDO(
		new conn\Config('mysql:host=localhost;dbname=test', 'root', NULL)
);
conn\Pool::add($conn, 'test');

?>

select using table factory This method allows very quick, one-off access to your data.

<?php

use \lib360\db\data as data;

$userTable = data\TableFactory::get('test', 'users');
$result = $userTable->select();

?>

select using a table class Defining a table class allows you to define a reusable component instead of using defaults from factory. Below $db is the database alias name, and $name is the table or storage name.

<?php

class UserTable extends data\Table
{
	protected $db = 'test';
	protected $name = 'users';
}

$userTable = new UserTable();
$result = $userTable->select();

?>

create conditions Condition objects allow you to define a query restriction that can be reused. The condition object below would read: column user_id equals to integer 5.

<?php

use \lib360\db\condition as cond;
use \lib360\db\value as val;

$cond = new cond\Condition(
		new val\Value('user_id', val\Value::TYPE_COLUMN),
		cond\Condition::OPERATOR_EQUALS,
		new val\Value(5, val\Value::TYPE_INTEGER)
);

?>

use condition groups Condition groups allow you to combine conditions and other condition groups together.

<?php

$condgroup1 = new cond\ConditionGroup($cond1);
$condgroup1->addCondition(
		cond\ConditionGroup::OPERATOR_AND,
		$cond2
);

$condgroup1->addCondition(
		cond\ConditionGroup::OPERATOR_OR,
		$condgroup2
);

?>

use conditions in select Condition (or condition group) objects can be easily plugged in select/update/delete statements.

<?php

$result = $userTable->delete($condgroup1);

?>

limit returned fields per query This will select id and name fields only.

<?php

$result = $userTable->select($condgroup1, NULL, array('id', 'name'));

?>

limit fields in class definition This is equivalent of above but defined inside the class as default. You can always override per query.

<?php

class UserTable extends data\Table
{
	protected $db = 'test';
	protected $name = 'user';
	protected $fields = array('id', 'name');
}

$userTable = new UserTable();
$result = $userTable->select($condgroup1);

?>

create joins Let's say you want to display comments made by users; but comments table has the users' ID value, so you want to join against the users table to grab name instead. And you also want to join users table against user_groups to grab their group name.

<?php

use \lib360\db\value as val;
use \lib360\db\conditioin as cond;
use \lib360\db\join as join;

// create condition object linking comments.user_id = users.user_id
$cond12 = new cond\Condition(
				new val\Value('comments.user_id', val\Value::TYPE_COLUMN),
				cond\Condition::OPERATOR_EQUALS,
				new val\Value('users.user_id', val\Value::TYPE_COLUMN)
);

// create a condition object linking users.group_id = user_group.group_id
$cond23 = new cond\Condition(
				new val\Value('users.group_id', val\Value::TYPE_COLUMN),
				cond\Condition::OPERATOR_EQUALS,
				new val\Value('user_group.group_id', val\Value::TYPE_COLUMN)
);

// create a join object with initial inner join of users and comments tables
$j = new join\Join('comments', join\Join::JOIN_TYPE_INNER, 'users', $cond12);

// add user_group table as a left outer join
$j->addTable(join\Join::JOIN_TYPE_LEFT_OUTER, 'user_group', $cond23);

?>

create views Now use the above join inside a view class. Notice you can add as many join objects as desired.

<?php

use \lib360\db\data as data;

class UserCommentsView extends data\View
{

	public function __construct()
	{
		// same join creation code as above resulting in $j object
		// ...

		// add join to array
		$this->joins[] = $j;
	}

}

?>

use views Views can be used very similar to tables. In fact, they share most of the implementation.

<?php

$userComments = new UserCommentsView();

$result = $userComments->select();

?>

export XML Results of a select query can be easily exported to XML.

<?php

// DOM document
$dom = $result->toXML();

// XML string
$xml = $result->toXML()->saveXML();

?>

/image/usage anatomy.png

reference doxygen reference documentation class hierarchy namespaces