{ "info": { "author": "Lane", "author_email": "GeekerLane@gmail.com", "bugtrack_url": null, "classifiers": [ "License :: OSI Approved :: MIT License", "Operating System :: OS Independent", "Programming Language :: Python :: 3" ], "description": "# \u963f\u91cc\u4e91\u76f8\u5173\u64cd\u4f5c\n\n\u963f\u91cc\u4e91\u8868\u683c\u76f8\u5173\u64cd\u4f5c\n\n\u76ee\u524d\u652f\u6301\uff1a\n\n- \u8f93\u51fa\u7d22\u5f15\u4fe1\u606f\n- \u67e5\u8be2\u5168\u90e8\u6570\u636e\n- \u8868\u683c\u67e5\u8be2\uff1a\u77ed\u8bed\u67e5\u8be2\uff0c\u524d\u7f00\u5339\u914d\u67e5\u8be2\uff0c\u7cbe\u51c6\u67e5\u8be2\uff0c\u8303\u56f4\u67e5\u8be2\n- \u63d2\u5165\u6570\u636e\n- \u66f4\u65b0\u6570\u636e\n\n\u5f85\u589e\u52a0\uff1a\n- \u4f18\u5316\u66f4\u65b0\u51fd\u6570\n- \u589e\u52a0\u521b\u5efa\u8868\uff0c\u5220\u9664\u8868\uff0c\u67e5\u8be2\u793a\u4f8b\u5217\u8868\uff0c\u67e5\u8be2\u8868\u7684\u5217\u8868\n- \u4f18\u5316\u957f\u65f6\u95f4\u67e5\u8be2(\u907f\u514d\u8fde\u63a5\u4e2d\u65ad\u5e26\u6765\u7684\u67e5\u8be2\u4e2d\u65ad)\n\n\u6ce8\u610f\uff1a\u963f\u91cc\u4e91\u64cd\u4f5c\u8bf7\u4f7f\u7528\u5185\u7f51, \u7d22\u5f15\u540d\u9ed8\u8ba4\u4e3afilter, \u8be5\u6a21\u5757\u76ee\u524d\u53eatopwin\u5185\u90e8\u4f7f\u7528.\n\n## \u5b89\u88c5\n\n```bash\npip install aliyun_table_topwin\n```\n\n\u5982\u679c\u5df2\u7ecf\u5b89\u88c5\uff0c\u53ef\u4ee5\u7528\u4e0b\u9762\u547d\u4ee4\u5347\u7ea7\uff1a\n\n```bash\npip install --upgrade aliyun_table_topwin\n```\n\n\u5b89\u88c5\u5b8c\u6210\u540e\uff0c\u5728\u4ea4\u4e92\u754c\u9762\u6267\u884c\uff1a\n\n```python\n>>> from aliyun_table import TableClient\n```\n\n\u5982\u679c\u6ca1\u6709\u62a5\u9519\uff0c\u8bf4\u660e\u5b89\u88c5\u6210\u529f\n\n### \u8f93\u51fa\u7d22\u5f15\n\n```python\nfrom aliyun_table import TableClient\n# \u521d\u59cb\u5316\u8868\u683c\u5b58\u50a8\u7c7b, \u7ed9\u5b9a\u5b9e\u4f8b\u540d\u548c\u8868\u540d\ntable_cli = TableClient(table_name='douyin_video', instance_name='Video')\n# \u8f93\u51fa\u7d22\u5f15\u4fe1\u606f\ntable_cli.show_index()\n```\n\n### \u63d2\u5165\u6570\u636e\u548c\u66f4\u65b0\u6570\u636e\n\n\u63d2\u5165\u6570\u636e\u548c\u66f4\u65b0\u6570\u636e\u53ef\u4ee5\u76f4\u63a5\u4f20\u5165\u6570\u636e\u5b57\u5178.\n\n```python\nfrom aliyun_table import TableClient\n\n# \u521d\u59cb\u5316\u8868\u683c\u5b58\u50a8\u7c7b, \u7ed9\u5b9a\u5b9e\u4f8b\u540d\u548c\u8868\u540d\ntable_cli = TableClient(table_name='test_video', instance_name='Video')\n\nd = {\n '_id': 'a03de98a3f',\n 'user_name': 'test_user',\n 'video_id': '1231985983120',\n 'description': 'hahaha',\n}\n\n# put_row()\u53ea\u6709\u6570\u636e\u4e0d\u5b58\u5728\u65f6\u624d\u63d2\u5165\uff0c\u7b2c\u4e00\u4e2a\u53c2\u6570\u4e3a\u4e3b\u952e\u540d\uff0c\u7b2c\u4e8c\u4e2a\u53c2\u6570\u4e3a\u5168\u90e8\u6570\u636e\u7684\u5b57\u5178.\ntable_cli.put_row('_id', d)\n\nd = {\n '_id': 'a03de98a3f',\n 'user_name': 'test_user0000',\n 'video_id': '123456789',\n 'description': 'lol',\n}\n# update_row()\u76ee\u524d\u4e3a\u5f3a\u5236\u66f4\u65b0, \u53c2\u6570\u540cput_row\ntable_cli.put_row('_id', d)\n```\n\n## \u67e5\u8be2 \n\n\u67e5\u8be2\u51fd\u6570```query()```\u63a5\u6536\u7684\u53c2\u6570\uff1a\n\u5982\u679c```get_total_count```\u4e3a```True```, \u8fed\u4ee3\u5668\u8fd4\u56de\u7684\u6570\u636e\u4e3a\u4e00\u4e2a\u4e8c\u5143\u7ec4: \n\t(\u67e5\u8be2\u5230\u7684\u6570\u91cf\uff0c\u67e5\u8be2\u5230\u7684\u6570\u636e\u5b57\u5178)\n\u5982\u679c```get_total_count```\u4e3a```False```, \u8fed\u4ee3\u5668\u8fd4\u56de\u7684\u6570\u636e\u4e3a\u5355\u72ec\u7684\u6570\u636e\u5b57\u5178\u3002\n\n\n```python\ndef query(self, \n\t must_query_list=[], \n\t must_not_query_list=[], \n\t should_query_list=[], \n\t get_total_count=False, \n\t sort_list=None, \n\t index_name='filter', \n\t column_to_get=None):\n :param must_query_list: \u9700\u8981\u6ee1\u8db3\u7684\u67e5\u8be2\u6761\u4ef6\u5217\u8868, \u4e0d\u6307\u5b9a\u5219\u9ed8\u8ba4\u4e3a\u67e5\u8be2\u5168\u90e8\u6570\u636e\n :param must_not_query_list: \u4e0d\u67e5\u8be2\u7684\u6761\u4ef6\u5217\u8868\uff08\u6ee1\u8db3\u8fd9\u4e9b\u6761\u4ef6\u7684\u6570\u636e\u4e0d\u67e5\u8be2\n :param should_query_list: should query\u6761\u4ef6\u5217\u8868\n :param get_total_count: \u662f\u5426\u9700\u8981\u83b7\u53d6\u67e5\u8be2\u5230\u7684\u603b\u6570\u91cf\n :param sort_list: \u5217\u7684\u6392\u5e8f\u5217\u8868\uff0c\u683c\u5f0f\u4e3alist. \u9ed8\u8ba4\u4e0d\u6392\u5e8f\n ...\n```\n\n### \u67e5\u8be2\u5217\u8868\u7684\u6784\u9020\n\n\u67e5\u8be2\u5217\u8868\u7684\u6784\u9020\u4e3a\u4e00\u4e2a\u4e09\u5143\u7ec4:\n(\u67e5\u8be2\u7c7b\u578b\uff0c\u67e5\u8be2\u7684\u5217\uff0c\u67e5\u8be2\u7684\u5185\u5bb9)\n\n!!!\u8bf7\u4fdd\u8bc1\u67e5\u8be2\u7684\u5217\u5728\u7d22\u5f15\u4e2d\n\n1.\u8303\u56f4\u67e5\u8be2\uff1a\n\n\u8303\u56f4\u67e5\u8be2\u652f\u6301\u5f00\u95ed\u533a\u95f4, \u652f\u6301\u6574\u578b\u548c\u5b57\u7b26\u4e32\u7c7b\u578b\n\n```python\n('range', 'save_time', '[1528008647000, 1528008657000]')\n('range', 'like_count', '(100, 200]')\n# \u5b57\u7b26\u4e32\u7c7b\u578b\u4e5f\u53ef\u4ee5\n('range', '_id', '[\"abcdefg\", \"sdfinegl123\"]')\n```\n\n2.\u7cbe\u51c6\u67e5\u8be2\n\n\n```python\n# \u67e5\u8be2user_id\u4e3a123456\u7684\u6570\u636e\n('term', 'user_id', '123456')\n# \u6784\u9020\u591a\u4e2a\u7cbe\u51c6\u67e5\u8be2, \u6ce8\u610f\u6b64\u65f6\u67e5\u8be2\u5185\u5bb9\u5e94\u4e3a\u5217\u8868 (terms\u67e5\u8be2\u5c1a\u672a\u6d4b\u8bd5)\n('terms', 'user_id', ['123456', '123', '33445'])\n```\n\n3.\u77ed\u8bed\u5339\u914d\u67e5\u8be2\n\n```python\n# \u67e5\u8be2\u7528\u6237\u540d\u5305\u542b`\u9648\u8d6b`\u7684\u6570\u636e\n('phrase', 'user_name', '\u9648\u8d6b')\n```\n\n4.\u524d\u7f00\u5339\u914d\u67e5\u8be2\n\n```python\n# \u67e5\u8be2\u7528\u6237\u540d\u524d\u7f00\u4e3a`\u54c8\u54c8\u54c8`\u7684\u7528\u6237\n('phrase', 'user_name', '\u54c8\u54c8\u54c8')\n```\n\n\n## \u67e5\u8be2\u793a\u4f8b\n\n\u67e5\u8be2\u548c\u6392\u5e8f\n\n```python\nfrom aliyun_table import TableClient\nvideo_client = TableClient(instance_name='Video', table_name='douyin_video')\n\n# \u67e5\u8be2\u65f6\u95f4\u8303\u56f4, \u8303\u56f4\u7684\u8303\u56f4\u5f62\u5f0f\u4e3a\u5f00\u95ed\u533a\u95f4,\u5b57\u7b26\u4e32\u53ef\u4ee5\u52a0\u5f15\u53f7\nmust_query_list = [\n ('range', 'save_time', '[1528008647000, 1528008657000]')\n]\n\n# \u5148\u6309\u7167\u70b9\u8d5e\u6570\u5012\u5e8f, (1\u4e3a\u6b63\u5e8f, -1\u4e3a\u5012\u5e8f), \u70b9\u8d5e\u6570\u76f8\u540c\u518d\u6309\u4fdd\u5b58\u65f6\u95f4\u5012\u5e8f\nsort_list = [\n ('like_count', -1),\n ('save_time', -1),\n]\n\n# \u5f00\u59cb\u67e5\u8be2\nfor item in video_client.query(must_query_list=must_query_list, sort_list=sort_list):\n\tprint(item)\n\n```\n\n\n\u7ec4\u5408\u6761\u4ef6\u67e5\u8be2:\n\n```python\n\"\"\"\n\u67e5\u8be2\u7528\u6237\u540d\u5305\u542b\u9648\u8d6b, \u70b9\u8d5e\u6570\u5927\u4e8e10000, \u5e76\u4e14\u63cf\u8ff0\u4e0d\u5305\u542b'\u54c8\u54c8\u54c8' \u7684\u89c6\u9891.\n\"\"\"\n\nfrom aliyun_table import TableClient\nvideo_client = TableClient(instance_name='Video', table_name='douyin_video')\n\n# \u67e5\u8be2\nmust_query_list = [\n ('phrase', 'user_name', '\u9648\u8d6b'),\n ('range', 'like_count', '[10000, 1111111111111111]'),\n]\nmust_not_query_list = [\n ('phrase', 'description', '\u54c8\u54c8\u54c8'),\n]\n# \u6309\u7167\u70b9\u8d5e\u6570\u5012\u5e8f, 1\u4e3a\u6b63\u5e8f, -1\u4e3a\u5012\u5e8f\nsort_list = [\n ('like_count', -1),\n]\n# query()\u51fd\u6570\u4f1a\u8fd4\u56de\u4e00\u4e2a\u751f\u6210\u5668\uff0c\u76f4\u63a5\u904d\u5386\u5c31\u53ef\u4ee5, \u4e0d\u9700\u8981\u7ffb\u9875.\nfor item in video_client.query(must_query_list=must_query_list, sort_list=sort_list):\n\tprint(item)\n\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": "", "keywords": "", "license": "", "maintainer": "", "maintainer_email": "", "name": "aliyun-table-topwin", "package_url": "https://pypi.org/project/aliyun-table-topwin/", "platform": "", "project_url": "https://pypi.org/project/aliyun-table-topwin/", "project_urls": null, "release_url": "https://pypi.org/project/aliyun-table-topwin/0.1.3/", "requires_dist": [ "pprint", "tablestore", "prettytable" ], "requires_python": ">=3.6", "summary": "Aliyun Table Store Operations", "version": "0.1.3" }, "last_serial": 6005546, "releases": { "0.1.0": [ { "comment_text": "", "digests": { "md5": "da58497624287d7a9ee89276532da03b", "sha256": "932b0a019d150104646af85fd37c2d7152befe7f967b7d9111e6a3b6c23b2c9d" }, "downloads": -1, "filename": "aliyun_table_topwin-0.1.0-py3-none-any.whl", "has_sig": false, "md5_digest": "da58497624287d7a9ee89276532da03b", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.6", "size": 17890, "upload_time": "2019-10-21T04:04:30", "url": "https://files.pythonhosted.org/packages/a1/1f/78089ebc3348dbe222d5cacca1d0104d81e0843bb0df85f343a751da066d/aliyun_table_topwin-0.1.0-py3-none-any.whl" } ], "0.1.1": [ { "comment_text": "", "digests": { "md5": "58c7905cd53fb1f247f4af744249d15b", "sha256": "f02b5456cb8fded466b0330194bcd423a81abf8b27c9614adaf25d0350493179" }, "downloads": -1, "filename": "aliyun_table_topwin-0.1.1-py3-none-any.whl", "has_sig": false, "md5_digest": "58c7905cd53fb1f247f4af744249d15b", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.6", "size": 19564, "upload_time": "2019-10-21T05:22:14", "url": "https://files.pythonhosted.org/packages/fd/ad/46e16aae40223bb24b94352a2abd80b6a769fe58b01eef20c1ee1a28fbeb/aliyun_table_topwin-0.1.1-py3-none-any.whl" } ], "0.1.2": [ { "comment_text": "", "digests": { "md5": "4e8d9e195fe20a35c05fe122390f33b2", "sha256": "6efa4f18d31eecec91ceb6d8b49a431799c684044980c8e746ab6436e027aef2" }, "downloads": -1, "filename": "aliyun_table_topwin-0.1.2-py3-none-any.whl", "has_sig": false, "md5_digest": "4e8d9e195fe20a35c05fe122390f33b2", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.6", "size": 19578, "upload_time": "2019-10-21T05:26:47", "url": "https://files.pythonhosted.org/packages/c0/1c/6ba737696cadf5150172bb6230b57f034c24c2ad1f202937c0f0c422c086/aliyun_table_topwin-0.1.2-py3-none-any.whl" } ], "0.1.3": [ { "comment_text": "", "digests": { "md5": "bdee52a6dcaaa1b0ed9e3ca50182ca2a", "sha256": "3268e7daff3ecd14c6a78d60b1ce3025d45569d9f99e176b1978639b8501116f" }, "downloads": -1, "filename": "aliyun_table_topwin-0.1.3-py3-none-any.whl", "has_sig": false, "md5_digest": "bdee52a6dcaaa1b0ed9e3ca50182ca2a", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.6", "size": 19729, "upload_time": "2019-10-21T05:34:42", "url": "https://files.pythonhosted.org/packages/42/94/eb4db1d94c230caf13407c5fa1c85401d0ced7fc4b775cf8207a626682d7/aliyun_table_topwin-0.1.3-py3-none-any.whl" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "bdee52a6dcaaa1b0ed9e3ca50182ca2a", "sha256": "3268e7daff3ecd14c6a78d60b1ce3025d45569d9f99e176b1978639b8501116f" }, "downloads": -1, "filename": "aliyun_table_topwin-0.1.3-py3-none-any.whl", "has_sig": false, "md5_digest": "bdee52a6dcaaa1b0ed9e3ca50182ca2a", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.6", "size": 19729, "upload_time": "2019-10-21T05:34:42", "url": "https://files.pythonhosted.org/packages/42/94/eb4db1d94c230caf13407c5fa1c85401d0ced7fc4b775cf8207a626682d7/aliyun_table_topwin-0.1.3-py3-none-any.whl" } ] }