OraTAPI 1.5.7

This is a minor update.

Fix the issue where the primary key column(s) were not the first columns in the table. This broke the generation of the signature of delete APIs, causing a leading comma on the first parameter specification.

You can download and install the latest update using:

bin/update_ora_tapi.sh -t /tmp (macOS/Linux)
bin\update_ora_tapi -t <staging_path>(Windows)
Alternatively, if you are on an earlier release, or don't want to install a later update, download the oratapi-1.5.7.tar.gz file to install this version.

If you are new to OraTAPI, please read the OraTAPI - Oracle Table API Generator documentation.

See Performing Upgrades, if you already have OraTAPI installed.

OraTAPI 1.5.6

This is a minor update to include changes to the license, granting Oracle Corporation:

1. Use, copy, modify, and fork the OraTAPI codebase internally within Oracle, without the need to comply with the terms of the open source license under which it is
   publicly released (currently MIT).
2. Redistribute internally across Oracle systems, infrastructure, and repositories, without needing to retain open source attribution or license notices.

See ORACLE_INTERNAL_LICENSE.txt

If you are running 1.4.24 or later, you can download and install the latest update using:

bin/update_ora_tapi.sh -t /tmp (macOS/Linux)
bin\update_ora_tapi -t <staging_path>(Windows)
Alternatively, if you are on an earlier release, or don't want to install a later update, download the oratapi-1.5.6.tar.gz file to install this version.

If you are new to OraTAPI, please read the OraTAPI - Oracle Table API Generator documentation.

See Performing Upgrades, if you already have OraTAPI installed.

OraTAPI 1.5.3

This is a macOS install fix/update:

This fixes a bug with Python11/macOS/Homebrew. This resulted in a setup.sh an error:

Error: This environment is externally managed
╰─> To install Python packages system-wide, try brew install
   xyz, where xyz is the package you are trying to
   install...

If you are running 1.4.24 or later, you can download and install the latest update using:

bin/update_ora_tapi.sh -t /tmp (macOS/Linux)
bin\update_ora_tapi -t <staging_path>(Windows)
Alternatively, if you are on an earlier release, or don't want to install a later update, download the oratapi-1.5.3.tar.gz file to install this version.

If you are new to OraTAPI, please read the OraTAPI - Oracle Table API Generator documentation.

See Performing Upgrades, if you already have OraTAPI installed.

OraTAPI 1.5.2

This is a minor update:

• Fixes a template bug which impacted logger templates. This causes the delete procedure to be identified as the unit procedure for all types of APIs.

If you are running 1.4.24 or later, you can download and install the latest update using:

bin/update_ora_tapi.sh -t /tmp (macOS/Linux)
bin\update_ora_tapi -t <staging_path>(Windows)
Alternatively, if you are on an earlier release, or don't want to install a later update, download the oratapi-1.5.2.tar.gz file to install this version.

If you are new to OraTAPI, please read the OraTAPI - Oracle Table API Generator documentation.

See Performing Upgrades, if you already have OraTAPI installed.

OraTAPI 1.5.1

This is a minor update:

• Add OraTAPI.ini control for skipping tables (with warning) which have no primary key.
• Perform a table count check against the table owner schema. If there are no tables, we now error and exit.
• Improve exception handling when mandatory parameter combinations are omitted. (now user friendly).
• Refined sample OraTAPI.ini
• Added a unit test sample OraTAPI.ini (resources/config/samples/OraTAPI.ini.ut.sample)

If you are running 1.4.24 or later, you can download and install the latest update using:

bin/update_ora_tapi.sh -t /tmp (macOS/Linux)
bin\update_ora_tapi -t <staging_path>(Windows)
Alternatively, if you are on an earlier release, or don't want to install a later update, download the oratapi-1.5.1.tar.gz file to install this version.

If you are new to OraTAPI, please read the OraTAPI - Oracle Table API Generator documentation.

See Performing Upgrades, if you already have OraTAPI installed.

OraTAPI 1.4.34

This update is to the utPLSQL template responsible for constraint test (constraint_test.common.sample file). This was an adjustment relating to utPLSQL test generation.

Once you have applied the update:

If you have not modified your templates, simply reinstantiate using bin/quick_config -f -t <template-set> -T. Replace <template-set>with
whichever template set you are using (basic, liquibase, logger or llogger).

Examples:

• bin/quick_config.sh -f -t llogger -T (Mac/Linux)
• bin\quick_config -f -t llogger -T (Windows).

