comparison sqlpyPlus.py @ 79:01d578f4e6e7

prevent crash when pull unresolved
author catherine@DellZilla.myhome.westell.com
date Mon, 28 Apr 2008 12:20:53 -0400
parents 8529876f7541
children 83de0cb04f12
comparison
equal deleted inserted replaced
78:8529876f7541 79:01d578f4e6e7
535 535
536 --full, -f: get dependent objects as well""" 536 --full, -f: get dependent objects as well"""
537 537
538 options, arg = self.pullflags.parse(arg) 538 options, arg = self.pullflags.parse(arg)
539 object_type, owner, object_name = self.resolve(arg.strip(self.terminator).upper()) 539 object_type, owner, object_name = self.resolve(arg.strip(self.terminator).upper())
540 if not object_type:
541 return
540 self.stdout.write("%s %s.%s\n" % (object_type, owner, object_name)) 542 self.stdout.write("%s %s.%s\n" % (object_type, owner, object_name))
541 self.stdout.write(str(self.curs.callfunc('DBMS_METADATA.GET_DDL', cx_Oracle.CLOB, 543 self.stdout.write(str(self.curs.callfunc('DBMS_METADATA.GET_DDL', cx_Oracle.CLOB,
542 [object_type, object_name, owner]))) 544 [object_type, object_name, owner])))
543 if options.has_key('full'): 545 if options.has_key('full'):
544 for dependent_type in ('OBJECT_GRANT', 'CONSTRAINT', 'TRIGGER'): 546 for dependent_type in ('OBJECT_GRANT', 'CONSTRAINT', 'TRIGGER'):