Pivet 0.46

Pivet 0.46 - Enhanced Configuration Builder

Major Improvements

• Smart Configuration Builder: Now provides real-time database validation and assistance when configuring Raw Data entries
• Improved User Experience: Better prompts, secure password input, and intelligent field suggestions
• Related Table Management: Simplified selection of related tables with include-based approach
• JSON Preview: Preview generated JSON output before saving configurations
• Configuration Testing: Test Raw Data configurations against live database before use

Additional Changes

• Enhanced JSON output formatting with better field ordering for Raw Data processor
• Improved error handling and validation throughout
• Better terminal compatibility (removed problematic emoji characters)

Technical Notes

• Added comprehensive database service layer for configuration assistance
• Improved connection management during interactive configuration
• Enhanced data structures for cleaner JSON serialization

Pivet 0.45

Pivet 0.45 Release Notes

🎉 Major New Features

Text-based GUI Interface

• Complete GUI implementation using Terminal.Gui framework
• Environment Editor - Interactive configuration of database connections
• Job Editor - Visual job configuration and management
• Configuration dialogs - User-friendly setup wizards
• Launch settings integration - Improved development experience

** NOTE: Currently the Text GUI is only useful for creating/editing config files. While the menu exists for running a job, that feature is not implemented yet. **

Enhanced Data Testing

• Raw Data Test Mode (--raw-data-test) - Preview related tables that Pivet discovers before running

🔧 Infrastructure & Platform Updates

.NET 8 Upgrade

• Upgraded to .NET 8 - Latest framework with performance improvements
• Updated all dependencies - Security and compatibility improvements
• Removed RHEL support - Streamlined build targets

Build System Improvements

• Updated GitHub Actions workflow - New build/release process
• Enhanced build system - Better cross-platform support
• Improved security - Fixed deprecated APIs and security vulnerabilities

🐛 Bug Fixes & Code Quality

• Removed dead code - Cleaner, more maintainable codebase
• JSON canonicalization improvements - More meaningful diffs for Raw Data processor
• Security improvements - Updated dependencies and fixed deprecated APIs

📦 Dependencies

• Newtonsoft.Json updated to 13.0.1 (security update)
• Terminal.Gui added for GUI functionality

📋 Documentation & Samples

• Sample configuration file added for easier setup
• Sample variables file (sample-vars.json) for configuration templating

---

Full Changelog: 0.44...0.45

This release represents a significant modernization of Pivet with the addition of a complete GUI interface, .NET 8 support, and numerous quality improvements. The new text-based GUI makes configuration much more user-friendly while maintaining full command-line compatibility.

Pivet 05/04/2022

Changes can now be committed in 3 modes:

• Single Commit
• PeopleCode Separate
• Top Level Separate

Single Commit is the default behavior, all changes are committed in a single commit.

PeopleCode Separate will commit all PeopleCode changes in a separate commit, and everything else in another commit.

Top Level Separate will commit each top level folder in the repository as its own commit.

All deleted objects are still committed in a single "Deleted Objects" commit.

To set a commit style there is a new property CommitStyle that goes on the Repository object like so:

{
  "Name": "JOB_NAME",
  "EnvironmentName": "ENVIRONMENT_NAME",
  "ProfileName": "PROFILE_NAME",
  "OutputFolder": "PATH_TO_WORKDIR",
  "Repository": {
    "CommitStyle": "TopLevelSeparate",
    "CommitByOprid": false,
    "Url": "REMOTE_GIT_URL",
    "User": "REMOTE_USER",
    "EncryptedPassword": "REMOTE_ENCRYPTED_PASSWORD"
  }
},

Valid values for CommitStyle are: SingleCommit, PeopleCodeSeparate, and TopLevelSeparate

Stylesheet Processor now only version controls free form stylesheets.

Previously it would produce 0 byte files for PeopleSoft stylesheets.

To version control PeopleSoft stylesheets, an enhancement to RawDataProcessor has been made which allows specifying ExtraCriteria to RawData entries. ExtraCriteria will be concatenated to the SQL Select statement like this:

SELECT * FROM <Table> (<like statement(s)>) AND <ExtraCriteria>

To version control PeopleSoft Stylesheets, add the following RawData entry into your config.json:

{
  "Record": "PSSTYLSHEETDEFN",
  "FilterField": "STYLESHEETNAME",
  "NamePattern": "{STYLESHEETNAME}.css",
  "Folder": "Stylesheets\\PeopleSoft\\",
  "IncludeRelated": true,
  "RelatedBlacklist": [],
  "ExtraCriteria": "STYLESHEETTYPE <> 2"
},

Pivet 2/28/2022

Allow empty commits. This occurs in some edge cases that have to do with older Pivet repositories (before .gitattributes) and line endings.

Pivet 2/24/2022

This release bumps the .NET framework to .NET 6.0 from .NET Core 2.2 which is end-of-life.

Pivet 2/23/2022

This release just bumps the libgit2 version to the latest which solves some dependency resolution issues on linux hosts.

Pivet - 02/21/2021

• Initial support for CREF versioning.
• Include CREF Attributes as related information.
• VersionController now places a .gitattributes file to enforce consistent line endings
• Revert to .NET Core 2.2 for Oracle Linux 6 support
• Support for an external vars file for config, allows to keep separate file with passwords. place values in a json object in vars.json and reference them as %KEY% in config.json
• Bugfix in RawDataProcessor

Pivet - 10/15/2019

Globalization Invariant has been set
publish.ps1 now produces self contained builds
SQL formatting is now accomplished by the BasicSQLFormatter library
Bugfix where -e could be specified by not enter password encryption mode
Additional prompt to confirm password before encrypting it
Invalid character names are now filtered out for SQL object filenames
Application Engine XSLTs have a new top lever folder instead of being in the SQL Object folder
Bugfix when the remote repository doesn't exist but is configured in config.json
Upgraded to .NET Core 3.0

Pivet - 09/27/2019

First public release of Pivet

Requires .NET 2.2.7
Works only on PeopleSoft instances that use Oracle Database

run Pivet with the -e flag to use the password encryptor.

Passwords in the config file are required to be encrypted.