【Python】拼接MySQL常用语句

import pymysql

class MK_sql ():
    """
    构建mySQL常见语句：增删改查排序
    """

    def __init__(self, table_name):
        self.table_name = table_name

    def mk_create(self, value: list):
        """
        构建mySQL创建表语句
        @param value: 字段列表
        @return:
        """
        if not isinstance (value, list):
            raise Exception ("TypeError")
        sql = "create table %s (%s)" % (self.table_name, self.to_str (value))
        return sql

    def mk_delete(self, condition: dict):
        """
        构建mySQL删除指定字段语句
        @param condition: 删除条件，dict型
        @return:
        """
        if not isinstance (condition, dict):
            raise Exception ("TypeError")
        sql = "delete from %s" % self.table_name
        sql += " where %s " % self.to_str_and (condition)
        return sql

    def mk_insert(self, value: list):