2023-07-26T03:03:34,228 Created temporary directory: /tmp/pip-build-tracker-zyz2szcr
2023-07-26T03:03:34,231 Initialized build tracking at /tmp/pip-build-tracker-zyz2szcr
2023-07-26T03:03:34,231 Created build tracker: /tmp/pip-build-tracker-zyz2szcr
2023-07-26T03:03:34,232 Entered build tracker: /tmp/pip-build-tracker-zyz2szcr
2023-07-26T03:03:34,233 Created temporary directory: /tmp/pip-wheel-8ex_ydr7
2023-07-26T03:03:34,241 Created temporary directory: /tmp/pip-ephem-wheel-cache-8ty8o8tl
2023-07-26T03:03:34,293 Looking in indexes: https://pypi.org/simple, https://www.piwheels.org/simple
2023-07-26T03:03:34,302 2 location(s) to search for versions of echoss-query:
2023-07-26T03:03:34,302 * https://pypi.org/simple/echoss-query/
2023-07-26T03:03:34,302 * https://www.piwheels.org/simple/echoss-query/
2023-07-26T03:03:34,303 Fetching project page and analyzing links: https://pypi.org/simple/echoss-query/
2023-07-26T03:03:34,304 Getting page https://pypi.org/simple/echoss-query/
2023-07-26T03:03:34,308 Found index url https://pypi.org/simple/
2023-07-26T03:03:34,492 Fetched page https://pypi.org/simple/echoss-query/ as application/vnd.pypi.simple.v1+json
2023-07-26T03:03:34,498   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:03:34,499   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:03:34,500   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:03:34,501   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:03:34,502   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:03:34,503   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:03:34,504   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:03:34,505   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:03:34,506 Fetching project page and analyzing links: https://www.piwheels.org/simple/echoss-query/
2023-07-26T03:03:34,506 Getting page https://www.piwheels.org/simple/echoss-query/
2023-07-26T03:03:34,509 Found index url https://www.piwheels.org/simple/
2023-07-26T03:03:34,718 Fetched page https://www.piwheels.org/simple/echoss-query/ as text/html
2023-07-26T03:03:34,720 Skipping link: not a file: https://www.piwheels.org/simple/echoss-query/
2023-07-26T03:03:34,720 Skipping link: not a file: https://pypi.org/simple/echoss-query/
2023-07-26T03:03:34,754 Given no hashes to check 1 links for project 'echoss-query': discarding no candidates
2023-07-26T03:03:34,785 Collecting echoss-query==0.0.1
2023-07-26T03:03:34,790   Created temporary directory: /tmp/pip-unpack-ucf56g89
2023-07-26T03:03:34,962   Downloading echoss_query-0.0.1.tar.gz (2.3 kB)
2023-07-26T03:03:35,024   Added echoss-query==0.0.1 from https://files.pythonhosted.org/packages/b7/cb/b7cd8881a68e94b66f83245834ee86da3c283385e4b7d3570b795c7d0924/echoss_query-0.0.1.tar.gz to build tracker '/tmp/pip-build-tracker-zyz2szcr'
2023-07-26T03:03:35,027   Running setup.py (path:/tmp/pip-wheel-8ex_ydr7/echoss-query_caffb98dd7634ee5afb6e48e6bcb1b31/setup.py) egg_info for package echoss-query
2023-07-26T03:03:35,028   Created temporary directory: /tmp/pip-pip-egg-info-x6q3m2ka
2023-07-26T03:03:35,029   Preparing metadata (setup.py): started
2023-07-26T03:03:35,031   Running command python setup.py egg_info
2023-07-26T03:03:36,547   # echoss_query
2023-07-26T03:03:36,548   -------------
2023-07-26T03:03:36,549   사용 전 config(인증 정보) 폴더의 유무를 확인한 뒤 사용해야한다.

2023-07-26T03:03:36,549   ### Installaion
2023-07-26T03:03:36,550   -------------
2023-07-26T03:03:36,550   To install this package, please use Python 3.8 or higher.

2023-07-26T03:03:36,550   Install from Source:
2023-07-26T03:03:36,551   ```
2023-07-26T03:03:36,551       git clone https://gitlab.echoss.net/big-data/solution-center/echoss_query
2023-07-26T03:03:36,552       cd ~/echoss_query
2023-07-26T03:03:36,552       pip install -r requirements.txt
2023-07-26T03:03:36,552   ```

