def __insertConfigHistory(self, conn, dbId, msg): # now update change history sql = ( 'INSERT INTO gp_configuration_history (time, dbid, "desc") VALUES(\n' "now(),\n " + self.__toSqlIntValue(dbId) + ",\n " + self.__toSqlCharValue(msg) + "\n)" ) logger.debug(sql) dbconn.executeUpdateOrInsert(conn, sql, 1)
def __updateSegmentReplicationPort(self, conn, seg): # run an update sql = "UPDATE pg_catalog.gp_segment_configuration\n" + \ " SET\n" + \ " replication_port = " + self.__toSqlIntValue(seg.getSegmentReplicationPort()) + "\n" \ "WHERE dbid = " + self.__toSqlIntValue(seg.getSegmentDbId()) logger.debug(sql) dbconn.executeUpdateOrInsert(conn, sql, 1)
def __updateSystemConfigFaultStrategy(self, conn, gpArray): """ Update the fault strategy. """ fs = gpArray.getFaultStrategy() sql = "UPDATE gp_fault_strategy\n SET fault_strategy = " + self.__toSqlCharValue(fs) + "\n" logger.debug(sql) dbconn.executeUpdateOrInsert(conn, sql, 1)
def __insertConfigHistory(self, conn, dbId, msg): # now update change history sql = "INSERT INTO gp_configuration_history (time, dbid, \"desc\") VALUES(\n" \ "now(),\n " + \ self.__toSqlIntValue(dbId) + ",\n " + \ self.__toSqlCharValue(msg) + "\n)" logger.debug(sql) dbconn.executeUpdateOrInsert(conn, sql, 1)
def __updateSegmentModeStatus(self, conn, seg): # run an update sql = "UPDATE pg_catalog.gp_segment_configuration\n" + \ " SET\n" + \ " mode = " + self.__toSqlCharValue(seg.getSegmentMode()) + ",\n" \ " status = " + self.__toSqlCharValue(seg.getSegmentStatus()) + "\n" \ "WHERE dbid = " + self.__toSqlIntValue(seg.getSegmentDbId()) logger.debug(sql) dbconn.executeUpdateOrInsert(conn, sql, 1)
def __updateSegmentAddress(self, conn, seg): # run an update sql = "UPDATE pg_catalog.gp_segment_configuration\n" + \ " SET\n" + \ " hostname = " + self.__toSqlCharValue(seg.getHostName()) + ",\n" \ " address = " + self.__toSqlCharValue(seg.getAddress()) + "\n" \ "WHERE dbid = " + self.__toSqlIntValue(seg.getRegistrationOrder()) logger.debug(sql) dbconn.executeUpdateOrInsert(conn, sql, 1)