duxet/laravel-rethinkdb

RethinkDB adapter for Laravel

3.0 2016-11-16 11:17 UTC

Requires

• php: >=5.5.0
• danielmewes/php-rql: ~2.3.0
• illuminate/container: >=5.0.0
• illuminate/contracts: >=5.0.0
• illuminate/database: >=5.0.0
• illuminate/support: >=5.0.0

Requires (Dev)

• codeclimate/php-test-reporter: 0.1.*@dev
• mockery/mockery: 0.9.*@dev
• orchestra/testbench: 3.0.*
• phpunit/phpunit: ~4.0
• psr/log: 1.0.0

MIT

• duxet

README

RethinkDB adapter for Laravel (with Eloquent support)

God bless @jenssegers for his great laravel-mongodb project. I have used his tests and some other code, since it's awesome codebase for supporting other NoSQL databases. I hope he won't be angry on me for that ;)

Installation

Requirements.

1. RethinkDB: You need to make sure that you have installed RethinkDB successfully, you can reffer to rethinkdb documentation for the full instruction of how to install RethinkDB.

2. Laravel 5.2: this package was designed to work with Laravel 5.2, so it will not work with laravel 4.x.

Installation

To fully install this package you will have either to add it manually to your composer.json file, or you can execute the following command :

composer require "duxet/laravel-rethinkdb:dev-master"

This will install the package and all the required package for it to work.

Service Provider

After you install the library you will need to add the Service Provider file to your app.php file like :

duxet\Rethinkdb\RethinkdbServiceProvider::class,

inside your providers array.

Database configuration

Now that you have the service provider setup, you will need to add the following configuration array at the end of your database connections array like :

'rethinkdb' => [
    'name'      => 'rethinkdb',
    'driver'    => 'rethinkdb',
    'host'      => env('DB_HOST', 'localhost'),
    'port'      => env('DB_PORT', 28015),
    'database'  => env('DB_DATABASE', 'homestead'),            
]

After you add it, you can just configure your enviroment file to be something like :

DB_HOST=localhost
DB_DATABASE=homestead
DB_CONNECTION=rethinkdb

but you can always updatr your DB_HOST to point to the IP where you have installed RethinkDB.

Migration

Create a Migration File

You can easily create a migration file using the following command which will create a migration file for you to create the users table and use the package schema instead of Laravel schema:

php artisan make:rethink-migration Users --create

Please note that you can use the same options that you use in make:migration with make:rethink-migration, as its based on laravel make:migration

Be aware that Laravel Schema API is not fully implemented. For example, ID columns using increments will not be auto-incremented unsigned integers, and will instead be a UUID unless explicitly set. The easiest solution is to maintain UUID use within RethinkDB, turn off incremental IDs in Laravel, and finally implement UUID use in Laravel.

Running The Migrations

Nothing will change here, you will keep using the same laravel commands which you are used to execute to run the migration.

Example of Laravel Users Migration file

This is an example of how the laravel Users Migration file has become

<?php

use duxet\Rethinkdb\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateUsersTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('users', function (Blueprint $table) {
            $table->increments('id');
            $table->string('name');
            $table->string('email')->unique();
            $table->string('password', 60);
            $table->rememberToken();
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::drop('users');
    }
}

Model

Create a Model Class

You can easily create a model class using the following command which will create it for you and use the package model instead of Laravel model:

php artisan make:rethink-model News

Please note that you can use the same options that you use in make:model with make:rethink-model, as its based on laravel make:model

Example of Laravel News Model Class

This is an example of how the laravel model class has become

<?php

namespace App;

use duxet\Rethinkdb\Eloquent\Model;

class News extends Model
{
    //
}

Update a Model Class

Be aware that any model that Laravel generates during its initial installation will need to be updated manually in order for them to work properly. For example, the User model extends Illuminate\Foundation\Auth\User, which further extends Illuminate\Database\Eloquent\Model instead of \duxet\Rethinkdb\Eloquent\Model;. The import Illuminate\Foundation\Auth\User needs to be removed from the User model and replaced with \duxet\Rethinkdb\Eloquent\Model;, and any interfaces and associated traits implemented in Illuminate\Foundation\Auth\User that are required will need to be ported to the User model.

Example of Laravel User Model Class

This is an example of how the laravel User model class has become

use Illuminate\Auth\Authenticatable;
use duxet\Rethinkdb\Eloquent\Model;
use Illuminate\Auth\Passwords\CanResetPassword;
use Illuminate\Foundation\Auth\Access\Authorizable;
use Illuminate\Contracts\Auth\Authenticatable as AuthenticatableContract;
use Illuminate\Contracts\Auth\Access\Authorizable as AuthorizableContract;
use Illuminate\Contracts\Auth\CanResetPassword as CanResetPasswordContract;

class User extends Model implements
    AuthenticatableContract,
    AuthorizableContract,
    CanResetPasswordContract
{
    use Authenticatable, Authorizable, CanResetPassword;
    
    //
}