PrepareSql.py 文件源码

def DeleteEvent(self,values):
        sql = 'insert into {}.{}({}) values('.format(self.databasename,self.tablename,','.join([a[0] for a in self.table_column_list]))
        for idex,value in enumerate(values):
            if type(value) is types.StringType:
                if value == 'Null':
                    sql += '{}'.format(value)
                else:
                    sql += '"{}"'.format(value)
            else:
                sql += '{}'.format(value)
            if len(values[idex:]) <= 1:
                sql += ')'
            else:
                sql += ','
        if _remote_filed._rollback_status:
            print '{: >21}{}{}'.format('', '-- ', sql)
        else:
            self.__tmppack(sql, 2)