HyperSQL

HyperSQL is like a doxygen for SQL, hypermapping SQL views, procedures, packages and functions to HTML source code listings and showing all code locations where these are used. The internal "where used" functionality also scans C++ and Java source files.

Features:

• flexible configuration by use of .ini files
• generates nicely formatted HTML files, CSS adjustable by use of .css files
• parses SQL, C++ and Java files according to file extensions you configured
• generates hyperlinked listings of all objects found (SQL views, packages, functions, procedures, etc.)
• hyperlinks object names to their appearance in the source code
• generates "where used" lists, to show where your objects have been used by other objects (if they have) - helps you to find unused code if not, or example usages if found
• support for Javadoc style comments

What is new in this release:

• Fixed Javadoc Parser (case-sensitivity issue)
• Unittests: Added presql ("setup") and postsql ("teardown") to testcases
• Unittests: Added basetype (to specify the basic type, e.g. VARCHAR, for some parameter originally defined like e.g. TABLE.COL%TYPE, to JUnit)
• Unittests: Added check_sql to evaluate a "void" procedure
• Object Type "TYPE" supported now (JavaDoc: @type)
• fixes to make it work with Windows

What is new in version 3.8.5:

• code reorg for better maintenance and re-usability
• HTML files now get more "static" names so one can link to them directly (same for "anchors" in those files)
• prepared code for Python v3 compatibility

What is new in version 3.8.0:

• fixed line numbers in code links
• rewrote JavaDoc parser using RegExps - now all tags should be able to span multiple lines
• added support for automated log rotation
• added feature to capture non-handled Python warnings and make them obey the configured log level. This is disabled by default and only works with Python 2.7 and above

What is new in version 3.7.5:

• adding size details to forms pages
• new javadoc tag @testcase to define unit-tests
• added unit test XML export
• added demo script to create PL/SQL unit tests from the XML exports

What is new in version 3.7.0:

• Todos/Bugs are now also collected from forms
• new keyword verification.stats_javadoc_forms (0/1) lets you include forms todo/bug count within the javadoc stats on the code stats page
• javadoc verification is now available for Oracle Forms program units as well (partially - no parameter validation yet). To enable, set the new keyword verification.verify_forms to 1 (it is disabled by default)
• missing @return made verification crash
• source code links for forms themselves where routed to line 0, which does not exist
• file_size_limit for forms now is bound to the PL/SQL code size instead of file size, as this is the "included source code"
• javadoc evaluator crashed the script when an object was defined without name being specified
• fixed a typo causing the script to crash on stand-alone functions
• trailing brackets on object names (e.g. "CREATE TABLE dummy(") caused crashes on where_used scan
• form files have been accidentally included in file size and lines stats

What is new in version 3.6.0:

• reorganized core libraries. Some have been outsourced to a separate package iz_tools, as they contain quite generic stuff only
• bunch of keywords and types added for syntax highlighting (requires cleaning the code cache to have effect for unchanged files if using the cache)
• some improvements concerning the processing Oracle Forms
• links on form details page fixed up
• links on form details page fixed up
• lists on full-form-index were messed up
• more details on forms: package functions/procedures are now listed - provided they have javadoc information attached

What is new in version 3.5.5:

• added support for stand-alone functions and procedures
• added full form listing (analogue to the full package listing with funcs etc.)
• more details for Oracle Forms included in output
• new config keyword include_source_limit: Limit inclusion of source code by file size (default: '0' = unlimited, emulating behavior of previous versions)

What is new in version 3.5.0:

• Added basic support for Oracle Forms (including Javadoc @form tag)
• Files removed from their locations in the source tree now also get automatically removed from cache

What is new in version 3.4.0:

• added support for triggers (incl. Javadoc tag @trigger)
• COMMENT ON ignores for where_used completed (now also ignoring e.g. MViews)
• some more code cleanup and optimization (scanning source for objects)
• ! missing desc for function/procedure parameters was always marked in verification, regardless whether 'desc' should have been checked (mandatory_tags where ignored)
• columns (@col) are now also checked against mandatory_tags (desc)

Requirements:

• Python