%global _empty_manifest_terminate_build 0 Name: python-brunns-row Version: 2.1.0 Release: 1 Summary: Convenience wrapper for DB API and csv.DictReader rows, and similar. License: MIT License URL: https://brunns-row.readthedocs.io Source0: https://mirrors.nju.edu.cn/pypi/web/packages/d9/2d/1d219360c477f5abbed3dd4bca5aabddd9b7ab9e7a1c9b76c782754b9ba3/brunns-row-2.1.0.tar.gz BuildArch: noarch %description # brunns-row Convenience wrapper for DB API and csv.DictReader rows, and similar, inspired by [Greg Stein](https://github.com/gstein)'s lovely [dtuple module](https://code.activestate.com/recipes/81252-using-dtuple-for-flexible-query-result-access/). [![made-with-python](https://img.shields.io/badge/Made%20with-Python-1f425f.svg)](https://www.python.org/) [![Build Status](https://travis-ci.org/brunns/brunns-row.svg?branch=master&logo=travis)](https://travis-ci.org/brunns/brunns-row) [![PyPi Version](https://img.shields.io/pypi/v/brunns-row.svg?logo=pypi)](https://pypi.org/project/brunns-row/#history) [![Python Versions](https://img.shields.io/pypi/pyversions/brunns-row.svg?logo=python)](https://pypi.org/project/brunns-row/) [![Licence](https://img.shields.io/github/license/brunns/brunns-row.svg)](https://github.com/brunns/brunns-row/blob/master/LICENSE) [![GitHub all releases](https://img.shields.io/github/downloads/brunns/brunns-row/total.svg?logo=github)](https://github.com/brunns/brunns-row/releases/) [![GitHub forks](https://img.shields.io/github/forks/brunns/brunns-row.svg?label=Fork&logo=github)](https://github.com/brunns/brunns-row/network/members) [![GitHub stars](https://img.shields.io/github/stars/brunns/brunns-row.svg?label=Star&logo=github)](https://github.com/brunns/brunns-row/stargazers/) [![GitHub watchers](https://img.shields.io/github/watchers/brunns/brunns-row.svg?label=Watch&logo=github)](https://github.com/brunns/brunns-row/watchers/) [![GitHub contributors](https://img.shields.io/github/contributors/brunns/brunns-row.svg?logo=github)](https://github.com/brunns/brunns-row/graphs/contributors/) [![GitHub issues](https://img.shields.io/github/issues/brunns/brunns-row.svg?logo=github)](https://github.com/brunns/brunns-row/issues/) [![GitHub issues-closed](https://img.shields.io/github/issues-closed/brunns/brunns-row.svg?logo=github)](https://github.com/brunns/brunns-row/issues?q=is%3Aissue+is%3Aclosed) [![GitHub pull-requests](https://img.shields.io/github/issues-pr/brunns/brunns-row.svg?logo=github)](https://github.com/brunns/brunns-row/pulls) [![GitHub pull-requests closed](https://img.shields.io/github/issues-pr-closed/brunns/brunns-row.svg?logo=github)](https://github.com/brunns/brunns-row/pulls?utf8=%E2%9C%93&q=is%3Apr+is%3Aclosed) [![Codacy Badge](https://api.codacy.com/project/badge/Grade/6f43e871d3514176bebc650849ac7d4a)](https://www.codacy.com/app/brunns/brunns-row) [![Codacy Coverage](https://api.codacy.com/project/badge/coverage/6f43e871d3514176bebc650849ac7d4a)](https://www.codacy.com/app/brunns/brunns-row) [![Documentation Status](https://readthedocs.org/projects/brunns-row/badge/?version=latest)](https://brunns-row.readthedocs.io/en/latest/?badge=latest) [![Lines of Code](https://tokei.rs/b1/github/brunns/brunns-row)](https://github.com/brunns/brunns-row) ## Setup Install with pip: pip install brunns-row (As usual, use of a [venv](https://docs.python.org/3/library/venv.html) or [virtualenv](https://virtualenv.pypa.io) is recommended.) ## Usage The basic approach is to create a wrapper object from some kind of description - typically a [DBAPI cursor](https://www.python.org/dev/peps/pep-0249/#cursor-objects)'s [description](https://www.python.org/dev/peps/pep-0249/#description), or a [csv.DictReader](https://docs.python.org/3/library/csv.html#csv.DictReader)'s [fieldnames](https://docs.python.org/3/library/csv.html#csv.csvreader.fieldnames) attribute - then to use the wrapper's `wrap(row)` method to wrap each row. `wrap(row)` returns an object from which you can access the row's fields as attributes. A couple of simple examples: ### DB API ```python cursor = conn.cursor() cursor.execute("SELECT kind, rating FROM sausages ORDER BY rating DESC;") wrapper = RowWrapper(cursor.description) rows = [wrapper.wrap(row) for row in cursor.fetchall()] for row in rows: print(row.kind, row.rating) ``` ### csv.DictReader ```python reader = csv.DictReader(csv_file) wrapper = RowWrapper(reader.fieldnames) rows = [wrapper.wrap(row) for row in reader] for row in rows: print(row.kind, row.rating) ``` Attributes names are simply the column names where possible, converted to valid identifiers where necessary by replacing invalid characters with "\_"s, prefixing any leading numerics with "a\_", and de-duplicating where necessary by adding numeric suffixes. ## Developing Requires [tox](https://tox.readthedocs.io). Run `make precommit` tells you if you're OK to commit. For more options, run: make help ## Releasing Requires [hub](https://hub.github.com/), [setuptools](https://setuptools.readthedocs.io), [wheel](https://github.com/pypa/wheel) and [twine](https://twine.readthedocs.io). To release version `n.n.n`, first update the version number in `setup.py`, then: ```sh version="n.n.n" # Needs to match new version number in setup.py. git checkout -b "release-$version" make precommit && git commit -am"Release $version" && git push --set-upstream origin "release-$version" # If not already all pushed, which it should be. hub release create "V$version" -t"release-$version" -m"Version $version" python setup.py sdist bdist_wheel twine upload dist/*$version* git checkout master git merge "release-$version" ``` %package -n python3-brunns-row Summary: Convenience wrapper for DB API and csv.DictReader rows, and similar. Provides: python-brunns-row BuildRequires: python3-devel BuildRequires: python3-setuptools BuildRequires: python3-pip %description -n python3-brunns-row # brunns-row Convenience wrapper for DB API and csv.DictReader rows, and similar, inspired by [Greg Stein](https://github.com/gstein)'s lovely [dtuple module](https://code.activestate.com/recipes/81252-using-dtuple-for-flexible-query-result-access/). [![made-with-python](https://img.shields.io/badge/Made%20with-Python-1f425f.svg)](https://www.python.org/) [![Build Status](https://travis-ci.org/brunns/brunns-row.svg?branch=master&logo=travis)](https://travis-ci.org/brunns/brunns-row) [![PyPi Version](https://img.shields.io/pypi/v/brunns-row.svg?logo=pypi)](https://pypi.org/project/brunns-row/#history) [![Python Versions](https://img.shields.io/pypi/pyversions/brunns-row.svg?logo=python)](https://pypi.org/project/brunns-row/) [![Licence](https://img.shields.io/github/license/brunns/brunns-row.svg)](https://github.com/brunns/brunns-row/blob/master/LICENSE) [![GitHub all releases](https://img.shields.io/github/downloads/brunns/brunns-row/total.svg?logo=github)](https://github.com/brunns/brunns-row/releases/) [![GitHub forks](https://img.shields.io/github/forks/brunns/brunns-row.svg?label=Fork&logo=github)](https://github.com/brunns/brunns-row/network/members) [![GitHub stars](https://img.shields.io/github/stars/brunns/brunns-row.svg?label=Star&logo=github)](https://github.com/brunns/brunns-row/stargazers/) [![GitHub watchers](https://img.shields.io/github/watchers/brunns/brunns-row.svg?label=Watch&logo=github)](https://github.com/brunns/brunns-row/watchers/) [![GitHub contributors](https://img.shields.io/github/contributors/brunns/brunns-row.svg?logo=github)](https://github.com/brunns/brunns-row/graphs/contributors/) [![GitHub issues](https://img.shields.io/github/issues/brunns/brunns-row.svg?logo=github)](https://github.com/brunns/brunns-row/issues/) [![GitHub issues-closed](https://img.shields.io/github/issues-closed/brunns/brunns-row.svg?logo=github)](https://github.com/brunns/brunns-row/issues?q=is%3Aissue+is%3Aclosed) [![GitHub pull-requests](https://img.shields.io/github/issues-pr/brunns/brunns-row.svg?logo=github)](https://github.com/brunns/brunns-row/pulls) [![GitHub pull-requests closed](https://img.shields.io/github/issues-pr-closed/brunns/brunns-row.svg?logo=github)](https://github.com/brunns/brunns-row/pulls?utf8=%E2%9C%93&q=is%3Apr+is%3Aclosed) [![Codacy Badge](https://api.codacy.com/project/badge/Grade/6f43e871d3514176bebc650849ac7d4a)](https://www.codacy.com/app/brunns/brunns-row) [![Codacy Coverage](https://api.codacy.com/project/badge/coverage/6f43e871d3514176bebc650849ac7d4a)](https://www.codacy.com/app/brunns/brunns-row) [![Documentation Status](https://readthedocs.org/projects/brunns-row/badge/?version=latest)](https://brunns-row.readthedocs.io/en/latest/?badge=latest) [![Lines of Code](https://tokei.rs/b1/github/brunns/brunns-row)](https://github.com/brunns/brunns-row) ## Setup Install with pip: pip install brunns-row (As usual, use of a [venv](https://docs.python.org/3/library/venv.html) or [virtualenv](https://virtualenv.pypa.io) is recommended.) ## Usage The basic approach is to create a wrapper object from some kind of description - typically a [DBAPI cursor](https://www.python.org/dev/peps/pep-0249/#cursor-objects)'s [description](https://www.python.org/dev/peps/pep-0249/#description), or a [csv.DictReader](https://docs.python.org/3/library/csv.html#csv.DictReader)'s [fieldnames](https://docs.python.org/3/library/csv.html#csv.csvreader.fieldnames) attribute - then to use the wrapper's `wrap(row)` method to wrap each row. `wrap(row)` returns an object from which you can access the row's fields as attributes. A couple of simple examples: ### DB API ```python cursor = conn.cursor() cursor.execute("SELECT kind, rating FROM sausages ORDER BY rating DESC;") wrapper = RowWrapper(cursor.description) rows = [wrapper.wrap(row) for row in cursor.fetchall()] for row in rows: print(row.kind, row.rating) ``` ### csv.DictReader ```python reader = csv.DictReader(csv_file) wrapper = RowWrapper(reader.fieldnames) rows = [wrapper.wrap(row) for row in reader] for row in rows: print(row.kind, row.rating) ``` Attributes names are simply the column names where possible, converted to valid identifiers where necessary by replacing invalid characters with "\_"s, prefixing any leading numerics with "a\_", and de-duplicating where necessary by adding numeric suffixes. ## Developing Requires [tox](https://tox.readthedocs.io). Run `make precommit` tells you if you're OK to commit. For more options, run: make help ## Releasing Requires [hub](https://hub.github.com/), [setuptools](https://setuptools.readthedocs.io), [wheel](https://github.com/pypa/wheel) and [twine](https://twine.readthedocs.io). To release version `n.n.n`, first update the version number in `setup.py`, then: ```sh version="n.n.n" # Needs to match new version number in setup.py. git checkout -b "release-$version" make precommit && git commit -am"Release $version" && git push --set-upstream origin "release-$version" # If not already all pushed, which it should be. hub release create "V$version" -t"release-$version" -m"Version $version" python setup.py sdist bdist_wheel twine upload dist/*$version* git checkout master git merge "release-$version" ``` %package help Summary: Development documents and examples for brunns-row Provides: python3-brunns-row-doc %description help # brunns-row Convenience wrapper for DB API and csv.DictReader rows, and similar, inspired by [Greg Stein](https://github.com/gstein)'s lovely [dtuple module](https://code.activestate.com/recipes/81252-using-dtuple-for-flexible-query-result-access/). [![made-with-python](https://img.shields.io/badge/Made%20with-Python-1f425f.svg)](https://www.python.org/) [![Build Status](https://travis-ci.org/brunns/brunns-row.svg?branch=master&logo=travis)](https://travis-ci.org/brunns/brunns-row) [![PyPi Version](https://img.shields.io/pypi/v/brunns-row.svg?logo=pypi)](https://pypi.org/project/brunns-row/#history) [![Python Versions](https://img.shields.io/pypi/pyversions/brunns-row.svg?logo=python)](https://pypi.org/project/brunns-row/) [![Licence](https://img.shields.io/github/license/brunns/brunns-row.svg)](https://github.com/brunns/brunns-row/blob/master/LICENSE) [![GitHub all releases](https://img.shields.io/github/downloads/brunns/brunns-row/total.svg?logo=github)](https://github.com/brunns/brunns-row/releases/) [![GitHub forks](https://img.shields.io/github/forks/brunns/brunns-row.svg?label=Fork&logo=github)](https://github.com/brunns/brunns-row/network/members) [![GitHub stars](https://img.shields.io/github/stars/brunns/brunns-row.svg?label=Star&logo=github)](https://github.com/brunns/brunns-row/stargazers/) [![GitHub watchers](https://img.shields.io/github/watchers/brunns/brunns-row.svg?label=Watch&logo=github)](https://github.com/brunns/brunns-row/watchers/) [![GitHub contributors](https://img.shields.io/github/contributors/brunns/brunns-row.svg?logo=github)](https://github.com/brunns/brunns-row/graphs/contributors/) [![GitHub issues](https://img.shields.io/github/issues/brunns/brunns-row.svg?logo=github)](https://github.com/brunns/brunns-row/issues/) [![GitHub issues-closed](https://img.shields.io/github/issues-closed/brunns/brunns-row.svg?logo=github)](https://github.com/brunns/brunns-row/issues?q=is%3Aissue+is%3Aclosed) [![GitHub pull-requests](https://img.shields.io/github/issues-pr/brunns/brunns-row.svg?logo=github)](https://github.com/brunns/brunns-row/pulls) [![GitHub pull-requests closed](https://img.shields.io/github/issues-pr-closed/brunns/brunns-row.svg?logo=github)](https://github.com/brunns/brunns-row/pulls?utf8=%E2%9C%93&q=is%3Apr+is%3Aclosed) [![Codacy Badge](https://api.codacy.com/project/badge/Grade/6f43e871d3514176bebc650849ac7d4a)](https://www.codacy.com/app/brunns/brunns-row) [![Codacy Coverage](https://api.codacy.com/project/badge/coverage/6f43e871d3514176bebc650849ac7d4a)](https://www.codacy.com/app/brunns/brunns-row) [![Documentation Status](https://readthedocs.org/projects/brunns-row/badge/?version=latest)](https://brunns-row.readthedocs.io/en/latest/?badge=latest) [![Lines of Code](https://tokei.rs/b1/github/brunns/brunns-row)](https://github.com/brunns/brunns-row) ## Setup Install with pip: pip install brunns-row (As usual, use of a [venv](https://docs.python.org/3/library/venv.html) or [virtualenv](https://virtualenv.pypa.io) is recommended.) ## Usage The basic approach is to create a wrapper object from some kind of description - typically a [DBAPI cursor](https://www.python.org/dev/peps/pep-0249/#cursor-objects)'s [description](https://www.python.org/dev/peps/pep-0249/#description), or a [csv.DictReader](https://docs.python.org/3/library/csv.html#csv.DictReader)'s [fieldnames](https://docs.python.org/3/library/csv.html#csv.csvreader.fieldnames) attribute - then to use the wrapper's `wrap(row)` method to wrap each row. `wrap(row)` returns an object from which you can access the row's fields as attributes. A couple of simple examples: ### DB API ```python cursor = conn.cursor() cursor.execute("SELECT kind, rating FROM sausages ORDER BY rating DESC;") wrapper = RowWrapper(cursor.description) rows = [wrapper.wrap(row) for row in cursor.fetchall()] for row in rows: print(row.kind, row.rating) ``` ### csv.DictReader ```python reader = csv.DictReader(csv_file) wrapper = RowWrapper(reader.fieldnames) rows = [wrapper.wrap(row) for row in reader] for row in rows: print(row.kind, row.rating) ``` Attributes names are simply the column names where possible, converted to valid identifiers where necessary by replacing invalid characters with "\_"s, prefixing any leading numerics with "a\_", and de-duplicating where necessary by adding numeric suffixes. ## Developing Requires [tox](https://tox.readthedocs.io). Run `make precommit` tells you if you're OK to commit. For more options, run: make help ## Releasing Requires [hub](https://hub.github.com/), [setuptools](https://setuptools.readthedocs.io), [wheel](https://github.com/pypa/wheel) and [twine](https://twine.readthedocs.io). To release version `n.n.n`, first update the version number in `setup.py`, then: ```sh version="n.n.n" # Needs to match new version number in setup.py. git checkout -b "release-$version" make precommit && git commit -am"Release $version" && git push --set-upstream origin "release-$version" # If not already all pushed, which it should be. hub release create "V$version" -t"release-$version" -m"Version $version" python setup.py sdist bdist_wheel twine upload dist/*$version* git checkout master git merge "release-$version" ``` %prep %autosetup -n brunns-row-2.1.0 %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-brunns-row -f filelist.lst %dir %{python3_sitelib}/* %files help -f doclist.lst %{_docdir}/* %changelog * Wed Apr 12 2023 Python_Bot - 2.1.0-1 - Package Spec generated