1. Timme Buffington
  2. PowerBuilder
  3. Wednesday, 22 May 2019 13:47 PM UTC

I was looking for a code analysis tool that can be used with PB2017 R3?

Christophe Dufourmantelle Accepted Answer Pending Moderation
  1. Thursday, 23 May 2019 12:17 PM UTC
  2. PowerBuilder
  3. # 1

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

Comment
There are no comments made yet.
René Ullrich Accepted Answer Pending Moderation
  1. Thursday, 23 May 2019 05:32 AM UTC
  2. PowerBuilder
  3. # 2

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

 

Comment
  1. Tobias Roth
  2. Thursday, 23 May 2019 05:57 AM UTC
Hi René,

would it be possible to get some examples for that checks? Thanks

Tobi
  1. Helpful
  1. René Ullrich
  2. Thursday, 23 May 2019 06:02 AM UTC
Hi Tobias,

what do you want to see as an example?
  1. Helpful
There are no comments made yet.
Michael Kramer Accepted Answer Pending Moderation
  1. Wednesday, 22 May 2019 22:46 PM UTC
  2. PowerBuilder
  3. # 3

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

Comment
  1. iliyan iliev
  2. Monday, 16 November 2020 15:42 PM UTC
Michael , plugin is free ?! Can be download ?! Can publish link ?!
  1. Helpful
  1. Michael Kramer
  2. Monday, 16 November 2020 16:38 PM UTC
Hi Iliyan, I heard about this at a user group meeting in Germany in 2019. It was internal work-in-progress at Eventim back then. I suggest you check with the Eventim guys. I assume some of them are active on ELEVATE 2020 which is live right now (and free and virtual so no travel required).
  1. Helpful
  1. Michael Kramer
  2. Monday, 16 November 2020 16:40 PM UTC
Or Iliyan, try ask a new question here on community forum on this specific topic. Probably more notice when new question instead of comment-on-comment on "old" topic. Godspeed.
  1. Helpful
There are no comments made yet.
Olan Knight Accepted Answer Pending Moderation
  1. Wednesday, 22 May 2019 14:08 PM UTC
  2. PowerBuilder
  3. # 4

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

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.