automatic import of python-pandas-access

3 files changed, 218 insertions, 0 deletions

diff --git a/.gitignore b/.gitignore
index e69de29..fcc92a3 100644
--- a/.gitignore
+++ b/.gitignore
@@ -0,0 +1 @@
+/pandas_access-0.0.1.tar.gz
diff --git a/python-pandas-access.spec b/python-pandas-access.spec
new file mode 100644
index 0000000..b383f12
--- /dev/null
+++ b/python-pandas-access.spec
@@ -0,0 +1,216 @@
+%global _empty_manifest_terminate_build 0
+Name:		python-pandas_access
+Version:	0.0.1
+Release:	1
+Summary:	A tiny, subprocess-based tool for reading a MS Access database(.rdb) as a Pandas DataFrame.
+License:	License :: OSI Approved :: MIT License
+URL:		https://github.com/jbn/pandas_access
+Source0:	https://mirrors.nju.edu.cn/pypi/web/packages/04/5d/019eb5f99b8d5ebee3e1e8f046482fd5b7c35ba2d02b8e8553798d01cfe9/pandas_access-0.0.1.tar.gz
+BuildArch:	noarch
+
+
+%description
+# What is this?
+
+A tiny, `subprocess`-based tool for reading a 
+[MS Access](https://products.office.com/en-us/access) 
+database (`.rdb`) as a [Pandas](http://pandas.pydata.org/) 
+[DataFrame](http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.html). 
+
+## Installation
+
+To read the database, this package (thinly!) wraps 
+[MDBTools](http://mdbtools.sourceforge.net/). Since I assume you're already 
+using Pandas, it should be your only installation requirement. 
+
+If you are on `OSX`, install it via [Homebrew](http://brew.sh/):
+
+```sh
+$ brew install mdbtools
+```
+Then, do,
+```sh
+$ pip install pandas_access
+```
+
+## Usage
+
+```python
+import pandas_access as mdb
+
+# Listing the tables.
+for tbl in mdb.list_tables("my.mdb"):
+    print(tbl)
+    
+# Read a small table.
+df = pandas_access.read_table("my.mdb", "MyTable")
+
+# Read a huge table.
+accumulator = []
+for chunk in pandas_access.read_table("my.mdb", "MyTable", chunksize=10000):
+    accumulator.append(f(chunk))
+```
+
+If you need more power than this, see: 
+[pyodbc](https://github.com/mkleehammer/pyodbc).
+
+## Testing
+
+I needed this code in a quick pinch -- I had no access to MS Access, and I had
+a single `.mdb` file. If someone with Access would like to create a tiny 
+database for unit-testing purposes, I'd be much obliged.
+
+%package -n python3-pandas_access
+Summary:	A tiny, subprocess-based tool for reading a MS Access database(.rdb) as a Pandas DataFrame.
+Provides:	python-pandas_access
+BuildRequires:	python3-devel
+BuildRequires:	python3-setuptools
+BuildRequires:	python3-pip
+%description -n python3-pandas_access
+# What is this?
+
+A tiny, `subprocess`-based tool for reading a 
+[MS Access](https://products.office.com/en-us/access) 
+database (`.rdb`) as a [Pandas](http://pandas.pydata.org/) 
+[DataFrame](http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.html). 
+
+## Installation
+
+To read the database, this package (thinly!) wraps 
+[MDBTools](http://mdbtools.sourceforge.net/). Since I assume you're already 
+using Pandas, it should be your only installation requirement. 
+
+If you are on `OSX`, install it via [Homebrew](http://brew.sh/):
+
+```sh
+$ brew install mdbtools
+```
+Then, do,
+```sh
+$ pip install pandas_access
+```
+
+## Usage
+
+```python
+import pandas_access as mdb
+
+# Listing the tables.
+for tbl in mdb.list_tables("my.mdb"):
+    print(tbl)
+    
+# Read a small table.
+df = pandas_access.read_table("my.mdb", "MyTable")
+
+# Read a huge table.
+accumulator = []
+for chunk in pandas_access.read_table("my.mdb", "MyTable", chunksize=10000):
+    accumulator.append(f(chunk))
+```
+
+If you need more power than this, see: 
+[pyodbc](https://github.com/mkleehammer/pyodbc).
+
+## Testing
+
+I needed this code in a quick pinch -- I had no access to MS Access, and I had
+a single `.mdb` file. If someone with Access would like to create a tiny 
+database for unit-testing purposes, I'd be much obliged.
+
+%package help
+Summary:	Development documents and examples for pandas_access
+Provides:	python3-pandas_access-doc
+%description help
+# What is this?
+
+A tiny, `subprocess`-based tool for reading a 
+[MS Access](https://products.office.com/en-us/access) 
+database (`.rdb`) as a [Pandas](http://pandas.pydata.org/) 
+[DataFrame](http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.html). 
+
+## Installation
+
+To read the database, this package (thinly!) wraps 
+[MDBTools](http://mdbtools.sourceforge.net/). Since I assume you're already 
+using Pandas, it should be your only installation requirement. 
+
+If you are on `OSX`, install it via [Homebrew](http://brew.sh/):
+
+```sh
+$ brew install mdbtools
+```
+Then, do,
+```sh
+$ pip install pandas_access
+```
+
+## Usage
+
+```python
+import pandas_access as mdb
+
+# Listing the tables.
+for tbl in mdb.list_tables("my.mdb"):
+    print(tbl)
+    
+# Read a small table.
+df = pandas_access.read_table("my.mdb", "MyTable")
+
+# Read a huge table.
+accumulator = []
+for chunk in pandas_access.read_table("my.mdb", "MyTable", chunksize=10000):
+    accumulator.append(f(chunk))
+```
+
+If you need more power than this, see: 
+[pyodbc](https://github.com/mkleehammer/pyodbc).
+
+## Testing
+
+I needed this code in a quick pinch -- I had no access to MS Access, and I had
+a single `.mdb` file. If someone with Access would like to create a tiny 
+database for unit-testing purposes, I'd be much obliged.
+
+%prep
+%autosetup -n pandas_access-0.0.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-pandas_access -f filelist.lst
+%dir %{python3_sitelib}/*
+
+%files help -f doclist.lst
+%{_docdir}/*
+
+%changelog
+* Mon Apr 10 2023 Python_Bot <Python_Bot@openeuler.org> - 0.0.1-1
+- Package Spec generated
diff --git a/sources b/sources
new file mode 100644
index 0000000..731f68c
--- /dev/null
+++ b/sources
@@ -0,0 +1 @@
+82e333b28e9a4bd4af96763c7ccd882b  pandas_access-0.0.1.tar.gz