Difference between revisions of "Scout/Concepts/TableData"

  SQL.selectInto("SELECT PERSON_NR, PERSON_NAME FROM PERSONS INTO :{id}, :{name}", formData.getPersonTable());

public static class PersonTable extends AbstractTableFieldData {
 
  private static final long serialVersionUID = 1L;
  public static final int ID_COLUMN_ID = 0;
  public static final int NAME_COLUMN_ID = 1;
 
  public PersonTable() {
  }
 
  public Long getId(int row) {
    return (Long) getValueInternal(row, ID_COLUMN_ID);
  }
 
  public void setId(int row, Long id) {
    setValueInternal(row, ID_COLUMN_ID, id);
  }
 
  public String getName(int row) {
    return (String) getValueInternal(row, NAME_COLUMN_ID);
  }
 
  public void setName(int row, String name) {
    setValueInternal(row, NAME_COLUMN_ID, name);
  }
 
  @Override
  public int getColumnCount() {
    return 2;
  }
 
  @Override
  public Object getValueAt(int row, int column) {
    switch (column) {
      case ID_COLUMN_ID:
        return getId(row);
      case NAME_COLUMN_ID:
        return getName(row);
      default:
        return null;
    }
  }
 
  @Override
  public void setValueAt(int row, int column, Object value) {
    switch (column) {
      case ID_COLUMN_ID:
        setId(row, (Long) value);
        break;
      case NAME_COLUMN_ID:
        setName(row, (String) value);
        break;
    }
  }
}

private void mapPersonToFormData(AFormData formData, List<Person> persons) {
  PersonTable table = formData.getPersonTable();
  table.clearRows();
  for (Person person : persons) {
    int rowNum = table.addRow();
    table.setId(rowNum, person.getId());
    table.setName(rowNum, person.getName());
  }
}

private void mapPersonToFormData(AFormData formData, List<Person> persons) {
  //This pattern is not recommended:
  PersonTable table = formData.getPersonTable();
  table.clearRows();
  for (Person person : persons) {
    table.addRow(new Object[]{person.getId(), person.getName()}); //Do not use AbstractTableFieldData#addRow(Object[])
  }
}

private void mapPersonsFromFormData(AFormData formData, List<Person> persons) {
  PersonTable table = formData.getPersonTable();
  for (int rowNum = 0; rowNum < table.getRowCount(); rowNum++) {
    switch (table.getRowState(rowNum)) {
      case ITableHolder.STATUS_INSERTED:
        //insert a new person corresponding to the row:
        insertPerson(persons, table.getId(rowNum), table.getName(rowNum));
        break;
      case ITableHolder.STATUS_DELETED:
        //delete the person corresponding to the row:
        deletePerson(persons, table.getId(rowNum));
        break;
      case ITableHolder.STATUS_UPDATED:
        //modify the person corresponding to the row:
        updatePerson(persons, table.getId(rowNum), table.getName(rowNum));
        break;
      case ITableHolder.STATUS_NON_CHANGED:
      default:
        //Do nothing
        break;
    }
  }      
}

@FormData(sdkCommand = SdkCommand.USE, value = AbstractTableFieldBeanData.class, defaultSubtypeSdkCommand = DefaultSubtypeSdkCommand.CREATE)
public class TableField extends AbstractTableField {
  //... Table inner class.
}

public static class PersonTable extends AbstractTableFieldBeanData {
 
  private static final long serialVersionUID = 1L;
 
  public PersonTable() {
  }
 
  @Override
  public PersonTableRowData addRow() {
    return (PersonTableRowData) super.addRow();
  }
 
  @Override
  public PersonTableRowData addRow(int rowState) {
    return (PersonTableRowData) super.addRow(rowState);
  }
 
  @Override
  public PersonTableRowData createRow() {
    return new PersonTableRowData();
  }
 
  @Override
  public Class<? extends AbstractTableRowData> getRowType() {
    return PersonTableRowData.class;
  }
 
  @Override
  public PersonTableRowData[] getRows() {
    return (PersonTableRowData[]) super.getRows();
  }
 
  @Override
  public PersonTableRowData rowAt(int index) {
    return (PersonTableRowData) super.rowAt(index);
  }
 
  public void setRows(PersonTableRowData[] rows) {
    super.setRows(rows);
  }
 
  public static class PersonTableRowData extends AbstractTableRowData {
 
    private static final long serialVersionUID = 1L;
    public static final String id = "id";
    public static final String name = "name";
    private Long m_id;
    private String m_name;
 
    public TableRowData() {
    }
 
    public Long getId() {
      return m_id;
    }
 
    public void setId(Long id) {
      m_id = id;
    }
 
    public String getName() {
      return m_name;
    }
 
    public void setName(String name) {
      m_name = name;
    }
  }
}

private void mapPersonsToFormData(AFormData formData, List<Person> persons) {
  PersonTable table = formData.getPersonTable();
  table.clearRows();
  for (Person person : persons) {
    PersonTableRowData personRow = table.addRow();
    personRow.setId(person.getId());
    personRow.setName(person.getName());
  }
}

private void mapPersonsFromFormData(AFormData formData, List<Person> persons) {
  PersonTable table = formData.getPersonTable();
  for (PersonTableRowData personRow : table.getRows()) {
    switch (personRow.getRowState()) {
      case ITableHolder.STATUS_INSERTED:
        //insert a new person corresponding to the row:
        insertPerson(persons, personRow.getId(), personRow.getName());
        break;
      case ITableHolder.STATUS_DELETED:
        //delete the person corresponding to the row:
        deletePerson(persons, personRow.getId());
        break;
      case ITableHolder.STATUS_UPDATED:
        //modify the person corresponding to the row:
        updatePerson(persons, personRow.getId(), personRow.getName());
        break;
      case ITableHolder.STATUS_NON_CHANGED:
      default:
        //Do nothing
        break;
    }
  }
}