Python mysql通用查询、更新语句组装

Python mysql通用查询、更新语句组装

	"""通用更新"""
    def update_order(self, table_name, up_dict, where_dict):
        try:
            with LockContext(self.setting.bookdblock):
                sentence1 = 'UPDATE %s SET ' % table_name
                sentence2 = ','.join(['%s=%r' % (k, up_dict[k]) for k in up_dict])
                sentence3 = ' WHERE '
                sentence4 = ' AND '.join(['%s=%r' % (k, where_dict[k]) for k in where_dict