{ "info": { "author": "Nick Johnstone", "author_email": "ncwjohnstone@gmail.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 2 - Pre-Alpha", "Intended Audience :: Developers", "Natural Language :: English", "Programming Language :: Python :: 2", "Programming Language :: Python :: 2.6", "Programming Language :: Python :: 2.7" ], "description": "butterdb\n========\n\n| Master: |Build Status Master|\n| Develop: |Build Status Develop|\n\n`Documentation`_ | `butterdb on PyPi`_\n\nbutterdb is a library to help you work with Google Spreadsheet data. It lets you model your data as Python objects, to be easily manipulated or created.\n\nHow do I use it?\n-----\n.. image:: http://i.imgur.com/h75z1k6.png\n\n::\n\n import butterdb\n import json\n\n # For getting OAuth Credential JSON file see http://gspread.readthedocs.org/en/latest/oauth2.html\n # Ensure that the client_email has been granted privileges to any workbooks you wish to access.\n\n with open('SomeGoogleProject-2a31d827b2a9.json') as credentials_file:\n json_key = json.load(credentials_file)\n\n client_email = json_key['client_email']\n private_key = str(json_key['private_key']).encode('utf-8')\n \n database = butterdb.Database(name=\"MyDatabaseSheet\", client_email=client_email, private_key=private_key)\n \n @butterdb.register(database)\n class User(butterdb.Model):\n def __init__(self, name, password):\n self.name = self.field(name)\n self.password = self.field(password)\n \n users = User.get_instances()\n \n marianne = users[1]\n \n print(marianne.password) # rainbow_trout\n \n marianne.password = \"hunter2\"\n marianne.commit()\n\n\nHow do I make instances?\n=================\n\n::\n\n bob = User(\"bob\", \"BestPassword!\")\n bob.commit()\n\n\nWhere do I get it?\n------------\n\n``pip install butterdb``\n\nSimple as that?\n---------------\nYep! butterdb is a simple interface around `gspread`_. Just .commit() your objects when you want to update the spreadsheet!\n\nHow do I run the tests?\n-----\n`nosetests`\n\nWhat works?\n----------\n* Store data in Google Spreadsheets (the cloud!!!)\n* Models from classes\n* Fields as attributes. decimals, ints and strings only (as far as I know)\n* Commits\n* Mocked unit tests, mock database\n* Arbitrary cell execution with `=blah()` (free stored procedures?)\n* Auto backup/bad patch control\n\nWhat's missing?\n---------------\n* Spreadsheets must exist before connecting\n* References\n* Collections\n* Customizable fields\n* Customizable table size (arbitrarily hardcoded)\n\nFeedback\n--------\nComments, concerns, issues and pull requests welcomed. Reddit /u/Widdershiny or email me at ncwjohnstone@gmail.com.\n\nLicense\n-------\n\nMIT License. See LICENSE file for full text.\n\n.. _Documentation: http://butterdb.readthedocs.org\n.. _butterdb on PyPi: https://pypi.python.org/pypi/butterdb\n.. _gspread: https://github.com/burnash/gspread\n\n.. |Build Status Master| image:: https://travis-ci.org/Widdershin/butterdb.png?branch=master\n :target: https://travis-ci.org/Widdershin/butterdb\n.. |Build Status Develop| image:: https://travis-ci.org/Widdershin/butterdb.png?branch=develop\n :target: https://travis-ci.org/Widdershin/butterdb\n\n\n\n\nHistory\n-------\n\n0.1.0 7/3/14\n++++++++++++++++++\n\n* First release on PyPI.\n\n0.1.1 7/3/14\n++++++++++++++++++\n\n* Converted readme to rst from md\n\n0.1.2 7/3/14\n++++++++++++++++++\n\n* Included HISTORY.rst in package build\n\n0.1.3 7/3/14\n++++++++++++++++++\n\n* Model.field no longer requires name to be specified. Attribute name will be used if none is provided.\n* Model no longer needs to have id as a keyword argument, or call super in init\n* Tests now use pep8 asserts\n\n0.1.4 7/4/14\n++++++++++++++++++\n\n* Renamed project to butterdb\n\n0.1.5 12/6/15\n++++++++++++++++++\n\n* Use OAuth instead of now deprecated simple login (thanks to @julierae!)\n* Fix a bug in get_instance that broke modifying fields (thanks to @dequis!)", "description_content_type": null, "docs_url": null, "download_url": "UNKNOWN", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/Widdershin/butterdb", "keywords": "butterdb", "license": "MIT", "maintainer": null, "maintainer_email": null, "name": "butterdb", "package_url": "https://pypi.org/project/butterdb/", "platform": "UNKNOWN", "project_url": "https://pypi.org/project/butterdb/", "project_urls": { "Download": "UNKNOWN", "Homepage": "https://github.com/Widdershin/butterdb" }, "release_url": "https://pypi.org/project/butterdb/0.1.5/", "requires_dist": null, "requires_python": null, "summary": "butterdb is a Python ORM for Google Drive Spreadsheets.", "version": "0.1.5" }, "last_serial": 1589120, "releases": { "0.1.3": [], "0.1.4": [ { "comment_text": "", "digests": { "md5": "3472b5bd2d2a591b56364dea1d5cde67", "sha256": "0edd242e2e082c200312d31dc79bd616e8258194a09e982f3da0abf5bd5fb268" }, "downloads": -1, "filename": "butterdb-0.1.4.tar.gz", "has_sig": false, "md5_digest": "3472b5bd2d2a591b56364dea1d5cde67", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5159, "upload_time": "2014-04-07T04:32:29", "url": "https://files.pythonhosted.org/packages/57/40/6a8e6140135b52baedc2b40b07aec56d9007b355292f8bcc9ad145b20d96/butterdb-0.1.4.tar.gz" } ], "0.1.5": [ { "comment_text": "", "digests": { "md5": "063c9a95dde3afd53d60e3f28ff33e32", "sha256": "c75d0c7d56e2c836fbf932afb6b4bd1bb74a747c81c9bd03efa795a4ea9c7f01" }, "downloads": -1, "filename": "butterdb-0.1.5.tar.gz", "has_sig": false, "md5_digest": "063c9a95dde3afd53d60e3f28ff33e32", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5922, "upload_time": "2015-06-12T06:22:05", "url": "https://files.pythonhosted.org/packages/a1/98/c08dfaeca39b2705377c4c27eda1b4ee51ef7b7041e14f2d17346556357e/butterdb-0.1.5.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "063c9a95dde3afd53d60e3f28ff33e32", "sha256": "c75d0c7d56e2c836fbf932afb6b4bd1bb74a747c81c9bd03efa795a4ea9c7f01" }, "downloads": -1, "filename": "butterdb-0.1.5.tar.gz", "has_sig": false, "md5_digest": "063c9a95dde3afd53d60e3f28ff33e32", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5922, "upload_time": "2015-06-12T06:22:05", "url": "https://files.pythonhosted.org/packages/a1/98/c08dfaeca39b2705377c4c27eda1b4ee51ef7b7041e14f2d17346556357e/butterdb-0.1.5.tar.gz" } ] }