If you have modified your templates, you'll need to consider a manual copy/paste of the first line of:
resources/templates/ut_packages/body/samples/constraint_test.common.sample
to replace the first line in:
resources/templates/ut_packages/body/constraint_test.tpt

In addition to the above, when using the -s option, update_ora_tapi now provides a preview of the latest version's release notes before prompting for download.

If you are running 1.4.24 or later, you can download and install the latest update using:

• bin/update_ora_tapi.sh -t /tmp (macOS/Linux)
• bin\update_ora_tapi -t <staging_path>(Windows)

Alternatively, if you are on an earlier release, or don't want to install a later update, download the oratapi-1.4.34.tar.gz file to install this version.

If you are new to OraTAPI, please read the OraTAPI - Oracle Table API Generator documentation.

See Performing Upgrades, if you already have OraTAPI installed.

OraTAPI 1.4.32

UPDATES:

1. For utPLSQL procedure name generation, where we have a sys generated not null constraint, we now derived the test procedure name, based on the column name: test_<column_name_lc>_not_null. Note that the original Sys generated name, is still included to comments, to avoid confusion.
2. Improved update mechanism - cross-checks of OraTAPI.ini file improved and included to update_ora_tapi.
3. Fixed a problem with logger templates for the append parameters instruction. We now use the explicit primary key column parameters, instead of referencing the pk columns in p_row.

Download the oratapi-1.4.32.tar.gz file to install this version.

If you are new to OraTAPI, please read the OraTAPI - Oracle Table API Generator documentation.

See Performing Upgrades, if you already have OraTAPI installed.

OraTAPI 1.2.9

Updates:
Fix to update_ora_tapi - sample config templates were being updated to the config folder, instead of config/samples.

Also as per 1.4.27:

Include utPLSQL package generation - generates a complete Package spec and a starter package body. [currently beta]
Added Parent tables comment to UT package body.
Removed version from config (the juice wasn't worth the squeeze). Version is now maintained within each utility.
Add ability to include table domain (derived from characters leading up to 1st underscore in a table's name), as a substitution on the staging paths (table_domain_lc / table_domain).
Table list and API type parameters are now passed with spaces.
Added update_ora_tapi commands.
utPLSQL generated test procedures now split merge/upsert tests into two. One for insert tests and one for updates.
Introducing update_ora_tapi, for in-situ upgrades - README.md updated accordingly.

Download the oratapi-1.4.28.tar.gz file to install this version.

If you are new to OraTAPI, please read the OraTAPI - Oracle Table API Generator documentation.

See Performing Upgrades, if you already have OraTAPI installed.

If you wish to backport the update_ora_tapi command to a pre 1.4.24 version, download the backport_updater-1.4.zip ZIP file and copy it into the root folder of the OraTAPI installation. Unzip the contents, allowing it to replace any existing files-avoid unzipping to a folder based on the ZIP file name. Once done, run the setupcommand as per the guidance for installations. NOTE: On non-Windows environments, before running setup, you will need to set the execute permissions on the setup.shfile: chmod 750 setup.sh.

OraTAPI 1.4.24

Updates:

Include utPLSQL package generation - generates a complete Package spec and a starter package body. [currently beta]
Added Parent tables comment to UT package body.
Removed version from config (the juice wasn't worth the squeeze). Version is now maintained within each utility.
Add ability to include table domain (derived from characters leading up to 1st underscore in a table's name), as a substitution on the staging paths (table_domain_lc / table_domain).
Table list and API type parameters are now passed with spaces.
Added update_ora_tapi commands.
utPLSQL generated test procedures now split merge/upsert tests into two. One for insert tests and one for updates.
Introducing update_ora_tapi, for in-situ upgrades.

Download the oratapi-1.4.24.tar.gz file to install this version.

If you are new to OraTAPI, please read the OraTAPI - Oracle Table API Generator documentation.

See Performing Upgrades, if you already have OraTAPI installed.

OraTAPI 1.4.20

Include utPLSQL package generation - generates a complete Package spec and a starter package body. [currently beta]
Added Parent tables comment to UT package body.

Removed version from config (the juice wasn't worth the squeeze). Version is now maintained within each utility.

Add ability to include table domain (derived from characters leading up to 1st underscore in a table's name), as a substitution on the staging paths (table_domain_lc / table_domain).

Table list and API type parameters are now passed with spaces.

Download the oratapi-1.4.20.tar.gz file to install this version.

If you are new to OraTAPI, please read the OraTAPI - Oracle Table API Generator documentation.

See Performing Upgrades, if you already have OraTAPI installed.