2023-07-26T03:04:17,337 Created temporary directory: /tmp/pip-build-tracker-abyjx2h3 2023-07-26T03:04:17,340 Initialized build tracking at /tmp/pip-build-tracker-abyjx2h3 2023-07-26T03:04:17,340 Created build tracker: /tmp/pip-build-tracker-abyjx2h3 2023-07-26T03:04:17,340 Entered build tracker: /tmp/pip-build-tracker-abyjx2h3 2023-07-26T03:04:17,342 Created temporary directory: /tmp/pip-wheel-r5irubf0 2023-07-26T03:04:17,350 Created temporary directory: /tmp/pip-ephem-wheel-cache-_ljifn5g 2023-07-26T03:04:17,405 Looking in indexes: https://pypi.org/simple, https://www.piwheels.org/simple 2023-07-26T03:04:17,414 2 location(s) to search for versions of echoss-query: 2023-07-26T03:04:17,414 * https://pypi.org/simple/echoss-query/ 2023-07-26T03:04:17,414 * https://www.piwheels.org/simple/echoss-query/ 2023-07-26T03:04:17,415 Fetching project page and analyzing links: https://pypi.org/simple/echoss-query/ 2023-07-26T03:04:17,416 Getting page https://pypi.org/simple/echoss-query/ 2023-07-26T03:04:17,420 Found index url https://pypi.org/simple/ 2023-07-26T03:04:17,528 Fetched page https://pypi.org/simple/echoss-query/ as application/vnd.pypi.simple.v1+json 2023-07-26T03:04:17,534 Skipping link: No binaries permitted for echoss-query: https://files.pythonhosted.org/packages/5a/a7/ddf13a6f3e921bb2b1a62cc324fffa8074cd03cf1cdb7225d5f2893913cd/echoss_query-0.0.1-py3-none-any.whl (from https://pypi.org/simple/echoss-query/) (requires-python:>3.7) 2023-07-26T03:04:17,535 Found link https://files.pythonhosted.org/packages/b7/cb/b7cd8881a68e94b66f83245834ee86da3c283385e4b7d3570b795c7d0924/echoss_query-0.0.1.tar.gz (from https://pypi.org/simple/echoss-query/) (requires-python:>3.7), version: 0.0.1 2023-07-26T03:04:17,536 Skipping link: No binaries permitted for echoss-query: https://files.pythonhosted.org/packages/e5/50/f5ba0f6048ddbe518170c71749e4dd5cccaaa99f3d073d82b1a39285d855/echoss_query-0.0.2-py3-none-any.whl (from https://pypi.org/simple/echoss-query/) (requires-python:>3.7) 2023-07-26T03:04:17,537 Found link https://files.pythonhosted.org/packages/92/ac/0cb06eef54574ea563f1dd6b7a35e092fb05f62c2d92821bf5ab7c98756d/echoss_query-0.0.2.tar.gz (from https://pypi.org/simple/echoss-query/) (requires-python:>3.7), version: 0.0.2 2023-07-26T03:04:17,538 Skipping link: No binaries permitted for echoss-query: https://files.pythonhosted.org/packages/5f/6f/55d15831401f7f1f9c8a05b2996a469d97d1ce2128d0cbe2cd106fea9f7b/echoss_query-0.0.3-py3-none-any.whl (from https://pypi.org/simple/echoss-query/) (requires-python:>3.7) 2023-07-26T03:04:17,539 Found link https://files.pythonhosted.org/packages/b9/92/caa524de752bf0d15ea63a185876673f43c5cf6d09de2adaab0d60ac04cf/echoss_query-0.0.3.tar.gz (from https://pypi.org/simple/echoss-query/) (requires-python:>3.7), version: 0.0.3 2023-07-26T03:04:17,540 Skipping link: No binaries permitted for echoss-query: https://files.pythonhosted.org/packages/ac/ba/b284b4ac41fd0f387b205985182ab3abf434fda5fd3d3df9e4fd6bda8bc3/echoss_query-0.0.4-py3-none-any.whl (from https://pypi.org/simple/echoss-query/) (requires-python:>3.7) 2023-07-26T03:04:17,541 Found link https://files.pythonhosted.org/packages/89/59/09018c5eeb6c568ce568834f03f674142376ce670296bb6042f3073bebb3/echoss_query-0.0.4.tar.gz (from https://pypi.org/simple/echoss-query/) (requires-python:>3.7), version: 0.0.4 2023-07-26T03:04:17,542 Fetching project page and analyzing links: https://www.piwheels.org/simple/echoss-query/ 2023-07-26T03:04:17,543 Getting page https://www.piwheels.org/simple/echoss-query/ 2023-07-26T03:04:17,545 Found index url https://www.piwheels.org/simple/ 2023-07-26T03:04:17,757 Fetched page https://www.piwheels.org/simple/echoss-query/ as text/html 2023-07-26T03:04:17,760 Skipping link: No binaries permitted for echoss-query: https://www.piwheels.org/simple/echoss-query/echoss_query-0.0.1-py3-none-any.whl#sha256=83f507de250794be6b8f2eb053a3803e24bbdefe44ad1b574a2fb57efc08c35c (from https://www.piwheels.org/simple/echoss-query/) (requires-python:>3.7) 2023-07-26T03:04:17,761 Skipping link: not a file: https://www.piwheels.org/simple/echoss-query/ 2023-07-26T03:04:17,762 Skipping link: not a file: https://pypi.org/simple/echoss-query/ 2023-07-26T03:04:17,795 Given no hashes to check 1 links for project 'echoss-query': discarding no candidates 2023-07-26T03:04:17,826 Collecting echoss-query==0.0.2 2023-07-26T03:04:17,831 Created temporary directory: /tmp/pip-unpack-a4_ljrpf 2023-07-26T03:04:17,999 Downloading echoss_query-0.0.2.tar.gz (2.3 kB) 2023-07-26T03:04:18,056 Added echoss-query==0.0.2 from https://files.pythonhosted.org/packages/92/ac/0cb06eef54574ea563f1dd6b7a35e092fb05f62c2d92821bf5ab7c98756d/echoss_query-0.0.2.tar.gz to build tracker '/tmp/pip-build-tracker-abyjx2h3' 2023-07-26T03:04:18,059 Running setup.py (path:/tmp/pip-wheel-r5irubf0/echoss-query_30c73d86f32b4db9a00328098fdf09ab/setup.py) egg_info for package echoss-query 2023-07-26T03:04:18,061 Created temporary directory: /tmp/pip-pip-egg-info-s0lgy198 2023-07-26T03:04:18,062 Preparing metadata (setup.py): started 2023-07-26T03:04:18,064 Running command python setup.py egg_info 2023-07-26T03:04:19,797 # echoss_query 2023-07-26T03:04:19,798 ------------- 2023-07-26T03:04:19,799 사용 전 config(인증 정보) 폴더의 유무를 확인한 뒤 사용해야한다. 2023-07-26T03:04:19,799 ### Installaion 2023-07-26T03:04:19,800 ------------- 2023-07-26T03:04:19,800 To install this package, please use Python 3.8 or higher. 2023-07-26T03:04:19,801 Install from Source: 2023-07-26T03:04:19,801 ``` 2023-07-26T03:04:19,801 git clone https://gitlab.echoss.net/big-data/solution-center/echoss_query 2023-07-26T03:04:19,802 cd ~/echoss_query 2023-07-26T03:04:19,802 pip install -r requirements.txt 2023-07-26T03:04:19,802 ``` 2023-07-26T03:04:19,803 ### Quick Start 2023-07-26T03:04:19,803 ------------- 2023-07-26T03:04:19,803 ``` 2023-07-26T03:04:19,804 from echoss_query.query import echoss_query 2023-07-26T03:04:19,804 from echoss_query.dsl import query_dsl 2023-07-26T03:04:19,805 mysql = echoss_query.MysqlQuery('CONFIG_FILE_PATH' or dict) 2023-07-26T03:04:19,805 mongo = echoss_query.MongoQuery('CONFIG_FILE_PATH' or dict) 2023-07-26T03:04:19,806 elastic = query_dsl.ElasticSearch('CONFIG_FILE_PATH' or dict) 2023-07-26T03:04:19,807 #CREATE 2023-07-26T03:04:19,807 mysql.create('QUERY_STRING') 2023-07-26T03:04:19,808 elastic.index(index='INDEX_NAME') 2023-07-26T03:04:19,808 #DROP 2023-07-26T03:04:19,809 mysql.drop('QUERY_STRING') 2023-07-26T03:04:19,809 elastic.delete_index(index='INDEX_NAME') 2023-07-26T03:04:19,810 #TRUNCATE 2023-07-26T03:04:19,810 mysql.truncate('QUERY_STRING') 2023-07-26T03:04:19,811 #ALTER 2023-07-26T03:04:19,811 mysql.alter('QUERY_STRING') 2023-07-26T03:04:19,812 #SELECT 2023-07-26T03:04:19,813 mysql.select('QUERY_STRING') 2023-07-26T03:04:19,813 mongo.select('COLLECTION_NAME','QUERY_STRING or DICTIONARY') 2023-07-26T03:04:19,813 elastic.get(id='ID') 2023-07-26T03:04:19,814 elastic.search(field='FIELD_NAME',value='VALUE') 2023-07-26T03:04:19,814 elastic.get_source(id='ID') #-> Extract Source 2023-07-26T03:04:19,815 mysql.faster_select('QUERY_STRING') #-> Use SSCursor 2023-07-26T03:04:19,815 mysql.select_list('QUERY_STRING') #-> list 2023-07-26T03:04:19,816 #INSERT 2023-07-26T03:04:19,816 mysql.insert('QUERY_STRING') 2023-07-26T03:04:19,817 mongo.insert('COLLECTION_NAME','QUERY_STRING or DICTIONARY') 2023-07-26T03:04:19,817 elastic.create(id='ID', body='JSON_BODY') 2023-07-26T03:04:19,818 #UPDATE 2023-07-26T03:04:19,818 mysql.update('QUERY_STRING') 2023-07-26T03:04:19,819 mongo.update('COLLECTION_NAME','QUERY_STRING or DICTIONARY') 2023-07-26T03:04:19,819 elastic.update(id='ID', body='JSON_BODY') 2023-07-26T03:04:19,820 #DELETE 2023-07-26T03:04:19,821 mysql.delete('QUERY_STRING') 2023-07-26T03:04:19,821 mongo.delete('COLLECTION_NAME','QUERY_STRING or DICTIONARY') 2023-07-26T03:04:19,821 elastic.delete(id='ID') 2023-07-26T03:04:19,822 #Check Database 2023-07-26T03:04:19,823 mysql.databases() 2023-07-26T03:04:19,823 mongo.databases() 2023-07-26T03:04:19,824 #Check Tables 2023-07-26T03:04:19,824 mysql.tables('DB_NAME') 2023-07-26T03:04:19,824 #-MySQL Util Function- 2023-07-26T03:04:19,825 # Ping 2023-07-26T03:04:19,825 mysql.ping() 2023-07-26T03:04:19,826 elastic.ping() 2023-07-26T03:04:19,826 # Connection Information 2023-07-26T03:04:19,827 mysql.conn_info() 2023-07-26T03:04:19,827 elastic.info() 2023-07-26T03:04:19,828 # Close 2023-07-26T03:04:19,828 # crash process close 2023-07-26T03:04:19,828 mysql.close() 2023-07-26T03:04:19,829 ``` 2023-07-26T03:04:19,829 ### Code Quality 2023-07-26T03:04:19,830 When creating new functions, please follow the Google style Python docstrings. See example below: 2023-07-26T03:04:19,830 ``` 2023-07-26T03:04:19,830 def example_function(param1: int, param2: str) -> bool: 2023-07-26T03:04:19,830 """Example function that does something. 2023-07-26T03:04:19,831 Args: 2023-07-26T03:04:19,832 param1: The first parameter. 2023-07-26T03:04:19,832 param2: The second parameter. 2023-07-26T03:04:19,833 Returns: 2023-07-26T03:04:19,833 The return value. True for success, False otherwise. 2023-07-26T03:04:19,834 """ 2023-07-26T03:04:19,834 ``` 2023-07-26T03:04:19,834 running egg_info 2023-07-26T03:04:19,835 creating /tmp/pip-pip-egg-info-s0lgy198/echoss_query.egg-info 2023-07-26T03:04:19,874 writing /tmp/pip-pip-egg-info-s0lgy198/echoss_query.egg-info/PKG-INFO 2023-07-26T03:04:19,879 writing dependency_links to /tmp/pip-pip-egg-info-s0lgy198/echoss_query.egg-info/dependency_links.txt 2023-07-26T03:04:19,884 writing top-level names to /tmp/pip-pip-egg-info-s0lgy198/echoss_query.egg-info/top_level.txt 2023-07-26T03:04:19,888 writing manifest file '/tmp/pip-pip-egg-info-s0lgy198/echoss_query.egg-info/SOURCES.txt' 2023-07-26T03:04:20,089 reading manifest file '/tmp/pip-pip-egg-info-s0lgy198/echoss_query.egg-info/SOURCES.txt' 2023-07-26T03:04:20,096 writing manifest file '/tmp/pip-pip-egg-info-s0lgy198/echoss_query.egg-info/SOURCES.txt' 2023-07-26T03:04:20,216 Preparing metadata (setup.py): finished with status 'done' 2023-07-26T03:04:20,228 Source in /tmp/pip-wheel-r5irubf0/echoss-query_30c73d86f32b4db9a00328098fdf09ab has version 0.0.2, which satisfies requirement echoss-query==0.0.2 from https://files.pythonhosted.org/packages/92/ac/0cb06eef54574ea563f1dd6b7a35e092fb05f62c2d92821bf5ab7c98756d/echoss_query-0.0.2.tar.gz 2023-07-26T03:04:20,230 Removed echoss-query==0.0.2 from https://files.pythonhosted.org/packages/92/ac/0cb06eef54574ea563f1dd6b7a35e092fb05f62c2d92821bf5ab7c98756d/echoss_query-0.0.2.tar.gz from build tracker '/tmp/pip-build-tracker-abyjx2h3' 2023-07-26T03:04:20,244 Created temporary directory: /tmp/pip-unpack-79a6ouon 2023-07-26T03:04:20,245 Building wheels for collected packages: echoss-query 2023-07-26T03:04:20,258 Created temporary directory: /tmp/pip-wheel-ksgjeox4 2023-07-26T03:04:20,259 Building wheel for echoss-query (setup.py): started 2023-07-26T03:04:20,261 Destination directory: /tmp/pip-wheel-ksgjeox4 2023-07-26T03:04:20,261 Running command python setup.py bdist_wheel 2023-07-26T03:04:21,551 # echoss_query 2023-07-26T03:04:21,553 ------------- 2023-07-26T03:04:21,553 사용 전 config(인증 정보) 폴더의 유무를 확인한 뒤 사용해야한다. 2023-07-26T03:04:21,554 ### Installaion 2023-07-26T03:04:21,554 ------------- 2023-07-26T03:04:21,555 To install this package, please use Python 3.8 or higher. 2023-07-26T03:04:21,555 Install from Source: 2023-07-26T03:04:21,556 ``` 2023-07-26T03:04:21,556 git clone https://gitlab.echoss.net/big-data/solution-center/echoss_query 2023-07-26T03:04:21,557 cd ~/echoss_query 2023-07-26T03:04:21,557 pip install -r requirements.txt 2023-07-26T03:04:21,557 ``` 2023-07-26T03:04:21,558 ### Quick Start 2023-07-26T03:04:21,558 ------------- 2023-07-26T03:04:21,559 ``` 2023-07-26T03:04:21,559 from echoss_query.query import echoss_query 2023-07-26T03:04:21,559 from echoss_query.dsl import query_dsl 2023-07-26T03:04:21,560 mysql = echoss_query.MysqlQuery('CONFIG_FILE_PATH' or dict) 2023-07-26T03:04:21,560 mongo = echoss_query.MongoQuery('CONFIG_FILE_PATH' or dict) 2023-07-26T03:04:21,561 elastic = query_dsl.ElasticSearch('CONFIG_FILE_PATH' or dict) 2023-07-26T03:04:21,562 #CREATE 2023-07-26T03:04:21,562 mysql.create('QUERY_STRING') 2023-07-26T03:04:21,563 elastic.index(index='INDEX_NAME') 2023-07-26T03:04:21,563 #DROP 2023-07-26T03:04:21,564 mysql.drop('QUERY_STRING') 2023-07-26T03:04:21,564 elastic.delete_index(index='INDEX_NAME') 2023-07-26T03:04:21,565 #TRUNCATE 2023-07-26T03:04:21,565 mysql.truncate('QUERY_STRING') 2023-07-26T03:04:21,566 #ALTER 2023-07-26T03:04:21,566 mysql.alter('QUERY_STRING') 2023-07-26T03:04:21,567 #SELECT 2023-07-26T03:04:21,568 mysql.select('QUERY_STRING') 2023-07-26T03:04:21,568 mongo.select('COLLECTION_NAME','QUERY_STRING or DICTIONARY') 2023-07-26T03:04:21,568 elastic.get(id='ID') 2023-07-26T03:04:21,569 elastic.search(field='FIELD_NAME',value='VALUE') 2023-07-26T03:04:21,570 elastic.get_source(id='ID') #-> Extract Source 2023-07-26T03:04:21,570 mysql.faster_select('QUERY_STRING') #-> Use SSCursor 2023-07-26T03:04:21,570 mysql.select_list('QUERY_STRING') #-> list 2023-07-26T03:04:21,571 #INSERT 2023-07-26T03:04:21,572 mysql.insert('QUERY_STRING') 2023-07-26T03:04:21,572 mongo.insert('COLLECTION_NAME','QUERY_STRING or DICTIONARY') 2023-07-26T03:04:21,572 elastic.create(id='ID', body='JSON_BODY') 2023-07-26T03:04:21,573 #UPDATE 2023-07-26T03:04:21,573 mysql.update('QUERY_STRING') 2023-07-26T03:04:21,574 mongo.update('COLLECTION_NAME','QUERY_STRING or DICTIONARY') 2023-07-26T03:04:21,574 elastic.update(id='ID', body='JSON_BODY') 2023-07-26T03:04:21,575 #DELETE 2023-07-26T03:04:21,575 mysql.delete('QUERY_STRING') 2023-07-26T03:04:21,576 mongo.delete('COLLECTION_NAME','QUERY_STRING or DICTIONARY') 2023-07-26T03:04:21,576 elastic.delete(id='ID') 2023-07-26T03:04:21,577 #Check Database 2023-07-26T03:04:21,577 mysql.databases() 2023-07-26T03:04:21,577 mongo.databases() 2023-07-26T03:04:21,578 #Check Tables 2023-07-26T03:04:21,578 mysql.tables('DB_NAME') 2023-07-26T03:04:21,579 #-MySQL Util Function- 2023-07-26T03:04:21,579 # Ping 2023-07-26T03:04:21,580 mysql.ping() 2023-07-26T03:04:21,580 elastic.ping() 2023-07-26T03:04:21,581 # Connection Information 2023-07-26T03:04:21,581 mysql.conn_info() 2023-07-26T03:04:21,581 elastic.info() 2023-07-26T03:04:21,582 # Close 2023-07-26T03:04:21,582 # crash process close 2023-07-26T03:04:21,583 mysql.close() 2023-07-26T03:04:21,583 ``` 2023-07-26T03:04:21,583 ### Code Quality 2023-07-26T03:04:21,584 When creating new functions, please follow the Google style Python docstrings. See example below: 2023-07-26T03:04:21,584 ``` 2023-07-26T03:04:21,585 def example_function(param1: int, param2: str) -> bool: 2023-07-26T03:04:21,585 """Example function that does something. 2023-07-26T03:04:21,586 Args: 2023-07-26T03:04:21,586 param1: The first parameter. 2023-07-26T03:04:21,586 param2: The second parameter. 2023-07-26T03:04:21,587 Returns: 2023-07-26T03:04:21,587 The return value. True for success, False otherwise. 2023-07-26T03:04:21,588 """ 2023-07-26T03:04:21,588 ``` 2023-07-26T03:04:22,067 running bdist_wheel 2023-07-26T03:04:22,787 running build 2023-07-26T03:04:22,788 running build_py 2023-07-26T03:04:22,860 creating build 2023-07-26T03:04:22,861 creating build/lib 2023-07-26T03:04:22,863 creating build/lib/echoss_query 2023-07-26T03:04:22,866 copying echoss_query/__init__.py -> build/lib/echoss_query 2023-07-26T03:04:22,946 /home/piwheels/.local/lib/python3.7/site-packages/setuptools/_distutils/cmd.py:66: SetuptoolsDeprecationWarning: setup.py install is deprecated. 2023-07-26T03:04:22,947 !! 2023-07-26T03:04:22,947 ******************************************************************************** 2023-07-26T03:04:22,948 Please avoid running ``setup.py`` directly. 2023-07-26T03:04:22,948 Instead, use pypa/build, pypa/installer, pypa/build or 2023-07-26T03:04:22,948 other standards-based tools. 2023-07-26T03:04:22,949 See https://blog.ganssle.io/articles/2021/10/setup-py-deprecated.html for details. 2023-07-26T03:04:22,949 ******************************************************************************** 2023-07-26T03:04:22,950 !! 2023-07-26T03:04:22,950 self.initialize_options() 2023-07-26T03:04:23,019 installing to build/bdist.linux-armv7l/wheel 2023-07-26T03:04:23,020 running install 2023-07-26T03:04:23,080 running install_lib 2023-07-26T03:04:23,148 creating build/bdist.linux-armv7l 2023-07-26T03:04:23,150 creating build/bdist.linux-armv7l/wheel 2023-07-26T03:04:23,154 creating build/bdist.linux-armv7l/wheel/echoss_query 2023-07-26T03:04:23,156 copying build/lib/echoss_query/__init__.py -> build/bdist.linux-armv7l/wheel/echoss_query 2023-07-26T03:04:23,160 running install_egg_info 2023-07-26T03:04:23,324 running egg_info 2023-07-26T03:04:23,387 writing echoss_query.egg-info/PKG-INFO 2023-07-26T03:04:23,392 writing dependency_links to echoss_query.egg-info/dependency_links.txt 2023-07-26T03:04:23,397 writing top-level names to echoss_query.egg-info/top_level.txt 2023-07-26T03:04:23,466 reading manifest file 'echoss_query.egg-info/SOURCES.txt' 2023-07-26T03:04:23,474 writing manifest file 'echoss_query.egg-info/SOURCES.txt' 2023-07-26T03:04:23,477 Copying echoss_query.egg-info to build/bdist.linux-armv7l/wheel/echoss_query-0.0.2-py3.7.egg-info 2023-07-26T03:04:23,494 running install_scripts 2023-07-26T03:04:23,516 creating build/bdist.linux-armv7l/wheel/echoss_query-0.0.2.dist-info/WHEEL 2023-07-26T03:04:23,522 creating '/tmp/pip-wheel-ksgjeox4/echoss_query-0.0.2-py3-none-any.whl' and adding 'build/bdist.linux-armv7l/wheel' to it 2023-07-26T03:04:23,527 adding 'echoss_query/__init__.py' 2023-07-26T03:04:23,533 adding 'echoss_query-0.0.2.dist-info/METADATA' 2023-07-26T03:04:23,536 adding 'echoss_query-0.0.2.dist-info/WHEEL' 2023-07-26T03:04:23,538 adding 'echoss_query-0.0.2.dist-info/top_level.txt' 2023-07-26T03:04:23,541 adding 'echoss_query-0.0.2.dist-info/RECORD' 2023-07-26T03:04:23,543 removing build/bdist.linux-armv7l/wheel 2023-07-26T03:04:23,702 Building wheel for echoss-query (setup.py): finished with status 'done' 2023-07-26T03:04:23,709 Created wheel for echoss-query: filename=echoss_query-0.0.2-py3-none-any.whl size=2413 sha256=3f5e3b261934f0b9b9abb43832a40e9ae1e120c903917f47f558962ef9cb4bd6 2023-07-26T03:04:23,711 Stored in directory: /tmp/pip-ephem-wheel-cache-_ljifn5g/wheels/fb/92/a4/78a3ba34715ee1d9f4eec8797e9c59571e1ac3298d174962b0 2023-07-26T03:04:23,736 Successfully built echoss-query 2023-07-26T03:04:23,742 Removed build tracker: '/tmp/pip-build-tracker-abyjx2h3'