opsway / doctrine-dbal-postgresql Goto Github PK

Thoughts on a 1.0 release?

PHP 5.6 has been dead since 2018, what do you think about dropping support for anything less than php 7.4? Actually, 7.4 will be at EOL in 4 months, since this would be a new release, perhaps you could simply require PHP8, and take advantage of all the goodies it provides.

Test issue on GitHub

Hello,

The README mention a class ArrayAggregate (OpsWay\Doctrine\ORM\Query\AST\Functions\ArrayAggregate) but it's not in the repository.

to_tsquery and to_tsvector both support a config parameter to indicate which dictionary it will use.

This is useful on multi-language applications.

Is there any reason as to why this is not supported?

What is the requirement for a new version to be tagged?
I need the latest code, but I don't want to use dev-master on my composer.json.

Any way I can help?

Split functions & operators by different namespace. Group by types. Rename if needed.

I'm attempting to use FTS with Doctrine.
I copy'n'pasted from Readme to config.yml.

Then I got:

Attempted to load class "ToTsvector" from namespace "OpsWay\Doctrine\ORM\Query\AST\Functions".
Did you forget a "use" statement for "Opsway\Doctrine\ORM\Query\AST\Functions\ToTsvector"?

The issue is the root namespace. On your readme it is stated as OpsWay, when it should be Opsway.

I'm considering to write a PR addressing this issue, but I wonder what is wrong: the README or the namespace itself?

Opsway to OpsWay in all file & in composer.json
Issue was found in pull request #1

currently with ToTsquery, it fails if you enter a string with a space , without a and
for this postgresql propose the plainto_tsquery which is not supported by this library.

Hi! There was a need to use one function inside the other to get this line order by field->'first'->>'other'. Simple nesting did not work. Tell me, is this even possible? Thank you!

https://github.com/opsway/doctrine-dbal-postgresql/blob/master/src/Doctrine/DBAL/Types/TsVector.php#L62

Some of my search fields are nullable. should this function detect null and return an empty string?

I was simply wondering if the bit string types will be supported?
https://www.postgresql.org/docs/10/datatype-bit.html

Hi,

I registered TS_MTACH_OP to doctrine:
$config
->addCustomStringFunction('TS_MATCH_OP','Opsway\Doctrine\ORM\Query\AST\Functions\TsMatch');

In my resource file, I have this query:
$query = $this->em->createQuery('SELECT u FROM App\Entity\Users u WHERE TS_MATCH_OP( u.nameFTS, :name)');
$query->setParameter('name', 'Bob');
$users = $query->getResult();

but I have errors:

1. Doctrine\ORM\Query\QueryException
   Message: SELECT u FROM App\Entity\Users u WHERE TS_MATCH_OP( u.nameFTS, :name)
2. Doctrine\ORM\Query\QueryException
   [Syntax Error] line 0, col -1: Error: Expected =, <, <=, <>, >, >=, !=, got end of string

Can you help me with this error?