cakephparangodb/arangodb

An ArangoDb based model and Query builder for Cakephp 3.x

ArangoDB-CAKEPHP-3x - A ArangoDb based model and Query builder for Cakephp 3.x

, _(*1)

Table of Contents

• Description
• Requirements
• Installing the PHP client
  • Using Composer
  • Cloning the git repository
• How to use the Cakephp ArangoDb Client
  • Setting up the connection options
  • Models
  • Controllers

, _(*2)

, _(*3)

Description

This is the cakephp version of the arangodb-php lib. the cakephp client allows you to convert your models to arangodb supported models easily. the cakephp arangodb client also allows you to use cakephp find, save, delete, update and joins etc simillar to cake core functionality., _(*4)

, _(*5)

, _(*6)

Requirements

• Cakephp version 3.0 or higher, _(*7)

• ArangoDB database server version 3.0 or higher., _(*8)

• PHP version 5.6 or higher, _(*9)

Note on PHP version support:, _(*10)

, _(*11)

, _(*12)

Installing the Cakephp arangodb client

To get started you need PHP 5.6 or higher plus an ArangoDB server running on any host that you can access., _(*13)

There are two alternative ways to get the Cakephp ArangoDb client:, _(*14)

• Using Composer
• Cloning the git repository

, _(*15)

Alternative 1: Using Composer

composer require cakephparangodb/arangodb

NOTE IF ANY ERROR THEN Add minimum-stability and prefer-stable to your composer.json, _(*16)

Example, _(*17)

{
    "minimum-stability": "dev",
    "prefer-stable": true
}

, _(*18)

Alternative 2: Cloning the git repository

You need to have a git client installed. To clone this repository from github, execute the following command in your project directory:, _(*19)

git clone "https://github.com/shubham715/Cakephp-ArangoDb-Package.git"

This will create a subdirectory arangodb-php in your current directory. It contains all the files of the client library. It also includes a dedicated autoloader that you can use for autoloading the client libraries class files. To invoke this autoloader, add the following line to your PHP files that will use the library:, _(*20)

, _(*21)

Alternative 3: Invoking the autoloader directly

If you do not wish to include autoload.php to load and setup the autoloader, you can invoke the autoloader directly:, _(*22)

require 'cakephparangodb/lib/ArangoDBClient/autoloader.php';
\ArangoDBClient\Autoloader::init();

, _(*23)

, _(*24)

How to use the CAKEPHP client

, _(*25)

Setting up the connection options

In order to use Cakephp ArangoDB, you need to specify the connection options. currently its only available from core files of this client in future updates we will add functionality to change db config from app.php, _(*26)

For now you need to open yourProject/vendor/cakephparangodb/arangodb/lib/ArangoDBClient/Connect.php and change db config of $_options according to your db config., _(*27)

, _(*28)

Convert Cakephp Models to ArangoDb supported models. Change your cakephp models to like below example

Here for example i am changing UsersTable Model., _(*29)

Thats it. Now you can load model in your controller by using loadModel and use users Table of arangodb into controller like below example, _(*30)

, _(*31)

Here i am giving some examples that how you can use models in controller

FIND QUERY

Using Find

$data = $this->Users->find('all');

Using Find with conditions

$data = $this->Users->find('all',['conditions'=>['name'=>'test','email'=>'test@gmail.com']]);

Using findById()

$data = $this->Users->findById(10);

Using Find with select

$data = $this->Users->find('all',['select'=>['name','email','status']]);

Using FindOne

$data = $this->Users->findOne('all',['conditions'=>['email'=> $email]]);

advanced find with select , sort , limit

$data = $this->Users->find('all',['select'=>['name','email','status']]);
$data = $this->Users->find('all', ['conditions'=>['email'=>'test@gmail.com'],'order'=>['paydate'=> 'ASC'],'select'=>['name','email','status']]);

Using isUnique

$data = $this->Users->isUnique(['conditions'=>['email'=> $email]]);

Using Count

$data = $this->Users->count(['conditions'=>['email'=> $email]]);

Updation

Using updateById

$data = $this->Users->updateById(['email'=> $email],['id'=> 1]);

Using updateAll

$data = $this->Users->updateAll(['email'=> $email],['id'=> 1]);

deletion

deleteById, _(*32)

Using deleteById

$data = $this->Users->deleteById(1);

deleteAll, _(*33)

Using deleteAll

$data = $this->Users->deleteAll(['email'=> $email]);

Using createOrUpdate()

$data = $this->Users->createOrUpdate(['email'=> $email,'id'=> 10]);

Join

$data = $this->Users->findWithJoin('all',['contain'=> 'userdetails', 'conditions'=>['c.userid'=> 'u.id']]);
//Here c is refer for base table and u is for join table.

Save Data

$data = ['name'=>'shubham715', email'=> 'shubhamsharma715@gmail.com', 'status'=> 1];
$saveData = $this->Users->save($financeEntity);

, _(*34)

Here lots of examples that we will update soon., _(*35)