CodeGen 5.2.0

CodeGen Release Notes

• We added two file loop expansion tokens <FLOOP_ODBC_NAME> and <FLOOP_RPS_NAME>.
• This version of CodeGen was built with Synergy/DE 10.3.3c and requires a minimum Synergy runtime version of 10.1.1.

Symphony Framework Components

• There were no Symphony Orchestrator changes in this release.
• There were no Symphony Framework template file changes in this release.
• There were no Symphony Framework CodeGen Extensions changes in this release.

CodeGen 5.1.9

CodeGen Release Notes

• We made a slight change to the way that the multiple structures command line option (-ms) is processed, allowing it to be used when only one repository structure is specified. This allows for templates that use the <STRUCTURE_LOOP> construct to be used when only one structure is being processed.
• We fixed an issue that was causing the <FIELD_SPEC> token to produce incorrect values for auto-sequence and auto-timestamp fields. Previously the value 8 would be inserted, now the correct value i8 is inserted.
• We added two new structure expansion tokens <FILE_ODBC_NAME> and <FILE_RPS_NAME> that expands to the repository ODBC table name or structure name of the first file definition that is assigned to the structure being processed.
• This version of CodeGen was built with Synergy/DE 10.3.3c and requires a minimum Synergy runtime version of 10.1.1.

Symphony Framework Components

• There were no Symphony Orchestrator changes in this release.
• There were no Symphony Framework template file changes in this release.
• There were no Symphony Framework CodeGen Extensions changes in this release.

CodeGen 5.1.8

CodeGen Release Notes

• We added a new generic expansion token <DATABASE> that can be used to insert the name of the relational database currently being targeted.
• We added three new generic expression tokens <IF DATABASE_MYSQL>, <IF DATABASE_POSTGRESQL> and <IF DATABASE_SQLSERVER> that can be useful when developing database agnostic template files.
• We enhanced the <REQUIRES_OPTION> file header token by adding a new option TF which allows a template designer to specify that the template-defined folders feature must be enabled.
• This version of CodeGen was built with Synergy/DE 10.3.3b and requires a minimum Synergy runtime version of 10.1.1.

Symphony Framework Components

• There were no Symphony Orchestrator changes in this release.
• There were no Symphony Framework template file changes in this release.
• There were no Symphony Framework CodeGen Extensions changes in this release.

CodeGen 5.1.7

CodeGen Release Notes

• We added experimental support for generating code for MySQL and PostgreSQL databases by adding a new command line option -database. This option allows you to specify a target database type and affects the SQL-compatible data types that are generated by the field loop expansion token <FIELD_SQLTYPE>. If this option is not used then the default database continues to be Microsoft SQL Server, but this default may be changed via the new environment variable CODEGEN_DATABASE_TYPE. Before considering this support final we would appreciate any feedback from developers working with MySQL or PostgreSQL about whether we have chosen appropriate data type mappings. A list of these data type mappings can be found here.
• We changed the SQL Server data type mappings for D6 (YYMMDD) dates from DECIMAL(6) to DATE.
• We changed the SQL Server data type mappings for D6 (YYYYPP) and D4 (YYPP) period numbers from CHAR(6) and CHAR(4) to DECIMAL(6) and DECIMAL(4) respectively.
• We changed the SQL Server data type mappings for nullable time (HHMMSS and HHMM) from DECIMAL(6) and DECIMAL(4) to TIME(0).
• This version of CodeGen was built with Synergy/DE 10.3.3b and requires a minimum Synergy runtime version of 10.1.1.

Symphony Framework Components

• Symphony Orchestrator was upgraded to use Symphony Framework V3.2.11.
• There were no Symphony Framework template file changes in this release.
• There were no Symphony Framework CodeGen Extensions changes in this release.

CodeGen 5.1.6

CodeGen Release Notes

• We modified the way that key loops are processed so that if a repository structure has a mixture of access keys and foreign keys defined, the foreign keys are ignored when processing key loops.
• We added a new key loop expression <IF FIRST_SEG_NOCASE>.
• We added four new field loop expressions <IF AUTO_SEQUENCE>, <IF AUTO_TIMESTAMP>, <IF AUTO_TIMESTAMP_CREATED> and <IF AUTO_TIMESTAMP_UPDATED> which can be used to determine if fields are defined as auto sequence or auto time-stamp fields.
• We added two new key loop expressions <IF AUTO_TIMESTAMP_CREATED> and <IF AUTO_TIMESTAMP_UPDATED>.
• We added two new key segment loop expressions <IF SEG_AUTO_TIMESTAMP_CREATED> and <IF SEG_AUTO_TIMESTAMP_UPDATED>.
• We changed the behavior of the field loop expansion token <FIELD_TYPE_NAME>, which will now report the new values AUTO SEQUENCE or AUTO TIMESTAMP when auto sequence or auto time-stamp fields are encountered. Previously the token would have returned a generic value of INTEGER for both.
• This version of CodeGen is built with Synergy/DE 10.3.3a and requires a minimum Synergy runtime version of 10.1.1.

