ia\Lib\Synonyms
Synonims for import headers and or values
Case, accent, punctuantion, and snake_case/normal case insnesitive.
Levels parent_table has n parent_id has n originalNames each has n synonyms.
class ia\Lib\Synonyms
- namespace: ia\Lib
- Implements: Stringable
- Public Methods
- __construct( bool $tryPluralSingular = true, string $parent_id = '', string $parent_table = '' ) :
/**
* Synonyms::__construct()
*
* @param bool $tryPluralSingular
* @param string $parent_id
* @param string $parent_table
* @return
*/
- is_inDictionary( string $alternativeName, string|null $parent_id = null, string|null $parent_table = null ) : bool
/**
* True if word $alternativeName mactches to an original name
*
* @param string $alternativeName
* @param string|null $parent_id
* @param string|null $parent_table
* @return bool true $alternativeName exists in database
*/
- get_originalName( string $alternativeName, string|null $parent_id = null, string|null $parent_table = null ) : string|null
/**
* for $alternativeName return the original name or null if not regestered
*
* @param string $alternativeName
* @param string|null $parent_id
* @param string|null $parent_table
* @return string|null
*/
- get_original_id( string $alternativeName, string|null $parent_id = null, string|null $parent_table = null ) : string|null
/**
* Sfor $alternativeName return the original_id or null if not regestered
*
* @param string $alternativeName
* @param string|null $parent_id
* @param string|null $parent_table
* @return string|null
*/
- addSynonymsArray( array $synonyms, string|null $parent_id = null, string|null $parent_table = null ) :
/**
*
*
* @param array $synonyms ['tax Id'=>'rfc', 'vat number'=>'rfc']
* @param string|null $parent_id
* @param string|null $parent_table
* @return
*/
- addSynonym( string $alternativeName, string $original, string $original_id = null, string|null $parent_id = null, string|null $parent_table = null ) :
/**
* Synonyms::addSynonym()
*
* @param string $alternativeName
* @param string $original
* @param string $original_id
* @param string|null $parent_id
* @param string|null $parent_table
* @return
*/
- dbLoadSynonyms( IaMysqli $db, string $parent_id, string $parent_table ) : bool
/**
* @param IaMysqli $db
* @param string $parent_id
* @param string $parent_table
* @return bool true success, false failure
* @throws \ia\Sql\Mysql\IacSqlException
*/
- dbAddSynonymsArray( IaMysqli $db, array $synonyms, string|null $parent_id = null, string|null $parent_table = null ) : true
/**
* Synonyms::dbAddSynonymsArray()
*
* @param IaMysqli $db
* @param array $synonyms
* @param string|null $parent_id
* @param string|null $parent_table
* @return true ok, false db error
*/
- static queryUpdateOriginal( string|null $parent_table, string|null $parent_id, string $original, string $newOriginal ) : bool
/**
* Synonyms::queryUpdateOriginal()
*
* @param string|null $parent_table
* @param string|null $parent_id
* @param string $original
* @param string $newOriginal
* @return bool true ok, false db error
*/
- static queryUpdateOriginalById( string|null $parent_table, string|null $parent_id, string $original_id, string $newOriginal ) : bool
/**
* Synonyms::queryUpdateOriginalById()
*
* @param string|null $parent_table
* @param string|null $parent_id
* @param string $original_id
* @param string $newOriginal
* @return bool true ok, false db error
*/
- static queryDeleteSynonym( string|null $parent_table, string|null $parent_id, string $synonym ) : bool
/**
* Synonyms::queryDeleteSynonym()
*
* @param string|null $parent_table
* @param string|null $parent_id
* @param string $synonym
* @return bool true ok, false db error
*/
- static queryDeleteOriginal( string|null $parent_table, string|null $parent_id, string $original ) : bool
/**
* Synonyms::queryDeleteOriginal()
*
* @param string|null $parent_table
* @param string|null $parent_id
* @param string $original
* @return bool true ok, false db error
*/
- static queryDeleteOriginal_id( string|null $parent_table, string|null $parent_id, $original_id ) : bool
/**
* Synonyms::queryDeleteOriginal_id()
*
* @param string|null $parent_table
* @param string|null $parent_id
* @paramv $original_id
* @return bool true ok, false db error
*/
- dbReadSynonymOriginal( IaMysqli $db, string $parent_id = null, string $parent_table = null ) : array|bool
/**
* ['synonym'=>'original',...]
*
* @param IaMysqli $db
* @param string $parent_id
* @param string $parent_table
* @return array|bool ['synonym'=>'original',...] or false on error
* @throws \ia\Sql\Mysql\IacSqlException
*/
- dbReadSynonymOriginal_id( IaMysqli $db, string $parent_id = null, string $parent_table = null ) : array|bool
/**
* ['synonym'=>'original_id',...]
*
* @param IaMysqli $db
* @param string $parent_id
* @param string $parent_table
* @return array|bool ['synonym'=>'original_id',...] or false on error
* @throws \ia\Sql\Mysql\IacSqlException
*/
- Calls:
- MultipleInsert
- SqlBuilder
- Str
- iaPalabra
ia\Lib\Synonyms
ia\Lib\Synonyms
Synonims for import headers and or values
Case, accent, punctuantion, and snake_case/normal case insnesitive.
Levels parent_table has n parent_id has n originalNames each has n synonyms.
- Create:
$syn = new Synonyms(true, 'heading', 'person');
- Add manually:
$syn->addSynonymsArray(['tax ID'=>'r.f.c.', 'clave'=>'RFC', 'Registro_federal_de_causantes'=>'rfc']);
- Query it
- echo $syn->get_originalName('Tax. ID'); = rfc
- echo $syn->get_originalName('Tax_id'); = rfc
- echo $syn->get_originalName('TaX id'); = rfc
- echo $syn->get_originalName('Tax-id'); = rfc
- echo $syn->get_originalName('RFC'); = rfc
- echo $syn->get_originalName('r.F.c'); = rfc
- echo $syn->get_originalName('claves.'); = rfc
//////////////////////////////////////
|