def copytableschema(self, tablename): try: iTable = "" listsourceTable = listtables(self.m_sourceSession.nominalSchema(), tablename) listdestTable = listtables(self.m_destSession.nominalSchema(), tablename) self._checktable(listsourceTable, listdestTable) for key, value in listsourceTable.items(): iTable = key print iTable self._copytablelayout(iTable) self.m_destSession.transaction().commit() self.m_sourceSession.transaction().commit() print "copytableschema SUCCESS" return True except Exception, e: self.m_destSession.transaction().rollback() self.m_sourceSession.transaction().commit() raise Exception("Error in copytableschema method: " + str(e) + " : " + iTable) return False
def copytabledata(self,tablename,selectionclause,selectionparameters,rowCount=-1 ): try: iTable="" listsourceTable=listtables( self.m_sourceSession.nominalSchema(),tablename ) listdestTable=listtables( self.m_destSession.nominalSchema(),tablename ) currentCount = 0 for key,value in listsourceTable.items(): iTable = key print iTable tableexists = self._checkdata(iTable,listdestTable) if not tableexists: self._copytablelayout(iTable) self._copydatalayout(iTable,selectionclause,selectionparameters,currentCount,rowCount) self.m_destSession.transaction().commit() self.m_sourceSession.transaction().commit() print "copytabledata SUCCESS" return True except Exception, e: self.m_destSession.transaction().rollback() self.m_sourceSession.transaction().commit() raise Exception ("Error in copytabledata method: " + str(e)+" : " + iTable) return False
def copytableschema(self,tablename ): try: iTable="" listsourceTable=listtables( self.m_sourceSession.nominalSchema(),tablename ) listdestTable=listtables(self.m_destSession.nominalSchema(),tablename ) self._checktable(listsourceTable,listdestTable) for key,value in listsourceTable.items(): iTable = key print iTable self._copytablelayout(iTable) self.m_destSession.transaction().commit() self.m_sourceSession.transaction().commit() print "copytableschema SUCCESS" return True except Exception, e: self.m_destSession.transaction().rollback() self.m_sourceSession.transaction().commit() raise Exception ("Error in copytableschema method: " + str(e)+" : "+iTable) return False
def copytabledata(self, tablename, selectionclause, selectionparameters, rowCount=-1): try: iTable = "" listsourceTable = listtables(self.m_sourceSession.nominalSchema(), tablename) listdestTable = listtables(self.m_destSession.nominalSchema(), tablename) currentCount = 0 for key, value in listsourceTable.items(): iTable = key print iTable tableexists = self._checkdata(iTable, listdestTable) if not tableexists: self._copytablelayout(iTable) self._copydatalayout(iTable, selectionclause, selectionparameters, currentCount, rowCount) self.m_destSession.transaction().commit() self.m_sourceSession.transaction().commit() print "copytabledata SUCCESS" return True except Exception, e: self.m_destSession.transaction().rollback() self.m_sourceSession.transaction().commit() raise Exception("Error in copytabledata method: " + str(e) + " : " + iTable) return False