User Account Display
public ArrayList ucGetUFIColumnDope(
Connection dbconn,
SesameSession session )
public ArrayList ucGetUFIColumnDope(
Connection dbconn,
SesameSession session ) throws Exception {
ArrayList vodafoneDope = new ArrayList();
//build an arrayList of UFIColumnDope objects - one for each table
//USER_GROUP_USER table
UFIColumnDope ucd = new UFIColumnDope();
ucd.setTableName("USER_GROUP_USER");
ucd.setIsRepeating(true);
ucd.setIsEnumerated(true);
ucd.setColumnName("USER_GROUP_ID");
ucd.setColumnTitle("User Group ID");
ucd.setColumnLength(getFieldLength("USER_GROUP_ID",
"USER_GROUP_USER",
dbconn));
//build the Enumerated list
ValidationList userGroupList = UserGroup.getUserGroupsForImport(dbconn);
ucd.setValuesTitles(userGroupList);
vodafoneDope.add(ucd);
//UC_USER_AREA_ROLE table
ucd = new UFIColumnDope();
ucd.setTableName("UC_USER_AREA_ROLE");
ucd.setIsRepeating(true);
ucd.setIsEnumerated(true);
// security_group_id column
ucd.setColumnName("UC_USER_AREA_ROLE.SECURITY_GROUP_ID");
ucd.setColumnTitle("User Area Role - Role Id");
ucd.setColumnLength(getFieldLength("SECURITY_GROUP_ID",
"UC_USER_AREA_ROLE",
dbconn));
vodafoneDope.add(ucd);
//build the Enumerated list
ValidationList roleVL = SecurityGroup.getSecurityGroups(dbconn,
session.getUserId());
ucd.setValuesTitles(roleVL);
// area_id column
ucd = new UFIColumnDope();
ucd.setTableName("UC_USER_AREA_ROLE");
ucd.setIsRepeating(true);
ucd.setIsEnumerated(true);
ucd.setColumnName("UC_USER_AREA_ROLE.AREA_ID");
ucd.setColumnTitle("User Area Role - Area Id");
ucd.setColumnLength(getFieldLength("AREA_ID",
"UC_USER_AREA_ROLE",
dbconn));
vodafoneDope.add(ucd);
//build the Enumerated list
ValidationList areaVL = DataDictionary.executePrimarySql(dbconn, "AREA");
ucd.setValuesTitles(areaVL);
return vodafoneDope;
}