laravel-oci8 icon indicating copy to clipboard operation
laravel-oci8 copied to clipboard

FullText Search in laravel-oci8

Open jonas-elias opened this issue 2 years ago โ€ข 5 comments

Title ๐Ÿ˜Ž Hello, this pull request implements the "whereFullText()" method for laravel/oci8.

Description ๐Ÿคฏ The implementation utilizes the CONTAINS Oracle feature to perform a text search using the ctxsys.context index. To facilitate the creation of the index, a migration method named "fullText(nameColumn)" is included.

Additional notes ๐Ÿคจ I have made modifications to the "testDropAllTables()" method to incorporate a constraint for secondary tables created by Oracle. This change prevents an error when dropping secondary tables whose parent tables have text reference indexes, and ensures the proper disposal of secondary tables (Oracle's automatic cascade). The relevant column "SECONDARY" is described in the documentation (references 3 and 4).

Running tests ๐Ÿš€ ./vendor/phpunit/phpunit/phpunit --filter=testWhereFullText ./vendor/phpunit/phpunit/phpunit --filter=testOrWhereFullText

References ๐Ÿ–ฅ

  1. Oracle Documentation - CONTAINS
  2. Oracle Base - Full Text Indexing Using Oracle Text
  3. Oracle Documentation - ALL_TABLES
  4. Oracle Documentation - STATVIEW

Please review the changes, and if everything looks good, consider merging the pull request. Thank you ๐Ÿ˜!

jonas-elias avatar Aug 03 '23 23:08 jonas-elias