Symphony Framework Components

• There were no Symphony Orchestrator changes in this release.
• There were no Symphony Framework template file changes in this release.
• There were no Symphony Framework CodeGen Extensions changes in this release.

CodeGen 5.1.5

CodeGen Release Notes

• We added a new structure expression <IF STRUCTURE_HAS_UNIQUE_PK>.
• We fixed a problem that was preventing loop utility expressions from operating correctly.
• We fixed a problem that was causing the <IF LAST> field loop utility expression to operate incorrectly in primary key blocks.
• This version of CodeGen is built with Synergy/DE 10.3.3a and requires a minimum Synergy runtime version of 10.1.1.

Symphony Framework Components

• There were no Symphony Orchestrator changes in this release.
• There were no Symphony Framework template file changes in this release.
• There were no Symphony Framework CodeGen Extensions changes in this release.

CodeGen 5.1.4

CodeGen Release Notes

• We changed the SQL data mappings for time (HHMMSS and HHMM) fields from DECIMAL(n) to TIME(0). This will result in a change of output from the <FIELD_SQLTYPE> token. If this causes you any issues you can revert to the previously produced values by using custom data type mapping.
• The CodeGen installation was altered so that the changes to PATH occur immediately after the installation completes. This means that it is no longer necessary to reboot after installing CodeGen on a system for the first time.
• This version of CodeGen is built with Synergy/DE 10.3.3a and requires a minimum Synergy runtime version of 10.1.1.

Symphony Framework Components

• There were no Symphony Orchestrator changes in this release.
• There were no Symphony Framework template file changes in this release.
• There were no Symphony Framework CodeGen Extensions changes in this release.

CodeGen 5.1.3

CodeGen Release Notes

• Added a new loop utility expansion tokens <BSLASH> and <FSLASH>.
• Added a new field loop expression <IF LENGTH_OVER_8>.
• This version of CodeGen is built with Synergy/DE 10.3.3 and targets a minimum Synergy runtime version of 10.1.1.

Symphony Framework Components

• There were no Symphony Orchestrator changes in this release.
• There were no Symphony Framework template file changes in this release.
• There were no Symphony Framework CodeGen Extensions changes in this release.

CodeGen 5.1.2

CodeGen Release Notes

• We fixed a bug that was causing the <SELECTION_VALUE> selection loop expansion token to produce incorrect results for enumerated decimal and integer fields. The values being produced were previously off by 1, with values for fields with positive enumerated step values being one too high, and values for fields with negative enumerated step values being one too low.
• We changed the CodeGen installation so that it adds the CodeGen folder to the END of PATH instead of the beginning.

Symphony Framework Components

• We fixed a bug that was causing the <SYMPHONY_SELECTION_VALUE> selection loop expansion token to produce incorrect results for enumerated decimal and integer fields. The values being produced were previously off by 1, with values for fields with positive enumerated step values being one too high, and values for fields with negative enumerated step values being one too low.
• There were no Symphony Orchestrator changes in this release.
• There were no Symphony Framework template file changes in this release.

CodeGen 5.1.1

CodeGen Release Notes

• We have moved the CodeGen source code repository from CodePlex to GitHub; the only functional CodeGen changes in this release are related to that move (check for update mechanism, download URL, etc.).

  If you don't already have one we encourage you to Create a GitHub Account and to Watch CodeGen. If you wish to receive notifications about new CodeGen releases you can also subscribe tho the CodeGen Releases Atom feed.

  We have not changed the licensing terms, CodeGen is still distributed under the terms of the New BSD license (BSD). For the time being we plan to leave the CodePlex environment intact, but no new changes will be checked in there and no new releases will be published there.

  Here are a few useful GitHub URLs related to our new home:

  • Main project home page: https://github.com/Synergex/CodeGen
  • Wiki (information): https://github.com/Synergex/CodeGen/wiki
  • Download latest version: https://github.com/Synergex/CodeGen/releases/latest
  • Issue tracking: https://github.com/Synergex/CodeGen/issues
  • Releases Atom feed: https://github.com/Synergex/CodeGen/releases.atom

• We have made an internal change that has consolidated the functionality of the CodeGenEngineShared and CodeGenParser assemblies into the existing CodeGenEngine assembly and we modified the installation to remove the two redundant assemblies.

• We have upgraded the version of the WiX Toolset that we are using to create the CodeGen installation to V3.1.0.2213.

Symphony Framework Components

• There were no Symphony Orchestrator changes in this release.
• The Symphony_FileIO template was altered to use <TAGLOOP_FIELD_SQLNAME> instead of <TAGLOOP_FIELD_NAME>. This change only affects structures with tags.
• There were no Symphony Framework CodeGen Extensions changes in this release.