Summary

This PR adds 4 missing Query Builder methods for checking if a JSON path exists:

• whereJsonContainsKey()
• orWhereJsonContainsKey()
• whereJsonDoesntContainKey()
• orWhereJsonDoesntContainKey()

These methods exist in Laravel but were missing from Hyperf.

Changes

1. New Builder Methods

Added to src/database/src/Query/Builder.php:

$query->whereJsonContainsKey('options->languages');
$query->whereJsonDoesntContainKey('options->languages');

2. Grammar Support

Each database has different SQL syntax for this operation:

3. CompilesJsonPaths Trait

Ported Laravel's new CompilesJsonPaths trait to share improved JSON path compilation logic between Query Grammar and Schema Grammar classes.

Why this was needed:

Hyperf's wrapJsonPath (base Grammar) and wrapJsonPathAttributes (Postgres) were outdated and didn't handle array indices in JSON paths. For example, options->languages[0][1] was incorrectly treated as a single quoted key "languages[0][1]" instead of being parsed as "languages"[0][1].

The fix required updating these methods, but they were duplicated across Query Grammar and SQLite Schema Grammar. Laravel solves this with a shared trait.

Changes:

• Created CompilesJsonPaths trait in src/database/src/Concerns/ (matches Laravel's architecture)
• Query Grammar and Schema Grammar both use the trait (eliminates code duplication)
• Removed duplicate methods from SQLite Schema Grammar
• PostgresGrammar.php: Updated wrapJsonPathAttributes() + added parseJsonPathArrayKeys()

The trait contains:

• wrapJsonFieldAndPath() - splits JSON selector into field and path
• wrapJsonPath() - wraps JSON path with proper array index handling
• wrapJsonPathSegment() - parses individual path segments including array indices

Test fix:

The existing MySQL test in QueryBuilderTest.php had an incorrect expectation that matched the buggy behavior:

// Old (incorrect)
$this->assertSame('... \'$."languages[0][1]"\'...', $builder->toSql());

// New (correct - matches Laravel)
$this->assertSame('... \'$."languages"[0][1]\'...', $builder->toSql());

Laravel's test confirms the correct expectation: DatabaseQueryBuilderTest.php:6682-6683

4. PostgreSQL / SQLite Test Structure Fix

The database-pgsql and database-sqlite test files had two problems:

Problem 1: Class names

The old names were not consistent. I renamed them to match Laravel's class names:

I also removed a duplicate test class.

Problem 2: Postgres tests used deprecated Swoole extension

The main ContainerStub and DatabasePostgresBuilderTest test files used the deprecated pgsql-swoole driver:

// Old - deprecated Swoole extension
'driver' => 'pgsql-swoole',
PostgresSqlSwooleExtConnector::class
PostgreSqlSwooleExtConnection::class

Hyperf now uses PDO for PostgreSQL. The tests only run on Swoole < 6.0.

Solution:

1. Renamed old files to clearly show they test the deprecated extension:

   • ContainerStub.php → SwooleExtContainerStub.php
   • DatabasePostgresBuilderTest.php → DatabasePostgresSwooleExtQueryBuilderTest.php

2. Created new files for PDO driver:

   • ContainerStub.php - uses pgsql driver with PDO
   • DatabasePostgresQueryBuilderTest.php - pure unit tests like Laravel (no database needed)

Files Changed

New trait + JSON path fixes:

• src/database/src/Concerns/CompilesJsonPaths.php - new trait (matches Laravel's architecture)
• src/database/src/Query/Grammars/Grammar.php - uses CompilesJsonPaths trait + new compile method
• src/database/src/Schema/Grammars/Grammar.php - uses CompilesJsonPaths trait
• src/database-pgsql/src/Query/Grammars/PostgresGrammar.php - new compile method + wrapJsonPathAttributes improvements
• src/database-sqlite/src/Query/Grammars/SQLiteGrammar.php - new compile method
• src/database-sqlite/src/Schema/Grammars/SQLiteGrammar.php - removed duplicate methods (now inherited via trait)

New Builder methods:

• src/database/src/Query/Builder.php - new whereJsonContainsKey methods
• src/database/src/Query/Grammars/MySqlGrammar.php - new compile method

Tests:

• src/database/tests/QueryBuilderTest.php - MySQL tests + fixed array index expectation
• src/database-pgsql/tests/Cases/DatabasePostgresQueryBuilderTest.php - new file with array index tests
• src/database-sqlite/tests/DatabaseSQLiteQueryBuilderTest.php - renamed + array index tests