Function install_regexp_functions

tortoise/contrib/sqlite/regex.py:32–42

(connection: aiosqlite.Connection)

async def install_regexp_functions(connection: aiosqlite.Connection):
    def regexp(expr, item):
        if not expr or not item:
            return False
        return re.search(expr, item) is not None

    def iregexp(expr, item):
        return re.search(expr, item, re.IGNORECASE) is not None

    await connection.create_function("regexp", 2, regexp)
    await connection.create_function("match", 2, iregexp)