migratore


Namemigratore JSON
Version 0.5.5 PyPI version JSON
download
home_pagehttp://migratore.hive.pt
SummaryMigratore Infra-structure
upload_time2024-01-08 11:34:29
maintainer
docs_urlNone
authorHive Solutions Lda.
requires_python
licenseApache Software License
keywords migratore migration sql
VCS
bugtrack_url
requirements No requirements were recorded.
Travis-CI No Travis.
coveralls test coverage No coveralls.
            # [![Migratore](res/logo.png)](http://migratore.hive.pt)

Simple migration framework / infra-structure for SQL based databases.

## Installation

```bash
pip install migratore
```

## Execution

```bash
HOST=${HOST} DB=${DB_NAME} USERNAME=${DB_USER} PASSWORD=${DB_PASS} migratore upgrade
```

## Variables

* `HOST` - Hostname or IP address of the database system for migration
* `PORT` - TCP port to be used in the connection with the database system
* `UNIX_SOCKET` - Filesystem path to the UNIX socket file to be used in connection
* `DB` - Name of the database used as the migration target
* `USERNAME` - Username for authentication in database
* `PASSWORD` - Password to be used for authentication in database
* `FS` - Base file system path for file migration (may depend on migration context)

## Commands

* `help` - Prints a help message about the CLI interface
* `version` - Prints the current version of migratore
* `environ` - Displays the current environment in the standard output
* `list` - Lists the executed migrations on the current database
* `errors` - Lists the various errors from migration of the database
* `trace [id]` - Prints the traceback for the error execution with the provided id
* `rebuild [id]` - Run the partial execution of the migration with the given id
* `upgrade [path]` - Executes the pending migrations using the defined directory or current
* `skip [path]` - Skips the current migration (next to be run) using the defined directory or current
* `generate [path]` - Generates a new migration file into the target path

## Examples

```python
database = Migratore.get_database()
table = database.get_table("users")
table.add_column("username", type = "text")
```

## License

