automatic import of python-gsheets

1 files changed, 127 insertions, 0 deletions

diff --git a/python-gsheets.spec b/python-gsheets.spec
new file mode 100644
index 0000000..ba7affd
--- /dev/null
+++ b/python-gsheets.spec
@@ -0,0 +1,127 @@
+%global _empty_manifest_terminate_build 0
+Name:		python-gsheets
+Version:	0.6.1
+Release:	1
+Summary:	Pythonic wrapper for the Google Sheets API
+License:	MIT
+URL:		https://github.com/xflr6/gsheets
+Source0:	https://mirrors.nju.edu.cn/pypi/web/packages/75/81/4113175b8a0157301e5f4f4692c47db9fb35f78f5a27747f8c1367e67929/gsheets-0.6.1.zip
+BuildArch:	noarch
+
+Requires:	python3-google-api-python-client
+Requires:	python3-oauth2client
+Requires:	python3-tox
+Requires:	python3-flake8
+Requires:	python3-pep8-naming
+Requires:	python3-wheel
+Requires:	python3-twine
+Requires:	python3-sphinx
+Requires:	python3-sphinx-rtd-theme
+Requires:	python3-mock
+Requires:	python3-pytest
+Requires:	python3-pytest-mock
+Requires:	python3-pytest-cov
+
+%description
+|PyPI version| |License| |Supported Python| |Wheel|
+|Build| |Codecov| |Readthedocs-stable| |Readthedocs-latest|
+``gsheets`` is a small wrapper around the `Google Sheets API`_ (v4) to provide
+more convenient access to `Google Sheets`_ from Python scripts.
+`Turn on the API`_, download an OAuth client ID as JSON file, and create a
+``Sheets`` object from it. Use its index access (``__getitem__``) to retrieve
+SpreadSheet objects by their id, or use ``.get()`` with a sheet URL.
+Iterate over the ``Sheets`` object for all spreadsheets, or fetch spreadsheets
+by title with the ``.find()`` and ``.findall()`` methods.
+SpreadSheet objects are collections of WorkSheets, which provide access to the
+cell values via spreadsheet coordinates/slices (e.g. ``ws['A1']``) and
+zero-based cell position (e.g. ``ws.at(0, 1)``).
+Save WorkSheets (or all from a SpreadSheet) as CSV files with the
+``.to_csv()``-method. Create ``pandas.DataFrames`` from worksheet with the
+``.to_frame()``-method.
+
+%package -n python3-gsheets
+Summary:	Pythonic wrapper for the Google Sheets API
+Provides:	python-gsheets
+BuildRequires:	python3-devel
+BuildRequires:	python3-setuptools
+BuildRequires:	python3-pip
+%description -n python3-gsheets
+|PyPI version| |License| |Supported Python| |Wheel|
+|Build| |Codecov| |Readthedocs-stable| |Readthedocs-latest|
+``gsheets`` is a small wrapper around the `Google Sheets API`_ (v4) to provide
+more convenient access to `Google Sheets`_ from Python scripts.
+`Turn on the API`_, download an OAuth client ID as JSON file, and create a
+``Sheets`` object from it. Use its index access (``__getitem__``) to retrieve
+SpreadSheet objects by their id, or use ``.get()`` with a sheet URL.
+Iterate over the ``Sheets`` object for all spreadsheets, or fetch spreadsheets
+by title with the ``.find()`` and ``.findall()`` methods.
+SpreadSheet objects are collections of WorkSheets, which provide access to the
+cell values via spreadsheet coordinates/slices (e.g. ``ws['A1']``) and
+zero-based cell position (e.g. ``ws.at(0, 1)``).
+Save WorkSheets (or all from a SpreadSheet) as CSV files with the
+``.to_csv()``-method. Create ``pandas.DataFrames`` from worksheet with the
+``.to_frame()``-method.
+
+%package help
+Summary:	Development documents and examples for gsheets
+Provides:	python3-gsheets-doc
+%description help
+|PyPI version| |License| |Supported Python| |Wheel|
+|Build| |Codecov| |Readthedocs-stable| |Readthedocs-latest|
+``gsheets`` is a small wrapper around the `Google Sheets API`_ (v4) to provide
+more convenient access to `Google Sheets`_ from Python scripts.
+`Turn on the API`_, download an OAuth client ID as JSON file, and create a
+``Sheets`` object from it. Use its index access (``__getitem__``) to retrieve
+SpreadSheet objects by their id, or use ``.get()`` with a sheet URL.
+Iterate over the ``Sheets`` object for all spreadsheets, or fetch spreadsheets
+by title with the ``.find()`` and ``.findall()`` methods.
+SpreadSheet objects are collections of WorkSheets, which provide access to the
+cell values via spreadsheet coordinates/slices (e.g. ``ws['A1']``) and
+zero-based cell position (e.g. ``ws.at(0, 1)``).
+Save WorkSheets (or all from a SpreadSheet) as CSV files with the
+``.to_csv()``-method. Create ``pandas.DataFrames`` from worksheet with the
+``.to_frame()``-method.
+
+%prep
+%autosetup -n gsheets-0.6.1
+
+%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-gsheets -f filelist.lst
+%dir %{python3_sitelib}/*
+
+%files help -f doclist.lst
+%{_docdir}/*
+
+%changelog
+* Mon Apr 10 2023 Python_Bot <Python_Bot@openeuler.org> - 0.6.1-1
+- Package Spec generated