{ "info": { "author": "Open Knowledge Foundation", "author_email": "info@okfn.org", "bugtrack_url": null, "classifiers": [ "Development Status :: 4 - Beta", "Environment :: Web Environment", "Intended Audience :: Developers", "License :: OSI Approved :: MIT License", "Operating System :: OS Independent", "Programming Language :: Python :: 2", "Programming Language :: Python :: 2.7", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.3", "Programming Language :: Python :: 3.4", "Programming Language :: Python :: 3.5", "Topic :: Internet :: WWW/HTTP :: Dynamic Content", "Topic :: Software Development :: Libraries :: Python Modules" ], "description": "jsontableschema-bigquery-py\n===========================\n\n| |Travis|\n| |Coveralls|\n| |PyPi|\n| |SemVer|\n| |Gitter|\n\nGenerate and load BigQuery tables based on JSON Table Schema\ndescriptors.\n\n Version ``v0.3`` contains breaking changes:\n\n- renamed ``Storage.tables`` to ``Storage.buckets``\n- changed ``Storage.read`` to read into memory\n- added ``Storage.iter`` to yield row by row\n\nGetting Started\n---------------\n\nInstallation\n~~~~~~~~~~~~\n\n.. code:: bash\n\n pip install jsontableschema-bigquery\n\nStorage\n~~~~~~~\n\nPackage implements `Tabular\nStorage `__\ninterface.\n\nTo start using Google BigQuery service:\n\n- Create a new project -\n `link `__\n- Create a service key -\n `link `__\n- Download json credentials and set ``GOOGLE_APPLICATION_CREDENTIALS``\n environment variable\n\nWe can get storage this way:\n\n.. code:: python\n\n import io\n import os\n import json\n from apiclient.discovery import build\n from oauth2client.client import GoogleCredentials\n from jsontableschema_bigquery import Storage\n\n os.environ['GOOGLE_APPLICATION_CREDENTIALS'] = '.credentials.json'\n credentials = GoogleCredentials.get_application_default()\n service = build('bigquery', 'v2', credentials=credentials)\n project = json.load(io.open('.credentials.json', encoding='utf-8'))['project_id']\n storage = Storage(service, project, 'dataset', prefix='prefix')\n\nThen we could interact with storage:\n\n.. code:: python\n\n storage.buckets\n storage.create('bucket', descriptor)\n storage.delete('bucket')\n storage.describe('bucket') # return descriptor\n storage.iter('bucket') # yields rows\n storage.read('bucket') # return rows\n storage.write('bucket', rows)\n\nMappings\n~~~~~~~~\n\n::\n\n schema.json -> bigquery table schema\n data.csv -> bigquery talbe data\n\nDrivers\n~~~~~~~\n\nDefault Google BigQuery client is used -\n`docs `__.\n\nAPI Reference\n-------------\n\nSnapshot\n~~~~~~~~\n\nhttps://github.com/frictionlessdata/jsontableschema-py#snapshot\n\nDetailed\n~~~~~~~~\n\n- `Docstrings `__\n- `Changelog `__\n\nContributing\n------------\n\nPlease read the contribution guideline:\n\n`How to Contribute `__\n\nThanks!\n\n.. |Travis| image:: https://img.shields.io/travis/frictionlessdata/jsontableschema-bigquery-py/master.svg\n :target: https://travis-ci.org/frictionlessdata/jsontableschema-bigquery-py\n.. |Coveralls| image:: http://img.shields.io/coveralls/frictionlessdata/jsontableschema-bigquery-py.svg?branch=master\n :target: https://coveralls.io/r/frictionlessdata/jsontableschema-bigquery-py?branch=master\n.. |PyPi| image:: https://img.shields.io/pypi/v/jsontableschema-bigquery.svg\n :target: https://pypi.python.org/pypi/jsontableschema-bigquery\n.. |SemVer| image:: https://img.shields.io/badge/versions-SemVer-brightgreen.svg\n :target: http://semver.org/\n.. |Gitter| image:: https://img.shields.io/gitter/room/frictionlessdata/chat.svg\n :target: https://gitter.im/frictionlessdata/chat\n\n", "description_content_type": null, "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/frictionlessdata/jsontableschema-bigquery-py", "keywords": "frictionless data", "license": "MIT", "maintainer": "", "maintainer_email": "", "name": "jsontableschema-bigquery", "package_url": "https://pypi.org/project/jsontableschema-bigquery/", "platform": "", "project_url": "https://pypi.org/project/jsontableschema-bigquery/", "project_urls": { "Homepage": "https://github.com/frictionlessdata/jsontableschema-bigquery-py" }, "release_url": "https://pypi.org/project/jsontableschema-bigquery/0.5.0/", "requires_dist": [ "google-api-python-client (>=1.5,<2.0)", "jsontableschema (>=0.7,<2.0)", "python-slugify (>=1.2,<2.0)", "six (>=1.9,<2.0)", "tabulator (>=0.7,<2.0)", "unicodecsv (>=0.14,<2.0)", "pylama; extra == 'develop'", "tox; extra == 'develop'" ], "requires_python": "", "summary": "Generate BigQuery tables, load and extract data, based on JSON Table Schema descriptors.", "version": "0.5.0" }, "last_serial": 3149755, "releases": { "0.1.2": [ { "comment_text": "", "digests": { "md5": "619a31ec6e985b42f780c77bd841083b", "sha256": "8e92fb9f886dd5832781e9d54708118ff5f079571df30dce6fbcaec140a7a21c" }, "downloads": -1, "filename": "jsontableschema-bigquery-0.1.2.tar.gz", "has_sig": false, "md5_digest": "619a31ec6e985b42f780c77bd841083b", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 7936, "upload_time": "2016-03-26T10:57:36", "url": "https://files.pythonhosted.org/packages/8f/78/5df299f34c61ffadf3a5057bef6279db072c3fb74d8872cb689583651ea3/jsontableschema-bigquery-0.1.2.tar.gz" } ], "0.1.3": [ { "comment_text": "", "digests": { "md5": "a92e1744e83df31a9fd5ac28c0c5a500", "sha256": "2bf9036f167f032f67a3d17f6d1b76ec02ece7bc7249610f46dc9f32b1e94bbf" }, "downloads": -1, "filename": "jsontableschema_bigquery-0.1.3-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "a92e1744e83df31a9fd5ac28c0c5a500", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 10150, "upload_time": "2016-03-28T09:45:30", "url": "https://files.pythonhosted.org/packages/54/cf/6617bf43e430b107d58a07be3c15da568de6a172eebef29eb8fc91caf5c9/jsontableschema_bigquery-0.1.3-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "532622e0d3f209fb1f9e1a818f63701b", "sha256": "8063ac4b755b55d56edd6d7b1ff2dcc47d8049d38bfee6f8d17d9d8e676321aa" }, "downloads": -1, "filename": "jsontableschema-bigquery-0.1.3.tar.gz", "has_sig": false, "md5_digest": "532622e0d3f209fb1f9e1a818f63701b", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 7959, "upload_time": "2016-03-28T09:45:49", "url": "https://files.pythonhosted.org/packages/7f/c6/a6e5cc2b9f7be5cc19d9eafce0ab8f33376c6a74cbb8b8f01a44aa062aee/jsontableschema-bigquery-0.1.3.tar.gz" } ], "0.2.0": [ { "comment_text": "", "digests": { "md5": "755881214b6e7e5d7500c41053e91eeb", "sha256": "4b8a24f724a8db06c2b627667c5374dc964bc9c411011fcfa666eee726d8d0c0" }, "downloads": -1, "filename": "jsontableschema_bigquery-0.2.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "755881214b6e7e5d7500c41053e91eeb", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 8909, "upload_time": "2016-04-26T11:18:12", "url": "https://files.pythonhosted.org/packages/2f/83/3ae5da1104c49cca90e51de0bc609a0e468ba37cd4bf5feb242ef8156cf0/jsontableschema_bigquery-0.2.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "2ec6b5d1b17d2cfdd479b17e822f2d23", "sha256": "4a1d95f91ba99d5f3f77a05f312dc09d6aceaa5da48b9e4a29189b1407cc09a7" }, "downloads": -1, "filename": "jsontableschema-bigquery-0.2.0.tar.gz", "has_sig": false, "md5_digest": "2ec6b5d1b17d2cfdd479b17e822f2d23", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 7643, "upload_time": "2016-04-26T11:18:28", "url": "https://files.pythonhosted.org/packages/61/fe/466334246d577ed65ee44452e30c8336c680b29a68ea389333719e4910f3/jsontableschema-bigquery-0.2.0.tar.gz" } ], "0.2.1": [ { "comment_text": "", "digests": { "md5": "e375239ec153896848626ced09b82352", "sha256": "22ccc937e16aad10d96274b0910e1380604bf83d68ac0ca504d7ae3ffa6aee7d" }, "downloads": -1, "filename": "jsontableschema_bigquery-0.2.1-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "e375239ec153896848626ced09b82352", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 9005, "upload_time": "2016-05-12T15:26:49", "url": "https://files.pythonhosted.org/packages/0a/3b/bf62eb688c2e1bba983642a54cc902bc370ffa83fed1f468ba840d746d58/jsontableschema_bigquery-0.2.1-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "159eecf421edec29a4f3fbf1ea3eb7a6", "sha256": "2243fcb8c317b2655f4c701e3fc0f10f8c27694c5317b04c20bb0f8faf176526" }, "downloads": -1, "filename": "jsontableschema-bigquery-0.2.1.tar.gz", "has_sig": false, "md5_digest": "159eecf421edec29a4f3fbf1ea3eb7a6", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 7737, "upload_time": "2016-05-12T15:26:56", "url": "https://files.pythonhosted.org/packages/c0/d6/2bc0045419f8be43939fb3fbeeaccdb0c1381149a6fd07a67e71949a9e60/jsontableschema-bigquery-0.2.1.tar.gz" } ], "0.3.0": [ { "comment_text": "", "digests": { "md5": "ab37e5cc55963d4ee551e834b612f63b", "sha256": "9843c495120ad3b16ea033a9f1da0ae63bd65829c8b76c25d51a34f4509576cf" }, "downloads": -1, "filename": "jsontableschema_bigquery-0.3.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "ab37e5cc55963d4ee551e834b612f63b", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 9402, "upload_time": "2016-10-26T14:03:53", "url": "https://files.pythonhosted.org/packages/33/14/35797ba28d2f022eb3096b84ee6be7d43b6786791870a6ae3c76b923dbe4/jsontableschema_bigquery-0.3.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "9363a3902bd120f3727cc98d82f0ba84", "sha256": "42952ba2ac4b7d7ca1f23e920b63aa9d256002d86137cc4b8f3346b0409573dd" }, "downloads": -1, "filename": "jsontableschema-bigquery-0.3.0.tar.gz", "has_sig": false, "md5_digest": "9363a3902bd120f3727cc98d82f0ba84", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 7860, "upload_time": "2016-10-26T14:03:55", "url": "https://files.pythonhosted.org/packages/46/39/1c96a01b78ff261b9d63db42bda9d5b23247396b23275c0bb4573cc1e0c5/jsontableschema-bigquery-0.3.0.tar.gz" } ], "0.4.2": [ { "comment_text": "", "digests": { "md5": "53d15211ac0175f232522224656b466d", "sha256": "c5cc2e6629dee885ceac013580890f1b44e3465d66596208a57b95efba762e67" }, "downloads": -1, "filename": "jsontableschema_bigquery-0.4.2-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "53d15211ac0175f232522224656b466d", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 9224, "upload_time": "2017-06-06T09:22:58", "url": "https://files.pythonhosted.org/packages/aa/df/46b62c459f8999ed52381b219c466a1080d2540a36eff016408ce8bb75eb/jsontableschema_bigquery-0.4.2-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "0f1ed4547b53f55346bf947281203227", "sha256": "6337572236c0553da6b0870f5dbcd2b947fa9502fadec6d695e2761da9d024b1" }, "downloads": -1, "filename": "jsontableschema-bigquery-0.4.2.tar.gz", "has_sig": false, "md5_digest": "0f1ed4547b53f55346bf947281203227", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 7429, "upload_time": "2017-06-06T09:23:00", "url": "https://files.pythonhosted.org/packages/9e/b7/648fba80ddec104df629f999de024d9e4ef4d77fae1a578379052e07b45a/jsontableschema-bigquery-0.4.2.tar.gz" } ], "0.4.3": [ { "comment_text": "", "digests": { "md5": "19fed5e7080f59d63c65af74113426ef", "sha256": "f00e88791284f37d6cd9d3c801522cc44cc8904d40bf13d3de726705a58273a3" }, "downloads": -1, "filename": "jsontableschema_bigquery-0.4.3-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "19fed5e7080f59d63c65af74113426ef", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 9393, "upload_time": "2017-06-09T08:27:40", "url": "https://files.pythonhosted.org/packages/ba/52/3d6cbc4c9661f7a4c044efa67e7028c38d9c4d00a0bc5ba3403d9b6fd8f6/jsontableschema_bigquery-0.4.3-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "1450627939c2b330f4943f0f6c96b7a2", "sha256": "6c39c30a583d17579516772a292309193cb7fe0909f15533d4e77a863b4d247b" }, "downloads": -1, "filename": "jsontableschema-bigquery-0.4.3.tar.gz", "has_sig": false, "md5_digest": "1450627939c2b330f4943f0f6c96b7a2", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 7871, "upload_time": "2017-06-09T08:27:42", "url": "https://files.pythonhosted.org/packages/bf/f8/74ef255e79eb44d2ee1a1632260673b0ed6a21ed99a9912dc7f4de30a54a/jsontableschema-bigquery-0.4.3.tar.gz" } ], "0.5.0": [ { "comment_text": "", "digests": { "md5": "a00d2925498046f38be74fe091497aa8", "sha256": "ab26f4b081130675b7ec0b2f55ecf047ad840a8493a990a93d3356f3ad6a053e" }, "downloads": -1, "filename": "jsontableschema_bigquery-0.5.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "a00d2925498046f38be74fe091497aa8", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 9493, "upload_time": "2017-09-05T08:39:49", "url": "https://files.pythonhosted.org/packages/58/08/efcf7dab5af14aa683d67c519a0f6235c3c940d8d7dbd877093d891f5dc2/jsontableschema_bigquery-0.5.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "d545c1d3c8dc1f029b66bc541f8b8983", "sha256": "2aa5db666d81c652aa3a0cc6ffc7d5a668518a2455b9901d44f82af0f7d77197" }, "downloads": -1, "filename": "jsontableschema-bigquery-0.5.0.tar.gz", "has_sig": false, "md5_digest": "d545c1d3c8dc1f029b66bc541f8b8983", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 8006, "upload_time": "2017-09-05T08:39:50", "url": "https://files.pythonhosted.org/packages/07/e6/acc1ca3ef200c44967705c16f7c2db0c8dd9a8c274786e3b74f4eafa393c/jsontableschema-bigquery-0.5.0.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "a00d2925498046f38be74fe091497aa8", "sha256": "ab26f4b081130675b7ec0b2f55ecf047ad840a8493a990a93d3356f3ad6a053e" }, "downloads": -1, "filename": "jsontableschema_bigquery-0.5.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "a00d2925498046f38be74fe091497aa8", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 9493, "upload_time": "2017-09-05T08:39:49", "url": "https://files.pythonhosted.org/packages/58/08/efcf7dab5af14aa683d67c519a0f6235c3c940d8d7dbd877093d891f5dc2/jsontableschema_bigquery-0.5.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "d545c1d3c8dc1f029b66bc541f8b8983", "sha256": "2aa5db666d81c652aa3a0cc6ffc7d5a668518a2455b9901d44f82af0f7d77197" }, "downloads": -1, "filename": "jsontableschema-bigquery-0.5.0.tar.gz", "has_sig": false, "md5_digest": "d545c1d3c8dc1f029b66bc541f8b8983", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 8006, "upload_time": "2017-09-05T08:39:50", "url": "https://files.pythonhosted.org/packages/07/e6/acc1ca3ef200c44967705c16f7c2db0c8dd9a8c274786e3b74f4eafa393c/jsontableschema-bigquery-0.5.0.tar.gz" } ] }