{ "info": { "author": "Daniel CAUNE", "author_email": "daniel.caune@gmail.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 5 - Production/Stable", "License :: OSI Approved :: MIT License", "Operating System :: OS Independent", "Programming Language :: Python", "Topic :: Software Development :: Libraries" ], "description": "# Perseus MicrORM\n\nMajormode Perseus MicrORM Python Library is a small, little, mini, tiny, micro Object-Relational Mapping (ORM).\n\nMicrORM is not a object-relational mapping in the sense it maps Pyth objects to a Relational DataBase Management System (RDBMS), but in the sense it maps results of SQL queries, executed on a RDBMS, to Python objects.\n\n## Installation\n\nTo install [Perseus MicrORM Python Library](https://github.com/dcaune/perseus-microrm-python-library), simply enter the follow command line:\n\n``` shell\npip install perseus-microrm-library\n```\n\n## Usage\n\n``` python\nimport uuid\n\nfrom majormode.perseus.utils import cast\nfrom majormode.perseus.utils.rdbms import RdbmsConnection\n\n\nRDBMS_CONNECTION_PROPERTIES = {\n None: {\n 'rdbms_hostname': 'localhost',\n 'rdbms_port': 5432,\n 'rdbms_database_name': 'foo',\n 'rdbms_account_username': 'dbo',\n 'rdbms_account_password': ''\n }\n}\n\nPLACE_IDS = [\n uuid.UUID('54879ffc-a1ec-11e8-85bd-0008a20c190f'),\n uuid.UUID('9025d1c8-a1ec-11e8-9e29-0007cb040bcc')\n]\n\nwith RdbmsConnection.acquire_connection(\n RDBMS_CONNECTION_PROPERTIES,\n auto_commit=False,\n connection=None) as connection:\n cursor = connection.execute(\n \"\"\"\n SELECT place_id,\n ST_X(location) AS longitude,\n ST_Y(location) AS latitude,\n ST_Z(location) AS altitude,\n accuracy,\n creation_time\n FROM place\n WHERE place_id IN %[place_ids]s\n \"\"\",\n {\n 'place_ids': PLACE_IDS \n })\n rows = cursor.fetch_all()\n\n places = [\n row.get_object({\n 'place_id': cast.string_to_uuid,\n 'creation_time': cast.string_to_timestamp})\n for row in cursor.fetch_all()]\n\n for place in places:\n print(place.place_id, place.longitude, place.latitude)\n```\n\n\n", "description_content_type": "text/markdown", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/dcaune/perseus-microrm-python-library", "keywords": "", "license": "MIT", "maintainer": "", "maintainer_email": "", "name": "perseus-microrm-library", "package_url": "https://pypi.org/project/perseus-microrm-library/", "platform": "any", "project_url": "https://pypi.org/project/perseus-microrm-library/", "project_urls": { "Bug Tracker": "https://github.com/dcaune/perseus-microrm-python-library/issues", "Documentation": "https://github.com/dcaune/perseus-microrm-python-library", "Homepage": "https://github.com/dcaune/perseus-microrm-python-library", "Source Code": "https://github.com/dcaune/perseus-microrm-python-library" }, "release_url": "https://pypi.org/project/perseus-microrm-library/1.1.9/", "requires_dist": [ "psycopg2", "perseus-core-library" ], "requires_python": ">=3", "summary": "Python small, little, mini, tiny, micro Object-Relational Mapping (ORM)", "version": "1.1.9" }, "last_serial": 5544611, "releases": { "1.1.7": [ { "comment_text": "", "digests": { "md5": "3c0f7b0221e9c5c2870aec4a011f5822", "sha256": "21a95bbfd13b87b8b54f039a915b4ea695f03ba40f5ef6f263b4601b4775cad0" }, "downloads": -1, "filename": "perseus_microrm_library-1.1.7-py3-none-any.whl", "has_sig": false, "md5_digest": "3c0f7b0221e9c5c2870aec4a011f5822", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3", "size": 13287, "upload_time": "2019-07-16T05:29:59", "url": "https://files.pythonhosted.org/packages/b4/8f/b0e519d0b844f75bed6ccbfc099beb94bf7c972805d7fcc545d34f560be8/perseus_microrm_library-1.1.7-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "97ae226839de67bfa5f39c76dedba191", "sha256": "162f549e3b1c26631c48a9e643a367d42d641a6c2605fe2b36cd0fa0c1f9b8e5" }, "downloads": -1, "filename": "perseus-microrm-library-1.1.7.tar.gz", "has_sig": false, "md5_digest": "97ae226839de67bfa5f39c76dedba191", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3", "size": 11578, "upload_time": "2019-07-16T05:30:01", "url": "https://files.pythonhosted.org/packages/13/90/f4d020c6de340c346552096f078b262ab836896f1b8f6bb7dae1178249be/perseus-microrm-library-1.1.7.tar.gz" } ], "1.1.8": [ { "comment_text": "", "digests": { "md5": "e2ef2c378a51a3011cecd3fcf0c2d7eb", "sha256": "8ab3ae5c3d68e76596599f7f63c19bbaf55943c625078d5f4b0965f8b675d3cd" }, "downloads": -1, "filename": "perseus_microrm_library-1.1.8-py3-none-any.whl", "has_sig": false, "md5_digest": "e2ef2c378a51a3011cecd3fcf0c2d7eb", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3", "size": 13281, "upload_time": "2019-07-17T04:52:23", "url": "https://files.pythonhosted.org/packages/bb/ab/0b4e9d87f3981ad128e69f5ddbc1d1a8a158e25588ed8a3185c7cd73f7f6/perseus_microrm_library-1.1.8-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "a51af50f1a090c827007570815dfa12e", "sha256": "b5e28ba67dbd2009d949d343774b9bff2598e7bea7d8be76ce529fe7732ededd" }, "downloads": -1, "filename": "perseus-microrm-library-1.1.8.tar.gz", "has_sig": false, "md5_digest": "a51af50f1a090c827007570815dfa12e", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3", "size": 11568, "upload_time": "2019-07-17T04:52:25", "url": "https://files.pythonhosted.org/packages/15/93/3276419b64ca78e314d34d078b087b9350c7eda988aa9afbec42d420785d/perseus-microrm-library-1.1.8.tar.gz" } ], "1.1.9": [ { "comment_text": "", "digests": { "md5": "6cbe594a727847be2063ffdedc556683", "sha256": "1055f5f7df92978597caf9b5998ead8db17cc68b63dc61356427948c143dbbf8" }, "downloads": -1, "filename": "perseus_microrm_library-1.1.9-py3-none-any.whl", "has_sig": false, "md5_digest": "6cbe594a727847be2063ffdedc556683", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3", "size": 13264, "upload_time": "2019-07-17T07:44:31", "url": "https://files.pythonhosted.org/packages/45/bd/89512ae035a899d2413816accf458db9c5611390d618957c8c7af44bb1e3/perseus_microrm_library-1.1.9-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "583103fd4475f94566cd431bec7acc03", "sha256": "f4dbc14586e867a63a68948680b4bec381f4b70602665a3b61f705f1489b18c2" }, "downloads": -1, "filename": "perseus-microrm-library-1.1.9.tar.gz", "has_sig": false, "md5_digest": "583103fd4475f94566cd431bec7acc03", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3", "size": 11565, "upload_time": "2019-07-17T07:44:33", "url": "https://files.pythonhosted.org/packages/0a/9d/87f8c09079feb9af53ac05e23cdfc11aad126933cc36da06c849560b9f7f/perseus-microrm-library-1.1.9.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "6cbe594a727847be2063ffdedc556683", "sha256": "1055f5f7df92978597caf9b5998ead8db17cc68b63dc61356427948c143dbbf8" }, "downloads": -1, "filename": "perseus_microrm_library-1.1.9-py3-none-any.whl", "has_sig": false, "md5_digest": "6cbe594a727847be2063ffdedc556683", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3", "size": 13264, "upload_time": "2019-07-17T07:44:31", "url": "https://files.pythonhosted.org/packages/45/bd/89512ae035a899d2413816accf458db9c5611390d618957c8c7af44bb1e3/perseus_microrm_library-1.1.9-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "583103fd4475f94566cd431bec7acc03", "sha256": "f4dbc14586e867a63a68948680b4bec381f4b70602665a3b61f705f1489b18c2" }, "downloads": -1, "filename": "perseus-microrm-library-1.1.9.tar.gz", "has_sig": false, "md5_digest": "583103fd4475f94566cd431bec7acc03", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3", "size": 11565, "upload_time": "2019-07-17T07:44:33", "url": "https://files.pythonhosted.org/packages/0a/9d/87f8c09079feb9af53ac05e23cdfc11aad126933cc36da06c849560b9f7f/perseus-microrm-library-1.1.9.tar.gz" } ] }