jurysosnovsky/doctrine-binary

The extension to Doctrine 2 that add support for binary functions and bitwise operators available in MySQL, PostgreSQL, Oracle and SQLite.

1.0.1 2022-06-30 08:38 UTC

Requires

• php: ^7.2 || ^8.0
• doctrine/orm: ^2.7

Requires (Dev)

• friendsofphp/php-cs-fixer: ^3.8.0
• phpunit/phpunit: ^7.0 || ^8.0 || ^9.0
• symfony/cache: ^6.1
• symfony/yaml: ^4.4 || ^5.3 || ^6.0

BSD-3-Clause

• Jury Sosnovsky

• database
• orm
• mysql
• sqlite
• doctrine
• postgresql
• oracle
• binary
• bitwise

README

The set of extensions to Doctrine 2 that add support for binary functions and bitwise operators available in MySQL, Oracle, PostgreSQL and SQLite.

Installation

To install with composer:

composer require jurysosnovsky/doctrine-binary

Usage

For the Symfony please read How to Register custom DQL Functions.

For the standalone usage check out the documentation of Doctrine DQL User Defined Functions.

Most of databases uses common bitwise operators like AND (&) OR (|) NOT(~) etc. All available functions present in config.

MySQL

There are list of the available bitwise operators:

Bitwise AND (a & b) DoctrineBinary\Common\BitAnd

Bitwise OR (a | b) DoctrineBinary\Common\BitOr

Bitwise XOR (a ^ b) DoctrineBinary\Common\BitXor

Bitwise inversion (~a) DoctrineBinary\Common\BitInversion

Right shift (a >> b) DoctrineBinary\Common\LeftShift

Left shift (a << b) DoctrineBinary\Common\RightShift

There are list of the available binary functions:

BIT_COUNT(expr) DoctrineBinary\Mysql\BitCount

BIT_AND(expr) DoctrineBinary\Mysql\BitAnd

BIT_OR(expr) DoctrineBinary\Mysql\BitOr

BIT_XOR(expr) DoctrineBinary\Mysql\BitXor

PostgreSQL

There are list of the available bitwise operators:

Bitwise AND (a & b) DoctrineBinary\Common\BitAnd

Bitwise OR (a | b) DoctrineBinary\Common\BitOr

Bitwise exclusive OR (a # b) DoctrineBinary\Postgresql\BitXor

Bitwise NOT (~a) DoctrineBinary\Common\BitInversion

Right shift (a >> b) DoctrineBinary\Common\LeftShift

Left shift (a << b) DoctrineBinary\Common\RightShift

Oracle

There are list of the available bitwise operators:

Bitwise AND (a & b) DoctrineBinary\Common\BitAnd

Bitwise OR (a | b) DoctrineBinary\Common\BitOr

Bitwise XOR (a ^ b) DoctrineBinary\Common\BitXor

Bitwise NOT (~a) DoctrineBinary\Common\BitInversion

Right shift (a >> b) DoctrineBinary\Common\LeftShift

Left shift (a << b) DoctrineBinary\Common\RightShift

Zero-fill right shift (a >>> b) DoctrineBinary\Oracle\ZeroFill

There are list of the available binary functions:

BitAnd DoctrineBinary\Oracle\BitAnd

BitClear DoctrineBinary\Oracle\BitClear

BitNot DoctrineBinary\Oracle\BitNot

BitOr DoctrineBinary\Oracle\BitOr

BitRotate DoctrineBinary\Oracle\BitRotate

BitSet DoctrineBinary\Oracle\BitSet

BitShift DoctrineBinary\Oracle\BitShift

BitTest DoctrineBinary\Oracle\BitTest

BitXor DoctrineBinary\Oracle\BitXor

SQLite

There are list of the available bitwise operators:

Bitwise AND (a & b) DoctrineBinary\Common\BitAnd

Bitwise OR (a | b) DoctrineBinary\Common\BitOr

Bitwise NOT (~a) DoctrineBinary\Common\BitInversion

Right shift (a >> b) DoctrineBinary\Common\LeftShift

Left shift (a << b) DoctrineBinary\Common\RightShift

Other things

Run tests

composer run test

Code style fixes

composer run lint

Troubleshooting

If you want add something please send pull request.