echoss-query


Nameechoss-query JSON
Version 0.0.9 PyPI version JSON
download
home_page
Summaryechoss AI Bigdata Solution - Query Package
upload_time2024-01-05 05:19:13
maintainer
docs_urlNone
authorincheolshin
requires_python>3.7
license
keywords
VCS
bugtrack_url
requirements No requirements were recorded.
Travis-CI No Travis.
coveralls test coverage No coveralls.
            # echoss_query
-------------
사용 전 config(인증 정보) 폴더의 유무를 확인한 뒤 사용해야한다.

### Installaion
-------------
To install this package, please use Python 3.8 or higher. 

Install from Source:
```
    git clone https://gitlab.echoss.net/big-data/solution-center/echoss_query
    cd ~/echoss_query
    pip install -r requirements.txt
```

### Quick Start
-------------
```
    from echoss_query import MysqlQuery, MongoQuery, ElasticSearch

    mysql = MysqlQuery('CONFIG_FILE_PATH' or dict)
    mongo = MongoQuery('CONFIG_FILE_PATH' or dict)
    elastic = ElasticSearch('CONFIG_FILE_PATH' or dict)


    #CREATE
    mysql.create('QUERY_STRING')
    elastic.index(index='INDEX_NAME')

    #DROP
    mysql.drop('QUERY_STRING')
    elastic.delete_index(index='INDEX_NAME')

    #TRUNCATE
    mysql.truncate('QUERY_STRING')

    #ALTER
    mysql.alter('QUERY_STRING')

    #SELECT

    mysql.select('QUERY_STRING')
    mongo.select('COLLECTION_NAME','QUERY_STRING or DICTIONARY')
    elastic.get(id='ID')
    elastic.search(field='FIELD_NAME',value='VALUE')

    elastic.get_source(id='ID') #-> Extract Source
    mysql.faster_select('QUERY_STRING') #-> Use SSCursor
    mysql.select_list('QUERY_STRING') #-> list

    #INSERT

    mysql.insert('QUERY_STRING')
    mongo.insert('COLLECTION_NAME','QUERY_STRING or DICTIONARY')
    elastic.create(id='ID', body='JSON_BODY')

    #UPDATE

    mysql.update('QUERY_STRING')
    mongo.update('COLLECTION_NAME','QUERY_STRING or DICTIONARY')
    elastic.update(id='ID', body='JSON_BODY')
    
    #DELETE

    mysql.delete('QUERY_STRING')
    mongo.delete('COLLECTION_NAME','QUERY_STRING or DICTIONARY')
    elastic.delete(id='ID')
 
    #Check Database

    mysql.databases()
    mongo.databases()

    #Check Tables
    mysql.tables('DB_NAME')

    #-MySQL Util Function-

    # Ping
    mysql.ping()
    elastic.ping()

    # Connection Information
    mysql.conn_info()
    elastic.info()

    # Close
    # crash process close
    mysql.close()
```

### Code Quality
When creating new functions, please follow the Google style Python docstrings. See example below:
```
def example_function(param1: int, param2: str) -> bool:
    """Example function that does something.

    Args:
        param1: The first parameter.
        param2: The second parameter.

    Returns:
        The return value. True for success, False otherwise.

    """
```

            

