{ "info": { "author": "Salem Harrache", "author_email": "salem.harrache@inria.fr", "bugtrack_url": null, "classifiers": [ "Development Status :: 1 - Planning", "Intended Audience :: Developers", "License :: OSI Approved :: BSD License", "License :: OSI Approved :: GNU General Public License (GPL)", "Operating System :: OS Independent", "Programming Language :: Python", "Programming Language :: Python :: 3", "Topic :: Software Development :: Libraries :: Python Modules", "Topic :: System :: Clustering" ], "description": "==============\nPython OAR CLI\n==============\n\nOAR Command line interface\n\nInstallation\n============\n\nRequirements:\n - python >= 2.7\n - python-mysqldb/python-psycopg2 (for oar database archive)\n\nYou can install, upgrade, uninstall oar-cli with these commands::\n\n $ pip install [--user] oar-cli\n $ pip install [--user] --upgrade oar-cli\n $ pip uninstall oar-cli\n\nOr from git (last development version)::\n\n $ pip install git+https://github.com/oar-team/python-oar-cli.git\n\nOr if you already pulled the sources::\n\n $ pip install path/to/sources\n\nOr if you don't have pip::\n\n $ easy_install oar-cli\n\n\nOAR Database archive\n====================\n\nThis script allow you to copy your OAR database to another database for\narchiving purposes.\n\nIn order to do this, the tool offers two commands that can be launched\nregularly to simplify both databases maintenance.\n\nSync\n----\n\nThis command is used to copy data to archive on the archive database. It is\nonly useful when handling a *small amount of data*.\n\nIf your database is too big, we advise you to first create manually your\narchive database with a dump. If your archive database does not exist yet, and\nif it will be located on the same machine than your current OAR database, the\n'sync' command will clone the OAR database to the archive (extremely efficient\nfor postgresql).\n\n\nUsage\n~~~~~\n\n::\n\n Usage: oar-database-archive sync [OPTIONS]\n\n Send all resources and finished jobs to archive database.\n\n Options:\n --chunk INTEGER Chunk size [default: 10000]\n --ignore-jobs TEXT Ignore job state [default: ^Terminated, ^Error]\n --current-db-url TEXT The url for your current OAR database.\n --archive-db-url TEXT The url for your archive OAR database.\n -h, --help Show this message and exit.\n\nJobs unfinished (i.e. current jobs) are not copied by default. The symbol '^'\nmeans negation.\n\nFor more information about the URL format, please refer to the SQLAlchemy\ndocumentation: http://docs.sqlalchemy.org/en/latest/core/engines.html#database-urls\n\n\nExamples\n~~~~~~~~\n\n::\n\n $ oar-database-archive sync --archive-db-url postgresql://oar:oar@server:5432/oar_archive\n\nThis command will dump your current OAR database (configured in oar.conf) in\nthe given database. The second run will only copy the missing rows.\n\n**From postgresql to mysql**::\n\n $ oar-database-archive sync --current-db-url postgresql://user:password@server1:5432/oar \\\n --archive-db-url mysql://user:password@server2:3306/oar_archive\n\n**From mysql to sqlite**::\n\n $ oar-database-archive sync --current-db-url mysql://user:password@server1:3306/oar \\\n --archive-db-url sqlite:////tmp/archive.db\n\nPurge\n-----\n\nThe purge command is used to delete jobs and resources (previously archived)\nfrom the current OAR database.\n\n\nUsage\n~~~~~\n\n::\n\n Usage: oar-database-archive purge [OPTIONS]\n\n Purge old resources and old jobs from your current database.\n\n Options:\n --ignore-jobs TEXT Ignore job state [default: ^Terminated, ^Error]\n --max-job-id INTEGER Purge only jobs lower than this id\n --ignore-resources TEXT Ignore resource state [default: ^Dead]\n --current-db-url TEXT The url for your current OAR database.\n -h, --help Show this message and exit.\n\nThese options are almost similar. By default, all finished jobs are purged. You\ncan use ``--max-job-id`` to ignore all jobs with an ID greater than the ID used\nas parameter..\n\nAll resources in 'Dead' state are also purged. If we do not want to purge\nresources, the filter ``--ignore-resources all`` needs to be used.\n\nExample\n~~~~~~~\n\n::\n\n $ oar-database-archive purge \\\n --ignore-resources ^Dead \\\n --ignore-jobs ^Terminated --ignore-jobs ^Error \\\n --max-job-id 100000 \\\n --current-db-url postgresql://scott:tiger@localhost/oar_prod_database\n\nThis commande is used to delete all resourced marked as 'Dead' and all finished\njobs (and associated events) with a ID smaller than 100000.\n\n\nOAR CLI changelog\n=================\n\nVersion 0.3.5\n-------------\n\nReleased on July 08th 2015\n\n- Emptied admission_rules table before migration\n- Used postgresql binary COPY by default\n- Split big queries with BETWEEN clause to improved performance and avoided mysql crashes\n\nVersion 0.3.4\n-------------\n\nReleased on July 07th 2015\n\n- Removed OFFSET sql clause from big queries to avoided mysql crashes\n\nVersion 0.3.3\n-------------\n\nReleased on June 24th 2015\n\n- Added ``--conf`` option to used custom oar configuration file\n- Used postgresql COPY with csv format by default\n- Fixed modify nullable operation during schema upgrade\n\n\nVersion 0.3.2\n-------------\n\nReleased on June 23rd 2015\n\n- Minor bug fixes\n\nVersion 0.3.1\n-------------\n\nReleased on June 23rd 2015\n\n- Fixed project description in Pypi\n\nVersion 0.3.0\n-------------\n\nReleased on June 23rd 2015\n\n- Renamed the project to OAR CLI !\n- Added ``oar-database-migrate`` script.\n- Added ``--schema-only`` and ``--data-only`` features to ``oar-database-migrate`` script\n- Supported postgresql bulk insert using COPY clause to improved performance.\n- Handled database connection errors.\n- Managed the schema upgrade with alembic\n- Fixed max_job_to_sync query if we want to copy all jobs\n\n\nVersion 0.2.0\n-------------\n\nReleased on June 05th 2015\n\nDatabase Archive\n~~~~~~~~~~~~~~~~\n\n - Made deterministic order_by to sync queries in order to avoid IntegrityError during copy (Fixed #1)\n - Handled IntegrityError during bulk INSERT (Fixed #1)\n - Used Postgresql DELETE with the USING clause to improve performance (Fixed #2)\n - Made the delete orphan queries faster with LEFT JOIN in Mysql (Fixed #2)\n - Removed count query when performing a bulk delete query (Fixed #2)\n - Configured debug logging to displayed SQL queries\n - Added option to disable pagination during sync operation\n - Displayed default values in the CLI\n\nVersion 0.1.2\n-------------\n\nReleased on May 05th 2015\n\n- [database-archive] : Added ability to ignore all resources during purge\n\nVersion 0.1.1\n-------------\n\nReleased on May 04th 2015\n\n- Fixed pypi package\n\nVersion 0.1.0\n-------------\n\nFirst public preview release.", "description_content_type": null, "docs_url": null, "download_url": "UNKNOWN", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/oar-team/python-oar-cli", "keywords": null, "license": "GNU GPL", "maintainer": null, "maintainer_email": null, "name": "oar-cli", "package_url": "https://pypi.org/project/oar-cli/", "platform": "UNKNOWN", "project_url": "https://pypi.org/project/oar-cli/", "project_urls": { "Download": "UNKNOWN", "Homepage": "https://github.com/oar-team/python-oar-cli" }, "release_url": "https://pypi.org/project/oar-cli/0.3.5/", "requires_dist": null, "requires_python": null, "summary": "OAR Command line interface.", "version": "0.3.5" }, "last_serial": 1624805, "releases": { "0.3.0": [ { "comment_text": "", "digests": { "md5": "3a7369d1c2fd9ed151632e5efe40d871", "sha256": "c4ea4885843b62deb940ea292769946cd851b5e3d99d1bbdf9e6f26141785234" }, "downloads": -1, "filename": "oar_cli-0.3.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "3a7369d1c2fd9ed151632e5efe40d871", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 19497, "upload_time": "2015-06-23T14:20:58", "url": "https://files.pythonhosted.org/packages/02/6f/5572bce9c03fb189c41800027907db5c6095fcc4b9d13f2b46b10a12cb79/oar_cli-0.3.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "986a3f027f06d5d9f666b2ecc625bd2d", "sha256": "1b4e5920930e711ef802c577948308862edf30107723a1ed9ebf9902c965e697" }, "downloads": -1, "filename": "oar-cli-0.3.0.tar.gz", "has_sig": false, "md5_digest": "986a3f027f06d5d9f666b2ecc625bd2d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 13966, "upload_time": "2015-06-23T14:20:54", "url": "https://files.pythonhosted.org/packages/83/8d/c723aec231ffab9c73b90b35f4c40f67ee153f27cba44f0531b137c3c864/oar-cli-0.3.0.tar.gz" } ], "0.3.1": [ { "comment_text": "", "digests": { "md5": "3e05bddfe98a6df660941b3ce5cd5c26", "sha256": "aa35f5c557d85e7c0ad2c306609f4cb3072081e3ef75e13af3f9abd3c6556d07" }, "downloads": -1, "filename": "oar_cli-0.3.1-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "3e05bddfe98a6df660941b3ce5cd5c26", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 19503, "upload_time": "2015-06-23T14:41:28", "url": "https://files.pythonhosted.org/packages/0d/55/9307425d5b5f5b3570fbd08b743baebcd6cb9f8341fea4535a6b91f8d10b/oar_cli-0.3.1-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "909517c1c7fb438af3fe50efd64e07c1", "sha256": "4a8435906a52c09769b9b717615a022be0226f02ce953eaa5002fb35a5a1bc47" }, "downloads": -1, "filename": "oar-cli-0.3.1.tar.gz", "has_sig": false, "md5_digest": "909517c1c7fb438af3fe50efd64e07c1", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 13965, "upload_time": "2015-06-23T14:41:24", "url": "https://files.pythonhosted.org/packages/a2/b8/98774b074349cfcea9c6cf3e029aa551dfa06587bcb19777c7a2ee97e1ef/oar-cli-0.3.1.tar.gz" } ], "0.3.2": [ { "comment_text": "", "digests": { "md5": "73af7cf81cc442d94433cdb18d055a40", "sha256": "187e510314ed3c06347504c86742e530191fde40943e5ac07705db971f36c4a0" }, "downloads": -1, "filename": "oar_cli-0.3.2-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "73af7cf81cc442d94433cdb18d055a40", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 19524, "upload_time": "2015-06-23T14:45:10", "url": "https://files.pythonhosted.org/packages/ff/1b/41b6163bd36f94be88f764d003ea2ee22ccfd94ec202cf48760203a8a65d/oar_cli-0.3.2-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "05009fec9b19354719c9cc71cff6ff14", "sha256": "036d3c6be9e33c7bf9dade801e014e804b0b8a72bc589e8695858ef3ecc9683d" }, "downloads": -1, "filename": "oar-cli-0.3.2.tar.gz", "has_sig": false, "md5_digest": "05009fec9b19354719c9cc71cff6ff14", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 13967, "upload_time": "2015-06-23T14:45:06", "url": "https://files.pythonhosted.org/packages/80/5f/24cf6dd51189dd32e668dcf97c3b127916b0e2ac28e87e8e1aaa75ebac53/oar-cli-0.3.2.tar.gz" } ], "0.3.3": [ { "comment_text": "", "digests": { "md5": "b5bf4e45a8aad6dcfcb93789eddde79b", "sha256": "e5462e9d46523a440bc4b0fbea28727c0d2e600933a4e0cc60961bf67f125779" }, "downloads": -1, "filename": "oar_cli-0.3.3-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "b5bf4e45a8aad6dcfcb93789eddde79b", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 20015, "upload_time": "2015-06-24T21:07:36", "url": "https://files.pythonhosted.org/packages/12/f3/8bffadaa496f85e024861735e74acc93bca7e055b275738155bc68aaef13/oar_cli-0.3.3-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "fc999ed5a15cb81d9f4475eaabd15575", "sha256": "ae3b8e13bcaef5581c3b510983502019d63b58a79c5bad9ee77855d7cc8aaebc" }, "downloads": -1, "filename": "oar-cli-0.3.3.tar.gz", "has_sig": false, "md5_digest": "fc999ed5a15cb81d9f4475eaabd15575", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 16577, "upload_time": "2015-06-24T21:07:32", "url": "https://files.pythonhosted.org/packages/3a/a3/82a7426362a840649231fc01191977000058933275af3cad0998f841ccf2/oar-cli-0.3.3.tar.gz" } ], "0.3.4": [ { "comment_text": "", "digests": { "md5": "22203b357fdc68382fd9b6f68a66b727", "sha256": "6a8cb1111551206f34070889c5e064eb2a3d98cdb4d533e3c15c2539376e79d3" }, "downloads": -1, "filename": "oar_cli-0.3.4-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "22203b357fdc68382fd9b6f68a66b727", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 20035, "upload_time": "2015-07-07T11:34:23", "url": "https://files.pythonhosted.org/packages/05/d2/eaa6121f1191b6e47ba099241b446e0aadd510004670a19ba22c76bef581/oar_cli-0.3.4-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "331d847ebdd29d98b18785d5d8ede780", "sha256": "2c46868d266664f0741d2ab5dcb499c46b6d7af56a540f1582eae48cf480f208" }, "downloads": -1, "filename": "oar-cli-0.3.4.tar.gz", "has_sig": false, "md5_digest": "331d847ebdd29d98b18785d5d8ede780", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 16709, "upload_time": "2015-07-07T11:34:19", "url": "https://files.pythonhosted.org/packages/f9/55/49231eb51d2de3feebeb04a710188e9b9ea058afec59eb4d79f6a7801fd9/oar-cli-0.3.4.tar.gz" } ], "0.3.5": [ { "comment_text": "", "digests": { "md5": "a39d3e68e72a170de126bdb67e498a39", "sha256": "fef46d7c7ac4d6c0584443b15bf5219d5af7d5b4e2680dd48c8a25322a3f91ac" }, "downloads": -1, "filename": "oar_cli-0.3.5-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "a39d3e68e72a170de126bdb67e498a39", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 20324, "upload_time": "2015-07-08T17:54:56", "url": "https://files.pythonhosted.org/packages/3a/f8/93c329b4a44213454b7739f4c7677eb4c99fab35f65bb74a75ee9521c7e0/oar_cli-0.3.5-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "43000aabb902d63394232c556952c9c9", "sha256": "690080965a36cf984b9353be50d53be1097c7fd38c531d27062c9f890b618ab2" }, "downloads": -1, "filename": "oar-cli-0.3.5.tar.gz", "has_sig": false, "md5_digest": "43000aabb902d63394232c556952c9c9", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 17021, "upload_time": "2015-07-08T17:54:52", "url": "https://files.pythonhosted.org/packages/ad/11/4623c56beebf19074cd10f6c01990fcd93302d2e0f179543e87cc44d483f/oar-cli-0.3.5.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "a39d3e68e72a170de126bdb67e498a39", "sha256": "fef46d7c7ac4d6c0584443b15bf5219d5af7d5b4e2680dd48c8a25322a3f91ac" }, "downloads": -1, "filename": "oar_cli-0.3.5-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "a39d3e68e72a170de126bdb67e498a39", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 20324, "upload_time": "2015-07-08T17:54:56", "url": "https://files.pythonhosted.org/packages/3a/f8/93c329b4a44213454b7739f4c7677eb4c99fab35f65bb74a75ee9521c7e0/oar_cli-0.3.5-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "43000aabb902d63394232c556952c9c9", "sha256": "690080965a36cf984b9353be50d53be1097c7fd38c531d27062c9f890b618ab2" }, "downloads": -1, "filename": "oar-cli-0.3.5.tar.gz", "has_sig": false, "md5_digest": "43000aabb902d63394232c556952c9c9", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 17021, "upload_time": "2015-07-08T17:54:52", "url": "https://files.pythonhosted.org/packages/ad/11/4623c56beebf19074cd10f6c01990fcd93302d2e0f179543e87cc44d483f/oar-cli-0.3.5.tar.gz" } ] }