robotframework-oracledb-library


Namerobotframework-oracledb-library JSON
Version 0.1.4 PyPI version JSON
download
home_pagehttps://github.com/adeliogullari/robotframework-oracledb-library
SummaryOracle database library for Robot Framework
upload_time2023-12-25 19:18:31
maintainer
docs_urlNone
authorAbdullah Deliogullari
requires_python>=3.6, <4
licenseApache License 2.0
keywords robotframework testing testautomation oracle database
VCS
bugtrack_url
requirements No requirements were recorded.
Travis-CI No Travis.
coveralls test coverage No coveralls. 
            # OracleDBLibrary
OracleDBLibrary is a database testing library for Robot Framework that utilizes the python-oracledb tool internally.
The project is hosted on GitHub and downloads can be found from PyPI.

[![License](https://img.shields.io/badge/License-Apache_2.0-blue.svg)](https://opensource.org/licenses/Apache-2.0)

## Installation

The recommended installation method is using pip

    pip install --upgrade robotframework-oracledb-library

## Usage
To use OracleDBLibrary in Robot Framework tests, the library needs to first be imported using the ``Library`` setting as any other library.

When using Robot Framework, it is generally recommended writing as easy-to-understand tests as possible. 
The keywords provided by OracleDBLibrary is pretty low level, though, and often require implementation-specific arguments like data source name (DSN) to be passed as arguments. 
It is thus typically a good idea to write tests using Robot Framework's higher-level keywords that utilize OracleDBLibrary keywords internally. 
This is illustrated by the following example where OracleDBLibrary keywords like ``ORACLE MAKEDSN``, ``ORACLE CONNECT``, ``ORACLE CONNECTION PING`` and ``ORACLE CONNECTION CLOSE`` are primarily used by higher-level keywords like ``CONNECT TO ORACLE DATABASE WITH SID``.

    *** Settings ***
    Library           OracleDBLibrary

    *** Variables ***
    ${HOST}      localhost
    ${PORT}      1521
    ${SID}       ORCLCDB
    ${USER}      SYS
    ${PASSWORD}  Oradoc_db1
    ${MODE}      SYSDBA

    *** Test Cases ***
    CONNECT TO ORACLE DATABASE AND INSERT DATA
        CONNECT TO ORACLE DATABASE WITH SID
        INSERT DATA INTO ORACLE DATABASE
        DROP ORACLE DATABASE TABLE
        CLOSE ORACLE DATABASE CONNECTION AND CURSOR

    *** Keywords ***
    CONNECT TO ORACLE DATABASE WITH SID
        ${DSN}  ORACLE MAKEDSN  host=${HOST}  port=${PORT}  sid=${SID}
        ORACLE CONNECT  user=${USER}  password=${PASSWORD}  dsn=${DSN}  mode=${MODE}
        ${CONNECTION STATUS}  ORACLE CONNECTION PING
        SHOULD BE EQUAL  ${CONNECTION STATUS}  ${NONE}
    
    INSERT DATA INTO ORACLE DATABASE
        ORACLE CONNECTION CURSOR
        ${FIRST TABLE ROW}   EVALUATE  (1432, 'Abdullah', 'Deliogullari')
        ${SECOND TABLE ROW}  EVALUATE  (1453, 'Ahmet Burhan', 'Kutuk')
        ${THIRD TABLE ROW}   EVALUATE  (1481, 'Erim', 'Cerrahoglu')
        ORACLE CURSOR EXECUTE  CREATE TABLE persons (person_id NUMBER GENERATED BY DEFAULT AS IDENTITY, first_name VARCHAR2(50) NOT NULL, last_name VARCHAR2(50) NOT NULL, PRIMARY KEY(person_id))
        ORACLE CURSOR EXECUTE  INSERT INTO persons (person_id, first_name, last_name) VALUES ${FIRST TABLE ROW}
        ORACLE CURSOR EXECUTE  INSERT INTO persons (person_id, first_name, last_name) VALUES ${SECOND TABLE ROW}
        ORACLE CURSOR EXECUTE  INSERT INTO persons (person_id, first_name, last_name) VALUES ${THIRD TABLE ROW}
        ORACLE CONNECTION COMMIT

    DROP ORACLE DATABASE TABLE
        ORACLE CURSOR EXECUTE  DROP TABLE persons
        ORACLE CONNECTION COMMIT

    CLOSE ORACLE DATABASE CONNECTION AND CURSOR
        ORACLE CURSOR CLOSE
        ORACLE CONNECTION CLOSE

## License

RobotFramework OracleDB Library is open source software provided under the `Apache License 2.0`

Raw data

            {
    "_id": null,
    "home_page": "https://github.com/adeliogullari/robotframework-oracledb-library",
    "name": "robotframework-oracledb-library",
    "maintainer": "",
    "docs_url": null,
    "requires_python": ">=3.6, <4",
    "maintainer_email": "",
    "keywords": "robotframework testing testautomation oracle database",
    "author": "Abdullah Deliogullari",
    "author_email": "abdullahdeliogullari@yaani.com",
    "download_url": "https://files.pythonhosted.org/packages/de/e2/8be9ce12e1f14f859a4b9fdeff3b50885a9fa61ca6c3e0f868068a5d3513/robotframework-oracledb-library-0.1.4.tar.gz",
    "platform": "any",
    "description": "# OracleDBLibrary\nOracleDBLibrary is a database testing library for Robot Framework that utilizes the python-oracledb tool internally.\nThe project is hosted on GitHub and downloads can be found from PyPI.\n\n[![License](https://img.shields.io/badge/License-Apache_2.0-blue.svg)](https://opensource.org/licenses/Apache-2.0)\n\n## Installation\n\nThe recommended installation method is using pip\n\n    pip install --upgrade robotframework-oracledb-library\n\n## Usage\nTo use OracleDBLibrary in Robot Framework tests, the library needs to first be imported using the ``Library`` setting as any other library.\n\nWhen using Robot Framework, it is generally recommended writing as easy-to-understand tests as possible. \nThe keywords provided by OracleDBLibrary is pretty low level, though, and often require implementation-specific arguments like data source name (DSN) to be passed as arguments. \nIt is thus typically a good idea to write tests using Robot Framework's higher-level keywords that utilize OracleDBLibrary keywords internally. \nThis is illustrated by the following example where OracleDBLibrary keywords like ``ORACLE MAKEDSN``, ``ORACLE CONNECT``, ``ORACLE CONNECTION PING`` and ``ORACLE CONNECTION CLOSE`` are primarily used by higher-level keywords like ``CONNECT TO ORACLE DATABASE WITH SID``.\n\n    *** Settings ***\n    Library           OracleDBLibrary\n\n    *** Variables ***\n    ${HOST}      localhost\n    ${PORT}      1521\n    ${SID}       ORCLCDB\n    ${USER}      SYS\n    ${PASSWORD}  Oradoc_db1\n    ${MODE}      SYSDBA\n\n    *** Test Cases ***\n    CONNECT TO ORACLE DATABASE AND INSERT DATA\n        CONNECT TO ORACLE DATABASE WITH SID\n        INSERT DATA INTO ORACLE DATABASE\n        DROP ORACLE DATABASE TABLE\n        CLOSE ORACLE DATABASE CONNECTION AND CURSOR\n\n    *** Keywords ***\n    CONNECT TO ORACLE DATABASE WITH SID\n        ${DSN}  ORACLE MAKEDSN  host=${HOST}  port=${PORT}  sid=${SID}\n        ORACLE CONNECT  user=${USER}  password=${PASSWORD}  dsn=${DSN}  mode=${MODE}\n        ${CONNECTION STATUS}  ORACLE CONNECTION PING\n        SHOULD BE EQUAL  ${CONNECTION STATUS}  ${NONE}\n    \n    INSERT DATA INTO ORACLE DATABASE\n        ORACLE CONNECTION CURSOR\n        ${FIRST TABLE ROW}   EVALUATE  (1432, 'Abdullah', 'Deliogullari')\n        ${SECOND TABLE ROW}  EVALUATE  (1453, 'Ahmet Burhan', 'Kutuk')\n        ${THIRD TABLE ROW}   EVALUATE  (1481, 'Erim', 'Cerrahoglu')\n        ORACLE CURSOR EXECUTE  CREATE TABLE persons (person_id NUMBER GENERATED BY DEFAULT AS IDENTITY, first_name VARCHAR2(50) NOT NULL, last_name VARCHAR2(50) NOT NULL, PRIMARY KEY(person_id))\n        ORACLE CURSOR EXECUTE  INSERT INTO persons (person_id, first_name, last_name) VALUES ${FIRST TABLE ROW}\n        ORACLE CURSOR EXECUTE  INSERT INTO persons (person_id, first_name, last_name) VALUES ${SECOND TABLE ROW}\n        ORACLE CURSOR EXECUTE  INSERT INTO persons (person_id, first_name, last_name) VALUES ${THIRD TABLE ROW}\n        ORACLE CONNECTION COMMIT\n\n    DROP ORACLE DATABASE TABLE\n        ORACLE CURSOR EXECUTE  DROP TABLE persons\n        ORACLE CONNECTION COMMIT\n\n    CLOSE ORACLE DATABASE CONNECTION AND CURSOR\n        ORACLE CURSOR CLOSE\n        ORACLE CONNECTION CLOSE\n\n## License\n\nRobotFramework OracleDB Library is open source software provided under the `Apache License 2.0`\n",
    "bugtrack_url": null,
    "license": "Apache License 2.0",
    "summary": "Oracle database library for Robot Framework",
    "version": "0.1.4",
    "project_urls": {
        "Homepage": "https://github.com/adeliogullari/robotframework-oracledb-library"
    },
    "split_keywords": [
        "robotframework",
        "testing",
        "testautomation",
        "oracle",
        "database"
    ],
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "8f4ef71927a03b8f284a9813b55936423ce3d3b1adde5b28ebc73244b049e49d",
                "md5": "f192843f068e2e68c0eedb4b2e65836b",
                "sha256": "af62c1e98a5cf4a9c7978aaca025d5632ddd571d44aac913ccc97ad21ca0edc6"
            },
            "downloads": -1,
            "filename": "robotframework_oracledb_library-0.1.4-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "f192843f068e2e68c0eedb4b2e65836b",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": ">=3.6, <4",
            "size": 12783,
            "upload_time": "2023-12-25T19:18:30",
            "upload_time_iso_8601": "2023-12-25T19:18:30.144640Z",
            "url": "https://files.pythonhosted.org/packages/8f/4e/f71927a03b8f284a9813b55936423ce3d3b1adde5b28ebc73244b049e49d/robotframework_oracledb_library-0.1.4-py3-none-any.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "dee28be9ce12e1f14f859a4b9fdeff3b50885a9fa61ca6c3e0f868068a5d3513",
                "md5": "0f552a448564e1545353e8e5352073c5",
                "sha256": "9b69ce1539df6915e7b965ba2ac9a7f09df1db487d7a4db45664b3d6a335866d"
            },
            "downloads": -1,
            "filename": "robotframework-oracledb-library-0.1.4.tar.gz",
            "has_sig": false,
            "md5_digest": "0f552a448564e1545353e8e5352073c5",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": ">=3.6, <4",
            "size": 11995,
            "upload_time": "2023-12-25T19:18:31",
            "upload_time_iso_8601": "2023-12-25T19:18:31.680015Z",
            "url": "https://files.pythonhosted.org/packages/de/e2/8be9ce12e1f14f859a4b9fdeff3b50885a9fa61ca6c3e0f868068a5d3513/robotframework-oracledb-library-0.1.4.tar.gz",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "upload_time": "2023-12-25 19:18:31",
    "github": true,
    "gitlab": false,
    "bitbucket": false,
    "codeberg": false,
    "github_user": "adeliogullari",
    "github_project": "robotframework-oracledb-library",
    "travis_ci": false,
    "coveralls": false,
    "github_actions": true,
    "requirements": [],
    "lcname": "robotframework-oracledb-library"
}
Abdullah Deliogullari
Elapsed time: 0.17595s