Task: Delete a Project with a Windows Batch (.bat) File

• Permissions Required
• Other Requirements
• The Deletion Batch File
• Using the Batch File
• Modifying the Batch File
• Writing Other Batch Files
• Links

Permissions Required

The file requires that special user Anonymous has the following permissions for the project P and its analyses.

• ANALYSIS_DELETE a for all analyses a of P.
• PROJECT_DELETE P

If you will be extending the script to derive the project ID from an analysis directory for some analysis A of the project, you will also need the following permissions for A.

• ANALYSIS_READ A

See Modifying the Batch File for information on modifying the file to specify credentials for a non-Anonymous user with the required permissions.

Other Requirements

Use the cURL shipped with CodeSonar: $CSONAR/third-party/curl/inst/bin/curl, where $CSONAR is the CodeSonar installation directory. Either:

• add $CSONAR/third-party/curl/inst/bin/ to the front of your PATH,
  or
• edit the file so that the setting of CURL_CMD specifies the full path to $CSONAR/third-party/curl/inst/bin/curl.

The Deletion Batch File

The following file will delete

• the project whose project ID matches the second argument passed to the file,
• on the hub specified in the first argument to the file.

rem @ECHO off
set HUB=%1
set PROJECT_ID=%2

set CURL_CMD=curl -L --cookie-jar cookies.txt

(%CURL_CMD% -d remove_project_id=%PROJECT_ID% %HUB%)
exit /b

This batch file uses an HTTP POST request to perform the deletion: the POST request is for the hub Home page and must specify remove_project_id=pid, where pid is the project ID of the project to be deleted. It outputs the HTML landing page that reports successful deletion.

The hub functionality for deleting an analysis entails several HTTP redirects across a single session. When you are using an anonymous session, as here, it must be tracked using cookies. The script uses cURL options to ensure that the redirects and cookies are properly accounted for:

• -L instructs cURL to follow redirects.
• --cookie-jar cookies.txt instructs cURL to use local file cookies.txt to manage any cookies involved in completing the command.
  File cookies.txt will be created in your working directory, if it does not already exist.

Inspect the HTML source for a Project page to see the remove_project_form element and how its attributes and sub-elements correspond to the HTTP POST request constructed by the script.

Using the Batch File

To use this file with your hub, do the following.

1. Copy delete_project.bat to a suitable directory. The remainder of these instructions will refer to this directory as rundir.

   Make sure you have full file permissions in rundir, and that using file rundir/cookies.txt to manage cookies for this task will not cause conflicts with other uses of rundir. If there is a problem, either:

   • select a different rundir, or
   • edit the file to specify a different file name with --cookie-jar.
2. Run the file:
   cd rundir
   delete_project protocol://host:port pid
   where

   protocol	is the protocol for your hub: http or https.
   host:port	is the location of your hub.
   pid	is the project ID for the project whose name you wish to change. You can find the project ID: in the GUI Project page URL, which will be of the form http://hub_location/project/project_id.html, or by deriving it based on the analysis ID from the most recent analysis of the project, which in turn is available: in the URL specified at the end build/analysis command output, which will be of the form http://hub_location/analysis/analysis_id.html, or by running the following command, where path\to\projname.prj_files\ is the analysis directory codesonar analysis_id.py path\to\projname.prj_files\ or in file path\to\projname.prj_files\aid.txt, where path\to\projname.prj_files\ is the analysis directory. For details, see Derive the project ID from the analysis directory, below.

   The file will output information about its progress.
3. Attempt to open the project page protocol://host:port/project/pid.html in your web browser to confirm that the project is no longer available.

Invocation Example

Using the hub at http://[::1]:7341, delete the project with ID 3:

Troubleshooting

set CURL_CMD=curl -v -L --cookie-jar cookies.txt

set CURL_CMD=curl -k -L --cookie-jar cookies.txt

Modifying the Batch File

You may wish to make one or more of the following modifications.

• Stop printing the resulting HTML file to output
• Derive the project ID from the analysis directory
• Provide credentials for a non-Anonymous user

Stop printing the resulting HTML file to output

If you don't want to see the final HTML file notifying you of successful deletion as part of your script's output, you can redirect it to the null location by modifying your curl command. Note that if you make further changes that you need to debug later, you may wish to lift this suppression at least temporarily.

