{ "info": { "author": "Gord Thompson", "author_email": "gord@gordthompson.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 5 - Production/Stable", "Intended Audience :: Developers", "License :: OSI Approved :: MIT License", "Operating System :: OS Independent", "Programming Language :: Python", "Programming Language :: Python :: 3", "Programming Language :: Python :: Implementation :: CPython", "Topic :: Database :: Front-Ends" ], "description": "sqlalchemy-access\n=================\n\nA Microsoft Access dialect for SQLAlchemy.\n\nObjectives\n----------\n\nThis dialect is mainly intended to offer\npandas users an easy way to save a DataFrame into an\nAccess database via ``to_sql``.\n\nPre-requisites\n--------------\n\n- If you already have Microsoft Office (or standalone Microsoft Access) installed then install a version\n of Python with the same \"bitness\". For example, if you have 32-bit Office then you should install\n 32-bit Python.\n\n- If you do not already have Microsoft Office (or standalone Microsoft Access) installed then install\n the version of the Microsoft Access Database Engine Redistributable with the same \"bitness\" as the\n version of Python you will be using. For example, if you will be running 64-bit Python then you\n should install the 64-bit version of the Access Database Engine.\n\nSpecial case: If you will be running 32-bit Python and you will **only** be working with .mdb files\nthen you can use the older 32-bit ``Microsoft Access Driver (*.mdb)`` that ships with Windows.\n\nCo-requisites\n-------------\n\nThis dialect requires SQLAlchemy and pyodbc. They are both specified as requirements so ``pip`` will install\nthem if they are not already in place. To install, just::\n\n pip install sqlalchemy-access\n\nGetting Started\n---------------\n\nCreate an `ODBC DSN (Data Source Name)`_ that points to your Access database.\n(Tip: For best results, enable `ExtendedAnsiSQL`_.)\nThen, in your Python app, you can connect to the database via::\n\n from sqlalchemy import create_engine\n engine = create_engine(\"access+pyodbc://@your_dsn\")\n\nFor other ways of connecting see the `Getting Connected`_ page in the Wiki.\n\n.. _ODBC DSN (Data Source Name): https://support.microsoft.com/en-ca/help/966849/what-is-a-dsn-data-source-name\n.. _ExtendedAnsiSQL: https://github.com/sqlalchemy/sqlalchemy-access/wiki/%5Btip%5D-use-ExtendedAnsiSQL\n.. _Getting Connected: https://github.com/sqlalchemy/sqlalchemy-access/wiki/Getting-Connected\n\n", "description_content_type": "", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/sqlalchemy/sqlalchemy-access", "keywords": "SQLAlchemy Microsoft Access", "license": "MIT", "maintainer": "", "maintainer_email": "", "name": "sqlalchemy-access", "package_url": "https://pypi.org/project/sqlalchemy-access/", "platform": "", "project_url": "https://pypi.org/project/sqlalchemy-access/", "project_urls": { "Documentation": "https://github.com/sqlalchemy/sqlalchemy-access/wiki", "Homepage": "https://github.com/sqlalchemy/sqlalchemy-access", "Source": "https://github.com/sqlalchemy/sqlalchemy-access", "Tracker": "https://github.com/sqlalchemy/sqlalchemy-access/issues" }, "release_url": "https://pypi.org/project/sqlalchemy-access/1.0.3/", "requires_dist": [ "SQLAlchemy", "pyodbc (>=4.0.27)" ], "requires_python": "", "summary": "MS Access for SQLAlchemy", "version": "1.0.3" }, "last_serial": 5899930, "releases": { "1.0.0": [ { "comment_text": "", "digests": { "md5": "e49895c0e4c325a72838427cc8be8c96", "sha256": "ad6a21026cd5ce5249e1334611b1e1728aa890e924daca97e2347f30bbbf0582" }, "downloads": -1, "filename": "sqlalchemy_access-1.0.0-py3-none-any.whl", "has_sig": false, "md5_digest": "e49895c0e4c325a72838427cc8be8c96", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 11205, "upload_time": "2019-09-05T21:39:56", "url": "https://files.pythonhosted.org/packages/f4/d4/3db9a0c6f4df47574ea74273e12b28260d9c862d579abd6838e39f00f7cd/sqlalchemy_access-1.0.0-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "ea396f5ae7b6015d661c963fa9b28d14", "sha256": "b731970009b310fe2b138f32885aee3ab392b440947ca81472da51aa2fcecf77" }, "downloads": -1, "filename": "sqlalchemy-access-1.0.0.tar.gz", "has_sig": false, "md5_digest": "ea396f5ae7b6015d661c963fa9b28d14", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 10530, "upload_time": "2019-09-05T21:39:58", "url": "https://files.pythonhosted.org/packages/64/db/3208b113d33279f614976d0d0024be29b4e7ab56e93efb3a3f6b26f6aa93/sqlalchemy-access-1.0.0.tar.gz" } ], "1.0.0b1": [ { "comment_text": "", "digests": { "md5": "495f817709b2cbd87863136f70ea30f5", "sha256": "021235a99d3aadb58c13d2e3b4c608548b8712d0f2f0082d06e94de3bf4cb8fd" }, "downloads": -1, "filename": "sqlalchemy_access-1.0.0b1-py3-none-any.whl", "has_sig": false, "md5_digest": "495f817709b2cbd87863136f70ea30f5", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 11240, "upload_time": "2019-09-05T21:22:36", "url": "https://files.pythonhosted.org/packages/6f/7a/66a00966b4764f8640bd38c02a2167616a8a972055897f835277b5ba9648/sqlalchemy_access-1.0.0b1-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "b09e6f51a893859f9bcffdeca1e1bd0d", "sha256": "899a0bd5752408e9218866d4f7187dd9aeab466e353508e76521b78d4ae6559f" }, "downloads": -1, "filename": "sqlalchemy-access-1.0.0b1.tar.gz", "has_sig": false, "md5_digest": "b09e6f51a893859f9bcffdeca1e1bd0d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 10533, "upload_time": "2019-09-05T21:22:39", "url": "https://files.pythonhosted.org/packages/31/59/74cbdac7af1522dc81ca15710044fc52a4a77e0420b13ec6a5b68410da4c/sqlalchemy-access-1.0.0b1.tar.gz" } ], "1.0.1": [ { "comment_text": "", "digests": { "md5": "668f0112eb34ee1c74df0390e8ae64e8", "sha256": "96399142cf69093c3214fc2bd1fb158819e5c57e5543e7173374994176108131" }, "downloads": -1, "filename": "sqlalchemy_access-1.0.1-py3-none-any.whl", "has_sig": false, "md5_digest": "668f0112eb34ee1c74df0390e8ae64e8", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 11228, "upload_time": "2019-09-11T21:59:39", "url": "https://files.pythonhosted.org/packages/47/6a/45150fad138de3ca5f8a6ff5328f88fc677bb489d691fd531d3de0e11d74/sqlalchemy_access-1.0.1-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "9d1a5ea056292a2b917e49e0b3061955", "sha256": "5ac4b6c544d4adf5f9ae9848a533d2a1e210501d1d8ef990e8e30a1f140637bd" }, "downloads": -1, "filename": "sqlalchemy-access-1.0.1.tar.gz", "has_sig": false, "md5_digest": "9d1a5ea056292a2b917e49e0b3061955", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 10548, "upload_time": "2019-09-11T21:59:41", "url": "https://files.pythonhosted.org/packages/c9/7d/5ff7c4f75bb8bc060fdec63c91bbba1ae242adc31ecc86a3ec8d769cd3e5/sqlalchemy-access-1.0.1.tar.gz" } ], "1.0.2": [ { "comment_text": "", "digests": { "md5": "ea0526ff4c82872ad33179faea0cc918", "sha256": "33a1cd3c7e000123f7eb03da58868fb70f64c50d4ae720612a458c44cd931867" }, "downloads": -1, "filename": "sqlalchemy_access-1.0.2-py3-none-any.whl", "has_sig": false, "md5_digest": "ea0526ff4c82872ad33179faea0cc918", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 11242, "upload_time": "2019-09-14T22:18:39", "url": "https://files.pythonhosted.org/packages/4a/29/f1624cb1c7c86dafc912afd72d40ebf6f6de3e4cfb6a8d5a4f3cba40c623/sqlalchemy_access-1.0.2-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "2d5f864ed6a09365d78daf190365de55", "sha256": "4dd96cacd584aa4b7d42726c4327045e2560a05ab3f7c07f490dec4b93658f97" }, "downloads": -1, "filename": "sqlalchemy-access-1.0.2.tar.gz", "has_sig": false, "md5_digest": "2d5f864ed6a09365d78daf190365de55", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 10561, "upload_time": "2019-09-14T22:18:41", "url": "https://files.pythonhosted.org/packages/70/f2/36633c20acdc6f9c00a1fe2509a487d4698f332d571ba038b38748f392b3/sqlalchemy-access-1.0.2.tar.gz" } ], "1.0.3": [ { "comment_text": "", "digests": { "md5": "925dca3807223a874d4a6d7a550ba1e3", "sha256": "f764b1d0fbb65c8efe5624a80684119bc73d395d8a00257057eadf8378d2ed70" }, "downloads": -1, "filename": "sqlalchemy_access-1.0.3-py3-none-any.whl", "has_sig": false, "md5_digest": "925dca3807223a874d4a6d7a550ba1e3", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 12415, "upload_time": "2019-09-28T15:34:18", "url": "https://files.pythonhosted.org/packages/1d/00/b7e9611a4b17aaa0a02459a716cb984db9d7046046b4ea56af1a482a6fb3/sqlalchemy_access-1.0.3-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "96c56d8fa22590380d1e19daf98b5741", "sha256": "e72ebe22d018fc531483efbd6a9ea9ef2049e9e7e4a3ad6995b2f058d51231df" }, "downloads": -1, "filename": "sqlalchemy-access-1.0.3.tar.gz", "has_sig": false, "md5_digest": "96c56d8fa22590380d1e19daf98b5741", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 13287, "upload_time": "2019-09-28T15:34:19", "url": "https://files.pythonhosted.org/packages/ff/20/701dcac8b5b1f734789895943f2b76f3881b716740560d008946870c17bc/sqlalchemy-access-1.0.3.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "925dca3807223a874d4a6d7a550ba1e3", "sha256": "f764b1d0fbb65c8efe5624a80684119bc73d395d8a00257057eadf8378d2ed70" }, "downloads": -1, "filename": "sqlalchemy_access-1.0.3-py3-none-any.whl", "has_sig": false, "md5_digest": "925dca3807223a874d4a6d7a550ba1e3", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 12415, "upload_time": "2019-09-28T15:34:18", "url": "https://files.pythonhosted.org/packages/1d/00/b7e9611a4b17aaa0a02459a716cb984db9d7046046b4ea56af1a482a6fb3/sqlalchemy_access-1.0.3-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "96c56d8fa22590380d1e19daf98b5741", "sha256": "e72ebe22d018fc531483efbd6a9ea9ef2049e9e7e4a3ad6995b2f058d51231df" }, "downloads": -1, "filename": "sqlalchemy-access-1.0.3.tar.gz", "has_sig": false, "md5_digest": "96c56d8fa22590380d1e19daf98b5741", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 13287, "upload_time": "2019-09-28T15:34:19", "url": "https://files.pythonhosted.org/packages/ff/20/701dcac8b5b1f734789895943f2b76f3881b716740560d008946870c17bc/sqlalchemy-access-1.0.3.tar.gz" } ] }