metamodels/attribute_levenshtein

MetaModels attribute for maintaining a search index with levenshtein support

2.2.3 2023-05-29 22:01 UTC

Requires

• php: ^7.4
• contao-community-alliance/dc-general: ^2.2
• contao/core-bundle: ^4.9.0, <4.13.0
• metamodels/core: ^2.2
• symfony/dependency-injection: ^4.4.6
• symfony/event-dispatcher: ^4.4.6
• symfony/http-kernel: ~4.4.13

Requires (Dev)

• contao/manager-plugin: ^2.1
• menatwork/contao-multicolumnwizard-bundle: ^3.4
• phpcq/all-tasks: ^1.2

LGPL-3.0-or-later

• Christian Schiffler
• Stefan Heimes

• filter
• attribute
• contao
• metamodels
• levenshtein

README

Levenshtein-based search

The levenshtein attribute maintains an index of keywords across other attributes which can be searched using the levenshtein algorithm.

There is a filter rule that enables a similarity search via the created index. Optionally, an auto-completion ("Vanilla Script") can be activated (please note the template selection).

Adjustment of the index table

The fields for storing the index can be enlarged as required e.g. from a length of 64 to 256. To do this, create a corresponding DCA file and adjust the values. (Note: the keys and the file name still have the old, wrong notation with "sth").

// contao/dca/tl_metamodel_levensthein_index.php
$GLOBALS['TL_DCA']['tl_metamodel_levensthein_index']['fields']['transliterated']['sql'] =
    'varbinary(256) NOT NULL default \'\'';
$GLOBALS['TL_DCA']['tl_metamodel_levensthein_index']['fields']['word']['sql']           =
    'varchar(256) COLLATE utf8_bin NOT NULL default \'\'';