#NEWLINE# def test_reflection_on_include_columns( self ) : #NEWLINE# #INDENT# 'Test reflection of include_columns to be sure they respect case.' #NEWLINE# case_table = Table ( 'mysql_case' , MetaData ( testing . db ) , Column ( 'c1' , String ( 10 ) ) , Column ( 'C2' , String ( 10 ) ) , Column ( 'C3' , String ( 10 ) ) ) #NEWLINE# try : #NEWLINE# #INDENT# case_table . create ( ) #NEWLINE# reflected = Table ( 'mysql_case' , MetaData ( testing . db ) , autoload = True , include_columns = [ 'c1' , 'C2' ] ) #NEWLINE# for t in ( case_table , reflected ) : #NEWLINE# #INDENT# assert ( 'c1' in t . c . keys ( ) ) #NEWLINE# assert ( 'C2' in t . c . keys ( ) ) #NEWLINE# #UNINDENT# reflected2 = Table ( 'mysql_case' , MetaData ( testing . db ) , autoload = True , include_columns = [ 'c1' , 'c2' ] ) #NEWLINE# assert ( 'c1' in reflected2 . c . keys ( ) ) #NEWLINE# for c in [ 'c2' , 'C2' , 'C3' ] : #NEWLINE# #INDENT# assert ( reflected not in reflected2 . c . keys ( ) ) #NEWLINE# #UNINDENT# #UNINDENT# finally : #NEWLINE# #INDENT# case_table . drop ( )