oracle-object-tracker


Nameoracle-object-tracker JSON
Version 0.0.5 PyPI version JSON
download
home_pageNone
SummaryA Python-based tool for tracking Oracle database object DDL with git
upload_time2024-08-13 19:03:45
maintainerNone
docs_urlNone
authorNone
requires_python>=3.10
licenseNone
keywords oracle object tracker git ddl
VCS
bugtrack_url
requirements No requirements were recorded.
Travis-CI No Travis.
coveralls test coverage No coveralls.
            # Oracle Object Tracker

[<img src="https://img.shields.io/badge/GitHub-TruckCab%2Foracle--object--tracker-blue.svg?logo=Github">](https://github.com/TruckCab/oracle-object-tracker)
[![oracle-object-tracker-ci](https://github.com/TruckCab/oracle-object-tracker/actions/workflows/ci.yml/badge.svg)](https://github.com/TruckCab/oracle-object-tracker/actions/workflows/ci.yml)
[![Supported Python Versions](https://img.shields.io/pypi/pyversions/sidewinder-db)](https://pypi.org/project/sidewinder-db/)
[![PyPI version](https://badge.fury.io/py/oracle-object-tracker.svg)](https://badge.fury.io/py/oracle-object-tracker)
[![PyPI Downloads](https://img.shields.io/pypi/dm/oracle-object-tracker.svg)](https://pypi.org/project/oracle-object-tracker/)

## Install package
You can install `oracle-object-tracker` from source.

### Option 1 - from PyPi
```shell
# Create the virtual environment
python3 -m venv .venv

# Activate the virtual environment
. .venv/bin/activate

pip install oracle-object-tracker
```

### Option 2 - from source - for development
```shell
git clone https://github.com/TruckCab/oracle-object-tracker.git

cd oracle-object-tracker

# Create the virtual environment
python3 -m venv .venv

# Activate the virtual environment
. .venv/bin/activate

# Upgrade pip, setuptools, and wheel
pip install --upgrade pip setuptools wheel

# Install Sidewinder-DB - in editable mode with dev dependencies
pip install --editable .[dev]
```

### Note
For the following commands - if you running from source and using `--editable` mode (for development purposes) - you will need to set the PYTHONPATH environment variable as follows:
```shell
export PYTHONPATH=$(pwd)/src
```

## Usage
### Help
```shell
oracle-object-tracker --help
Usage: oracle-object-tracker [OPTIONS]

Options:
  --version / --no-version        Prints the Oracle Object Tracker version and
                                  exits.  [required]
  --username TEXT                 The Oracle database username to connect
                                  with.  [default: truck_cab; required]
  --password TEXT                 The Oracle database password to connect
                                  with.  [required]
  --hostname TEXT                 The Oracle database hostname to connect to.
                                  [default: oracle.truckcab.us; required]
  --service-name TEXT             The Oracle database service name to connect
                                  to.  [default:
                                  tcmpdb.sub10220134282.tcmvcn1.oraclevcn.com;
                                  required]
  --port INTEGER                  The Oracle database port to connect to.
                                  [default: 1521; required]
  --schema TEXT                   The schema to export objects for, may be
                                  specified more than once.  Defaults to the
                                  database username.  [default: TRUCK_CAB;
                                  required]
  --object-type TEXT              The object types to export.  [default:
                                  CLUSTER, DATABASE LINK, FUNCTION, INDEX,
                                  JAVA SOURCE, JOB, MATERIALIZED VIEW,
                                  MATERIALIZED VIEW LOG, PACKAGE, PACKAGE
                                  BODY, PROCEDURE, SEQUENCE, SYNONYM, TABLE,
                                  TRIGGER, TYPE, TYPE BODY, VIEW; required]
  --object-name-include-pattern TEXT
                                  The regexp pattern to use to filter object
                                  names to include in the export.  [default:
                                  .*; required]
  --object-name-exclude-pattern TEXT
                                  The regexp pattern to use to filter object
                                  names to exclude in the export.
  --output-directory TEXT         The path to the output directory - may be
                                  relative or absolute.  [default: /var/folder
                                  s/c8/b5pj7nzx627_9tbw374v3r1h0000gn/T/output
                                  ; required]
  --overwrite BOOLEAN             Controls whether to overwrite any existing
                                  DDL export files in the output path.
                                  [default: False; required]
  --git-repo TEXT                 Allows you to specify a git repository to
                                  push the output files to.  The repository
                                  must be accessible via SSH. Example:
                                  git@github.com:some-org/some-repo.git See: h
                                  ttps://docs.github.com/en/authentication/con
                                  necting-to-github-with-ssh/adding-a-new-ssh-
                                  key-to-your-github-account for more
                                  information on setting up SSH keys for
                                  GitHub.
  --git-branch TEXT               Specify the git branch to push to - if the
                                  --git-repo arg is used.  [default: main]
  --log-level TEXT                The logging level to use for the
                                  application.  [default: INFO; required]
  --help                          Show this message and exit.
```

## Handy development commands

#### Version management

##### Bump the version of the application - (you must have installed from source with the [dev] extras)
```bash
bumpver update --patch
```

            

Raw data

            {
    "_id": null,
    "home_page": null,
    "name": "oracle-object-tracker",
    "maintainer": null,
    "docs_url": null,
    "requires_python": ">=3.10",
    "maintainer_email": null,
    "keywords": "oracle, object, tracker, git, ddl",
    "author": null,
    "author_email": "Philip Moore <prmoore77@hotmail.com>, Stephen Weber <sweber@truckcab.com>",
    "download_url": "https://files.pythonhosted.org/packages/31/18/f461087d2b2a581409377d0def28eacac774c69ab03abfd14e1269a49aff/oracle_object_tracker-0.0.5.tar.gz",
    "platform": null,
    "description": "# Oracle Object Tracker\n\n[<img src=\"https://img.shields.io/badge/GitHub-TruckCab%2Foracle--object--tracker-blue.svg?logo=Github\">](https://github.com/TruckCab/oracle-object-tracker)\n[![oracle-object-tracker-ci](https://github.com/TruckCab/oracle-object-tracker/actions/workflows/ci.yml/badge.svg)](https://github.com/TruckCab/oracle-object-tracker/actions/workflows/ci.yml)\n[![Supported Python Versions](https://img.shields.io/pypi/pyversions/sidewinder-db)](https://pypi.org/project/sidewinder-db/)\n[![PyPI version](https://badge.fury.io/py/oracle-object-tracker.svg)](https://badge.fury.io/py/oracle-object-tracker)\n[![PyPI Downloads](https://img.shields.io/pypi/dm/oracle-object-tracker.svg)](https://pypi.org/project/oracle-object-tracker/)\n\n## Install package\nYou can install `oracle-object-tracker` from source.\n\n### Option 1 - from PyPi\n```shell\n# Create the virtual environment\npython3 -m venv .venv\n\n# Activate the virtual environment\n. .venv/bin/activate\n\npip install oracle-object-tracker\n```\n\n### Option 2 - from source - for development\n```shell\ngit clone https://github.com/TruckCab/oracle-object-tracker.git\n\ncd oracle-object-tracker\n\n# Create the virtual environment\npython3 -m venv .venv\n\n# Activate the virtual environment\n. .venv/bin/activate\n\n# Upgrade pip, setuptools, and wheel\npip install --upgrade pip setuptools wheel\n\n# Install Sidewinder-DB - in editable mode with dev dependencies\npip install --editable .[dev]\n```\n\n### Note\nFor the following commands - if you running from source and using `--editable` mode (for development purposes) - you will need to set the PYTHONPATH environment variable as follows:\n```shell\nexport PYTHONPATH=$(pwd)/src\n```\n\n## Usage\n### Help\n```shell\noracle-object-tracker --help\nUsage: oracle-object-tracker [OPTIONS]\n\nOptions:\n  --version / --no-version        Prints the Oracle Object Tracker version and\n                                  exits.  [required]\n  --username TEXT                 The Oracle database username to connect\n                                  with.  [default: truck_cab; required]\n  --password TEXT                 The Oracle database password to connect\n                                  with.  [required]\n  --hostname TEXT                 The Oracle database hostname to connect to.\n                                  [default: oracle.truckcab.us; required]\n  --service-name TEXT             The Oracle database service name to connect\n                                  to.  [default:\n                                  tcmpdb.sub10220134282.tcmvcn1.oraclevcn.com;\n                                  required]\n  --port INTEGER                  The Oracle database port to connect to.\n                                  [default: 1521; required]\n  --schema TEXT                   The schema to export objects for, may be\n                                  specified more than once.  Defaults to the\n                                  database username.  [default: TRUCK_CAB;\n                                  required]\n  --object-type TEXT              The object types to export.  [default:\n                                  CLUSTER, DATABASE LINK, FUNCTION, INDEX,\n                                  JAVA SOURCE, JOB, MATERIALIZED VIEW,\n                                  MATERIALIZED VIEW LOG, PACKAGE, PACKAGE\n                                  BODY, PROCEDURE, SEQUENCE, SYNONYM, TABLE,\n                                  TRIGGER, TYPE, TYPE BODY, VIEW; required]\n  --object-name-include-pattern TEXT\n                                  The regexp pattern to use to filter object\n                                  names to include in the export.  [default:\n                                  .*; required]\n  --object-name-exclude-pattern TEXT\n                                  The regexp pattern to use to filter object\n                                  names to exclude in the export.\n  --output-directory TEXT         The path to the output directory - may be\n                                  relative or absolute.  [default: /var/folder\n                                  s/c8/b5pj7nzx627_9tbw374v3r1h0000gn/T/output\n                                  ; required]\n  --overwrite BOOLEAN             Controls whether to overwrite any existing\n                                  DDL export files in the output path.\n                                  [default: False; required]\n  --git-repo TEXT                 Allows you to specify a git repository to\n                                  push the output files to.  The repository\n                                  must be accessible via SSH. Example:\n                                  git@github.com:some-org/some-repo.git See: h\n                                  ttps://docs.github.com/en/authentication/con\n                                  necting-to-github-with-ssh/adding-a-new-ssh-\n                                  key-to-your-github-account for more\n                                  information on setting up SSH keys for\n                                  GitHub.\n  --git-branch TEXT               Specify the git branch to push to - if the\n                                  --git-repo arg is used.  [default: main]\n  --log-level TEXT                The logging level to use for the\n                                  application.  [default: INFO; required]\n  --help                          Show this message and exit.\n```\n\n## Handy development commands\n\n#### Version management\n\n##### Bump the version of the application - (you must have installed from source with the [dev] extras)\n```bash\nbumpver update --patch\n```\n",
    "bugtrack_url": null,
    "license": null,
    "summary": "A Python-based tool for tracking Oracle database object DDL with git",
    "version": "0.0.5",
    "project_urls": {
        "Homepage": "https://github.com/prmoore77/oracle-object-tracker"
    },
    "split_keywords": [
        "oracle",
        " object",
        " tracker",
        " git",
        " ddl"
    ],
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "5b42a750096922ff338ee5da513d585b7c346594a1936d0c2f6a78e92456395c",
                "md5": "f8dcbbb7230ef15ea207a75460b954b2",
                "sha256": "d297db3c1599db2826edb594e8953df68fcf6f484ad25c048b802b16b5b71aab"
            },
            "downloads": -1,
            "filename": "oracle_object_tracker-0.0.5-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "f8dcbbb7230ef15ea207a75460b954b2",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": ">=3.10",
            "size": 8042,
            "upload_time": "2024-08-13T19:03:43",
            "upload_time_iso_8601": "2024-08-13T19:03:43.551672Z",
            "url": "https://files.pythonhosted.org/packages/5b/42/a750096922ff338ee5da513d585b7c346594a1936d0c2f6a78e92456395c/oracle_object_tracker-0.0.5-py3-none-any.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "3118f461087d2b2a581409377d0def28eacac774c69ab03abfd14e1269a49aff",
                "md5": "6826d1b625e87368ae0a0b0662c1e91d",
                "sha256": "1d0e16e3c17eb61068da6c4202895c7788f4bbada972ec6f69fdfbb75d17d180"
            },
            "downloads": -1,
            "filename": "oracle_object_tracker-0.0.5.tar.gz",
            "has_sig": false,
            "md5_digest": "6826d1b625e87368ae0a0b0662c1e91d",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": ">=3.10",
            "size": 8999,
            "upload_time": "2024-08-13T19:03:45",
            "upload_time_iso_8601": "2024-08-13T19:03:45.330178Z",
            "url": "https://files.pythonhosted.org/packages/31/18/f461087d2b2a581409377d0def28eacac774c69ab03abfd14e1269a49aff/oracle_object_tracker-0.0.5.tar.gz",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "upload_time": "2024-08-13 19:03:45",
    "github": true,
    "gitlab": false,
    "bitbucket": false,
    "codeberg": false,
    "github_user": "prmoore77",
    "github_project": "oracle-object-tracker",
    "github_not_found": true,
    "lcname": "oracle-object-tracker"
}
        
Elapsed time: 0.58559s