Short before Christmas André and I released version 0.5.0 of our PL/SQL table API generator. It took a long time to come to this point. One of the reasons behind was the fact that we had to rework some internals to support feature wishes from the community. Here the most important features of the new version:

  • Support for multicolumn primary keys
  • Support for 12c long identifier names
  • More control over the API features and name (10 new parameters)
  • Insert methods:
    • Can have the dictionary column defaults
    • Can return the whole row instead of the primary key
  • You can exclude columns (e.g. audit columns) for inserts and updates
  • Improved template engine:
    • Generated code better readable because of formatted parameter lists
    • Tables with many columns no longer breaking character limits
  • Special methods for testing and dummy data generation
  • Also see the full changelog on the project site

Happy new year and happy coding :-)
Ottmar