Java Row类代码示例

import com.google.code.or.common.glossary.Row; //导入依赖的package包/类
private void executeInsertPstmt(int stmtId, List<Row> rows) {
	PreparedStatement script = session.getPrepared(stmtId);
    for (Row row: rows) {
		Parameters param = toParameters(row);
		checkParameters(script, param);
		try {
			Object result = script.run(this.session, param);
			checkResult(result);
		}
		catch (OrcaException x) {
			if (x.getMessage().equals("EXISTENCE_VIOLATION")) {
				_log.warn("INSERT failure is ignored");
				return;
			}
			throw x;
		}
    }
}
 

import com.google.code.or.common.glossary.Row; //导入依赖的package包/类
private void executeUpdatePstmt(long tableId, int stmtId, TableMeta meta, List<Pair<Row>> rows) 
throws SQLException {
   	PreparedStatement script = session.getPrepared(stmtId);
       for (Pair<Row> pair: rows) {
   		Parameters param = toParameters(meta, pair);
   		checkParameters(script, param);
   		Object result = script.run(this.session, param);
   		if ((result instanceof Integer) && (((Integer)result) == 0)) {
   			// fall back to insert if update failed
   			_log.warn("update failed with 0 update count {}, switching to insert", meta.getObjectName().toString());
   			_log.warn("{}", pair);
   			executeInsertPstmt(tableId, Collections.singletonList(pair.getAfter()));
   			return;
   		}
		checkResult(result);
       }
   }
 

import com.google.code.or.common.glossary.Row; //导入依赖的package包/类
public MysqlBinlogData(
        Table table, 
        MysqlBinlogHandler binlogType, 
        Row rowBefore, 
        Row rowAfter){
    
    this.table = table;
    this.binlogType = binlogType;
    if(rowBefore != null){
        this.rowBefore = Collections.unmodifiableList(rowBefore.getColumns());
    }else{
        this.rowBefore = null;
    }
    if(rowAfter != null){
        this.rowAfter = Collections.unmodifiableList(rowAfter.getColumns());
    }else{
        this.rowAfter = null;
    }
    
}
 

import com.google.code.or.common.glossary.Row; //导入依赖的package包/类
private List<Map<String, Object>> getData(String tableName, List<Row> rows) {
    List<Map<String, Object>> dataList = new ArrayList<Map<String, Object>>();
    for (Row row : rows) {
        Map<String, Object> data = new HashMap<String, Object>();
        List<Column> columns = row.getColumns();
        List<ColumnInfo> columnSchemaInfo = databaseInfo.getTableInfo(tableName).getRowInfo().getColumnInfo();
        for (int index = 0; index < columns.size(); ++index) {
            ColumnInfo columnInfo = columnSchemaInfo.get(index);
            Column col = columns.get(index);
            data.put(columnInfo.getName(),
                     columnInfo.getColumnDataType().getConvertedValue(columnInfo.getColumnDataType(),
                             col.getValue()));
        }
        dataList.add(data);
    }
    return dataList;
}
 

import com.google.code.or.common.glossary.Row; //导入依赖的package包/类
private static List<Pair<Row>> getRowPairs(List<MySqlValue> oldValueList, List<MySqlValue> newValueList) {
    List<Pair<Row>> rowPairs = new ArrayList<Pair<Row>>();
    Row oldRow = new Row();
    Row newRow = new Row();
    List<Column> oldColumns = new ArrayList<Column>();
    List<Column> newColumns = new ArrayList<Column>();

    for (int index = 0; index < oldValueList.size(); ++index) {
        MySqlValue oldValue = oldValueList.get(index);
        oldColumns.add(getColumn(oldValue));

        MySqlValue newValue = newValueList.get(index);
        newColumns.add(getColumn(newValue));
    }
    oldRow.setColumns(oldColumns);
    newRow.setColumns(newColumns);
    Pair<Row> rowPair = new Pair<Row>(oldRow, newRow);
    rowPairs.add(rowPair);
    return rowPairs;
}
 

import com.google.code.or.common.glossary.Row; //导入依赖的package包/类
private void executeDeletePstmt(int stmtId, TableMeta meta, List<Row> rows) {
 	PreparedStatement script = session.getPrepared(stmtId);
     for (Row row: rows) {
 		Parameters param = toParameters(meta, row);
 		checkParameters(script, param);
         Object result = script.run(this.session, param);
 		if ((result instanceof Integer) && (((Integer)result) == 0)) {
 			_log.warn("delete failed with 0 update count {}", meta.getObjectName().toString());
 			_log.warn("{}", row);
 			return;
 		}
checkResult(result);
     }
 }
 