2023-07-26T03:03:36,553   ### Quick Start
2023-07-26T03:03:36,553   -------------
2023-07-26T03:03:36,553   ```
2023-07-26T03:03:36,554       from echoss_query.query import echoss_query
2023-07-26T03:03:36,554       from echoss_query.dsl import query_dsl

2023-07-26T03:03:36,555       mysql = echoss_query.MysqlQuery('CONFIG_FILE_PATH' or dict)
2023-07-26T03:03:36,555       mongo = echoss_query.MongoQuery('CONFIG_FILE_PATH' or dict)
2023-07-26T03:03:36,555       elastic = query_dsl.ElasticSearch('CONFIG_FILE_PATH' or dict)


2023-07-26T03:03:36,556       #CREATE
2023-07-26T03:03:36,557       mysql.create('QUERY_STRING')
2023-07-26T03:03:36,557       elastic.index(index='INDEX_NAME')

2023-07-26T03:03:36,558       #DROP
2023-07-26T03:03:36,558       mysql.drop('QUERY_STRING')
2023-07-26T03:03:36,558       elastic.delete_index(index='INDEX_NAME')

2023-07-26T03:03:36,559       #TRUNCATE
2023-07-26T03:03:36,559       mysql.truncate('QUERY_STRING')

2023-07-26T03:03:36,560       #ALTER
2023-07-26T03:03:36,560       mysql.alter('QUERY_STRING')

2023-07-26T03:03:36,561       #SELECT

2023-07-26T03:03:36,561       mysql.select('QUERY_STRING')
2023-07-26T03:03:36,562       mongo.select('COLLECTION_NAME','QUERY_STRING or DICTIONARY')
2023-07-26T03:03:36,562       elastic.get(id='ID')
2023-07-26T03:03:36,562       elastic.search(field='FIELD_NAME',value='VALUE')

2023-07-26T03:03:36,563       elastic.get_source(id='ID') #-> Extract Source
2023-07-26T03:03:36,563       mysql.faster_select('QUERY_STRING') #-> Use SSCursor
2023-07-26T03:03:36,564       mysql.select_list('QUERY_STRING') #-> list

2023-07-26T03:03:36,564       #INSERT

2023-07-26T03:03:36,565       mysql.insert('QUERY_STRING')
2023-07-26T03:03:36,565       mongo.insert('COLLECTION_NAME','QUERY_STRING or DICTIONARY')
2023-07-26T03:03:36,565       elastic.create(id='ID', body='JSON_BODY')

2023-07-26T03:03:36,566       #UPDATE

2023-07-26T03:03:36,567       mysql.update('QUERY_STRING')
2023-07-26T03:03:36,567       mongo.update('COLLECTION_NAME','QUERY_STRING or DICTIONARY')
2023-07-26T03:03:36,567       elastic.update(id='ID', body='JSON_BODY')

2023-07-26T03:03:36,568       #DELETE

2023-07-26T03:03:36,569       mysql.delete('QUERY_STRING')
2023-07-26T03:03:36,569       mongo.delete('COLLECTION_NAME','QUERY_STRING or DICTIONARY')
2023-07-26T03:03:36,569       elastic.delete(id='ID')

2023-07-26T03:03:36,570       #Check Database

2023-07-26T03:03:36,571       mysql.databases()
2023-07-26T03:03:36,571       mongo.databases()

2023-07-26T03:03:36,572       #Check Tables
2023-07-26T03:03:36,572       mysql.tables('DB_NAME')

2023-07-26T03:03:36,573       #-MySQL Util Function-

2023-07-26T03:03:36,573       # Ping
2023-07-26T03:03:36,574       mysql.ping()
2023-07-26T03:03:36,574       elastic.ping()

2023-07-26T03:03:36,574       # Connection Information
2023-07-26T03:03:36,575       mysql.conn_info()
2023-07-26T03:03:36,575       elastic.info()

2023-07-26T03:03:36,576       # Close
2023-07-26T03:03:36,576       # crash process close
2023-07-26T03:03:36,576       mysql.close()
2023-07-26T03:03:36,577   ```

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

