Abstract:
A system and method for managing at least one checked out file of a source control management repository are provided. The system includes a source control repository including at least one checked out file; a database including at least one parameter associated with the at least one checked out file; and a computing device for identifying the at least one checked out file, retrieving the at least one parameter associated with the at least one checked out file, and generating a report including the at least one parameter. The report may be presented to a user via a display or formatted as an XML file to be employed in other computing applications, e.g., automated backups.

Description:
BACKGROUND  
       [0001]     1. Field  
         [0002]     The present disclosure relates generally to data processing and computing systems, and more particularly, to a method and system for file management of checked out or open files of a source control management repository.  
         [0003]     2. Description of the Related Art  
         [0004]     The IT world is in a constant state of flux with new technologies, applications and platforms being constantly developed. In this ever-changing environment, application development managers and Chief Information Officers need to eliminate as much risk as possible. Most organizations must manage or support complex multiplatform applications that span the enterprise, including the mainframe server. For example, an online ticketing program for an airline has a web front-end. Its browser-based interface is connected to a back-office application on a UNIX server that also interacts with a DB2 database on the mainframe. While the application has components on several different platforms, it is still considered a single application because it serves a single business purpose—managing airline ticketing processing.  
         [0005]     Additionally, the teams working on these complex, multi-tiered projects may be deployed around the world to take advantage of “follow-the-sun” development. For example, at the end of their day, a team in California hands off its development projects to a team in Japan, who then turns it over to a third team in the UK, and that group turns it over to a team in New York and so on.  
         [0006]     Furthermore, presently a majority of applications have a web front-end—with all the associated HTML pages and web content—to capitalize on Internet-driven business opportunities. Therefore, Change Control Management (CCM) solutions have emerged as essential infrastructure components in the enterprise-wide application development arena.  
         [0007]     Change Control Management software provides life cycle management, source version control and configuration management capabilities. Conventional source control management products are designed to manage code changes as they are checked back into the source control repository. With today&#39;s distributed environments and multiple projects underway, developers have many unfinished projects on their machine&#39;s that are not checked back up in the source control repositories for long periods of time. Every developer and organization is at a great risk for not managing the code that is not included the checked-in file repository.  
         [0008]     Currently, developers have to manually remember the physical location from where the files were checked out and manually backup these files. Then, the developers have to remember the correlation between the physical locations of the file, the software packages it is associated with and the actual backed up location. With a single user involved in a project generally having multiple machines and multiple projects, the problem of keeping track of the checked out files for all the different projects is a very cumbersome and tedious process. This makes it hard to manage multiple files for a single developer and nearly impossible to achieve at an enterprise level.  
         [0009]     Therefore, a need exists for techniques to allow users, developers and administrators to easily and conveniently manage checked out or open files from a source control repository.  
       SUMMARY  
       [0010]     A system and method for managing at least one checked out file of a source control repository are provided. More specifically, a report is generated for each checked out file of a source control repository which allows a change control management (CCM) server to track the checked out file and determine whether the checked out file should be backed up. The report may include the following parameters associated with the checked out file: repository name, project name, state name, package group, package name, physical location of the checked out file, actual repository location of the file, date when the file was checked out, version, and creator.  
         [0011]     In one aspect of the present disclosure, a method for managing at least one checked out file is provided, the method including the steps of identifying the at least one checked out file of a source control repository; retrieving at least one parameter associated with the at least one checked out file, the at least one parameter stored in query database; generating a report including the at least one parameter; and presenting the report to a user.  
         [0012]     In another aspect of the present disclosure, a system for managing at least one checked out file is provided, the system including a source control repository including at least one checked out file; a database including at least one parameter associated with the at least one checked out file; and a computing device for identifying the at least one checked out file, retrieving the at least one parameter associated with the at least one checked out file, and generating a report including the at least one parameter. The report may be presented to a user via a display or formatted as an XML file to be employed in other computing applications, e.g., automated backups.  
         [0013]     In a further aspect of the present disclosure, a set of computer-executable instructions for managing at least one checked out file is provided, the computer-executable instructions include the steps of identifying the at least one checked out file of a source control repository; retrieving at least one parameter associated with the at least one checked out file, the at least one parameter stored in query database; generating a report including the at least one parameter; and presenting the report to a user. 
     
    
     BRIEF DESCRIPTION OF THE DRAWINGS  
       [0014]     The above and other aspects, features, and advantages of the present disclosure will become more apparent in light of the following detailed description when taken in conjunction with the accompanying drawings in which:  
         [0015]      FIG. 1  is a block diagram of an exemplary system for managing checked-out files of a source control management repository in accordance with an embodiment of the present disclosure;  
         [0016]      FIG. 2  is an exemplary enterprise computing system;  
         [0017]      FIGS. 3A  and B are flowcharts for illustrating a method for file management in accordance with an embodiment of the present disclosure; and  
         [0018]     FIGS.  4 A-C are flowcharts for illustrating a method for file management across an enterprise computing system. 
     
    
     DETAILED DESCRIPTION  
       [0019]     Preferred embodiments of the present disclosure will be described hereinbelow with reference to the accompanying drawings. In the following description, well-known functions or constructions are not described in detail to avoid obscuring the present disclosure in unnecessary detail.  
         [0020]     A system and method for file management of a source control management repository are provided. The system and method of the present disclosure provide a user with all the information required to keep track of checked out or open files in a source control repository of a Life Cycle Management (LCM) system, e.g., AllFusion™ commercially available from Computer Associates International, Inc. of Islandia, N.Y. The system and method will generate a report, e.g., a “Checked out item” report, and it may contain the following information: 
        i. Group Name     ii. User Name     iii. Broker Name     iv. Repository Name     v. Project Name     vi. State Name     vii. Package group     viii. Package Name     ix. Physical location of the checked out file (\\MachineName\Fully Qualified Path)     x. Actual repository location of the file in the LCM (View Path)     xi. Date when the file was checked out     xii. Other Misc information (branched files, versions, Status (Released or not), Creator, Created on, Modifier, Modified on).        
 
         [0033]     The organization of the report provides valuable information, since it compiles identification and location data concerning a file from a plurality of sources. Each field of the report will now be described. “Group Name” field contains information about one or more user groups to which a user belongs. “User Name” field is used to store a user name of a person who is currently working with the checked out file, e.g., Harvest user name. “Broker Name” contains the name of the broker, i.e., the location of the repository. “Repository Name” includes the name of the repository for which the report was generated. “Project Name” contains the name of the project which contains open files. “State Name” stores the State where the project is located. “Package group” contains the name of the package group, e.g., a collection of files. “Physical location of the checked out file” describes the fully qualified path for the location from which the file is checked out. The physical location is specified by the user when a check out for update process is run. “Actual repository location of the file in the LCM (View Path)” is the absolute repository path. Date when the file was checked out corresponds to the time stamp when the check out for update process for performed. One skilled in the art will understand that these parameters may contain information other than described above. In addition, the report may contain any number of the parameters discussed above as well as additional parameters which help to identify the file required to be backed up. Other information may include, but is not limited to, branched files, versions, status (e.g., whether released or not), creator, time of the creation, modifier, time of the modification, etc.  
         [0034]     Based on the report generated, the system and method will have the ability to create an external XML report file with all the information. This report will then be fed to external applications like backup agents, external agents or workflow applications. An exemplary system employing the generated report of the present disclosure is described in concurrently filed co-pending U.S. Patent Application, entitled “SYSTEM AND METHOD FOR BACKING UP OPEN FILES OF A SOURCE CONTROL MANAGEMENT REPOSITORY” (Attorney Docket No. 20000390), under Express Mail Certificate No. EV 464570669 US the contents of which are hereby incorporated by reference in its entirety. Furthermore, the system and method has the ability to create a diff file, e.g., a differential file, for all the checked out files.  
         [0035]     The system will implement a User Interface (UI) or a command line utility to allow the user to customize the format of the report and add new fields at run time. The UI may also give the user the ability to query the report by the main fields (e.g., group, user name, repository name, project name, state name, package name, the client location or the client machine name, repository location of the file check out date and the server name).  
         [0036]     The method of the present disclosure is implemented in a server process that can be queried to retrieve this report. Storage of this report will be in an encrypted form by the server. Once the report is created, the server process will keep track of the information and determine whether the information in the report is out of date, and if so, automatically update the information. Updating the report can be done on per user or per project basis. The process can be run by the server when it is idle or at a certain predetermined time or when a dynamic request is received.  
         [0037]     It is to be understood that the present invention may be implemented in various forms of hardware, software, firmware, special purpose processors, or a combination thereof. In one embodiment, the present disclosure may be implemented in software as an application program tangibly embodied on a program storage device. The application program may be uploaded to, and executed by, a machine  100  comprising any suitable architecture such as a personal computer, a workstation or server. Referring to  FIG. 1 , preferably, the machine  100  is implemented on a computer platform having hardware such as one or more central processing units (CPU)  102 , a random access memory (RAM)  104 , a read only memory (ROM)  106  and input/output (I/O) interface(s) such as a keyboard  108 , cursor control device  110  (e.g., a mouse or joystick) and display device  112 . A system bus  115  couples the various components and may be any of several types of bus structures including a memory bus or memory controller, a peripheral bus, and a local bus using any of a variety of bus architectures. The computer platform also includes an operating system and micro instruction code. The various processes and functions described herein may either be part of the micro instruction code or part of the application program (or a combination thereof) which is executed via the operating system. In addition, various other peripheral devices may be connected to the computer platform by various interfaces and bus structures, such as a parallel port, serial port or universal serial bus (USB), for example, additional storage devices and a printer.  
         [0038]     It is to be further understood that because some of the constituent system components and method steps depicted in the accompanying figures may be implemented in software, the actual connections between the system components (or the process steps) may differ depending upon the manner in which the present disclosure is programmed. Given the teachings of the present disclosure provided herein, one of ordinary skill in the related art will be able to contemplate these and similar implementations or configurations of the present disclosure. The authentication method of the present disclosure may be used at several levels, including operating system, application, or application components.  
         [0039]     The computer  100  may operate in a networked environment using logical connections to one or more remote computers as shown in  FIG. 2 . The remote computer may be a personal computer  202 , a server  204 , a router  206 , a mainframe  208 , a network PC, a peer device or other common network node, and typically includes many or all of the elements described above relative to the computer  100 . It is to be appreciated that the network  210  may be a local area network (LAN), wide area network (WAN), the Internet or any known network that couples a plurality of computers to enable various modes of communication via network messages. For example, the network environment may be a corporate intranet including a single server and multiple personal computers housed within a single facility, or alternatively, multiple servers with multiple personal computers located in various geographic locations.  
         [0040]     Since all the information of the above-described report is currently available in the change management product, a method of the present disclosure will extract all the above mentioned information from its physical data storage, e.g., the source control repository. The method of retrieving the information and generating the report will now be described in relation to  FIGS. 3 and 4 . This report will be available at three levels: 
        1. User based     2. Project based from an administrator tool     3. Enterprise level 
 
 1. User Based 
       
 
         [0044]     The user based report will contain information pertaining to a single logged in user. This functionality may be invoked from a button on a toolbar or a menu item in the change control management (CCM) software client. Preferably, this functionality will be available from the client software. This report will contain all the checked out file details for a single user. The user interface will allow the user to configure the report and search by specifying the following parameters or variables: Repository Name, Project Name, State Name, Package group, Package Name, Physical location of the checked out file (\\MachineName\Fully Qualified Path), Actual repository location of the file in the LCM (View Path), Date when the file was checked out, Other Misc information (branched files, versions, Status (Released or not), Creator, Created on, Modifier, Modified on). In a Windows™ based system, the information will be presented in a grid, which will allow a user to sort the results, rearrange the column and search for key attributes, e.g., file names.  
         [0045]     Referring to FIGS.  3 A-B, the method is initiated when a user requests the checked-file report (step  302 ). The method then determines if certain parameters are specified, e.g., server, user name and password (step  304 ). If the parameters are not specified, the method will prompt the user for user name, password and server name (step  306 ). Once the parameters are specified, the method will attempt to log on the user to the server by verifying the user&#39;s credentials (step  308 ). If access is denied, the method will exit the program with an error message, e.g., “Please recheck the user name, password, server name and try again” (step  310 ) and the process will end.  
         [0046]     If access is granted, at step  308 , the method will formulate a query to derive the proper information for the report. The program will determine if the utility was invoked in default/prompt mode (step  312 ). If yes, the program will set the values for all parameters to ALL (Repository Name, Project Name, State Name, Group Name, Package Name, User Name) (step  314 ). Otherwise, the program will form a query with specified parameters (Repository Name, Project Name, State Name, Group Name, Package Name, User Name) (step  316 ). Once the parameters are specified, the program will query database tables or data storage to retrieve the proper information (step  318 ).  
         [0047]     Next, the program will determine if the request was from the UI or a command line utility (step  320 ). If the request was from the UI, the data is returned to data structures (step  322 ) and the data is formatted, a grid is generated and the data is displayed in the gird (step  324 ).  
         [0048]     If the request was not generated by the UI, the report will be generated in XML format (step  326 ). The report will then be published at the user-specified location (step  328 ).  
         [0000]     2. Administrator Based  
         [0049]     At an administrator&#39;s level, the report generated will be available from the CCM server. The CCM Administrator will be able to find out the checked out file information for the entire repository not just for a single user. This report will provide complete information as to where exactly the checked out source code items for the all the repository on a particular server are which is critical if an organization is going through a merger or an organization change. This report will enable users to quickly resume work on older projects and help administrators quickly locate user-specific changes. This is especially helpful with broken builds where the developer is unavailable and it is essential to obtain access to the file in order to fix it. This feature allows the administrator to obtain the latest version of the file without manually determining if there is another more recent version of the file available.  
         [0000]     3. Enterprise Based  
         [0050]     On an enterprise level, the report generated consolidates information from many multiple CCM products, brokers and servers. The report will have the ability to segregate the required information from disparate change control management products, servers and brokers.  
         [0051]     The enterprise approach will interact with multiple Change Control Management (CCM) products. The method of the present disclosure will query both distributed environments employing servers and clients (e.g., via Computer Associates Harvest™) and mainframe environments (e.g., via Computer Associates Endevor™) to retrieve the reports for all the projects. Then, these reports will be combined by the program to provide an enterprise checkout change management (CM) report. As above, the report will be generated depending upon the logged in user&#39;s credentials. A user might be able to generate the report only for the projects for which he/she has access. The administrator will be able to view this report for all the projects across different source code repositories.  
         [0052]     In a large organization, multiple LCM (Life Cycle Management) servers can be used for change management (CM). In this case one CM server will be designated as the master CM server. This server will register all the CM servers in an organization. The master server will then query all the registered servers for the checked out file report and then the master server will consolidate this report for a global CM checked out file report.  
         [0053]     Referring to FIGS.  4 A-C, a method for generating a checked out file report will be described. Initially, a user inputs parameters specifying the desired data (step  402 ), e.g., users, projects, servers, mainframes, etc. The application program then parses the input to generate a query with specified parameters for the distributed environment (e.g., Allfusion Harvest™ server) and for the mainframe environment (e.g., Endevor™ Mainframe CM) (step  404 ). Initially, the program determines if the query for the distributed environment is empty (step  406 ). If parameters exist for the distributed environment, the data is retrieved using a command line HCO command or the program forms a query and calls a JDBC (Java Database Connectivity) API (Application Program Interface) for a direct read access to the CCM tables (step  408 ). The data received is then cached (step  410 ).  
         [0054]     Next, the program generates a query for the mainframe environment. The program determines if the query for the mainframe environment is empty, and if so, passes onto step  420 . Otherwise, if the query has specified parameters, the program formulates an API call for the mainframe CCM software (step  414 ), makes a call through CCI to the mainframe CCM API Server (step  416 ) and caches the data received (step  418 ).  
         [0055]     Once all the data has been retrieved, the program determines if the request for the report was generated from the UI (step  420 ). If yes, the program returns the data to data structures (step  422 ) and formats the data, generates a grid and displays the data in the grid (step  424 ). If the request did not come from the UI, the program generates the report in XML format (step  426 ) and publishes/copies the report at the user specified location (step  428 ).  
         [0056]     The change management server will provide an ability to publish the checked out item report in a variety of formats, e.g., CSV and XML. This report can then be transmitted to an external application like backup agents or workflow applications. This feature enables variety of key functionalities like integration of this report with a workflow or a backup agent.  
         [0057]     A new command line server utility capable of running on all the major platforms is implemented to create the report in addition to requesting the report from the UI. This command line utility will return the link to the actual location of the generated report. The key parameters to this utility are authentication, which is accomplished by retrieving the following information: login Information, including user name, password; and query parameters, including group name, user name for which the information is to be retrieved, repository name, project name, state name, package group, and package name. This may be accomplished by inputting specific commands. For instance, in the Harvest™ CM the following command line utility syntax may be used: hcf [-usr username] [-pw password] [-f full filename for checked out file report] [-b name] [-r repository name] [-p project name] [-s state name] [-g group name] [-n package name] [-u user name] [-prompt] [-o filename] [-h] [?] with each of the parameters described below in Table 1:  
                           TABLE 1                                       -usr   User Name           -pw   Password           -f   Fully qualified path and filename for the report           -b   Specifies the Harvest broker Name from which               the report is to be generated           -r   Specifies the repository name for which the               report is to be generated           -p   Specifies a particular project name for which the               report is to be generated           -s   Specifies the Harvest ™ state Name from which               the report is to be generated           -g   Specifies the group name, the report will be               generated for all the users in this group           -n   Specifies a particular package name for which               the report will be generated           -u   Specifies a particular user name from which the               report is to be generated           -prompt   Prompts you for user name and password           -o filename   Specifies a file name to retrieves the output log.               Both output and errors are directed to this file           -h or ?   Displays brief command usage           -no parameters   Displays brief command usage           -Default   Prompt for user name and password. Then               generate the report for all the projects and               repositories this user has access to.                      
 
         [0058]     The report is generated only if the supplied user name and password has the required privileges for accessing the data; if the credentials do not have sufficient privileges then this command returns with an error message.  
         [0059]     The generation of this report at the enterprise level can be resource intensive. Therefore, in such circumstance, initially, the existing database schema is evaluated to determine what time stamping mechanism is in place. This allows the server or broker based report to be generated and, if a new request for the report retrieval is received, then the server will be able to quickly determine what sections of the report needs to be regenerated. The time stamp of the report will be used by the server to determine which sections of the report are outdated. An SQL query can be run on the database tables to quickly determine what new changes has been made since the report was generated. For new requests, the server can selectively update the sections of the report.  
         [0060]     While the disclosure has been shown and described with reference to certain preferred embodiments thereof, it will be understood by those skilled in the art that various changes in form and detail may be made therein without departing from the spirit and scope of the disclosure as defined by the appended claims.