#NEWLINE# def setUp( self ) : #NEWLINE# #INDENT# super ( DropAllObjectsTest , self ) . setUp ( ) #NEWLINE# self . metadata = metadata = schema . MetaData ( ) #NEWLINE# schema . Table ( 'a' , metadata , schema . Column ( 'id' , types . Integer , primary_key = True ) , mysql_engine = 'InnoDB' ) #NEWLINE# schema . Table ( 'b' , metadata , schema . Column ( 'id' , types . Integer , primary_key = True ) , schema . Column ( 'a_id' , types . Integer , schema . ForeignKey ( 'a.id' ) ) , mysql_engine = 'InnoDB' ) #NEWLINE# schema . Table ( 'c' , metadata , schema . Column ( 'id' , types . Integer , primary_key = True ) , schema . Column ( 'b_id' , types . Integer , schema . ForeignKey ( 'b.id' ) ) , schema . Column ( 'd_id' , types . Integer , schema . ForeignKey ( 'd.id' , use_alter = True , name = 'c_d_fk' ) ) , mysql_engine = 'InnoDB' ) #NEWLINE# schema . Table ( 'd' , metadata , schema . Column ( 'id' , types . Integer , primary_key = True ) , schema . Column ( 'c_id' , types . Integer , schema . ForeignKey ( 'c.id' ) ) , mysql_engine = 'InnoDB' ) #NEWLINE# metadata . create_all ( self . engine , checkfirst = False ) #NEWLINE# self . addCleanup ( metadata . drop_all , self . engine , checkfirst = True )