// populate (could optionally have reflective populate) public synchronized void populate(SQLRow row) { row.setValue("source", food.getSource().getName()); row.setValue("food", food.getSourceID()); if (date != 0) { row.setValue("time", new Timestamp(date)); } row.setValue("grams", new Double(grams)); if (measure != Measure.GRAM) { row.setValue("measure", measure.getDescription()); } }
// generate the table mapping, could use xml def public synchronized SQLRow toSQLRow() { SQLRow row = new SQLRow("serving"); row.addColumn("source", Types.VARCHAR); row.addColumn("food", Types.VARCHAR); row.addColumn("time", Types.TIMESTAMP); row.addColumn("grams", Types.DOUBLE); row.addColumn("measure", Types.VARCHAR); return row; }