%global _empty_manifest_terminate_build 0
Name:		python-mdb-parser
Version:	0.0.3
Release:	1
Summary:	Microsoft Access (.mdb, .accdb) database file parser
License:	MIT
URL:		https://github.com/fedestella263/mdb_parser
Source0:	https://mirrors.nju.edu.cn/pypi/web/packages/ec/fc/5a13d517f6a17cedfeae70a88bb83ea61a08901fb683a7d9ff315e4475d5/mdb_parser-0.0.3.tar.gz
BuildArch:	noarch


%description
# MDBParser

Easy use Python library to read Microsoft Access (.mdb, .accdb) database files, this library use the mdb-tools command.

## Installing

Use pip:  `pip install mdb-parser`

Or install manually:
```
git clone https://github.com/fedestella263/mdb_parser
cd mdb_parser
python3 setup.py install
```

## Usage Example

```
from mdb_parser import MDBParser, MDBTable

db = MDBParser(file_path="db.accdb")

# Get and print the database tables
print(db.tables)

# Get a table from the DB.
table = db.get_table("MY_TABLE_NAME")

# Or you can use the MDBTable class.
table = MDBTable(file_path="db.accdb", table="MY_TABLE_NAME")

# Get and print the table columns.
print(table.columns)

# Iterate the table rows.
for row in table:
    print(row)
```

%package -n python3-mdb-parser
Summary:	Microsoft Access (.mdb, .accdb) database file parser
Provides:	python-mdb-parser
BuildRequires:	python3-devel
BuildRequires:	python3-setuptools
BuildRequires:	python3-pip
%description -n python3-mdb-parser
# MDBParser

Easy use Python library to read Microsoft Access (.mdb, .accdb) database files, this library use the mdb-tools command.

## Installing

Use pip:  `pip install mdb-parser`

Or install manually:
```
git clone https://github.com/fedestella263/mdb_parser
cd mdb_parser
python3 setup.py install
```

## Usage Example

```
from mdb_parser import MDBParser, MDBTable

db = MDBParser(file_path="db.accdb")

# Get and print the database tables
print(db.tables)

# Get a table from the DB.
table = db.get_table("MY_TABLE_NAME")

# Or you can use the MDBTable class.
table = MDBTable(file_path="db.accdb", table="MY_TABLE_NAME")

# Get and print the table columns.
print(table.columns)

# Iterate the table rows.
for row in table:
    print(row)
```

%package help
Summary:	Development documents and examples for mdb-parser
Provides:	python3-mdb-parser-doc
%description help
# MDBParser

Easy use Python library to read Microsoft Access (.mdb, .accdb) database files, this library use the mdb-tools command.

## Installing

Use pip:  `pip install mdb-parser`

Or install manually:
```
git clone https://github.com/fedestella263/mdb_parser
cd mdb_parser
python3 setup.py install
```

## Usage Example

```
from mdb_parser import MDBParser, MDBTable

db = MDBParser(file_path="db.accdb")

# Get and print the database tables
print(db.tables)

# Get a table from the DB.
table = db.get_table("MY_TABLE_NAME")

# Or you can use the MDBTable class.
table = MDBTable(file_path="db.accdb", table="MY_TABLE_NAME")

# Get and print the table columns.
print(table.columns)

# Iterate the table rows.
for row in table:
    print(row)
```

%prep
%autosetup -n mdb-parser-0.0.3

%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-mdb-parser -f filelist.lst
%dir %{python3_sitelib}/*

%files help -f doclist.lst
%{_docdir}/*

%changelog
* Fri May 05 2023 Python_Bot <Python_Bot@openeuler.org> - 0.0.3-1
- Package Spec generated