pato-gui 4.0.0

Paulissoft Application Tools for Oracle (PATO) GUI.

pato-gui

Table of contents

1. Introduction
2. Installation
   1. Start a command prompt
   2. Installing from PyPi
   3. Installing from source
3. Usage
   1. Launch the GUI
   2. Help
4. Links

Introduction

A Python GUI for PATO as an alternative for the Maven command line.

First you probably need to clone PATO so you use its Maven POM files or other Maven POM files having them as parent.

This GUI would not have been possible without Gooey.

Installation

This utility needs Python 3. In order to support several Python versions and/or (virtual) environments on your computer, I prefer Mamba from the Miniforge project on GitHub. See the installation instructions there if you want to use that distribution. Mamba is an environment manager similar to Conda variants like Anaconda and Miniconda but much faster. Together with Poetry this is a good combination to distribute libraries to PyPi.

Start a command prompt

Needed for installing and running the PATO GUI. Please Google it if you don't know how to start a command prompt.

First please note that the dollar sign you will see below is the command line prompt sign and not a character you have to type. The command line prompt will differ between Operating Systems.

Installing from PyPi

First set up a virtual environment using your preferred method:

Using Mamba (see above) you can create (and activate) such an environment via:

$ mamba create --name <environment> python
$ mamba activate <environment>

Now continue with:

$ python3 -m pip install pato-gui

Now pato-gui should be available and this command shows you the help:

$ pato-gui -h

You can also build an executable:

$ cd <temporary directory>
$ pato-gui-build

In the dist/PatoGui folder you will find the PatoGui executable.

Of course you can put the executable in dist/PatoGui somewhere in your path.

Installing from source

Clone the Git repo pato-gui first.

Go to the root folder and issue this command for more help:

$ make help

To run from the start:

$ make env-create
$ mambo activate pato-gui
$ make test
$ make run

Usage

Launch the GUI

I assume that you have built the executable.

Launch it via:

$ <path to PatoGui>/PatoGui

A graphical interface will pop up.

If you know the Maven POM file already:

$ <path to PatoGui>/PatoGui <POM file>

Help

From the command line:

$ <path to PatoGui>/PatoGui -h

And in the left top corner of the GUI screen there is a Help button.

Links

These links have been helpful to convert a setuptools based project to Poetry and Mamba.

• using python-poetry to publish to test.pypi.org
• Poetry Read The Docs
• Migrating a project to Poetry
• Convert Python requirements to Poetry format
• Specify docs dependency groups with Poetry and Read the Docs
• Convert a Poetry package to the src layout
• Use poetry to create binary distributable with pyinstaller on package?
• Setup Guide for Poetry Dev Environment on Apple Silicon.
• https://stackoverflow.com/questions/70851048/does-it-make-sense-to-use-conda-poetry
• Conda and Poetry: A Harmonious Fusion
• Welcome to Mamba’s documentation!
• How to Use Poetry with Conda for Package Management on a Specific Python Version
• Examples of using conda + poetry for cross-platform Python package portability
• Mambaforge/miniforge

Changelog

All notable changes to this project will be documented in this file.

The format is based on Keep a Changelog, and this project adheres to Semantic Versioning.

• Added for new features.
• Changed for changes in existing functionality.
• Deprecated for soon-to-be removed features.
• Removed for now removed features.
• Fixed for any bug fixes.
• Security in case of vulnerabilities.

[Unreleased]

[4.0.0] - 2023-11-14

Fixed

• Two databases named orcl and something like dev, tst or acc does not work.
• The PATO GUI must run Maven with the batch switch -B
• Development build does not work on Windows
• pip complains about SSL not enabled for Miniconda Python.
• Development build does not work on Windows.

Deprecated

• Pato GUI must run on Python 3.6 or higher.

[3.0.1] - 2023-10-15

Fixed

• Pato GUI must run on Python 3.6 or higher.

[3.0.0] - 2023-10-14

Added

• Python executables must be determined at run-time.

Fixed

• Pato gui script does not run due to missing pythonw executable.

[2.1.0] - 2023-09-06

Added

• APEX seed and publish.

Fixed

• The GUI does not start with a message that the property db.config.dir must have been set.

[2.0.0] - 2022-11-23

Added

• Remove all references to Oracle Tools in documentation.

[1.2.0] - 2022-10-13

Added

• It must be possible to use the Maven daemon.

[1.1.1] - 2022-07-22

Fixed

• When you supply the database configuration directory as a relative path, the execution fails.

[1.1.0] - 2021-09-10

Added

• Added actions db-info and db-code (added in oracle-tools 1.2.0).

[1.0.0] - 2021-06-04

Added

• Display information about the Java run-time and compiler.
• Applied Python best practices.