yapro/doctrine2-orientdb-restful-driver

Doctrine2 PHP RESTful driver for OrientDB graph database.

Doctrine2 RESTful-driver for OrientDB

System requirements

Install orientDB v.1.7 from branch develop. Last cheked this version on:, _(*1)

commit 4f3aba5faa6a404367aea41e3fbab3dbe7c06da4
Author: enisher <enisher@gmail.com>
Date:   Thu May 15 23:33:51 2014 +0300

To work with database, you must perform actions described below., _(*2)

Start the database (complete path):, _(*3)

$ /var/www/orientDB/bin/server.sh

if you receive an error:, _(*4)

java: command not found

install java, example java 1.7.0_45. You can confirm the version command:, _(*5)

$ java -version

Setup

1) In file /app/config/config.yml replace string:, _(*6)

driver:   %database_driver%

on this string:, _(*7)

driver_class:   OrientDB\Driver

2) Change you settings for connect to database in file:, _(*8)

/app/config/parameters.yml

for example default settings:, _(*9)

parameters:
    database_driver: pdo_mysql
    database_host: localhost
    database_port: 2480
    database_name: GratefulDeadConcerts
    database_user: admin
    database_password: admin
    mailer_transport: smtp
    mailer_host: 127.0.0.1
    mailer_user: null
    mailer_password: null
    locale: en
    secret: ThisTokenIsNotSoSecretChangeIt

3) Add following code into your composer.json, _(*10)

      "require": {
          ...
          "yapro/doctrine2-orientdb-restful-driver": "dev-master"
      },

and run command:, _(*11)

$ composer update yapro/doctrine2-orientdb-restful-driver --prefer-source

All ready., _(*12)

How use it

1) Create you entities classes (php files) with PHPDoc annotations for field rid, example:, _(*13)

/**
 * @ORM\Id
 * @ORM\Column(type="bigint", name="@rid")
 * @ORM\GeneratedValue(strategy="IDENTITY")
 */
private $rid = 0;

2) Run console command for create/update you entities:, _(*14)

$ php app/console doctrine:schema:update --force

If you delete entity class, this command not delete class(table) in OrientDB. If you need this action, please delete class(table) in OrientDB with command:, _(*15)

orientdb {YouDatabase}> drop class YouEntityName

UnitTest

You can check you fix (or features) with next command:, _(*16)

$ bin/phpunit -c app vendor/yapro/doctrine2-orientdb-restful-driver/Tests/Crud.php --env=dev

Help

You Entity Schemas, Doctrine getting and compare in \Doctrine\ORM\Tools\SchemaTool::getUpdateSchemaSql, _(*17)

$fromSchema - schemas from you database

$toSchema - schemas from you classes

If there is a desire to practice with queries, connect the console client to the database:, _(*18)

$ /var/www/orientDB/bin/console.sh

orientdb> connect remote:localhost root You_password ( from file config/orientdb-server-config.xml )

If you are in console client and created class(table) in OrientDB with RESTful driver, you may need to see this update in orientDB console. For this action, please run:, _(*19)

orientdb {YouDatabase}> reload schema

and than:, _(*20)

orientdb {YouDatabase}> info