* @throws DatabaseException
* if a database error occurs
*/
- public Group createGroup(String name) throws DatabaseException {
+ public Group createGroup(String name, String shortName) throws DatabaseException {
Query query = new Query(Type.INSERT, "GROUPS");
String id = UUID.randomUUID().toString();
query.addValueField(new ValueField("ID", new StringParameter(id)));
query.addValueField(new ValueField("NAME", new StringParameter(name)));
+ query.addValueField(new ValueField("SHORT_NAME", new StringParameter(shortName)));
database.insert(query);
return getGroupById(id);
}
public void saveGroup(Group group) throws DatabaseException {
Query query = new Query(Type.UPDATE, "GROUPS");
query.addValueField(new ValueField("NAME", new StringParameter(group.getName())));
+ query.addValueField(new ValueField("SHORT_NAME", new StringParameter(group.getShortName())));
query.addWhereClause(new ValueFieldWhereClause(new ValueField("ID", new StringParameter(group.getId()))));
database.update(query);
/* save properties. */
*/
@Override
public Group createObject(ResultSet resultSet) throws SQLException {
- return new LazyGroup(resultSet.getString("GROUPS.ID")).setName(resultSet.getString("GROUPS.NAME"));
+ return new LazyGroup(resultSet.getString("GROUPS.ID")).setName(resultSet.getString("GROUPS.NAME")).setShortName(resultSet.getString("GROUPS.SHORT_NAME"));
}
}