1. Edit delete_project.bat so that curl is invoked with the -o flag and a suitable value.

   set CURL_CMD=curl -o nul -L --cookie-jar cookies.txt

Derive the project ID from the analysis directory

Instead of specifying the project ID on the command line, you can change the file to read the analysis directory from the command line and derive the project ID by reading the most recent analysis ID from the analysis directory, requesting the corresponding Analysis page from the hub, then reading the project ID from the Analysis page.

Because this approach requires the Analysis page for the analysis A in question, you must have the following permissions for A in addition to the required project permissions.

• ANALYSIS_READ A

Once you have verified that you have these permissions, proceed as follows.

1. Edit delete_project.bat so that the line setting ANALYSIS_ID is replaced with three lines:

   set ANALYSIS_DIR=%2
   set CSONAR=codesonar.exe
   for /F "tokens=*" %%g in ('%CSONAR% analysis_id.py %ANALYSIS_DIR%') do (set ANALYSIS_ID=%%g)
   

   If it is not in your PATH, adjust the setting of CSONAR to include the full path to your codesonar.exe executable.
2. Delete the line setting PROJECT_HTML_URL and replace it with the following line setting ANALYSIS_HTML_URL.

   ANALYSIS_HTML_URL='{0}/analysis/{1}.html'.format(HUB,ANALYSIS_ID)

3. Insert the following code at the end of the batch file (after the existing exit /b line). This new function downloads a page using the URL in its first argument, searches the page for the first occurrence of a partial Project page URL, then extracts the ID from the URL and returns it through the second argument.

   :pid_from_analysis_page
   set URL=%1
   
   :: get the LINE containing this link
   set LINE=
   FOR /F "delims=" %%i IN ('%CURL_CMD% %URL% ^| findstr -r  /c:"<a href=\"/project\/[0-9]*.html\"" 2^>nul') DO set LINE=%%i
   
   :: If there's no such line, report an error.
   if "%LINE%" == "" (
      echo Project ID not found.
      echo This probably means you do not have ANALYSIS_READ permission
      echo for the analysis and so cannot access %ANALYSIS_HTML_URL%.
      exit /b
   )
   
   :: Remove problematic special characters from LINE, then
   :: find the SUBLINE that occurs between '/project/' and the next '/'
   set "LINE=%LINE: =%"
   set "LINE=%LINE:"=%"
   set SUBLINE=""
   set /A PRJ_SEEN=0
   set /A COUNTER=0
   
   :LOOPBEGIN
   set /A COUNTER+=1
   FOR /F  "delims=/ tokens=%COUNTER%" %%A IN ("%LINE%") DO (
       if %PRJ_SEEN%==1 (
           set SUBLINE=%%A
           goto :LOOPEND)
       if "%%A"=="project" set /A PRJ_SEEN=1
       goto :LOOPBEGIN)
   :LOOPEND
   
   :: Set the out parameter to the first token when SUBLINE is split by '.'
   FOR /F "delims=. tokens=1"  %%i IN ("%SUBLINE%") DO (set PID=%%i)
   
   call set %~2=%PID%
   
   exit /b 

4. Insert the following code after the line setting CURL_CMD. This calls the new pid_from_analysis_page function to derive the required Project ID and return it as the value of PROJECT_ID. If no ID has been found, the batch file exits.

   (call:pid_from_analysis_page %ANALYSIS_HTML_URL% PROJECT_ID)
   if %PROJECT_ID% == "" exit /b 

5. When you invoke the script, specify the analysis directory as the second argument.

   For example: using the hub at http://[::1]:7341, delete the analysis whose analysis directory is C:\myprojects\projectX.prj_files\.

   delete_project http://[::1]:7341 C:\myprojects\projectX.prj_files\

Provide credentials for a non-Anonymous user

If your hub is configured so that special user Anonymous does not have the required permissions, you will need to edit the file to submit credentials for a suitable hub user account.

See CodeSonar HTTP API: Authentication for more information on authentication strategies.

Links

• Typical CodeSonar Tasks
• HTTP API Documentation
• The CodeSonar Hub
• CodeSonar GUI Reference