Status for Andrew DeFaria

• Checked in recent changes to GPDB and its associated scripts

• gpdb_add_project:
• Added interrupt handling
• Moved logic that determines what site a machine is in from here to gpdb.pm
• Fixed but in checking "no such map" from NIS
• gpdb_add_vob:
• Added function prototypes
• Changed to put together list of vobs from all regions
• Added getting of Vob Family UUID and Vob UUID
• Now using gpdb_currentSite
• gpdb_convertuk:
  • Added function prototypes
• gpdb.pm:
• Reorganized export list
• Added gpdb_mklink_user_to_site, gpdb_mklink_user_to_project, gpdb_unlink_user_from_project, gpdb_unlink_user_from_site
• Implement gpdb_siteForHostname. This routine returns the site name for the passed in hostname (default localhost)
• Implemented gpdb_getuserByID
• Changed handling of retunred %ccdefaults
• Changed gpdb_getProject to properly return the retired flag
• Change gpdb_putProject to call gpdb_mklink_user_to_project
• Renamed siteName and projectName to gpdb_siteName and gpdb_projectName respctively
• Implemented gpdb_siteAdmins. This returns an array of AXIDs who are site admins
• tables.sql:
• Added family_uuid and vob_uuid

Posted by at 10:30 AM | Permalink

• Changed gpdb_add_vob.pl to use Rexec.pm in order that it may be able to collect information about vobs from other sites

gpdb_add_vob.pl and other sites

It was hoped that we cout point things to "login servers" instead of machines specifically designated as DesignSync servers as had been the case for gpdb_add_project.pl. These script really only require cleartool and access, through the automount map, to the sync_custom area in order to pick up the SiteRegistry.reg file.

However gpdb_add_vob.pl uses a heuristic in an attempt to determine what project a particular vob is associated with. The heuristic states that the vob storage path will have as part of it's path, a project directory. While this is often, but not always, the case here in Dallas, it is not the case at all in Nice! Thus, even though gpdb_add_vob.pl can log into remote sites to gather information about vobs, when logging into Nice it finds that no vob in Nice adheres to this convention and thus it cannot add vob records for any vob in Nice. Nice had been using vob attributes for things like the AID of the owner of the vob but there is no attribute for the project that a vob is associated with!

Posted by at 8:27 AM | Permalink

• Changed gpdb_getProjectsAtSite to be able to separately return all Clearcase projects, Designsync projects, Clearcase & Designsync projects, projects without Clearcase or Designsync associated with them
• Modified gpdb_add_vob.pl to traverse through all regions of current registry server to collect all vob tags
• Modified clearcase record to include fields for VOB Family uuid and VOB uuid. Also modified gpdb_add_vob.pl to get these uuids
• Investigated Victor's CC Metrics database
• Fixed bug in gpdb_add_vob.pl that was adding clearcase records assigned to the wrong site.

Posted by at 11:20 AM | Permalink

• Changed gpdb_convertuk.pl to properly add mapping records for Site Admins
• Changed Single Site Display to display Site Admins
• Change Single Site Display to include all information from Excel design spreadsheet from Bill. Also tightened up display of cc_defaults
• Added new gpdb_siteForHostname that returns the site for a given hostname. Default is current host. Uses nslookup to retrieve the CNAME for the host

Posted by at 11:27 AM | Permalink