#NEWLINE# def _generate_sql( self ) : #NEWLINE# #INDENT# query_params = [ ] #NEWLINE# sql = { #NEWLINE# #INDENT# 'local' : self . _generate_local ( ) , #NEWLINE# 'source_file' : self . _generate_source_file ( query_params ) , #NEWLINE# 'database_name' : self . job . spec . target . database , #NEWLINE# 'table_name' : self . job . spec . target . table , #NEWLINE# 'fields_spec' : self . _generate_fields_spec ( query_params ) , #NEWLINE# 'lines_spec' : self . _generate_lines_spec ( query_params ) , #NEWLINE# 'ignore' : self . _generate_ignore ( query_params ) , #NEWLINE# 'columns' : self . _generate_columns ( query_params ) , #NEWLINE# 'file_id' : self . _generate_file_id ( query_params ) , #NEWLINE# 'dup_key_method' : self . _generate_dup_key_method ( ) , #NEWLINE# #UNINDENT# } #NEWLINE# return ( { k : ( v if ( v is not None ) else '' ) for ( k , v ) in sql . iteritems ( ) } , query_params )