{ "info": { "author": "Lamy Jean-Baptiste (Jiba)", "author_email": "jibalamy@free.fr", "bugtrack_url": null, "classifiers": [ "Development Status :: 4 - Beta", "Intended Audience :: Developers", "Intended Audience :: Information Technology", "License :: OSI Approved :: GNU Lesser General Public License v3 or later (LGPLv3+)", "Operating System :: OS Independent", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.5", "Programming Language :: Python :: Implementation :: PyPy", "Topic :: Database" ], "description": "ORMithorynque\r\n=============\r\n\r\nORMithorynque is an ORM (Object Relational Mapper), that is to say an object-oriented database\r\nbuilt on top of a relational database (SQLite3).\r\nORMithorynque allows to save and reload Python object in a database, and to perform complex\r\nand optimized request on the database.\r\nORMithorynque can be seen as SQLite3 with objects and (multiple) inheritance,\r\nor Python object system with SQL queries.\r\n\r\nThe key features of ORMithorynque are:\r\n\r\n* Very good performance thanks to prebuilt requests and agressive caching\r\n (faster than SQLAlchemy, SQLObject, Pony and Peewee)\r\n* Automatic database schema update when adding new tables, new columns or new indexes\r\n* Single and multiple inheritance support\r\n* Transactions\r\n* Native SQL queries\r\n* Funny name :)\r\n\r\nAnd its main drawbacks are:\r\n \r\n* Support a single database backend (SQLite3)\r\n* No specific high-level query language\r\n* Not thread-safe\r\n\r\nORMithorynque is available under the GNU LGPL licence v3.\r\nIt requires Python 3.2 (or more) or Pypy 3.\r\n\r\n \r\nInstallation\r\n------------\r\n\r\nTo install ORMithorynque, type the following command into the command prompt (with root permission):\r\n\r\n::\r\n\r\n pip install ormithorynque\r\n\r\n\r\nWhat can I do with ORMithorynque?\r\n---------------------------------\r\n\r\nOpen an ORMithorynque database from a filename (if the database does not exist, it is automatically created):\r\n\r\n::\r\n\r\n >>> import ormithorynque\r\n \r\n >>> database = ormithorynque.Database(\"database_filename.sqlite3\")\r\n\r\nCreate two classes, with a one-to-many relation between them (tables are automatically created with the class\r\nif they do not exist; if they exist, they are automatically updated with new column if needed):\r\n\r\n::\r\n \r\n >>> class Person(database.Object):\r\n ... name = database.SQLAttribute(str, indexed = True)\r\n ... first_name = database.SQLAttribute(str)\r\n ... houses = database.SQLOneToMany(\"House\", \"owner\")\r\n \r\n >>> class House(database.Object):\r\n ... address = database.SQLAttribute(\"Nowhere\") # String attribute with a default value\r\n ... owner = database.SQLAttribute(object)\r\n\r\nCreate two instances (database is automatically updated):\r\n\r\n::\r\n \r\n >>> someone = Person(name = \"Some\", first_name=\"One\")\r\n \r\n >>> house = House(address = \"Somewhere\", owner = someone)\r\n\r\nThe attributes of the instances can be accessed and modified (database is automatically update):\r\n\r\n::\r\n\r\n >>> someone.name\r\n Some\r\n >>> someone.name = \"Some2\"\r\n \r\n >>> someone.houses\r\n [>]\r\n\r\nFinally, plain SQL can be used to query the database:\r\n\r\n::\r\n\r\n >>> database.select_one(\"select count(id) from Person\")\r\n (1,)\r\n \r\n \r\nChangelog\r\n---------\r\n\r\n0.1\r\n***\r\n\r\n* First release\r\n\r\n\r\nLinks\r\n-----\r\n\r\nORMithorynque on BitBucket (development repository): https://bitbucket.org/jibalamy/ormithorynque\r\n\r\nORMithorynque on PyPI (Python Package Index, stable release): https://pypi.python.org/pypi/ormithorynque\r\n\r\nDocumentation: http://pythonhosted.org/ORMithorynque\r\n\r\nMail me for any comment, problem, suggestion or help !\r\n\r\nJiba -- Jean-Baptiste LAMY -- jibalamy @ free.fr", "description_content_type": null, "docs_url": "https://pythonhosted.org/ORMithorynque/", "download_url": "UNKNOWN", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://bitbucket.org/jibalamy/ormithorynque", "keywords": "ORM object database", "license": "LGPLv3+", "maintainer": "", "maintainer_email": "", "name": "ORMithorynque", "package_url": "https://pypi.org/project/ORMithorynque/", "platform": "UNKNOWN", "project_url": "https://pypi.org/project/ORMithorynque/", "project_urls": { "Download": "UNKNOWN", "Homepage": "https://bitbucket.org/jibalamy/ormithorynque" }, "release_url": "https://pypi.org/project/ORMithorynque/0.1.1/", "requires_dist": null, "requires_python": null, "summary": "ORMithorynque is an ORM (Object Relational Mapper) for Python and SQLite3 with excellent performances and multiple inheritance support.", "version": "0.1.1" }, "last_serial": 2174779, "releases": { "0.1": [ { "comment_text": "", "digests": { "md5": "313f506ca39bfd80a94ad9d23e1d9013", "sha256": "860c0b48127de99a5c4201ef8f22e4169fa1dbe16d00f0b628bfe099e2297615" }, "downloads": -1, "filename": "ORMithorynque-0.1.tar.bz2", "has_sig": false, "md5_digest": "313f506ca39bfd80a94ad9d23e1d9013", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 342937, "upload_time": "2016-06-18T11:38:01", "url": "https://files.pythonhosted.org/packages/bc/fa/a0a39fa18c5ee29e450d6e971fe2523d0176ad055acc981ca8007947ed3a/ORMithorynque-0.1.tar.bz2" } ], "0.1.1": [ { "comment_text": "", "digests": { "md5": "76e27989e62209a860927d2fd5966171", "sha256": "feab6f89d78e4d1d0e63a494c67ea2e652691598af2bd21b720c42794133c768" }, "downloads": -1, "filename": "ORMithorynque-0.1.1.tar.bz2", "has_sig": false, "md5_digest": "76e27989e62209a860927d2fd5966171", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 341895, "upload_time": "2016-06-18T11:46:06", "url": "https://files.pythonhosted.org/packages/c6/2b/b567398995654371665d5f75d9bc7dbd0be41b9bc3e79c06b2948ce2cc96/ORMithorynque-0.1.1.tar.bz2" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "76e27989e62209a860927d2fd5966171", "sha256": "feab6f89d78e4d1d0e63a494c67ea2e652691598af2bd21b720c42794133c768" }, "downloads": -1, "filename": "ORMithorynque-0.1.1.tar.bz2", "has_sig": false, "md5_digest": "76e27989e62209a860927d2fd5966171", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 341895, "upload_time": "2016-06-18T11:46:06", "url": "https://files.pythonhosted.org/packages/c6/2b/b567398995654371665d5f75d9bc7dbd0be41b9bc3e79c06b2948ce2cc96/ORMithorynque-0.1.1.tar.bz2" } ] }