A set of tools to use and manage any OrientDB instance from PHP.

Orient includes:

• the HTTP protocol binding
• the query builder
• the data mapper ( Object Graph Mapper )

If you don't know OrientDB here are few resources:

Homepage: http://www.orientechnologies.com/ Documentation: http://code.google.com/p/orient | http://www.odino.org/tags?tag=orient

Set up the submodules after you cloned the repo:

git submodule init
git submodule update

The binding is complete: it is an HTTP client wrapper with some methods bound to OrientDB's HTTP interface.

Its usage is straightforward:

$driver   = new Congow\Orient\Http\Client\Curl();
$orient   = new Congow\Orient\Foundation\Binding($driver, '127.0.0.1', '2480', 'admin', 'admin', 'demo');
$response = $orient->query("SELECT FROM Address");
$output   = json_decode($response->getBody());

foreach ($output->result as $address)
{
  var_dump($address->street);
}

Use the PHP5.3 standard autoloader (https://gist.github.com/221634).

The query-builder is finished, in the future we will consider the integration of OrientDB Graph Edition: http://code.google.com/p/orient/wiki/GraphEdTutorial.

To take advantage of the QB you only have to instantiate a Query object:

use Congow\Orient\Query;

$query = new Query();
$query->from(array('users'))->where('username = ?', "admin");

echo $query->getRaw(); // SELECT FROM users WHERE username = "admin"

The Query object incapsulates lots of sub-commands, like SELECT, DROP, GRANT, INSERT and so on...

You can use also those commands:

use Congow\Orient\Query\Command\Select;

$select = new Select('users');
echo $select->getRaw(); // SELECT FROM users

However, we strongly discourage this approach: commands will change, Query, thought as a facade, - hopely - not.

You'd better take a look at the tests of the Query class and its subcommands to get a full overview of the available commands: in order to match OrientDB's native SQL-like synthax we tried to preserve names and stuff like that, but a few things have changed so far.

We started working on the mapper and, right now, it is able to map OrientDB responses (converted in StdObject) to annotation-mapped POPOs. Also collections are hydrated properly.

However, it's under heavy work, so don't expect to be able to use it in a few weeks. Next steps are:

• hydrate OrientDB native data-type (it includes floats, embedded-set|link|list, embedded-map|link|list and many others...)
• provide a base repository class
• implementation of the persistence from the ODM to OrientDB

Orient incapsulates also a few utilities for PHP developers: on of them is an implementation of Dijkstra's algorithm.

use Congow\Orient\Graph;
use Congow\Orient\Graph\Vertex;
use Congow\Orient\Algorithm; 

$graph = new Graph();

$rome      = new Vertex('Rome');
$paris     = new Vertex('Paris');
$london    = new Vertex('London');

$rome->connect($paris, 2);
$rome->connect($london, 3);
$paris->connect($london, 1);

$graph->add($rome);
$graph->add($paris);
$graph->add($london);

$algorithm = new Algorithm\Dijkstra($graph);
$algorithm->setStartingVertex($rome);
$algorithm->setEndingVertex($tokio);

var_dump($algorithm->solve());

In order to run the tests you only need to:

cd /path/to/repo
phpunit --configuration=test/PHPUnit/phpunit.xml

This should be enough. For the braves, if you want to run the full test suite, which includes the integration tests, you should:

• download the supported version of OrientDB
• make sure it has the demo database bundled with every Congow\OrientDB release (if you use a snapshot, please create the database directory and copy there the database bundled with the latest OrientDB official release)
• add the server administration credential admin/admin in config/orientdb-server-config.xml
• launch the server on :2424, reacheable via web at the :2480

and then you can run the full test-suite:

cd /path/to/repo
phpunit --configuration=test/PHPUnit/phpunit.xml test/

As you'll notice, tests are obviously slower (they need a direct connection through the HTTP protocol to Congow\OrientDB), so we highly discourage you from testing this way. They also may file the first time you launch them, because we set the curl timeout limit to 1 second, and the first connections to Congow\OrientDB require it to bootstrap lots of stuff (so during more than 1 second, making the tests fail): try to re-launch the tests, you should see the green bar. Integration tests, by the way, are run by the development team before any tag in the repository, so you are sure that any tag is fully tested against a real Congow\OrientDB instance.

You can take a look at the library coding health by using PHP_CodeBrowser.

You need to install:

• phpcpd
• phpdcd
• phploc
• phpmd
• phpdepend
• phpunit ( of course )
• phpcb

and then run:

chmod +x report.sh
./report.sh

You'll be able to see the HTML reports in log/report/index.html.

Copyright (C) 2011 by Alessandro Nadalin [email protected] Copyright (C) 2011 by David Funaro [email protected]

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE

These are the requirements in order to use the library:

• PHP >= 5.3.3
• APC
• OrientDB 1.0.0RC5

In order to launch the test suite PHPUnit 3.5 is required.

See: https://github.com/congow/Orient/issues

If you want to take a look at a fancy PHPDoc documentation you can use doxygen:

sudo apt-get install doxygen

and then use the script provided under the docs directory:

doxygen docs/orient.d

which will generate technical documentation under the folder docs/html.