automatic import of python-pycof

3 files changed, 331 insertions, 0 deletions

diff --git a/.gitignore b/.gitignore
index e69de29..5c252c6 100644
--- a/.gitignore
+++ b/.gitignore
@@ -0,0 +1 @@
+/pycof-1.5.4.tar.gz
diff --git a/python-pycof.spec b/python-pycof.spec
new file mode 100644
index 0000000..c092c8b
--- /dev/null
+++ b/python-pycof.spec
@@ -0,0 +1,329 @@
+%global _empty_manifest_terminate_build 0
+Name:		python-pycof
+Version:	1.5.4
+Release:	1
+Summary:	A package for commonly used functions
+License:	MIT License
+URL:		https://www.florianfelice.com/pycof
+Source0:	https://mirrors.nju.edu.cn/pypi/web/packages/89/cd/0f4b1c8373288b4c9f88596c785dac1b8ae7d584cadfcd0d7c26dc9008c4/pycof-1.5.4.tar.gz
+BuildArch:	noarch
+
+Requires:	python3-boto3
+Requires:	python3-bs4
+Requires:	python3-dateparser
+Requires:	python3-google-api-python-client
+Requires:	python3-google-auth-httplib2
+Requires:	python3-google-auth-oauthlib
+Requires:	python3-google-auth
+Requires:	python3-httplib2
+Requires:	python3-matplotlib
+Requires:	python3-numpy
+Requires:	python3-pandas
+Requires:	python3-psycopg2-binary
+Requires:	python3-pyarrow
+Requires:	python3-pymysql
+Requires:	python3-sshtunnel
+Requires:	python3-tqdm
+Requires:	python3-xlrd
+
+%description
+# PYCOF (PYthon COmmon Functions)
+
+## 1. Installation
+[![Downloads](https://pepy.tech/badge/pycof)](https://pepy.tech/project/pycof)
+[![PyPI version](https://badge.fury.io/py/pycof.svg)](https://pypi.org/project/pycof/)
+
+You can get pycof from [PyPI](https://pypi.org/project/pycof/) with:
+
+```bash
+pip install pycof
+```
+
+The library is supported on Windows, Linux and MacOs.
+
+## 2. Usage
+
+### 2.1. Documentation
+
+You can find the full documentation at [https://www.florianfelice.com/pycof](https://www.florianfelice.com/pycof?orgn=github) or by clicking on the name of each function in the next section.
+It will redirect you the the function's specific documentation.
+
+### 2.1. Available functions
+
+The current version of the library provides:
+
+* [**`remote_execute_sql`**](https://www.florianfelice.com/pycof/sql/sql.html#pycof.sql.remote_execute_sql): aggragated function for SQL queries to `SELECT`, `INSERT`, `DELETE` or `COPY`.
+* [**`read`**](https://www.florianfelice.com/pycof/datamngt/datamngt.html#pycof.data.read): Load any data file, regarless of the format.
+* [**`send_email`**](https://www.florianfelice.com/pycof/format/format.html#pycof.format.send_email): simple function to send email to contacts in a concise way.
+* [**`verbose_display`**](https://www.florianfelice.com/pycof/format/format.html#pycof.misc.verbose_display): extended function to [print](https://docs.python.org/3/library/functions.html#print) strings, lists, data frames and progression bar if used as a wrapper in `for` loops.
+* [**`add_zero`**](https://www.florianfelice.com/pycof/format/format.html#pycof.format.add_zero): simple function to convert `int` to `str` by adding a 0 is less than 10.
+* [**`group`**](https://www.florianfelice.com/pycof/format/format.html#pycof.format.group): will convert an `int` to a `str` with thousand seperator.
+* [**`replace_zero`**](https://www.florianfelice.com/pycof/format/format.html#pycof.format.replace_zero): will transform 0 values to `-` for display purposes.
+* [**`week_sunday`**](https://www.florianfelice.com/pycof/format/format.html#pycof.format.week_sunday): will return week number of last sunday date of a given date.
+* [**`display_name`**](https://www.florianfelice.com/pycof/format/format.html#pycof.format.display_name): displays the current user name. Will display either `first`, `last` or `full` name.
+* [**`write`**](https://www.florianfelice.com/pycof/format/format.html#pycof.misc.write): writes a `str` to a specific file (usually .txt) in one line of code.
+* [**`file_age`**](https://www.florianfelice.com/pycof/format/format.html#pycof.misc.file_age): computes the age (in days, hours, ...) of a given local file.
+* [**`str2bool`**](https://www.florianfelice.com/pycof/format/format.html#pycof.format.str2bool): converts string to boolean.
+* And [**`many others`**](https://www.florianfelice.com/pycof)!
+
+
+
+### 2.2. Config file for credentials
+
+The function [`remote_execute_sql`](https://www.florianfelice.com/pycof/sql/sql.html#pycof.sql.remote_execute_sql) and [`send_email`](https://www.florianfelice.com/pycof/format/format.html#pycof.format.send_email) will by default look for the credentials located at `/etc/.pycof/config.json`.
+On Windows, save the config file as `C:/Windows/.pycof/config.json`.
+
+The file follows the below structure:
+
+```bash
+{
+	"DB_USER": "",
+	"DB_PASSWORD": "",
+	"DB_HOST": "",
+	"DB_PORT": "3306",
+	"DB_DATABASE": "",
+	"__COMMENT_1__": "Email specific, send_email"
+	"EMAIL_USER": "",
+	"EMAIL_PASSWORD": "",
+	"EMAIL_SMTP": "smtp.gmail.com",
+	"EMAIL_PORT": "587"
+	"__COMMENT_2__": "IAM specific, if useIAM=True in remote_execute_sql",
+	"CLUSTER_NAME": "",
+	"AWS_ACCESS_KEY_ID": "",
+	"AWS_SECRET_ACCESS_KEY": "",
+	"REGION": "eu-west-1"
+}
+```
+
+On Unix based system, run:
+```bash
+sudo nano /etc/.pycof/config.json
+```
+
+and paste the above json after filling the empty strings (pre-filled values are standard default values).
+
+*__Reminder:__* To save the file, with nano press `CTRL + O`, confirm with `y` then `CTRL + X` to exit.
+
+On Windows, use the path `C:/Windows/.pycof/config.json`.
+
+
+
+
+%package -n python3-pycof
+Summary:	A package for commonly used functions
+Provides:	python-pycof
+BuildRequires:	python3-devel
+BuildRequires:	python3-setuptools
+BuildRequires:	python3-pip
+%description -n python3-pycof
+# PYCOF (PYthon COmmon Functions)
+
+## 1. Installation
+[![Downloads](https://pepy.tech/badge/pycof)](https://pepy.tech/project/pycof)
+[![PyPI version](https://badge.fury.io/py/pycof.svg)](https://pypi.org/project/pycof/)
+
+You can get pycof from [PyPI](https://pypi.org/project/pycof/) with:
+
+```bash
+pip install pycof
+```
+
+The library is supported on Windows, Linux and MacOs.
+
+## 2. Usage
+
+### 2.1. Documentation
+
+You can find the full documentation at [https://www.florianfelice.com/pycof](https://www.florianfelice.com/pycof?orgn=github) or by clicking on the name of each function in the next section.
+It will redirect you the the function's specific documentation.
+
+### 2.1. Available functions
+
+The current version of the library provides:
+
+* [**`remote_execute_sql`**](https://www.florianfelice.com/pycof/sql/sql.html#pycof.sql.remote_execute_sql): aggragated function for SQL queries to `SELECT`, `INSERT`, `DELETE` or `COPY`.
+* [**`read`**](https://www.florianfelice.com/pycof/datamngt/datamngt.html#pycof.data.read): Load any data file, regarless of the format.
+* [**`send_email`**](https://www.florianfelice.com/pycof/format/format.html#pycof.format.send_email): simple function to send email to contacts in a concise way.
+* [**`verbose_display`**](https://www.florianfelice.com/pycof/format/format.html#pycof.misc.verbose_display): extended function to [print](https://docs.python.org/3/library/functions.html#print) strings, lists, data frames and progression bar if used as a wrapper in `for` loops.
+* [**`add_zero`**](https://www.florianfelice.com/pycof/format/format.html#pycof.format.add_zero): simple function to convert `int` to `str` by adding a 0 is less than 10.
+* [**`group`**](https://www.florianfelice.com/pycof/format/format.html#pycof.format.group): will convert an `int` to a `str` with thousand seperator.
+* [**`replace_zero`**](https://www.florianfelice.com/pycof/format/format.html#pycof.format.replace_zero): will transform 0 values to `-` for display purposes.
+* [**`week_sunday`**](https://www.florianfelice.com/pycof/format/format.html#pycof.format.week_sunday): will return week number of last sunday date of a given date.
+* [**`display_name`**](https://www.florianfelice.com/pycof/format/format.html#pycof.format.display_name): displays the current user name. Will display either `first`, `last` or `full` name.
+* [**`write`**](https://www.florianfelice.com/pycof/format/format.html#pycof.misc.write): writes a `str` to a specific file (usually .txt) in one line of code.
+* [**`file_age`**](https://www.florianfelice.com/pycof/format/format.html#pycof.misc.file_age): computes the age (in days, hours, ...) of a given local file.
+* [**`str2bool`**](https://www.florianfelice.com/pycof/format/format.html#pycof.format.str2bool): converts string to boolean.
+* And [**`many others`**](https://www.florianfelice.com/pycof)!
+
+
+
+### 2.2. Config file for credentials
+
+The function [`remote_execute_sql`](https://www.florianfelice.com/pycof/sql/sql.html#pycof.sql.remote_execute_sql) and [`send_email`](https://www.florianfelice.com/pycof/format/format.html#pycof.format.send_email) will by default look for the credentials located at `/etc/.pycof/config.json`.
+On Windows, save the config file as `C:/Windows/.pycof/config.json`.
+
+The file follows the below structure:
+
+```bash
+{
+	"DB_USER": "",
+	"DB_PASSWORD": "",
+	"DB_HOST": "",
+	"DB_PORT": "3306",
+	"DB_DATABASE": "",
+	"__COMMENT_1__": "Email specific, send_email"
+	"EMAIL_USER": "",
+	"EMAIL_PASSWORD": "",
+	"EMAIL_SMTP": "smtp.gmail.com",
+	"EMAIL_PORT": "587"
+	"__COMMENT_2__": "IAM specific, if useIAM=True in remote_execute_sql",
+	"CLUSTER_NAME": "",
+	"AWS_ACCESS_KEY_ID": "",
+	"AWS_SECRET_ACCESS_KEY": "",
+	"REGION": "eu-west-1"
+}
+```
+
+On Unix based system, run:
+```bash
+sudo nano /etc/.pycof/config.json
+```
+
+and paste the above json after filling the empty strings (pre-filled values are standard default values).
+
+*__Reminder:__* To save the file, with nano press `CTRL + O`, confirm with `y` then `CTRL + X` to exit.
+
+On Windows, use the path `C:/Windows/.pycof/config.json`.
+
+
+
+
+%package help
+Summary:	Development documents and examples for pycof
+Provides:	python3-pycof-doc
+%description help
+# PYCOF (PYthon COmmon Functions)
+
+## 1. Installation
+[![Downloads](https://pepy.tech/badge/pycof)](https://pepy.tech/project/pycof)
+[![PyPI version](https://badge.fury.io/py/pycof.svg)](https://pypi.org/project/pycof/)
+
+You can get pycof from [PyPI](https://pypi.org/project/pycof/) with:
+
+```bash
+pip install pycof
+```
+
+The library is supported on Windows, Linux and MacOs.
+
+## 2. Usage
+
+### 2.1. Documentation
+
+You can find the full documentation at [https://www.florianfelice.com/pycof](https://www.florianfelice.com/pycof?orgn=github) or by clicking on the name of each function in the next section.
+It will redirect you the the function's specific documentation.
+
+### 2.1. Available functions
+
+The current version of the library provides:
+
+* [**`remote_execute_sql`**](https://www.florianfelice.com/pycof/sql/sql.html#pycof.sql.remote_execute_sql): aggragated function for SQL queries to `SELECT`, `INSERT`, `DELETE` or `COPY`.
+* [**`read`**](https://www.florianfelice.com/pycof/datamngt/datamngt.html#pycof.data.read): Load any data file, regarless of the format.
+* [**`send_email`**](https://www.florianfelice.com/pycof/format/format.html#pycof.format.send_email): simple function to send email to contacts in a concise way.
+* [**`verbose_display`**](https://www.florianfelice.com/pycof/format/format.html#pycof.misc.verbose_display): extended function to [print](https://docs.python.org/3/library/functions.html#print) strings, lists, data frames and progression bar if used as a wrapper in `for` loops.
+* [**`add_zero`**](https://www.florianfelice.com/pycof/format/format.html#pycof.format.add_zero): simple function to convert `int` to `str` by adding a 0 is less than 10.
+* [**`group`**](https://www.florianfelice.com/pycof/format/format.html#pycof.format.group): will convert an `int` to a `str` with thousand seperator.
+* [**`replace_zero`**](https://www.florianfelice.com/pycof/format/format.html#pycof.format.replace_zero): will transform 0 values to `-` for display purposes.
+* [**`week_sunday`**](https://www.florianfelice.com/pycof/format/format.html#pycof.format.week_sunday): will return week number of last sunday date of a given date.
+* [**`display_name`**](https://www.florianfelice.com/pycof/format/format.html#pycof.format.display_name): displays the current user name. Will display either `first`, `last` or `full` name.
+* [**`write`**](https://www.florianfelice.com/pycof/format/format.html#pycof.misc.write): writes a `str` to a specific file (usually .txt) in one line of code.
+* [**`file_age`**](https://www.florianfelice.com/pycof/format/format.html#pycof.misc.file_age): computes the age (in days, hours, ...) of a given local file.
+* [**`str2bool`**](https://www.florianfelice.com/pycof/format/format.html#pycof.format.str2bool): converts string to boolean.
+* And [**`many others`**](https://www.florianfelice.com/pycof)!
+
+
+
+### 2.2. Config file for credentials
+
+The function [`remote_execute_sql`](https://www.florianfelice.com/pycof/sql/sql.html#pycof.sql.remote_execute_sql) and [`send_email`](https://www.florianfelice.com/pycof/format/format.html#pycof.format.send_email) will by default look for the credentials located at `/etc/.pycof/config.json`.
+On Windows, save the config file as `C:/Windows/.pycof/config.json`.
+
+The file follows the below structure:
+
+```bash
+{
+	"DB_USER": "",
+	"DB_PASSWORD": "",
+	"DB_HOST": "",
+	"DB_PORT": "3306",
+	"DB_DATABASE": "",
+	"__COMMENT_1__": "Email specific, send_email"
+	"EMAIL_USER": "",
+	"EMAIL_PASSWORD": "",
+	"EMAIL_SMTP": "smtp.gmail.com",
+	"EMAIL_PORT": "587"
+	"__COMMENT_2__": "IAM specific, if useIAM=True in remote_execute_sql",
+	"CLUSTER_NAME": "",
+	"AWS_ACCESS_KEY_ID": "",
+	"AWS_SECRET_ACCESS_KEY": "",
+	"REGION": "eu-west-1"
+}
+```
+
+On Unix based system, run:
+```bash
+sudo nano /etc/.pycof/config.json
+```
+
+and paste the above json after filling the empty strings (pre-filled values are standard default values).
+
+*__Reminder:__* To save the file, with nano press `CTRL + O`, confirm with `y` then `CTRL + X` to exit.
+
+On Windows, use the path `C:/Windows/.pycof/config.json`.
+
+
+
+
+%prep
+%autosetup -n pycof-1.5.4
+
+%build
+%py3_build
+
+%install
+%py3_install
+install -d -m755 %{buildroot}/%{_pkgdocdir}
+if [ -d doc ]; then cp -arf doc %{buildroot}/%{_pkgdocdir}; fi
+if [ -d docs ]; then cp -arf docs %{buildroot}/%{_pkgdocdir}; fi
+if [ -d example ]; then cp -arf example %{buildroot}/%{_pkgdocdir}; fi
+if [ -d examples ]; then cp -arf examples %{buildroot}/%{_pkgdocdir}; fi
+pushd %{buildroot}
+if [ -d usr/lib ]; then
+	find usr/lib -type f -printf "/%h/%f\n" >> filelist.lst
+fi
+if [ -d usr/lib64 ]; then
+	find usr/lib64 -type f -printf "/%h/%f\n" >> filelist.lst
+fi
+if [ -d usr/bin ]; then
+	find usr/bin -type f -printf "/%h/%f\n" >> filelist.lst
+fi
+if [ -d usr/sbin ]; then
+	find usr/sbin -type f -printf "/%h/%f\n" >> filelist.lst
+fi
+touch doclist.lst
+if [ -d usr/share/man ]; then
+	find usr/share/man -type f -printf "/%h/%f.gz\n" >> doclist.lst
+fi
+popd
+mv %{buildroot}/filelist.lst .
+mv %{buildroot}/doclist.lst .
+
+%files -n python3-pycof -f filelist.lst
+%dir %{python3_sitelib}/*
+
+%files help -f doclist.lst
+%{_docdir}/*
+
+%changelog
+* Mon May 29 2023 Python_Bot <Python_Bot@openeuler.org> - 1.5.4-1
+- Package Spec generated
diff --git a/sources b/sources
new file mode 100644
index 0000000..1e17dc5
--- /dev/null
+++ b/sources
@@ -0,0 +1 @@
+07b827fe823efc74ba9eac7b20f20dfd  pycof-1.5.4.tar.gz