# AccessDB Parser (Pure Python)
Microsoft Access (.mdb / .accdb) database files parser. The parsing logic is fully written in python and works without any external binary dependencies.
# Installing
Use pip: `pip install access-parser`
Or install manually:
```bash
git clone https://github.com/ClarotyICS/access_parser.git
cd access_parser
python3 setup.py install
```
# Demo
[![asciicast](https://asciinema.org/a/345445.svg)](https://asciinema.org/a/345445)
# Usage Example
```python
from access_parser import AccessParser
# .mdb or .accdb file
db = AccessParser("/path/to/mdb/file.mdb")
# Print DB tables
print(db.catalog)
# Tables are stored as defaultdict(list) -- table[column][row_index]
table = db.parse_table("table_name")
# Pretty print all tables
db.print_database()
```
### Known Issues
*
This library was tested on a limited subset of database files. Due to the differences between database versions and the complexity of the parsing we expect to find more parsing edge-cases.
To help us resolve issues faster please provide as much data as you can when opening an issue - DB file if possible and full trace including log messages.
### Thanks
* This library was made possible by the great work by mdb-tools. The logic in this library heavily relies on the excellent documentation they have https://github.com/brianb/mdbtools
* Huge thanks to Mashav Sapir for the help debugging, CRing and contributing to this project https://github.com/mashavs
Raw data
{
"_id": null,
"home_page": "https://github.com/ClarotyICS/access_parser",
"name": "access-parser",
"maintainer": "",
"docs_url": null,
"requires_python": ">=3.6",
"maintainer_email": "",
"keywords": "",
"author": "Uri Katz",
"author_email": "uri.k@claroty.com",
"download_url": "https://files.pythonhosted.org/packages/c2/31/0caf076793dbd7f71014a81305bd77fa50591fa5ff7272186c2c5614dd4d/access_parser-0.0.5.tar.gz",
"platform": null,
"description": "# AccessDB Parser (Pure Python)\nMicrosoft Access (.mdb / .accdb) database files parser. The parsing logic is fully written in python and works without any external binary dependencies.\n\n# Installing\nUse pip: `pip install access-parser`\n\nOr install manually:\n```bash\ngit clone https://github.com/ClarotyICS/access_parser.git\ncd access_parser\npython3 setup.py install\n```\n\n# Demo\n[![asciicast](https://asciinema.org/a/345445.svg)](https://asciinema.org/a/345445)\n\n# Usage Example\n```python\nfrom access_parser import AccessParser\n\n# .mdb or .accdb file\ndb = AccessParser(\"/path/to/mdb/file.mdb\")\n\n# Print DB tables\nprint(db.catalog)\n\n# Tables are stored as defaultdict(list) -- table[column][row_index]\ntable = db.parse_table(\"table_name\")\n\n# Pretty print all tables\ndb.print_database()\n\n```\n\n### Known Issues\n* \n\nThis library was tested on a limited subset of database files. Due to the differences between database versions and the complexity of the parsing we expect to find more parsing edge-cases.\n\nTo help us resolve issues faster please provide as much data as you can when opening an issue - DB file if possible and full trace including log messages.\n \n \n### Thanks\n* This library was made possible by the great work by mdb-tools. The logic in this library heavily relies on the excellent documentation they have https://github.com/brianb/mdbtools\n* Huge thanks to Mashav Sapir for the help debugging, CRing and contributing to this project https://github.com/mashavs\n",
"bugtrack_url": null,
"license": "",
"summary": "Access database (*.mdb, *.accdb) parser",
"version": "0.0.5",
"project_urls": {
"Homepage": "https://github.com/ClarotyICS/access_parser"
},
"split_keywords": [],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "c2310caf076793dbd7f71014a81305bd77fa50591fa5ff7272186c2c5614dd4d",
"md5": "9edfb6097bdb52812be38bc48514d7d1",
"sha256": "eb1497186e744657f11bdfea2cae9595b0b4af4c43730b53a7f10072c875d50a"
},
"downloads": -1,
"filename": "access_parser-0.0.5.tar.gz",
"has_sig": false,
"md5_digest": "9edfb6097bdb52812be38bc48514d7d1",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.6",
"size": 17389,
"upload_time": "2023-06-01T07:42:55",
"upload_time_iso_8601": "2023-06-01T07:42:55.606490Z",
"url": "https://files.pythonhosted.org/packages/c2/31/0caf076793dbd7f71014a81305bd77fa50591fa5ff7272186c2c5614dd4d/access_parser-0.0.5.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2023-06-01 07:42:55",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "ClarotyICS",
"github_project": "access_parser",
"travis_ci": false,
"coveralls": false,
"github_actions": false,
"lcname": "access-parser"
}