2023-07-26T03:10:43,213 Created temporary directory: /tmp/pip-build-tracker-h1lwneaf 2023-07-26T03:10:43,216 Initialized build tracking at /tmp/pip-build-tracker-h1lwneaf 2023-07-26T03:10:43,216 Created build tracker: /tmp/pip-build-tracker-h1lwneaf 2023-07-26T03:10:43,216 Entered build tracker: /tmp/pip-build-tracker-h1lwneaf 2023-07-26T03:10:43,218 Created temporary directory: /tmp/pip-wheel-qg7t_2_0 2023-07-26T03:10:43,226 Created temporary directory: /tmp/pip-ephem-wheel-cache-i_2fp6s4 2023-07-26T03:10:43,284 Looking in indexes: https://pypi.org/simple, https://www.piwheels.org/simple 2023-07-26T03:10:43,292 2 location(s) to search for versions of echoss-query: 2023-07-26T03:10:43,292 * https://pypi.org/simple/echoss-query/ 2023-07-26T03:10:43,292 * https://www.piwheels.org/simple/echoss-query/ 2023-07-26T03:10:43,293 Fetching project page and analyzing links: https://pypi.org/simple/echoss-query/ 2023-07-26T03:10:43,294 Getting page https://pypi.org/simple/echoss-query/ 2023-07-26T03:10:43,299 Found index url https://pypi.org/simple/ 2023-07-26T03:10:43,407 Fetched page https://pypi.org/simple/echoss-query/ as application/vnd.pypi.simple.v1+json 2023-07-26T03:10:43,413 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:10:43,414 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:10:43,415 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:10:43,416 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:10:43,417 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:10:43,418 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:10:43,419 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:10:43,420 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:10:43,421 Fetching project page and analyzing links: https://www.piwheels.org/simple/echoss-query/ 2023-07-26T03:10:43,421 Getting page https://www.piwheels.org/simple/echoss-query/ 2023-07-26T03:10:43,424 Found index url https://www.piwheels.org/simple/ 2023-07-26T03:10:43,967 Fetched page https://www.piwheels.org/simple/echoss-query/ as text/html 2023-07-26T03:10:43,970 Skipping link: No binaries permitted for echoss-query: https://www.piwheels.org/simple/echoss-query/echoss_query-0.0.2-py3-none-any.whl#sha256=3f5e3b261934f0b9b9abb43832a40e9ae1e120c903917f47f558962ef9cb4bd6 (from https://www.piwheels.org/simple/echoss-query/) (requires-python:>3.7) 2023-07-26T03:10:43,971 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:10:43,971 Skipping link: not a file: https://www.piwheels.org/simple/echoss-query/ 2023-07-26T03:10:43,972 Skipping link: not a file: https://pypi.org/simple/echoss-query/ 2023-07-26T03:10:44,005 Given no hashes to check 1 links for project 'echoss-query': discarding no candidates 2023-07-26T03:10:44,036 Collecting echoss-query==0.0.3 2023-07-26T03:10:44,040 Created temporary directory: /tmp/pip-unpack-9sc3ptda 2023-07-26T03:10:44,213 Downloading echoss_query-0.0.3.tar.gz (2.3 kB) 2023-07-26T03:10:44,270 Added echoss-query==0.0.3 from https://files.pythonhosted.org/packages/b9/92/caa524de752bf0d15ea63a185876673f43c5cf6d09de2adaab0d60ac04cf/echoss_query-0.0.3.tar.gz to build tracker '/tmp/pip-build-tracker-h1lwneaf' 2023-07-26T03:10:44,275 Running setup.py (path:/tmp/pip-wheel-qg7t_2_0/echoss-query_82884ffae8da4945a2530a3bb9946d8a/setup.py) egg_info for package echoss-query 2023-07-26T03:10:44,276 Created temporary directory: /tmp/pip-pip-egg-info-_nma1np0 2023-07-26T03:10:44,277 Preparing metadata (setup.py): started 2023-07-26T03:10:44,279 Running command python setup.py egg_info 2023-07-26T03:10:45,795 # echoss_query 2023-07-26T03:10:45,796 ------------- 2023-07-26T03:10:45,796 사용 전 config(인증 정보) 폴더의 유무를 확인한 뒤 사용해야한다. 2023-07-26T03:10:45,797 ### Installaion 2023-07-26T03:10:45,798 ------------- 2023-07-26T03:10:45,798 To install this package, please use Python 3.8 or higher. 2023-07-26T03:10:45,799 Install from Source: 2023-07-26T03:10:45,799 ``` 2023-07-26T03:10:45,799 git clone https://gitlab.echoss.net/big-data/solution-center/echoss_query 2023-07-26T03:10:45,799 cd ~/echoss_query 2023-07-26T03:10:45,800 pip install -r requirements.txt 2023-07-26T03:10:45,800 ``` 2023-07-26T03:10:45,801 ### Quick Start 2023-07-26T03:10:45,801 ------------- 2023-07-26T03:10:45,801 ``` 2023-07-26T03:10:45,802 from echoss_query.query import echoss_query 2023-07-26T03:10:45,802 from echoss_query.dsl import query_dsl 2023-07-26T03:10:45,803 mysql = echoss_query.MysqlQuery('CONFIG_FILE_PATH' or dict) 2023-07-26T03:10:45,803 mongo = echoss_query.MongoQuery('CONFIG_FILE_PATH' or dict) 2023-07-26T03:10:45,804 elastic = query_dsl.ElasticSearch('CONFIG_FILE_PATH' or dict) 2023-07-26T03:10:45,805 #CREATE 2023-07-26T03:10:45,805 mysql.create('QUERY_STRING') 2023-07-26T03:10:45,806 elastic.index(index='INDEX_NAME') 2023-07-26T03:10:45,806 #DROP 2023-07-26T03:10:45,807 mysql.drop('QUERY_STRING') 2023-07-26T03:10:45,807 elastic.delete_index(index='INDEX_NAME') 2023-07-26T03:10:45,808 #TRUNCATE 2023-07-26T03:10:45,808 mysql.truncate('QUERY_STRING') 2023-07-26T03:10:45,809 #ALTER 2023-07-26T03:10:45,809 mysql.alter('QUERY_STRING') 2023-07-26T03:10:45,810 #SELECT 2023-07-26T03:10:45,810 mysql.select('QUERY_STRING') 2023-07-26T03:10:45,811 mongo.select('COLLECTION_NAME','QUERY_STRING or DICTIONARY') 2023-07-26T03:10:45,811 elastic.get(id='ID') 2023-07-26T03:10:45,811 elastic.search(field='FIELD_NAME',value='VALUE') 2023-07-26T03:10:45,812 elastic.get_source(id='ID') #-> Extract Source 2023-07-26T03:10:45,812 mysql.faster_select('QUERY_STRING') #-> Use SSCursor 2023-07-26T03:10:45,813 mysql.select_list('QUERY_STRING') #-> list 2023-07-26T03:10:45,813 #INSERT 2023-07-26T03:10:45,814 mysql.insert('QUERY_STRING') 2023-07-26T03:10:45,814 mongo.insert('COLLECTION_NAME','QUERY_STRING or DICTIONARY') 2023-07-26T03:10:45,815 elastic.create(id='ID', body='JSON_BODY') 2023-07-26T03:10:45,815 #UPDATE 2023-07-26T03:10:45,816 mysql.update('QUERY_STRING') 2023-07-26T03:10:45,816 mongo.update('COLLECTION_NAME','QUERY_STRING or DICTIONARY') 2023-07-26T03:10:45,817 elastic.update(id='ID', body='JSON_BODY') 2023-07-26T03:10:45,818 #DELETE 2023-07-26T03:10:45,818 mysql.delete('QUERY_STRING') 2023-07-26T03:10:45,819 mongo.delete('COLLECTION_NAME','QUERY_STRING or DICTIONARY') 2023-07-26T03:10:45,819 elastic.delete(id='ID') 2023-07-26T03:10:45,820 #Check Database 2023-07-26T03:10:45,820 mysql.databases() 2023-07-26T03:10:45,820 mongo.databases() 2023-07-26T03:10:45,821 #Check Tables 2023-07-26T03:10:45,821 mysql.tables('DB_NAME') 2023-07-26T03:10:45,822 #-MySQL Util Function- 2023-07-26T03:10:45,823 # Ping 2023-07-26T03:10:45,823 mysql.ping() 2023-07-26T03:10:45,823 elastic.ping() 2023-07-26T03:10:45,824 # Connection Information 2023-07-26T03:10:45,824 mysql.conn_info() 2023-07-26T03:10:45,825 elastic.info() 2023-07-26T03:10:45,825 # Close 2023-07-26T03:10:45,826 # crash process close 2023-07-26T03:10:45,826 mysql.close() 2023-07-26T03:10:45,826 ``` 2023-07-26T03:10:45,827 ### Code Quality 2023-07-26T03:10:45,827 When creating new functions, please follow the Google style Python docstrings. See example below: 2023-07-26T03:10:45,827 ``` 2023-07-26T03:10:45,828 def example_function(param1: int, param2: str) -> bool: 2023-07-26T03:10:45,828 """Example function that does something. 2023-07-26T03:10:45,829 Args: 2023-07-26T03:10:45,829 param1: The first parameter. 2023-07-26T03:10:45,829 param2: The second parameter. 2023-07-26T03:10:45,830 Returns: 2023-07-26T03:10:45,830 The return value. True for success, False otherwise. 2023-07-26T03:10:45,831 """ 2023-07-26T03:10:45,832 ``` 2023-07-26T03:10:45,832 running egg_info 2023-07-26T03:10:45,832 creating /tmp/pip-pip-egg-info-_nma1np0/echoss_query.egg-info 2023-07-26T03:10:45,872 writing /tmp/pip-pip-egg-info-_nma1np0/echoss_query.egg-info/PKG-INFO 2023-07-26T03:10:45,876 writing dependency_links to /tmp/pip-pip-egg-info-_nma1np0/echoss_query.egg-info/dependency_links.txt 2023-07-26T03:10:45,880 writing top-level names to /tmp/pip-pip-egg-info-_nma1np0/echoss_query.egg-info/top_level.txt 2023-07-26T03:10:45,883 writing manifest file '/tmp/pip-pip-egg-info-_nma1np0/echoss_query.egg-info/SOURCES.txt' 2023-07-26T03:10:46,083 reading manifest file '/tmp/pip-pip-egg-info-_nma1np0/echoss_query.egg-info/SOURCES.txt' 2023-07-26T03:10:46,090 writing manifest file '/tmp/pip-pip-egg-info-_nma1np0/echoss_query.egg-info/SOURCES.txt' 2023-07-26T03:10:46,211 Preparing metadata (setup.py): finished with status 'done' 2023-07-26T03:10:46,222 Source in /tmp/pip-wheel-qg7t_2_0/echoss-query_82884ffae8da4945a2530a3bb9946d8a has version 0.0.3, which satisfies requirement echoss-query==0.0.3 from https://files.pythonhosted.org/packages/b9/92/caa524de752bf0d15ea63a185876673f43c5cf6d09de2adaab0d60ac04cf/echoss_query-0.0.3.tar.gz 2023-07-26T03:10:46,224 Removed echoss-query==0.0.3 from https://files.pythonhosted.org/packages/b9/92/caa524de752bf0d15ea63a185876673f43c5cf6d09de2adaab0d60ac04cf/echoss_query-0.0.3.tar.gz from build tracker '/tmp/pip-build-tracker-h1lwneaf' 2023-07-26T03:10:46,238 Created temporary directory: /tmp/pip-unpack-c0xzgi1s 2023-07-26T03:10:46,239 Building wheels for collected packages: echoss-query 2023-07-26T03:10:46,252 Created temporary directory: /tmp/pip-wheel-zmzppltv 2023-07-26T03:10:46,253 Building wheel for echoss-query (setup.py): started 2023-07-26T03:10:46,255 Destination directory: /tmp/pip-wheel-zmzppltv 2023-07-26T03:10:46,255 Running command python setup.py bdist_wheel 2023-07-26T03:10:47,334 # echoss_query 2023-07-26T03:10:47,335 ------------- 2023-07-26T03:10:47,336 사용 전 config(인증 정보) 폴더의 유무를 확인한 뒤 사용해야한다. 2023-07-26T03:10:47,336 ### Installaion 2023-07-26T03:10:47,337 ------------- 2023-07-26T03:10:47,337 To install this package, please use Python 3.8 or higher. 2023-07-26T03:10:47,338 Install from Source: 2023-07-26T03:10:47,338 ``` 2023-07-26T03:10:47,339 git clone https://gitlab.echoss.net/big-data/solution-center/echoss_query 2023-07-26T03:10:47,339 cd ~/echoss_query 2023-07-26T03:10:47,339 pip install -r requirements.txt 2023-07-26T03:10:47,339 ``` 2023-07-26T03:10:47,340 ### Quick Start 2023-07-26T03:10:47,340 ------------- 2023-07-26T03:10:47,341 ``` 2023-07-26T03:10:47,341 from echoss_query.query import echoss_query 2023-07-26T03:10:47,341 from echoss_query.dsl import query_dsl 2023-07-26T03:10:47,342 mysql = echoss_query.MysqlQuery('CONFIG_FILE_PATH' or dict) 2023-07-26T03:10:47,343 mongo = echoss_query.MongoQuery('CONFIG_FILE_PATH' or dict) 2023-07-26T03:10:47,343 elastic = query_dsl.ElasticSearch('CONFIG_FILE_PATH' or dict) 2023-07-26T03:10:47,344 #CREATE 2023-07-26T03:10:47,344 mysql.create('QUERY_STRING') 2023-07-26T03:10:47,345 elastic.index(index='INDEX_NAME') 2023-07-26T03:10:47,345 #DROP 2023-07-26T03:10:47,346 mysql.drop('QUERY_STRING') 2023-07-26T03:10:47,346 elastic.delete_index(index='INDEX_NAME') 2023-07-26T03:10:47,347 #TRUNCATE 2023-07-26T03:10:47,347 mysql.truncate('QUERY_STRING') 2023-07-26T03:10:47,348 #ALTER 2023-07-26T03:10:47,348 mysql.alter('QUERY_STRING') 2023-07-26T03:10:47,349 #SELECT 2023-07-26T03:10:47,350 mysql.select('QUERY_STRING') 2023-07-26T03:10:47,350 mongo.select('COLLECTION_NAME','QUERY_STRING or DICTIONARY') 2023-07-26T03:10:47,350 elastic.get(id='ID') 2023-07-26T03:10:47,351 elastic.search(field='FIELD_NAME',value='VALUE') 2023-07-26T03:10:47,351 elastic.get_source(id='ID') #-> Extract Source 2023-07-26T03:10:47,352 mysql.faster_select('QUERY_STRING') #-> Use SSCursor 2023-07-26T03:10:47,352 mysql.select_list('QUERY_STRING') #-> list 2023-07-26T03:10:47,353 #INSERT 2023-07-26T03:10:47,353 mysql.insert('QUERY_STRING') 2023-07-26T03:10:47,354 mongo.insert('COLLECTION_NAME','QUERY_STRING or DICTIONARY') 2023-07-26T03:10:47,354 elastic.create(id='ID', body='JSON_BODY') 2023-07-26T03:10:47,355 #UPDATE 2023-07-26T03:10:47,355 mysql.update('QUERY_STRING') 2023-07-26T03:10:47,355 mongo.update('COLLECTION_NAME','QUERY_STRING or DICTIONARY') 2023-07-26T03:10:47,356 elastic.update(id='ID', body='JSON_BODY') 2023-07-26T03:10:47,356 #DELETE 2023-07-26T03:10:47,357 mysql.delete('QUERY_STRING') 2023-07-26T03:10:47,357 mongo.delete('COLLECTION_NAME','QUERY_STRING or DICTIONARY') 2023-07-26T03:10:47,357 elastic.delete(id='ID') 2023-07-26T03:10:47,358 #Check Database 2023-07-26T03:10:47,359 mysql.databases() 2023-07-26T03:10:47,359 mongo.databases() 2023-07-26T03:10:47,359 #Check Tables 2023-07-26T03:10:47,360 mysql.tables('DB_NAME') 2023-07-26T03:10:47,360 #-MySQL Util Function- 2023-07-26T03:10:47,361 # Ping 2023-07-26T03:10:47,361 mysql.ping() 2023-07-26T03:10:47,362 elastic.ping() 2023-07-26T03:10:47,362 # Connection Information 2023-07-26T03:10:47,363 mysql.conn_info() 2023-07-26T03:10:47,363 elastic.info() 2023-07-26T03:10:47,364 # Close 2023-07-26T03:10:47,364 # crash process close 2023-07-26T03:10:47,364 mysql.close() 2023-07-26T03:10:47,365 ``` 2023-07-26T03:10:47,365 ### Code Quality 2023-07-26T03:10:47,365 When creating new functions, please follow the Google style Python docstrings. See example below: 2023-07-26T03:10:47,366 ``` 2023-07-26T03:10:47,366 def example_function(param1: int, param2: str) -> bool: 2023-07-26T03:10:47,367 """Example function that does something. 2023-07-26T03:10:47,367 Args: 2023-07-26T03:10:47,368 param1: The first parameter. 2023-07-26T03:10:47,368 param2: The second parameter. 2023-07-26T03:10:47,369 Returns: 2023-07-26T03:10:47,369 The return value. True for success, False otherwise. 2023-07-26T03:10:47,370 """ 2023-07-26T03:10:47,370 ``` 2023-07-26T03:10:47,833 running bdist_wheel 2023-07-26T03:10:48,563 running build 2023-07-26T03:10:48,564 running build_py 2023-07-26T03:10:48,636 creating build 2023-07-26T03:10:48,638 creating build/lib 2023-07-26T03:10:48,640 creating build/lib/echoss_query 2023-07-26T03:10:48,643 copying echoss_query/__init__.py -> build/lib/echoss_query 2023-07-26T03:10:48,723 /home/piwheels/.local/lib/python3.7/site-packages/setuptools/_distutils/cmd.py:66: SetuptoolsDeprecationWarning: setup.py install is deprecated. 2023-07-26T03:10:48,723 !! 2023-07-26T03:10:48,724 ******************************************************************************** 2023-07-26T03:10:48,724 Please avoid running ``setup.py`` directly. 2023-07-26T03:10:48,724 Instead, use pypa/build, pypa/installer, pypa/build or 2023-07-26T03:10:48,725 other standards-based tools. 2023-07-26T03:10:48,725 See https://blog.ganssle.io/articles/2021/10/setup-py-deprecated.html for details. 2023-07-26T03:10:48,726 ******************************************************************************** 2023-07-26T03:10:48,726 !! 2023-07-26T03:10:48,726 self.initialize_options() 2023-07-26T03:10:48,794 installing to build/bdist.linux-armv7l/wheel 2023-07-26T03:10:48,795 running install 2023-07-26T03:10:48,857 running install_lib 2023-07-26T03:10:48,926 creating build/bdist.linux-armv7l 2023-07-26T03:10:48,927 creating build/bdist.linux-armv7l/wheel 2023-07-26T03:10:48,931 creating build/bdist.linux-armv7l/wheel/echoss_query 2023-07-26T03:10:48,934 copying build/lib/echoss_query/__init__.py -> build/bdist.linux-armv7l/wheel/echoss_query 2023-07-26T03:10:48,938 running install_egg_info 2023-07-26T03:10:49,104 running egg_info 2023-07-26T03:10:49,167 writing echoss_query.egg-info/PKG-INFO 2023-07-26T03:10:49,171 writing dependency_links to echoss_query.egg-info/dependency_links.txt 2023-07-26T03:10:49,177 writing top-level names to echoss_query.egg-info/top_level.txt 2023-07-26T03:10:49,245 reading manifest file 'echoss_query.egg-info/SOURCES.txt' 2023-07-26T03:10:49,254 writing manifest file 'echoss_query.egg-info/SOURCES.txt' 2023-07-26T03:10:49,257 Copying echoss_query.egg-info to build/bdist.linux-armv7l/wheel/echoss_query-0.0.3-py3.7.egg-info 2023-07-26T03:10:49,272 running install_scripts 2023-07-26T03:10:49,295 creating build/bdist.linux-armv7l/wheel/echoss_query-0.0.3.dist-info/WHEEL 2023-07-26T03:10:49,299 creating '/tmp/pip-wheel-zmzppltv/echoss_query-0.0.3-py3-none-any.whl' and adding 'build/bdist.linux-armv7l/wheel' to it 2023-07-26T03:10:49,304 adding 'echoss_query/__init__.py' 2023-07-26T03:10:49,309 adding 'echoss_query-0.0.3.dist-info/METADATA' 2023-07-26T03:10:49,311 adding 'echoss_query-0.0.3.dist-info/WHEEL' 2023-07-26T03:10:49,313 adding 'echoss_query-0.0.3.dist-info/top_level.txt' 2023-07-26T03:10:49,314 adding 'echoss_query-0.0.3.dist-info/RECORD' 2023-07-26T03:10:49,316 removing build/bdist.linux-armv7l/wheel 2023-07-26T03:10:49,477 Building wheel for echoss-query (setup.py): finished with status 'done' 2023-07-26T03:10:49,484 Created wheel for echoss-query: filename=echoss_query-0.0.3-py3-none-any.whl size=2397 sha256=35dcdd54385469c7be3d176f0bd1cc427e87c1656a145b17d36e36331fa79de9 2023-07-26T03:10:49,486 Stored in directory: /tmp/pip-ephem-wheel-cache-i_2fp6s4/wheels/9d/47/a5/a4b82574daed4485d8c2c043b05455e9827cab0a0cf128794f 2023-07-26T03:10:49,510 Successfully built echoss-query 2023-07-26T03:10:49,517 Removed build tracker: '/tmp/pip-build-tracker-h1lwneaf'