§ ‘Õ[hãóš—ddlmZddlmZddlmZddlmZddlmZddlmZddlm Z ddlm Z dd l m Z Gd „d e ej ¦«Zd S) é)Úexc)Úutil)Ú coercions)Úelements)Ú operators)Úroles)Ú _generative)Ú Generative)ÚSelfcó~‡—eZdZdZdZdZˆfd„Zedefd„¦«Z edefd„¦«Z edefd„¦«Z ˆxZ S) ÚmatchasProduce a ``MATCH (X, Y) AGAINST ('TEXT')`` clause. E.g.:: from sqlalchemy import desc from sqlalchemy.dialects.mysql import match match_expr = match( users_table.c.firstname, users_table.c.lastname, against="Firstname Lastname", ) stmt = ( select(users_table) .where(match_expr.in_boolean_mode()) .order_by(desc(match_expr)) ) Would produce SQL resembling: .. sourcecode:: sql SELECT id, firstname, lastname FROM user WHERE MATCH(firstname, lastname) AGAINST (:param_1 IN BOOLEAN MODE) ORDER BY MATCH(firstname, lastname) AGAINST (:param_2) DESC The :func:`_mysql.match` function is a standalone version of the :meth:`_sql.ColumnElement.match` method available on all SQL expressions, as when :meth:`_expression.ColumnElement.match` is used, but allows to pass multiple columns :param cols: column expressions to match against :param against: expression to be compared towards :param in_boolean_mode: boolean, set "boolean mode" to true :param in_natural_language_mode: boolean , set "natural language" to true :param with_query_expansion: boolean, set "query expansion" to true .. versionadded:: 1.4.19 .. seealso:: :meth:`_expression.ColumnElement.match` Ú mysql_matchTc󌕗|stjd¦«‚| dd¦«}|€tjd¦«‚tjt j|¦«}tj  tj |¬¦«}d|_ tj| dd¦«| dd¦«| dd¦«d œ¦«}|r*tjd d  |¦«z¦«‚t!¦« ||tj|¬ ¦«dS) Nzcolumns are requiredÚagainstzagainst is required)ÚclausesFÚin_boolean_modeÚin_natural_language_modeÚwith_query_expansion)Úmysql_boolean_modeÚmysql_natural_languageÚmysql_query_expansionzunknown arguments: %sz, )Ú modifiers)rÚ ArgumentErrorÚpoprÚexpectrÚExpressionElementRolerÚBooleanClauseListÚ_construct_rawrÚcomma_opÚgrouprÚ immutabledictÚjoinÚsuperÚ__init__Úmatch_op)ÚselfÚcolsÚkwrÚleftÚflagsÚ __class__s €ús/var/www/api.easyaligner.net/htdocs/venv_linux/lib/python3.11/site-packages/sqlalchemy/dialects/mysql/expression.pyr$zmatch.__init__MsAø€Øð <ÝÔ#Ð$:Ñ;Ô;Ð ;à—&’&˜ DÑ)Ô)ˆà ˆ?ÝÔ#Ð$9Ñ:Ô:Ð :ÝÔ"Ý Ô 'Ø ñ ô ˆõ Ô)×8Ò8Ý Ô Øð9ñ ô ˆðˆŒ åÔ"à&(§f¢fÐ->ÀÑ&FÔ&FØ*,¯&ª&Ø.°ñ+ô+ð*,¯ªÐ0FÈÑ)NÔ)Nð  ð ñ ô ˆð ð OÝÔ#Ð$;¸t¿yºyȹ}¼}Ñ$MÑNÔNÐ Nå ‰Œ×Ò˜˜w­ Ô(:ÀeÐÑLÔLÐLÐLÐLóÚreturncóH—|j ddi¦«|_|S)z¢Apply the "IN BOOLEAN MODE" modifier to the MATCH expression. :return: a new :class:`_mysql.match` instance with modifications applied. rT©rÚunion©r&s r,rzmatch.in_boolean_modeos&€ðœ×-Ò-Ð/CÀTÐ.JÑKÔKˆŒØˆ r-cóH—|j ddi¦«|_|S)z³Apply the "IN NATURAL LANGUAGE MODE" modifier to the MATCH expression. :return: a new :class:`_mysql.match` instance with modifications applied. rTr0r2s r,rzmatch.in_natural_language_modezs&€ðœ×-Ò-Ð/GÈÐ.NÑOÔOˆŒØˆ r-cóH—|j ddi¦«|_|S)z§Apply the "WITH QUERY EXPANSION" modifier to the MATCH expression. :return: a new :class:`_mysql.match` instance with modifications applied. rTr0r2s r,rzmatch.with_query_expansion†s&€ðœ×-Ò-Ð/FÈÐ.MÑNÔNˆŒØˆ r-) Ú__name__Ú __module__Ú __qualname__Ú__doc__Ú__visit_name__Ú inherit_cacher$r r rrrÚ __classcell__)r+s@r,r r sÊø€€€€€ð1ð1ðf#€Nà€Mð Mð Mð Mð Mð MðDð ðððñ„[ððð ¨$ð ð ð ñ„[ð ðð dðððñ„[ðððððr-r N)ÚrrÚsqlrrrrÚsql.baser r Ú util.typingr ÚBinaryExpressionr ©r-r,úrBsìððÐÐÐÐÐØÐÐÐÐÐØÐÐÐÐÐØÐÐÐÐÐØÐÐÐÐÐØÐÐÐÐÐØ#Ð#Ð#Ð#Ð#Ð#Ø"Ð"Ð"Ð"Ð"Ð"ØÐÐÐÐÐðzðzðzðzðzˆJ˜Ô1ñzôzðzðzðzr-