Fix and enhance python script that compares run times of two programs

Summary:

The python script/utility is for Linux operating system. This is a time checking python script which is divided into 2 python scripts. The first python script ([login to view URL]) is the script that compares the run time and check-in times of two different programs. This script contains 421 lines which includes several comments and empty lines. The second python script ([login to view URL]) pops up a GUI with pre-populated fields. Users can change the values of the fields on GUI and click OK. This script contains 178 lines which includes empty lines and comments. This script runs the first script to perform the time comparison and creates output report in a *.csv file. Then it converts .csv file into .xlsx file. And then it opens the .xlsx file using LibreOffice.

What Needs to be fixed:

This utility used to work 100% when it was created 2 years ago. It has been updated a couple of times. Now it needs three fixes.

Milestone 1 - Fixing Code:

Fix 1: By default the utility creates intermediate and output files in the run directory (project directory). But the project directory can be readOnly. It should be fixed to create all the files in user's home directory (~/).

Fix 2: This utility used to work hierarchically. Now it works only one level. Needs to be fixed so that it can work hierarchically.

Fix 3: This utility creates a *.csv file (output report file) but doesn't convert it to *.xlsx file which used to work before. Fix needs to me made so that it converts *.csv file to *.xlsx file.

Milestone 2 - Enhancement:

Enhancement 1: The existing utility is made to work with Cadence Assura so it uses Cadence Assura DRC or LVS file as input. The python code needs to be enhanced so that it can work with Mentor Calibre as well. That means it can take Mentor Calibre DRC or LVS log file as input. The syntax of the log files of the 2 different software tools (Assura and Calibre) are different.

Note:

- IC Manage is a Version Control software.

- Cadence Assura is a design verification software

- Mentor Calibre is another design verification software.

What I will provide:

- The python scripts ([login to view URL] & [login to view URL])

- Sample Assura DRC log file

- Sample Assura LVS log file

- Sample intermediate *.tree file

- Sample *.csv output file

- sample Calibre DRC and LVS log files (for Milestone 2 - after milestone 1 is complete)

Details:

1. User runs [login to view URL] from Linux terminal in a project directory (/proj/proj1/physical). This directory can be readOnly. Running this python script pops up a GUI.

2. When user clicks OK on the GUI, it runs [login to view URL] script.

3. It runs fastTree to create *.tree file with hierarchy.

4. Checks the run time of Cadence Assura DRC or LVS by looking at the run log file provided as an input.

5. Gets the names of all the cells in the *.tree file and then finds the check-in time of all these cells by looking at the IC Manage depo (repository).

6. Compares the run time of Assura DRC or LVS (whichever is used as input) with the IC Manage check-in times of all the cells in the hierarchy.

7. If the check-in times of all the cells were before run time of DRC or LVS then it reports that there are no potential problems.

8. If check-in time of any cell was after the DRC or LVS was run then it reports the number of potential problems.

9. The python utility creates *.csv file with check-in times of all the cells and run time of DRC or LVS and describes a potential problem whenever it finds that a cell was checked-in after the DRC or LVS was run.

10. Converts *.csv file to *.xlsx file

11. Opens *.xlsx final report.

Python Linux

Project ID: #26302907

About the project