Migratore is currently licensed under the [Apache License, Version 2.0](http://www.apache.org/licenses/).

## Build Automation

[![Build Status](https://app.travis-ci.com/hivesolutions/migratore.svg?branch=master)](https://travis-ci.com/github/hivesolutions/migratore)
[![Build Status GitHub](https://github.com/hivesolutions/migratore/workflows/Main%20Workflow/badge.svg)](https://github.com/hivesolutions/migratore/actions)
[![Coverage Status](https://coveralls.io/repos/hivesolutions/migratore/badge.svg?branch=master)](https://coveralls.io/r/hivesolutions/migratore?branch=master)
[![PyPi Status](https://img.shields.io/pypi/v/migratore.svg)](https://pypi.python.org/pypi/migratore)
[![License](https://img.shields.io/badge/license-Apache%202.0-blue.svg)](https://www.apache.org/licenses/)



            

Raw data

            {
    "_id": null,
    "home_page": "http://migratore.hive.pt",
    "name": "migratore",
    "maintainer": "",
    "docs_url": null,
    "requires_python": "",
    "maintainer_email": "",
    "keywords": "migratore migration sql",
    "author": "Hive Solutions Lda.",
    "author_email": "development@hive.pt",
    "download_url": "https://files.pythonhosted.org/packages/4e/90/57707dc7fc4adcdd673fa8d02d7f44cf26a55eb8696e7920673bbba59553/migratore-0.5.5.tar.gz",
    "platform": null,
    "description": "# [![Migratore](res/logo.png)](http://migratore.hive.pt)\n\nSimple migration framework / infra-structure for SQL based databases.\n\n## Installation\n\n```bash\npip install migratore\n```\n\n## Execution\n\n```bash\nHOST=${HOST} DB=${DB_NAME} USERNAME=${DB_USER} PASSWORD=${DB_PASS} migratore upgrade\n```\n\n## Variables\n\n* `HOST` - Hostname or IP address of the database system for migration\n* `PORT` - TCP port to be used in the connection with the database system\n* `UNIX_SOCKET` - Filesystem path to the UNIX socket file to be used in connection\n* `DB` - Name of the database used as the migration target\n* `USERNAME` - Username for authentication in database\n* `PASSWORD` - Password to be used for authentication in database\n* `FS` - Base file system path for file migration (may depend on migration context)\n\n## Commands\n\n* `help` - Prints a help message about the CLI interface\n* `version` - Prints the current version of migratore\n* `environ` - Displays the current environment in the standard output\n* `list` - Lists the executed migrations on the current database\n* `errors` - Lists the various errors from migration of the database\n* `trace [id]` - Prints the traceback for the error execution with the provided id\n* `rebuild [id]` - Run the partial execution of the migration with the given id\n* `upgrade [path]` - Executes the pending migrations using the defined directory or current\n* `skip [path]` - Skips the current migration (next to be run) using the defined directory or current\n* `generate [path]` - Generates a new migration file into the target path\n\n## Examples\n\n```python\ndatabase = Migratore.get_database()\ntable = database.get_table(\"users\")\ntable.add_column(\"username\", type = \"text\")\n```\n\n## License\n\nMigratore is currently licensed under the [Apache License, Version 2.0](http://www.apache.org/licenses/).\n\n## Build Automation\n\n[![Build Status](https://app.travis-ci.com/hivesolutions/migratore.svg?branch=master)](https://travis-ci.com/github/hivesolutions/migratore)\n[![Build Status GitHub](https://github.com/hivesolutions/migratore/workflows/Main%20Workflow/badge.svg)](https://github.com/hivesolutions/migratore/actions)\n[![Coverage Status](https://coveralls.io/repos/hivesolutions/migratore/badge.svg?branch=master)](https://coveralls.io/r/hivesolutions/migratore?branch=master)\n[![PyPi Status](https://img.shields.io/pypi/v/migratore.svg)](https://pypi.python.org/pypi/migratore)\n[![License](https://img.shields.io/badge/license-Apache%202.0-blue.svg)](https://www.apache.org/licenses/)\n\n\n",
    "bugtrack_url": null,
    "license": "Apache Software License",
    "summary": "Migratore Infra-structure",
    "version": "0.5.5",
    "project_urls": {
        "Homepage": "http://migratore.hive.pt"
    },
    "split_keywords": [
        "migratore",
        "migration",
        "sql"
    ],
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "981911243acabd59e4935787591e146af7f5172cfd4200a33f108958b5184c27",
                "md5": "eb22f2586233dcb0160618a4c7dce1c2",
                "sha256": "5a57b62e2db4d3e57115cf1b04baea4d117ba1e735d457028b04f1094bd09d2a"
            },
            "downloads": -1,
            "filename": "migratore-0.5.5-py2.py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "eb22f2586233dcb0160618a4c7dce1c2",
            "packagetype": "bdist_wheel",
            "python_version": "py2.py3",
            "requires_python": null,
            "size": 18875,
            "upload_time": "2024-01-08T11:34:27",
            "upload_time_iso_8601": "2024-01-08T11:34:27.375319Z",
            "url": "https://files.pythonhosted.org/packages/98/19/11243acabd59e4935787591e146af7f5172cfd4200a33f108958b5184c27/migratore-0.5.5-py2.py3-none-any.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "4e9057707dc7fc4adcdd673fa8d02d7f44cf26a55eb8696e7920673bbba59553",
                "md5": "72904cf095bbdfb37615cc1a04194dc5",
                "sha256": "4a1185a3ec35e32404863767fdf03249c98cc4f54b45d5978ee199220777d073"
            },
            "downloads": -1,
            "filename": "migratore-0.5.5.tar.gz",
            "has_sig": false,
            "md5_digest": "72904cf095bbdfb37615cc1a04194dc5",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 15059,
            "upload_time": "2024-01-08T11:34:29",
            "upload_time_iso_8601": "2024-01-08T11:34:29.097766Z",
            "url": "https://files.pythonhosted.org/packages/4e/90/57707dc7fc4adcdd673fa8d02d7f44cf26a55eb8696e7920673bbba59553/migratore-0.5.5.tar.gz",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "upload_time": "2024-01-08 11:34:29",
    "github": false,
    "gitlab": false,
    "bitbucket": false,
    "codeberg": false,
    "lcname": "migratore"
}
        
Elapsed time: 0.26973s