{ "info": { "author": "chowmean", "author_email": "gaurav.dev.iiitm@gmail.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 4 - Beta", "Environment :: Plugins", "Intended Audience :: Developers", "License :: Other/Proprietary License", "Natural Language :: English", "Operating System :: OS Independent", "Programming Language :: Python", "Topic :: Software Development :: Libraries :: Python Modules" ], "description": "# DBSheet\nUsing google spreadsheets as database. \n\n## This package helps you make use of google sheets as databases. What all it supports \n\n1. Creating Tables\n2. Inserting Rows\n3. Get all records\n4. Search for One Row\n5. Search for particular number of Rows \n\n## How to initialize\n```python\nfrom db_sheet.db_sheet import DbSheet\nfrom db_sheet.sheet_table import WorkingTable, CreateTable, Table\ndb = DbSheet(db_name = \"SHEETBACKEND\", api_creds = \"client_secret.json\", scope = ['https://spreadsheets.google.com/feeds'])\nsheet = db.get_db_conn()\n```\n\nSheet is like database.\n\n\n### Creating tables\n\n```python\nfrom db_sheet.db_sheet import DbSheet\nfrom db_sheet.sheet_table import WorkingTable, CreateTable, Table\ndb = DbSheet(db_name = \"SHEETBACKEND\", api_creds = \"client_secret.json\", scope = ['https://spreadsheets.google.com/feeds'])\nsheet = db.get_db_conn()\ntable = Table({\"Col1\",\"col2\"},\"name_of_table\")\ncreator = CreateTable(table, sheet)\ncreator.create_table()\n```\n\n### Inserting Rows\n\n```python\nfrom db_sheet.sheet_table import WorkingTable, CreateTable, Table\nworking_table = WorkingTable(\"tablename\",sheet)\nworking_table.insert({\"value1\",\"value2\"}\n```\n\n\n### Get all records\n\n```python\nfrom db_sheet.sheet_table import WorkingTable, CreateTable, Table\nworking_table = WorkingTable(\"tablename\",sheet)\nworking_table.get_all()\n```\n\n### Search for One Row\n\n```python\nfrom db_sheet.sheet_table import WorkingTable, CreateTable, Table\nworking_table = WorkingTable(\"tablename\",sheet)\nworking_table.get_one(\"column_name\",value)\n```\n\n### Search for particular number of Rows \n\n```python\nfrom db_sheet.sheet_table import WorkingTable, CreateTable, Table\nworking_table = WorkingTable(\"tablename\",sheet)\nworking_table.find(\"column_name\",value,total_count_u_need)\n```\n\n\n## Contribution:\n\n### You can contibute by following below simple steps.\n\n1. Make sure your build is passing\n2. Keep your code clean and proper commenting with pep8. \n\nThats it for now. Will add more since its just a begginging.\nSuggestions are welcome. Please create an issue if you think this is **** and you can make it better :D\n\n@ Author: chowmean", "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/chowmean/DBSheet", "keywords": "DBSheet, db_sheet, google spreadsheets. excel", "license": "Apache-2.0", "maintainer": "", "maintainer_email": "", "name": "db-sheet", "package_url": "https://pypi.org/project/db-sheet/", "platform": "", "project_url": "https://pypi.org/project/db-sheet/", "project_urls": { "Homepage": "https://github.com/chowmean/DBSheet" }, "release_url": "https://pypi.org/project/db-sheet/0.1.4/", "requires_dist": null, "requires_python": "", "summary": "db_sheet: Using Google Spreadsheets as Database.", "version": "0.1.4" }, "last_serial": 4658129, "releases": { "0.1.1": [ { "comment_text": "", "digests": { "md5": "d722d9b82b901561c03bebb975440086", "sha256": "e5d0214cd57c3fe9fa0801b1665368e52a4f1facaa9ceae5094564c7596e5212" }, "downloads": -1, "filename": "db_sheet-0.1.1.tar.gz", "has_sig": false, "md5_digest": "d722d9b82b901561c03bebb975440086", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3248, "upload_time": "2019-01-03T22:50:03", "url": "https://files.pythonhosted.org/packages/f0/32/280cc446ae0c3db22b0f4657fefa619da4c6f858ab5d8b680ff14eb82d1c/db_sheet-0.1.1.tar.gz" } ], "0.1.2": [ { "comment_text": "", "digests": { "md5": "9074148a097af1b0c9e580f0cfcb162c", "sha256": "c8377db370a6a74d115ae061082795299abbca60da26a4f51478bdfcb852d5a0" }, "downloads": -1, "filename": "db_sheet-0.1.2.tar.gz", "has_sig": false, "md5_digest": "9074148a097af1b0c9e580f0cfcb162c", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3473, "upload_time": "2019-01-03T22:55:46", "url": "https://files.pythonhosted.org/packages/67/8b/8c523245ef5e2cad49afe9ae88678a05b7425a1d2e009590aa6648decebc/db_sheet-0.1.2.tar.gz" } ], "0.1.3": [ { "comment_text": "", "digests": { "md5": "0f81187d973af8eb9331a39df737084d", "sha256": "dcc51187074483ef7a98801259ee74bb617c0781895ce53e919048efb0f86cbe" }, "downloads": -1, "filename": "db_sheet-0.1.3.tar.gz", "has_sig": false, "md5_digest": "0f81187d973af8eb9331a39df737084d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3493, "upload_time": "2019-01-03T22:58:42", "url": "https://files.pythonhosted.org/packages/fa/ed/2e81630a9fc680334f211440cc1a8b19963cea3c5dd4cf501a93cfda6e5a/db_sheet-0.1.3.tar.gz" } ], "0.1.4": [ { "comment_text": "", "digests": { "md5": "430054a926b54a36c178a33ae754ca1b", "sha256": "8cd56628a20ec3c91b119b9579290e9072873e07c0909635f81778ed0a038967" }, "downloads": -1, "filename": "db_sheet-0.1.4.tar.gz", "has_sig": false, "md5_digest": "430054a926b54a36c178a33ae754ca1b", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3510, "upload_time": "2019-01-03T23:00:36", "url": "https://files.pythonhosted.org/packages/00/b0/a87b66f0ea81e22b417b04fdadf7838f1da84dd8a50428df0c89fc29e207/db_sheet-0.1.4.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "430054a926b54a36c178a33ae754ca1b", "sha256": "8cd56628a20ec3c91b119b9579290e9072873e07c0909635f81778ed0a038967" }, "downloads": -1, "filename": "db_sheet-0.1.4.tar.gz", "has_sig": false, "md5_digest": "430054a926b54a36c178a33ae754ca1b", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3510, "upload_time": "2019-01-03T23:00:36", "url": "https://files.pythonhosted.org/packages/00/b0/a87b66f0ea81e22b417b04fdadf7838f1da84dd8a50428df0c89fc29e207/db_sheet-0.1.4.tar.gz" } ] }