{ "info": { "author": "Raffaele Sena", "author_email": "raff367@gmail.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 4 - Beta", "Environment :: Console", "Intended Audience :: Developers", "License :: OSI Approved :: MIT License", "Operating System :: OS Independent", "Programming Language :: Python :: 2", "Programming Language :: Python :: 2.6", "Programming Language :: Python :: 2.7", "Topic :: Database :: Front-Ends", "Topic :: Internet", "Topic :: Internet :: WWW/HTTP :: Indexing/Search", "Topic :: Utilities" ], "description": "elseql\n======\nYou know, for Query\n-------------------\nA SQL-like command line / REPL client for ElasticSearch\n\n### USAGE\n\n elseql [--debug] [--port=host:port] \n\n### COMMANDS\n\n* select - see SEARCH SYNTAX\n* describe [index]\n* set options [on|off]\n* help\n\n### SEARCH SYNTAX\n\n SELECT {fields}\n [FACETS facet-fields]\n [SCRIPT script-field = 'script']\n FROM index\n [WHERE where-condition]\n [FILTER filter-condition]\n [ORDERY BY order-fields]\n [LIMIT [start,] count]\n\nwhere:\n fields: '*' or comma-separated list of field names to be returned\n\n facet-fields: comma-separated list of fields to execute a facet query on\n\n script-field: name of script field, to be used in select clause\n script: ElasticSearch script\n\n index: index to query\n\n where-condition:\n {field-name} [ = != > >= < <= ] {value}\n {field-name} LIKE {value}\n {field-name} IN (value1, value2, ...)\n {field-name} BETWEEN {min-value} AND {max-value}\n NOT {where-condition}\n {where-condition} AND {where-condition}\n {where-condition} OR {where-condition}\n\n or where-condition:\n 'query in Lucene syntax'\n\n filter-condition: \n QUERY {where-condition} - query filter, same syntax as where condition\n EXIST {field-name} - exists field filter\n MISSING {field.name} - missing field filter\n\n order-fields: comma-separated list of {field-name} [ASC | DESC]\n\n start: start index for pagination\n count: maximum number of returned results\n\nA special case for LIMIT start,count allows to do a \"scroll\" query (i.e. results will be returned in batches):\n\n start: -1 - enable \"scroll\" query\n count: batch size - the query will return {count} results (actually {count} per shard) and will be repeated until all results are returned.\n\nThis is very useful when you are expecting large result sets (or you are doing a full table scan). Note that in\n\"scroll\" mode sort and facets are disabled.\n\n### INSTALLATION\n\nFrom pypi:\n\n\tsudo easy_install elseql\nor:\n\n\tsudo pip install elseql\n\nWith python and setuptools installed:\n\n\tsudo python setup.py install\n\nYou can also run the command without installing as:\n\n\tpython -m elseql.elseql\n\nTo do this you will need the pyparsing, rawes and cmd2 packages installed, that are automatically installed in the previous step.\n\n\tsudo easy_install pyparsing\n\tsudo easy_install rawes\n sudo easy_install cmd2\n\nThe cmd2 package add a few extra features \"command-line\" related features. The most useful is redirection:\n\n\telsesql> select id,field1,field2 from index where condition > result.csv\n\nNote that because '>' is used for redirection you'll need to use GT in the where clause insted (also available LT, GTE, LTE)\n\n### SEE ALSO\n\nhttp://elasticsearch.org/, You know, for Search\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/raff/elseql", "keywords": "", "license": "MIT", "maintainer": "", "maintainer_email": "", "name": "elseql", "package_url": "https://pypi.org/project/elseql/", "platform": "Posix; MacOS X; Windows", "project_url": "https://pypi.org/project/elseql/", "project_urls": { "Homepage": "https://github.com/raff/elseql" }, "release_url": "https://pypi.org/project/elseql/0.3.0/", "requires_dist": null, "requires_python": "", "summary": "SQL-like command line client for ElasticSearch", "version": "0.3.0" }, "last_serial": 3559063, "releases": { "0.2.1": [ { "comment_text": "built for Darwin-12.2.0", "digests": { "md5": "030b9f02313779deae89aefff238fdd1", "sha256": "473c79bf8e8e8b08d3737c1a5ac71cb1283ee2551228835ae9f9c417f95074c3" }, "downloads": -1, "filename": "elseql-0.2.1.macosx-10.8-intel.tar.gz", "has_sig": false, "md5_digest": "030b9f02313779deae89aefff238fdd1", "packagetype": "bdist_dumb", "python_version": "any", "requires_python": null, "size": 19053, "upload_time": "2012-10-25T16:36:44", "url": "https://files.pythonhosted.org/packages/e4/d8/ee6ce14679a1506d2845fd63a2d6fef889c316d6d5da6b5f87e4a420100d/elseql-0.2.1.macosx-10.8-intel.tar.gz" }, { "comment_text": "", "digests": { "md5": "bd93728e9f96ed13e08052d25e3c3069", "sha256": "43549ddf8f48414bed7a207e4351778d331b817bd5f37b27f1e8cc1250aaf8c5" }, "downloads": -1, "filename": "elseql-0.2.1-py2.7.egg", "has_sig": false, "md5_digest": "bd93728e9f96ed13e08052d25e3c3069", "packagetype": "bdist_egg", "python_version": "2.7", "requires_python": null, "size": 22987, "upload_time": "2012-10-25T16:36:45", "url": "https://files.pythonhosted.org/packages/e8/f3/c8f94efeb01c238eb55da810e4f43c4cbe770db3b56ef17efd4e371a4339/elseql-0.2.1-py2.7.egg" }, { "comment_text": "", "digests": { "md5": "410ecc45a3e2cd6a2e12c9ccdc79135d", "sha256": "ce9e2a41e7ea9183e0a77bd7c3dd6e4ad909f0ae20b85ec41a7eb38df9821779" }, "downloads": -1, "filename": "elseql-0.2.1.tar.gz", "has_sig": false, "md5_digest": "410ecc45a3e2cd6a2e12c9ccdc79135d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 9247, "upload_time": "2012-10-25T16:36:41", "url": "https://files.pythonhosted.org/packages/f3/ab/5d88e5545303f3f64b11d25ddff714505d5da70dc6696a86c24f0bbe911f/elseql-0.2.1.tar.gz" } ], "0.2.2": [ { "comment_text": "", "digests": { "md5": "204259466381bf73ce83fcb0c8dd6678", "sha256": "5e83d6996fdd57acd316a4ce9e7baab8da1d621b8a8e54720b5f1b906e8de7f5" }, "downloads": -1, "filename": "elseql-0.2.2-py2.7.egg", "has_sig": false, "md5_digest": "204259466381bf73ce83fcb0c8dd6678", "packagetype": "bdist_egg", "python_version": "2.7", "requires_python": null, "size": 22934, "upload_time": "2012-10-25T17:22:58", "url": "https://files.pythonhosted.org/packages/62/b4/903ce45f748c7bfec7610b31e542061189fa3e0e3a3caef57269bc270eb2/elseql-0.2.2-py2.7.egg" }, { "comment_text": "", "digests": { "md5": "edf5865a36a7a39bd83131c6434bd1b9", "sha256": "cfef18ed884a6f4959f6ff82b7e8f6194db5fba7c64686051b555d8cc832f02e" }, "downloads": -1, "filename": "elseql-0.2.2.tar.gz", "has_sig": false, "md5_digest": "edf5865a36a7a39bd83131c6434bd1b9", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 9220, "upload_time": "2012-10-25T17:22:58", "url": "https://files.pythonhosted.org/packages/48/e7/40c963c01c60c75d8baa5f9a8ce77c1b52bd86ea73bcca071555bc78f1cf/elseql-0.2.2.tar.gz" } ], "0.2.3": [ { "comment_text": "", "digests": { "md5": "a02071844ca2ce3a3c013a5782894b4b", "sha256": "47c08c81a0b80fdb4e821ee140d232b828b572055ffaa7b2d728f6d0c330f5a7" }, "downloads": -1, "filename": "elseql-0.2.3-py2.7.egg", "has_sig": false, "md5_digest": "a02071844ca2ce3a3c013a5782894b4b", "packagetype": "bdist_egg", "python_version": "2.7", "requires_python": null, "size": 23121, "upload_time": "2012-10-26T03:53:10", "url": "https://files.pythonhosted.org/packages/c2/9a/8e36aeff700e60674a429b61809ee245760d93920961a71314294d6496cb/elseql-0.2.3-py2.7.egg" }, { "comment_text": "", "digests": { "md5": "8ff681b9f1738b53079756ec02e31248", "sha256": "01187119eed22b7b919f1f4147da4d7244a61d15244f2b95bf4942b146ae9b98" }, "downloads": -1, "filename": "elseql-0.2.3.tar.gz", "has_sig": false, "md5_digest": "8ff681b9f1738b53079756ec02e31248", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 9329, "upload_time": "2012-10-26T03:53:08", "url": "https://files.pythonhosted.org/packages/f4/6c/6e54e6598cecb11f026f2e03b283c9919afa4ea92fa1c69cda5ee23559d6/elseql-0.2.3.tar.gz" } ], "0.3.0": [ { "comment_text": "", "digests": { "md5": "013f851be6bf483669e2035edc39dd06", "sha256": "b050f6c1f9d7ed3ab41aaf86f6c6e22db844eb4e187142ac5e3fbd6d753c932a" }, "downloads": -1, "filename": "elseql-0.3.0-py2.7.egg", "has_sig": false, "md5_digest": "013f851be6bf483669e2035edc39dd06", "packagetype": "bdist_egg", "python_version": "2.7", "requires_python": null, "size": 24589, "upload_time": "2018-02-07T02:04:55", "url": "https://files.pythonhosted.org/packages/75/b5/de1f1e4d6f5071a5d716c8969c310f21bbe7ce849c21d383969b51e85431/elseql-0.3.0-py2.7.egg" }, { "comment_text": "", "digests": { "md5": "201c95ce4e480af549dc0662875c1c92", "sha256": "811de2b69af25bd31318ab612ba5598c93ba34a245b5fedb9131de15aa5af843" }, "downloads": -1, "filename": "elseql-0.3.0.tar.gz", "has_sig": false, "md5_digest": "201c95ce4e480af549dc0662875c1c92", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 11622, "upload_time": "2018-02-07T02:06:58", "url": "https://files.pythonhosted.org/packages/93/3c/1c28eab2d1bee31779bbb302ea8b92cc4866c2bb4151c855f58f98c0e968/elseql-0.3.0.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "013f851be6bf483669e2035edc39dd06", "sha256": "b050f6c1f9d7ed3ab41aaf86f6c6e22db844eb4e187142ac5e3fbd6d753c932a" }, "downloads": -1, "filename": "elseql-0.3.0-py2.7.egg", "has_sig": false, "md5_digest": "013f851be6bf483669e2035edc39dd06", "packagetype": "bdist_egg", "python_version": "2.7", "requires_python": null, "size": 24589, "upload_time": "2018-02-07T02:04:55", "url": "https://files.pythonhosted.org/packages/75/b5/de1f1e4d6f5071a5d716c8969c310f21bbe7ce849c21d383969b51e85431/elseql-0.3.0-py2.7.egg" }, { "comment_text": "", "digests": { "md5": "201c95ce4e480af549dc0662875c1c92", "sha256": "811de2b69af25bd31318ab612ba5598c93ba34a245b5fedb9131de15aa5af843" }, "downloads": -1, "filename": "elseql-0.3.0.tar.gz", "has_sig": false, "md5_digest": "201c95ce4e480af549dc0662875c1c92", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 11622, "upload_time": "2018-02-07T02:06:58", "url": "https://files.pythonhosted.org/packages/93/3c/1c28eab2d1bee31779bbb302ea8b92cc4866c2bb4151c855f58f98c0e968/elseql-0.3.0.tar.gz" } ] }