I was looking for a code analysis tool that can be used with PB2017 R3?
I was looking for a code analysis tool that can be used with PB2017 R3?
Actually, code review is one way of leveraging the static analysis of the code.
You can also explore dependencies, generate diagrams or documentation, compare code, analyse code performance, etc. (here is a list for PowerBuilder , Oracle or SQL Server).
Christophe
Hi Timme,
depending what results you are expecting you can also write your own code analyzer with PowerBuilder using Classdefinition object.
I wrote such a simple tool in a few days that can
- check for duplicate objects
- check for objects without a library comment
- check naming convention for objects
- check expected inheritance for objects
- check for script header
- check naming convention for functions and variables
- check for unused local variables
- check datawindow SQL against the database
- check datawindow column datatypes against the database
Hi Timme,
One option is SonarQube (https://www.sonarqube.org).
Monday at German PB user group conference (https://pbugg.de/en/agenda-2019/) Uwe from Eventim showcased using SonarQube for code analysis.
Unfortunately SonarQube doesn't support PowerScript out of the box, However, they have a recent hire fresh of college who wrote a PowerScript grammer as plugin for SonarQube. Voilá! SonarQube supports PowerScript.
HTH /Michael
If you have LOT$ of $$$money$$$ then look at the Novalys product "Visual Expert".
In fact, there's a PowerBuilder TV presentation on this product tomorrow:
http://www.powerbuildertv.com/index.php/en
Olan