%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