laravel-oci8
laravel-oci8 copied to clipboard
FullText Search in laravel-oci8
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 ๐ฅ
- Oracle Documentation - CONTAINS
- Oracle Base - Full Text Indexing Using Oracle Text
- Oracle Documentation - ALL_TABLES
- Oracle Documentation - STATVIEW
Please review the changes, and if everything looks good, consider merging the pull request. Thank you ๐!