2023-07-26T03:03:36,579       Args:
2023-07-26T03:03:36,579           param1: The first parameter.
2023-07-26T03:03:36,580           param2: The second parameter.

2023-07-26T03:03:36,580       Returns:
2023-07-26T03:03:36,581           The return value. True for success, False otherwise.

2023-07-26T03:03:36,581       """
2023-07-26T03:03:36,582   ```
2023-07-26T03:03:36,582   running egg_info
2023-07-26T03:03:36,582   creating /tmp/pip-pip-egg-info-x6q3m2ka/echoss_query.egg-info
2023-07-26T03:03:36,625   writing /tmp/pip-pip-egg-info-x6q3m2ka/echoss_query.egg-info/PKG-INFO
2023-07-26T03:03:36,629   writing dependency_links to /tmp/pip-pip-egg-info-x6q3m2ka/echoss_query.egg-info/dependency_links.txt
2023-07-26T03:03:36,634   writing top-level names to /tmp/pip-pip-egg-info-x6q3m2ka/echoss_query.egg-info/top_level.txt
2023-07-26T03:03:36,637   writing manifest file '/tmp/pip-pip-egg-info-x6q3m2ka/echoss_query.egg-info/SOURCES.txt'
2023-07-26T03:03:36,842   reading manifest file '/tmp/pip-pip-egg-info-x6q3m2ka/echoss_query.egg-info/SOURCES.txt'
2023-07-26T03:03:36,849   writing manifest file '/tmp/pip-pip-egg-info-x6q3m2ka/echoss_query.egg-info/SOURCES.txt'
2023-07-26T03:03:36,969   Preparing metadata (setup.py): finished with status 'done'
2023-07-26T03:03:36,981   Source in /tmp/pip-wheel-8ex_ydr7/echoss-query_caffb98dd7634ee5afb6e48e6bcb1b31 has version 0.0.1, which satisfies requirement echoss-query==0.0.1 from https://files.pythonhosted.org/packages/b7/cb/b7cd8881a68e94b66f83245834ee86da3c283385e4b7d3570b795c7d0924/echoss_query-0.0.1.tar.gz
2023-07-26T03:03:36,983   Removed echoss-query==0.0.1 from https://files.pythonhosted.org/packages/b7/cb/b7cd8881a68e94b66f83245834ee86da3c283385e4b7d3570b795c7d0924/echoss_query-0.0.1.tar.gz from build tracker '/tmp/pip-build-tracker-zyz2szcr'
2023-07-26T03:03:36,997 Created temporary directory: /tmp/pip-unpack-8g32dos6
2023-07-26T03:03:36,998 Building wheels for collected packages: echoss-query
2023-07-26T03:03:37,012   Created temporary directory: /tmp/pip-wheel-vv67izbi
2023-07-26T03:03:37,013   Building wheel for echoss-query (setup.py): started
2023-07-26T03:03:37,015   Destination directory: /tmp/pip-wheel-vv67izbi
2023-07-26T03:03:37,015   Running command python setup.py bdist_wheel
2023-07-26T03:03:38,318   # echoss_query
2023-07-26T03:03:38,319   -------------
2023-07-26T03:03:38,319   사용 전 config(인증 정보) 폴더의 유무를 확인한 뒤 사용해야한다.

2023-07-26T03:03:38,320   ### Installaion
2023-07-26T03:03:38,320   -------------
2023-07-26T03:03:38,321   To install this package, please use Python 3.8 or higher.

2023-07-26T03:03:38,322   Install from Source:
2023-07-26T03:03:38,322   ```
2023-07-26T03:03:38,322       git clone https://gitlab.echoss.net/big-data/solution-center/echoss_query
2023-07-26T03:03:38,322       cd ~/echoss_query
2023-07-26T03:03:38,323       pip install -r requirements.txt
2023-07-26T03:03:38,323   ```

2023-07-26T03:03:38,324   ### Quick Start
2023-07-26T03:03:38,324   -------------
2023-07-26T03:03:38,324   ```
2023-07-26T03:03:38,325       from echoss_query.query import echoss_query
2023-07-26T03:03:38,325       from echoss_query.dsl import query_dsl

2023-07-26T03:03:38,326       mysql = echoss_query.MysqlQuery('CONFIG_FILE_PATH' or dict)
2023-07-26T03:03:38,326       mongo = echoss_query.MongoQuery('CONFIG_FILE_PATH' or dict)
2023-07-26T03:03:38,326       elastic = query_dsl.ElasticSearch('CONFIG_FILE_PATH' or dict)


2023-07-26T03:03:38,327       #CREATE
2023-07-26T03:03:38,327       mysql.create('QUERY_STRING')
2023-07-26T03:03:38,328       elastic.index(index='INDEX_NAME')

2023-07-26T03:03:38,328       #DROP
2023-07-26T03:03:38,329       mysql.drop('QUERY_STRING')
2023-07-26T03:03:38,329       elastic.delete_index(index='INDEX_NAME')

2023-07-26T03:03:38,330       #TRUNCATE
2023-07-26T03:03:38,330       mysql.truncate('QUERY_STRING')

2023-07-26T03:03:38,331       #ALTER
2023-07-26T03:03:38,331       mysql.alter('QUERY_STRING')

2023-07-26T03:03:38,332       #SELECT

2023-07-26T03:03:38,332       mysql.select('QUERY_STRING')
2023-07-26T03:03:38,333       mongo.select('COLLECTION_NAME','QUERY_STRING or DICTIONARY')
2023-07-26T03:03:38,333       elastic.get(id='ID')
2023-07-26T03:03:38,333       elastic.search(field='FIELD_NAME',value='VALUE')

2023-07-26T03:03:38,334       elastic.get_source(id='ID') #-> Extract Source
2023-07-26T03:03:38,334       mysql.faster_select('QUERY_STRING') #-> Use SSCursor
2023-07-26T03:03:38,334       mysql.select_list('QUERY_STRING') #-> list

2023-07-26T03:03:38,335       #INSERT

2023-07-26T03:03:38,335       mysql.insert('QUERY_STRING')
2023-07-26T03:03:38,336       mongo.insert('COLLECTION_NAME','QUERY_STRING or DICTIONARY')
2023-07-26T03:03:38,336       elastic.create(id='ID', body='JSON_BODY')

2023-07-26T03:03:38,337       #UPDATE

2023-07-26T03:03:38,337       mysql.update('QUERY_STRING')
2023-07-26T03:03:38,338       mongo.update('COLLECTION_NAME','QUERY_STRING or DICTIONARY')
2023-07-26T03:03:38,338       elastic.update(id='ID', body='JSON_BODY')

2023-07-26T03:03:38,339       #DELETE

2023-07-26T03:03:38,339       mysql.delete('QUERY_STRING')
2023-07-26T03:03:38,340       mongo.delete('COLLECTION_NAME','QUERY_STRING or DICTIONARY')
2023-07-26T03:03:38,340       elastic.delete(id='ID')

2023-07-26T03:03:38,340       #Check Database

2023-07-26T03:03:38,341       mysql.databases()
2023-07-26T03:03:38,341       mongo.databases()

2023-07-26T03:03:38,342       #Check Tables
2023-07-26T03:03:38,342       mysql.tables('DB_NAME')

2023-07-26T03:03:38,343       #-MySQL Util Function-

2023-07-26T03:03:38,343       # Ping
2023-07-26T03:03:38,344       mysql.ping()
2023-07-26T03:03:38,344       elastic.ping()

2023-07-26T03:03:38,345       # Connection Information
2023-07-26T03:03:38,345       mysql.conn_info()
2023-07-26T03:03:38,345       elastic.info()

2023-07-26T03:03:38,346       # Close
2023-07-26T03:03:38,346       # crash process close
2023-07-26T03:03:38,347       mysql.close()
2023-07-26T03:03:38,347   ```

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

2023-07-26T03:03:38,349       Args:
2023-07-26T03:03:38,350           param1: The first parameter.
2023-07-26T03:03:38,350           param2: The second parameter.

2023-07-26T03:03:38,350       Returns:
2023-07-26T03:03:38,351           The return value. True for success, False otherwise.

2023-07-26T03:03:38,351       """
2023-07-26T03:03:38,352   ```
2023-07-26T03:03:38,805   running bdist_wheel
2023-07-26T03:03:39,520   running build
2023-07-26T03:03:39,521   running build_py
2023-07-26T03:03:39,594   creating build
2023-07-26T03:03:39,595   creating build/lib
2023-07-26T03:03:39,596   creating build/lib/echoss_query
2023-07-26T03:03:39,599   copying echoss_query/__init__.py -> build/lib/echoss_query
2023-07-26T03:03:39,679   /home/piwheels/.local/lib/python3.7/site-packages/setuptools/_distutils/cmd.py:66: SetuptoolsDeprecationWarning: setup.py install is deprecated.
2023-07-26T03:03:39,680   !!

2023-07-26T03:03:39,681           ********************************************************************************
2023-07-26T03:03:39,681           Please avoid running ``setup.py`` directly.
2023-07-26T03:03:39,681           Instead, use pypa/build, pypa/installer, pypa/build or
2023-07-26T03:03:39,682           other standards-based tools.

2023-07-26T03:03:39,682           See https://blog.ganssle.io/articles/2021/10/setup-py-deprecated.html for details.
2023-07-26T03:03:39,683           ********************************************************************************

2023-07-26T03:03:39,684   !!
2023-07-26T03:03:39,684     self.initialize_options()
2023-07-26T03:03:39,752   installing to build/bdist.linux-armv7l/wheel
2023-07-26T03:03:39,753   running install
2023-07-26T03:03:39,817   running install_lib
2023-07-26T03:03:39,887   creating build/bdist.linux-armv7l
2023-07-26T03:03:39,888   creating build/bdist.linux-armv7l/wheel
2023-07-26T03:03:39,892   creating build/bdist.linux-armv7l/wheel/echoss_query
2023-07-26T03:03:39,895   copying build/lib/echoss_query/__init__.py -> build/bdist.linux-armv7l/wheel/echoss_query
2023-07-26T03:03:39,898   running install_egg_info
2023-07-26T03:03:40,064   running egg_info
2023-07-26T03:03:40,127   writing echoss_query.egg-info/PKG-INFO
2023-07-26T03:03:40,131   writing dependency_links to echoss_query.egg-info/dependency_links.txt
2023-07-26T03:03:40,137   writing top-level names to echoss_query.egg-info/top_level.txt
2023-07-26T03:03:40,206   reading manifest file 'echoss_query.egg-info/SOURCES.txt'
2023-07-26T03:03:40,214   writing manifest file 'echoss_query.egg-info/SOURCES.txt'
2023-07-26T03:03:40,218   Copying echoss_query.egg-info to build/bdist.linux-armv7l/wheel/echoss_query-0.0.1-py3.7.egg-info
2023-07-26T03:03:40,233   running install_scripts
2023-07-26T03:03:40,255   creating build/bdist.linux-armv7l/wheel/echoss_query-0.0.1.dist-info/WHEEL
2023-07-26T03:03:40,261   creating '/tmp/pip-wheel-vv67izbi/echoss_query-0.0.1-py3-none-any.whl' and adding 'build/bdist.linux-armv7l/wheel' to it
2023-07-26T03:03:40,266   adding 'echoss_query/__init__.py'
2023-07-26T03:03:40,271   adding 'echoss_query-0.0.1.dist-info/METADATA'
2023-07-26T03:03:40,274   adding 'echoss_query-0.0.1.dist-info/WHEEL'
2023-07-26T03:03:40,276   adding 'echoss_query-0.0.1.dist-info/top_level.txt'
2023-07-26T03:03:40,279   adding 'echoss_query-0.0.1.dist-info/RECORD'
2023-07-26T03:03:40,281   removing build/bdist.linux-armv7l/wheel
2023-07-26T03:03:40,441   Building wheel for echoss-query (setup.py): finished with status 'done'
2023-07-26T03:03:40,448   Created wheel for echoss-query: filename=echoss_query-0.0.1-py3-none-any.whl size=2412 sha256=83f507de250794be6b8f2eb053a3803e24bbdefe44ad1b574a2fb57efc08c35c
2023-07-26T03:03:40,450   Stored in directory: /tmp/pip-ephem-wheel-cache-8ty8o8tl/wheels/46/ac/ec/52851a5889abb0d8581cf519f06e3ced8180e6074999932d18
2023-07-26T03:03:40,474 Successfully built echoss-query
2023-07-26T03:03:40,480 Removed build tracker: '/tmp/pip-build-tracker-zyz2szcr'