@ogobrecht ogobrecht released this May 27, 2017 · 1 commit to master since this release

Assets 2
  • Fixes #5: Parameter with PK is not used to insert - thanks to Jacek Gębal to report this issue

@ogobrecht ogobrecht released this Mar 30, 2017 · 4 commits to master since this release

Assets 2

new generated API functions / procedures

  • adding a row_exists_yn function that returns 'Y' or 'N', same functionality as the existing row_exists function but allows to check a row within SQL context
  • adding additional read_row functions that takes unique constraint columns as parameter and returns the row, for each unique constraint one read_row function
  • new enable INSERT, UPDATE, DELETE parameter for fine granular definition, which DML operations are allowed on the table
  • optional DML view as logical layer above the database table. This can be used in e.g. in APEX instead of the table to create forms, interactive grids etc AND to ensure, that table API is used
  • optional DML view trigger that additionally catches unallowed DML operations and throws exceptions in dependency of new enable INSERT, UPDATE, DELETE parameter

code optimizations

  • getter functions for each column: remove unnecessary variable declaration (variable v_return)
  • setter functions for each column: remove unnecessary variable declaration (variable v_#column_name#)
  • limit clause for bulk collect operations introduced to avoid session memory conflicts

other stuff

  • added some additional comments on internal procedures and functions
  • renaming internal variables more consistently
  • supporting special column names, by using quotes around column names and validating / converting parameter names

@ogobrecht ogobrecht released this Jul 3, 2016 · 17 commits to master since this release

Assets 2

0.3.0 (2016-07-03)

  • First public release
  • André: Complete redesign with global package collections and initialisation phase to avoid many dictionary queries
  • Ottmar: Integration of all dependencies as package utilities, template engine to avoid many replace statements, integration in SQL-Developer, save parameters in source code for easy recreation

0.2.0 (not published)

  • André: Read row procedure for APEX with out parameters for the page items, rowtype based methods
  • Ottmar: Generic change log, get pk by unique columns function, idea for rowtype based methods

0.1.0 (not published)

  • André: Idea and first running version
  • Ottmar: Fan of the idea and first usage in a project :-)