Skip to main content

Python wrapper of the Oracle Forms API

Project description

pyoracle_forms

https://raw.githubusercontent.com/LatvianPython/pyoracle_forms/master/media/coverage.svg?sanitize=true https://img.shields.io/pypi/pyversions/pyoracle_forms https://img.shields.io/badge/code%20style-black-000000.svg https://img.shields.io/pypi/v/pyoracle_forms https://travis-ci.org/LatvianPython/pyoracle_forms.svg?branch=master

Wraps the Oracle Forms API under Python, so that you can write scripts to make programmatic changes to Oracle Forms .fmb files with ease.

Installation and usage

Installation

The package can be installed from PyPI with pip install pyoracle-forms

Usage

from pyoracle_forms import Module

with Module.load("./your_form.fmb") as module:
    for data_block in module.data_blocks:
        for item in data_block.items:
            item.font_name = "Comic Sans MS"

    module.save()

Best used with an interactive environment, such as Jupyter Notebook, as you get better autocomplete there due to attributes getting determined dynamically.

You also need access to successfully installed version of Oracle Forms, otherwise the scripts won’t work, as this solution depends on the Oracle Forms API.

Caveats

By default forms API version is assumed to be 12c, and the encoding of .fmb file text as utf-8, to use a different version or encoding you must currently use the following code before importing pyoracle_forms. Versions supported are 12c, 10g and 6i of the Oracle forms API.

import builtins

builtins.pyoracle_forms_VERSION = "12c"
builtins.pyoracle_forms_ENCODING = "utf-8"

from pyoracle_forms import ...

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

pyoracle_forms-0.1.4.tar.gz (67.8 kB view hashes)

Uploaded Source

Built Distribution

pyoracle_forms-0.1.4-py3-none-any.whl (74.9 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page