From 6ef9fab3825ab4f6e9239ddde36e2a6ed909417e Mon Sep 17 00:00:00 2001 From: Anton Kovalevich Date: Wed, 6 Oct 2021 00:20:25 +0300 Subject: [PATCH] Add test_match_expression_supports_bindparam --- test/dialect/mysql/test_compiler.py | 12 +++++++++++- 1 file changed, 11 insertions(+), 1 deletion(-) diff --git a/test/dialect/mysql/test_compiler.py b/test/dialect/mysql/test_compiler.py index 169d46ed24..46e29ce8c0 100644 --- a/test/dialect/mysql/test_compiler.py +++ b/test/dialect/mysql/test_compiler.py @@ -53,7 +53,7 @@ from sqlalchemy.dialects.mysql import insert from sqlalchemy.dialects.mysql import match from sqlalchemy.sql import column from sqlalchemy.sql import table -from sqlalchemy.sql.expression import literal_column +from sqlalchemy.sql.expression import bindparam, literal_column from sqlalchemy.testing import assert_raises_message from sqlalchemy.testing import AssertsCompiledSQL from sqlalchemy.testing import eq_ @@ -1283,6 +1283,16 @@ class MatchExpressionTest(fixtures.TestBase, AssertsCompiledSQL): expr = case(expr) self.assert_compile(expr, expected) + def test_match_expression_supports_bindparam(self): + firstname = self.match_table.c.firstname + lastname = self.match_table.c.lastname + against = bindparam('against', required=True) + + expr = match(firstname, lastname, against=against) + + expected = "MATCH (user.firstname, user.lastname) AGAINST (%s)" + self.assert_compile(expr, expected) + def test_cols_required(self): assert_raises_message( exc.ArgumentError, -- 2.47.3