使用正则表达式来提取出sql语句中where的值

import re

sql = "SELECT * FROM table WHERE col1 = 'value1' AND col2 = 'value2'"

# 使用正则表达式提取出where的值
result = re.findall(r"WHERE\s+(.*?)(?:\s+|$)", sql)

if result:
    # 提取出的值是一个字符串，可以进一步处理成列表或其他格式
    values = result[0].split(" AND ")
    print(values)
else:
    print("No 'where' clause found in the SQL statement.")

import pymysql

class SQLExecutor:
    def __init__(self, host, port, user, password, database):
        self.host = host
        self.port = port
        self.user = user
        self.password = password
        self.database = database
    
    def execute(self, sql):
        try:
            # 连接到数据库
            connection = pymysql.connect(
                host=self.host,
                port=self.port,
                user=self.user,
                password=self.password,
                database=self.database
            )
            
            # 创建游标对象
            cursor = connection.cursor()
            
            # 执行SQL语句
            cursor.execute(sql)
            
            # 提交事务
            connection.commit()
            
            # 获取执行结果
            result = cursor.fetchall()
            
            # 关闭游标和连接
            cursor.close()
            connection.close()
            
            return result
        except Exception as e:
            print("An error occurred:", str(e))
            return None

# 示例使用
host = "localhost"
port = 3306
user = "root"
password = "password"
database = "mydb"

executor = SQLExecutor(host, port, user, password, database)

# 执行查询语句
sql = "SELECT * FROM table"
result = executor.execute(sql)
print(result)

# 执行插入语句
sql = "INSERT INTO table (col1, col2) VALUES ('value1', 'value2')"
executor.execute(sql)