Raw data

            {
    "_id": null,
    "home_page": "",
    "name": "echoss-query",
    "maintainer": "",
    "docs_url": null,
    "requires_python": ">3.7",
    "maintainer_email": "",
    "keywords": "",
    "author": "incheolshin",
    "author_email": "incheolshin@12cm.co.kr",
    "download_url": "https://files.pythonhosted.org/packages/b2/1e/bb1736729997d584a9642f254146cbfeea7e34d61db620e0a4f04a38ea76/echoss_query-0.0.9.tar.gz",
    "platform": null,
    "description": "# echoss_query\n-------------\n\uc0ac\uc6a9 \uc804 config(\uc778\uc99d \uc815\ubcf4) \ud3f4\ub354\uc758 \uc720\ubb34\ub97c \ud655\uc778\ud55c \ub4a4 \uc0ac\uc6a9\ud574\uc57c\ud55c\ub2e4.\n\n### Installaion\n-------------\nTo install this package, please use Python 3.8 or higher. \n\nInstall from Source:\n```\n    git clone https://gitlab.echoss.net/big-data/solution-center/echoss_query\n    cd ~/echoss_query\n    pip install -r requirements.txt\n```\n\n### Quick Start\n-------------\n```\n    from echoss_query import MysqlQuery, MongoQuery, ElasticSearch\n\n    mysql = MysqlQuery('CONFIG_FILE_PATH' or dict)\n    mongo = MongoQuery('CONFIG_FILE_PATH' or dict)\n    elastic = ElasticSearch('CONFIG_FILE_PATH' or dict)\n\n\n    #CREATE\n    mysql.create('QUERY_STRING')\n    elastic.index(index='INDEX_NAME')\n\n    #DROP\n    mysql.drop('QUERY_STRING')\n    elastic.delete_index(index='INDEX_NAME')\n\n    #TRUNCATE\n    mysql.truncate('QUERY_STRING')\n\n    #ALTER\n    mysql.alter('QUERY_STRING')\n\n    #SELECT\n\n    mysql.select('QUERY_STRING')\n    mongo.select('COLLECTION_NAME','QUERY_STRING or DICTIONARY')\n    elastic.get(id='ID')\n    elastic.search(field='FIELD_NAME',value='VALUE')\n\n    elastic.get_source(id='ID') #-> Extract Source\n    mysql.faster_select('QUERY_STRING') #-> Use SSCursor\n    mysql.select_list('QUERY_STRING') #-> list\n\n    #INSERT\n\n    mysql.insert('QUERY_STRING')\n    mongo.insert('COLLECTION_NAME','QUERY_STRING or DICTIONARY')\n    elastic.create(id='ID', body='JSON_BODY')\n\n    #UPDATE\n\n    mysql.update('QUERY_STRING')\n    mongo.update('COLLECTION_NAME','QUERY_STRING or DICTIONARY')\n    elastic.update(id='ID', body='JSON_BODY')\n    \n    #DELETE\n\n    mysql.delete('QUERY_STRING')\n    mongo.delete('COLLECTION_NAME','QUERY_STRING or DICTIONARY')\n    elastic.delete(id='ID')\n \n    #Check Database\n\n    mysql.databases()\n    mongo.databases()\n\n    #Check Tables\n    mysql.tables('DB_NAME')\n\n    #-MySQL Util Function-\n\n    # Ping\n    mysql.ping()\n    elastic.ping()\n\n    # Connection Information\n    mysql.conn_info()\n    elastic.info()\n\n    # Close\n    # crash process close\n    mysql.close()\n```\n\n### Code Quality\nWhen creating new functions, please follow the Google style Python docstrings. See example below:\n```\ndef example_function(param1: int, param2: str) -> bool:\n    \"\"\"Example function that does something.\n\n    Args:\n        param1: The first parameter.\n        param2: The second parameter.\n\n    Returns:\n        The return value. True for success, False otherwise.\n\n    \"\"\"\n```\n",
    "bugtrack_url": null,
    "license": "",
    "summary": "echoss AI Bigdata Solution - Query Package",
    "version": "0.0.9",
    "project_urls": null,
    "split_keywords": [],
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "7ad56194663e82e3ec97aa472a5c1ffc28199fc249ece009a70909951e7f9808",
                "md5": "719af0abcbe8a044cb77812c1fcc2f35",
                "sha256": "12c09b0b12e0c1bc3a00461fbe17facb6bbe4c476f61a5398af3411fa17b08c1"
            },
            "downloads": -1,
            "filename": "echoss_query-0.0.9-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "719af0abcbe8a044cb77812c1fcc2f35",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": ">3.7",
            "size": 8864,
            "upload_time": "2024-01-05T05:19:12",
            "upload_time_iso_8601": "2024-01-05T05:19:12.019892Z",
            "url": "https://files.pythonhosted.org/packages/7a/d5/6194663e82e3ec97aa472a5c1ffc28199fc249ece009a70909951e7f9808/echoss_query-0.0.9-py3-none-any.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "b21ebb1736729997d584a9642f254146cbfeea7e34d61db620e0a4f04a38ea76",
                "md5": "7582d9fcb6d7774f07e7a63b3352289a",
                "sha256": "15fc577b1be8c37af8adb825b0d58cf3c87a14914ce9a818058cdce254bb15e4"
            },
            "downloads": -1,
            "filename": "echoss_query-0.0.9.tar.gz",
            "has_sig": false,
            "md5_digest": "7582d9fcb6d7774f07e7a63b3352289a",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": ">3.7",
            "size": 8791,
            "upload_time": "2024-01-05T05:19:13",
            "upload_time_iso_8601": "2024-01-05T05:19:13.801850Z",
            "url": "https://files.pythonhosted.org/packages/b2/1e/bb1736729997d584a9642f254146cbfeea7e34d61db620e0a4f04a38ea76/echoss_query-0.0.9.tar.gz",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "upload_time": "2024-01-05 05:19:13",
    "github": false,
    "gitlab": false,
    "bitbucket": false,
    "codeberg": false,
    "lcname": "echoss-query"
}
        
Elapsed time: 0.18539s