b2pweb / bdf-prime

bench/ShardingBench.php

<?php

namespace Bdf\Prime;

require_once __DIR__.'/_files/BenchData.php';

use Bdf\Prime\Bench\BenchData;
use Bdf\Prime\Bench\User;
use Bdf\Prime\Connection\ConnectionConfig;

The type Bdf\Prime\Connection\ConnectionConfig was not found. Maybe you did not declare it correctly or list all dependencies?

use Bdf\Prime\Query\Contract\Query\InsertQueryInterface;
use Bdf\Prime\Repository\EntityRepository;
use Bdf\Prime\Types\ArrayType;

/**
 * Bench sharding connection
 *
 * @Revs(10)
 * @Warmup(1)
 */
class ShardingBench extends \BenchCaseAdapter
{
    /**
     * @var ServiceLocator
     */
    protected $prime;

    /**
     * @var BenchData
     */
    protected $data;

    /**
     * @var EntityRepository
     */
    protected $repository;

    /**
     *
     */
    public function setUp()
    {
        $this->prime = new ServiceLocator();
        $this->prime->connections()->declareConnection('test', [
            'adapter'           => 'sqlite',
            'memory'            => true,
            'dbname'            => 'TEST',
            'distributionKey'   => 'id',
            'shards'    => [
                'shard1' => ['dbname'  => 'TEST_SHARD1'],
                'shard2' => ['dbname'  => 'TEST_SHARD2'],
            ]
        ]);
        $this->prime->connection('test')->getConfiguration()->getTypes()->register(ArrayType::class, 'array');

The method getConfiguration() does not exist on Bdf\Prime\Connection\ConnectionInterface. Since it exists in all sub-types, consider adding an abstract or default implementation to Bdf\Prime\Connection\ConnectionInterface.

        Locatorizable::configure($this->prime);

$this->prime of type Bdf\Prime\ServiceLocator is incompatible with the type Closure expected by parameter $locator of Bdf\Prime\Locatorizable::configure().

        $this->data = new BenchData($this->prime);
        $this->data->addBulkUsers(false);

        $this->repository = $this->prime->repository(User::class);
    }

    /**
     * {@inheritdoc}
     */
    public function tearDown()
    {
        $this->data->clear();
    }

    /**
     * @Groups({"count"})
     */
    public function bench_count()
    {
        return $this->repository->count(['id' => '23000123']) > 0;
    }

    /**
     * @Groups({"count"})
     */
    public function bench_countKeyValue()
    {
        return $this->repository->queries()->countKeyValue(['id' => '23000123']) > 0;
    }

    /**
     * @Groups({"findById"})
     */
    public function bench_findById()
    {
        return $this->repository->queries()->findById('23000123');
    }

    /**
     * @Groups({"findById"})
     */
    public function bench_builder_get()
    {
        return $this->repository->builder()->get('23000123');

The method get() does not exist on Bdf\Prime\Query\QueryInterface. It seems like you code against a sub-type of said class. However, the method does not exist in Bdf\Prime\Query\SqlQueryInterface. Are you sure you never get one of those?

    }

    /**
     * @Groups({"search"})
     */
    public function bench_search_keyValue()
    {
        return $this->repository->keyValue([

The method keyValue() does not exist on Bdf\Prime\Repository\EntityRepository. Since you implemented __call, consider adding a @method annotation.

            'name'        => 'user Common 123',
            'customer.id' => '330000',
        ])->first();
    }

    /**
     * @Groups({"search"})
     */
    public function bench_search_builder()
    {
        return $this->repository->builder()->where([
            'name'        => 'user Common 123',
            'customer.id' => '330000',
        ])->first();
    }

    /**
     * @Groups({"delete"})
     */
    public function bench_delete_keyValue()
    {
        $id = '23000'.str_pad(rand(1, 500), 3, '0', STR_PAD_LEFT);
        return $this->repository->keyValue('id', $id)->delete();
    }

    /**
     * @Groups({"delete"})
     */
    public function bench_delete_keyValue_cached()
    {
        static $query;

        if (!$query) {
            $query = $this->repository->keyValue();
        }

        $id = '23000'.str_pad(rand(1, 500), 3, '0', STR_PAD_LEFT);
        return $query->where('id', $id)->delete();
    }

    /**
     * @Groups({"delete"})
     */
    public function bench_delete_builder()
    {
        $id = '23000'.str_pad(rand(1, 500), 3, '0', STR_PAD_LEFT);
        return $this->repository->builder()->where('id', $id)->delete();
    }

    /**
     * @Groups({"update"})
     */
    public function bench_update_builder()
    {
        $id = '23000'.str_pad(rand(1, 500), 3, '0', STR_PAD_LEFT);
        return $this->repository->builder()->where('id', $id)->update(['name' => 'Bob']);
    }

    /**
     * @Groups({"update"})
     */
    public function bench_update_keyValue()
    {
        $id = '23000'.str_pad(rand(1, 500), 3, '0', STR_PAD_LEFT);
        return $this->repository->keyValue('id', $id)->update(['name' => 'Bob']);
    }

    /**
     * @Groups({"update"})
     */
    public function bench_update_keyValue_cached()
    {
        static $query;

        if (!$query) {
            $query = $this->repository->keyValue();
        }

        $id = '23000'.str_pad(rand(1, 500), 3, '0', STR_PAD_LEFT);
        return $query->where('id', $id)->update(['name' => 'Bob']);
    }

    /**
     * @Groups({"insert"})
     */
    public function bench_insert_optimised()
    {
        /** @var InsertQueryInterface $insert */
        $insert = $this->repository->queries()->make(InsertQueryInterface::class);

        for ($i = 0; $i < 100; ++$i) {
            $insert->values([
                'id'          => 6000000 + $i,
                'name'        => 'bulk user '.$i,
                'roles'       => ['2'],
                'customer.id' => 1,
            ]);
            $insert->execute();
        }

        // Clear data set
        $this->repository->where('id', 'between', [6000000, 7000000])->delete();
    }

    /**
     * @Groups({"insert"})
     */
    public function bench_insert_builder()
    {
        for ($i = 0; $i < 100; ++$i) {
            $this->repository->builder()->insert([
                'id'          => 6000000 + $i,
                'name'        => 'bulk user '.$i,
                'roles'       => ['2'],
                'customer.id' => 1,
            ]);
        }

        // Clear data set
        $this->repository->where('id', 'between', [6000000, 7000000])->delete();
    }
}