ucGetUFIColumnDope

Purpose

Applies To

User Account Display

Signature

    public ArrayList ucGetUFIColumnDope( 
                Connection dbconn, 
                SesameSession session )

Notes

Example

 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;
    }