python单独获取一个SQL的所有用到的表名

# -*- coding: utf-8 -*-
"""
author: Chester
"""

#import ply.lex as lex,
import re,os

def extract_table_name_from_sql(file,sql_str):

    # remove the /* */ comments
    q = re.sub(r"/\*[^*]*\*+(?:[^*/][^*]*\*+)*/", "", sql_str)

    # remove whole line -- and # comments
    lines = [line for line in q.splitlines() if not re.match("^\s*(--|#)", line)]

    # remove trailing -- and # comments
    q = " ".join([re.split("--|#", line)[0] for line in lines])

    # split on blanks, parens and semicolons
    tokens = re.split(r"[\s)(;]+", q)

    # scan the tokens. if we see a FROM or JOIN, we set the get_next
    # flag, and grab the next one (unless it's SELECT).

    result = []
    get_next = False
    for token in tokens:
        if get_next:
            if token.lower() not in ["", "select"]:
                result.append(token)
            get_next = False
        get_next = token.lower() in ["from", "join"]

    return result

file = 'xxxxxxx.sql'
pth = r'C:\test\sql'
filetxt = os.path.join(pth,file)
all_the_text =open(filetxt,encoding='utf-8').read( )
print(extract_table_name_from_sql(file,all_the_text))