Find acrossing multilines content blocks in pattern from a text file and process each block

block.py

#!/usr/bin/env python3

import re

# 1. define your block by a regular expression
RE_BLOCK = re.compile(
    r"MariaDB \[test\]> desc (?P<name>\w+?);\n(?P<definition>.+?)\n\d+? rows in set.+?",
    re.DOTALL | re.MULTILINE,
)

content = open("./schema.txt", "rt").read()


# 2. implement your logic of processing each matched block content
def process_block(block: re.Match):
    print(block.group(0))
    print(block.group("name"))
    print(block.group("definition"))


# driver code
for block in RE_BLOCK.finditer(content):
    process_block(block)