import com.google.code.or.common.glossary.Row; //导入依赖的package包/类
private Parameters toParameters(Row row) {
	List<Column> columns = row.getColumns();
	Object[] pureValues = new Object[columns.size()];
    for (int i=0; i<columns.size(); i++) {
    	pureValues[i] = toParameter(columns.get(i));
    }
    return new Parameters(pureValues);
}
 

import com.google.code.or.common.glossary.Row; //导入依赖的package包/类
public static MysqlBinlogTask getInstance(
        final MysqlBinlogProcessor processor,
        final TableMapEvent tableMapEvent,
        final MysqlBinlogHandler type, 
        final Row oldRow,
        final Row newRow,
        final String binlogFileName,
        final long binlogPosition,
        final long binlogTimestamp,
        final int binlogCurrentRowNumber,
        final int binlogTotalRowNumber){
    
    MysqlBinlogTask task = new MysqlBinlogTask();
    task.initialize(
            processor, 
            tableMapEvent, 
            type, 
            oldRow, 
            newRow, 
            binlogFileName, 
            binlogPosition, 
            binlogTimestamp,
            binlogCurrentRowNumber,
            binlogTotalRowNumber);
    
    return task;
    
}
 

import com.google.code.or.common.glossary.Row; //导入依赖的package包/类
private void initialize(
        final MysqlBinlogProcessor processor,
        final TableMapEvent tableMapEvent,
        final MysqlBinlogHandler type, 
        final Row oldRow,
        final Row newRow,
        final String binlogFileName,
        final long binlogPosition,
        final long binlogTimestamp,
        final int binlogCurrentRowNumber,
        final int binlogTotalRowNumber){
    
    this.processor = processor;
    this.tableMapEvent = tableMapEvent;
    this.type = type;
    this.oldRow = oldRow;
    this.newRow = newRow;
    
    this.binlogFileName = binlogFileName;
    this.binlogPosition = binlogPosition;
    this.binlogTimestamp = binlogTimestamp;
    this.binlogCurrentRowNumber = binlogCurrentRowNumber;
    this.binlogTotalRowNumber = binlogTotalRowNumber;
    
    dependencyValues.clear();
    waitingFlag.clear();
    waitingCount.set(0);
    _isFinished = false;
    
    // gen idx value
    calcDepedencyValues();
}
 

import com.google.code.or.common.glossary.Row; //导入依赖的package包/类
private void calcDependencyValue(String dbName, String tableName, Row row, Index idx){
    
    final List<com.google.code.or.common.glossary.Column> columnList = row.getColumns();
    
    StringBuilder builder = new StringBuilder(dbName)
            .append('.').append(tableName)
            .append('.').append(idx.getName());
    
    for(int i=0; i<idx.getColumns().size(); i++){
        
        builder.append('[').append(idx.getColumn(i).getName()).append('=');
        com.google.code.or.common.glossary.Column col = columnList.get(idx.getColumn(i).getPosition());
        Object value = col.getValue();
        
        if(value == null){
            
        }else if(value instanceof byte[]){
            Arrays.toString((byte[])value);
        }else{
            builder.append(value.toString());
        }
        builder.append("]");
    }
    
    dependencyValues.add(builder.toString());
    
}
 

import com.google.code.or.common.glossary.Row; //导入依赖的package包/类
private static List<Row> getRows(List<MySqlValue> valueList) {
    List<Row> rows = new ArrayList<Row>();
    Row singleRow = new Row();
    List<Column> columns = new ArrayList<Column>();
    for (MySqlValue value : valueList) {
        columns.add(getColumn(value));
    }
    singleRow.setColumns(columns);
    rows.add(singleRow);
    return rows;
}
 

import com.google.code.or.common.glossary.Row; //导入依赖的package包/类
static Struct convertPrimaryKeyData(Schema pkSchema, Table table, Row row) {
    Struct pkStruct = new Struct(pkSchema);

    for (String pk : table.getPKList()) {
        int idx = table.findColumnIndex(pk);

        Column column = row.getColumns().get(idx);
        ColumnDef def = table.getColumnList().get(idx);

        addFieldData(pkStruct, def, column);
    }
    return pkStruct;
}
 

import com.google.code.or.common.glossary.Row; //导入依赖的package包/类
static Struct convertRowData(Schema rowSchema, Table table, Row row) {
    Struct rowStruct = new Struct(rowSchema);

    for (int columnNumber = 0; columnNumber < table.getColumnList().size(); columnNumber++) {
        Column column = row.getColumns().get(columnNumber);
        ColumnDef def = table.getColumnList().get(columnNumber);

        addFieldData(rowStruct, def, column);
    }
    return rowStruct;
}
 

import com.google.code.or.common.glossary.Row; //导入依赖的package包/类
public Row getRowBefore(){
    return oldRow;
}
 

import com.google.code.or.common.glossary.Row; //导入依赖的package包/类
public Row getRowAfter(){
    return newRow;
}