#NEWLINE# def test_drop_column_in_schema( self ) : #NEWLINE# #INDENT# 'Drop a column from a table in a non-public schema' #NEWLINE# stmts = [ 'CREATE SCHEMA s1' , 'CREATE TABLE s1.t1 (c1 integer, c2 text, c3 date)' ] #NEWLINE# inmap = self . std_map ( ) #NEWLINE# inmap . update ( { #NEWLINE# #INDENT# 'schema s1' : { #NEWLINE# #INDENT# 'table t1' : { #NEWLINE# #INDENT# 'columns' : [ { #NEWLINE# #INDENT# 'c1' : { #NEWLINE# #INDENT# 'type' : 'integer' , #NEWLINE# #UNINDENT# } , #NEWLINE# #UNINDENT# } , { #NEWLINE# #INDENT# 'c2' : { #NEWLINE# #INDENT# 'type' : 'text' , #NEWLINE# #UNINDENT# } , #NEWLINE# #UNINDENT# } ] , #NEWLINE# #UNINDENT# } , #NEWLINE# #UNINDENT# } , #NEWLINE# #UNINDENT# } ) #NEWLINE# sql = self . to_sql ( inmap , stmts ) #NEWLINE# assert ( fix_indent ( sql [ 0 ] ) == 'ALTER TABLE s1.t1 DROP COLUMN c3' )