qbbr/pgsql-doctrine-random-function

PostgreSQL RANDOM() function for Doctrine ORM

122,456 4

symfony doctrine postgresql pgsql function random qbbr

Install
`composer require qbbr/pgsql-doctrine-random-function`
Latest Version:	1.0.1
License:	MIT
Last Updated:	Aug 16, 2024
Links:	GitHub · Packagist

Maintainer: qbbr

PgsqlDoctrineRandomFunction

PostgreSQL RANDOM() function for Doctrine ORM

Installation

Step 1: Download the package

$ composer require qbbr/pgsql-doctrine-random-function

Step 2: Configuration

# app/config/config.yml

doctrine:
    orm:
        # ...
        dql:
            numeric_functions:
                Random: Qbbr\PgsqlDoctrineRandomFunction\DQL\RandomFunction

Usage

$em = $this->getDoctrine()->getManager();

$result = $em->createQueryBuilder()
    ->select('e')
    ->from('AppBundle:Entity', 'e')
    ->orderBy('RANDOM()')
    ->setMaxResults(10)
    ->getQuery()
    ->getResult();

Related Packages

oro/doctrine-extensions

Doctrine Extensions for MySQL and PostgreSQL.

12,395,276 343

database doctrine dql function mysql postgresql type

fresh/doctrine-enum-bundle

Provides support of ENUM type for Doctrine2 in Symfony applications.

7,081,560 461

bundle dbal doctrine entity enum mssql mysql postgresql sqlite symfony type

goodwix/doctrine-json-odm

JSON Object-Document Mapping bundle for Symfony and Doctrine

27,087 22

database doctrine json odm orm postgresql symfony

martin-georgiev/postgresql-for-doctrine

Extends Doctrine with native PostgreSQL support for arrays, JSONB, ranges, PostG...

5,973,650 456

array-data-types arrays binary-data cidr date-interval dbal doctrine doctrine-dbal doctrine-dql doctrine-orm doctrine-types dql embeddings full-text-search fuzzystrmatch geo geography geometry geospatial gis hash-store hstore inet json json-data jsonb jsonpath levenshtein ltree macaddr martin-georgiev math-functions money multirange network-types pgsql pgvector postgis postgis-geometry postgres postgres-extension postgresql range soundex spatial text-search trigonometry tsquery tsvector uuid vector vector-search xml

halyc0n/pg-web-stats

Web present for pg_stat_statements

16 0

laravel laravel 5 pgsql postgresql ps_stat_statements