While developing, I came across the need to find all the elements that have a particular method attached to the onAction event. After looking at the repository’s SQL tables, it seems like it would be pretty simple to build a Servoy solution that would create SQL queries designed to return that sort of thing ala Waves In Motion’s Analyzer for FileMaker Pro. Before I spend hours (days, weeks…) making that, has anyone already done it and are you willing to share?
Steve In LA
Hi Steve,
Not that I know of - but we are in the “arguing” phase ( ) on the feature set of just such a product.
As you know the “file format” (SQL database) that holds all the Servoy information is open to all - so IF you can figure it out (IS possible - I tried it once) - then you can do it.
I’m NOT announcing a product or anything - BUT we’re looking into it as well.
Possible, but tricky. It seems that Servoy blocks my access to SQL tables that have been created by a Servoy repository_server. I tried several things, but couldn’t get Servoy to see the tables or even copies of the tables. I can understand, of course, that access to these tables SHOULD be limited. Perhaps using another program (gasp!) to build the analyzing interface will do the trick, since then I could have the analyzer and the Servoy solution open at the same time.
bcusick:
Hi Steve,Not that I know of - but we are in the “arguing” phase (
) on the feature set of just such a product.
As you know the “file format” (SQL database) that holds all the Servoy information is open to all - so IF you can figure it out (IS possible - I tried it once) - then you can do it.
I’m NOT announcing a product or anything - BUT we’re looking into it as well.
Would be great, but are you sure it would suffice to access servoy_repository to obtain useful information a product like Analyzer gives the developer?
I mean: what I need to know is if there are method not used by any button or any other method; if there are unused relations or globals.
Is it possible to get this kind of informations just querying the repository (and analyzing the result, of course)?
Hello,
I have made quite some views that point me for example to calculations and methods content. Such a view is not so hard to do and can be queried (not from inside Servoy, though). What you could do is create a set of views that interest you and then creat tables from those that use different names than the original. I think you will find a way to make those visible in Servoy then.
Patrick