{ "info": { "author": "bloopark systems GmbH & Co. KG, Eficent, Serpent CS, Odoo Community Association (OCA)", "author_email": "support@odoo-community.org", "bugtrack_url": null, "classifiers": [ "Framework :: Odoo", "License :: OSI Approved :: GNU Affero General Public License v3", "Programming Language :: Python" ], "description": ".. image:: https://img.shields.io/badge/licence-AGPL--3-blue.svg\n :target: http://www.gnu.org/licenses/agpl-3.0-standalone.html\n :alt: License: AGPL-3\n\n=========================\nPostgreSQL Trigram Search\n=========================\n\nThis addon provides the ability to create GIN or GiST indexes of char and text\nfields and also to use the search operator `%` in search domains. Currently\nthis module doesn't change the backend search or anything else. It provides\nonly the possibilty to perfrom the fuzzy search for external addons.\n\n\nInstallation\n============\n\n#. The PostgreSQL extension ``pg_trgm`` should be available. In debian based\n distribution you have to install the `postgresql-contrib` module.\n#. Install the ``pg_trgm`` extension to your database or give your postgresql\n user the ``SUPERUSER`` right (this allows the odoo module to install the\n extension to the database).\n\n\nConfiguration\n=============\n\nIf the odoo module is installed:\n\n#. You can define ``GIN`` and ``GiST`` indexes for `char` and `text` via\n `Settings -> Database Structure -> Trigram Index`. The index name will\n automatically created for new entries.\n\n\nUsage\n=====\n\n#. You can create an index for the `name` field of `res.partner`.\n#. In the search you can use:\n\n ``self.env['res.partner'].search([('name', '%', 'Jon Miller)])``\n\n#. In this example the function will return positive result for `John Miller` or\n `John Mill`.\n\n#. You can tweak the number of strings to be returned by adjusting the set limit\n (default: 0.3). NB: Currently you have to set the limit by executing the\n following SQL statment:\n\n ``self.env.cr.execute(\"SELECT set_limit(0.2);\")``\n\n#. Another interesting feature is the use of ``similarity(column, 'text')``\n function in the ``order`` parameter to order by similarity. This module just\n contains a basic implementation which doesn't perform validations and has to\n start with this function. For example you can define the function as\n followed:\n\n ``similarity(%s.name, 'John Mil') DESC\" % self.env['res.partner']._table``\n\nFor further questions read the Documentation of the\n`pg_trgm `_ module.\n\nKnown issues / Roadmap\n======================\n\n* Modify the general search parts (e.g. in tree view or many2one fields)\n* add better `order by` handling\n\n\nBug Tracker\n===========\n\nBugs are tracked on `GitHub Issues\n`_. In case of trouble, please\ncheck there if your issue has already been reported. If you spotted it first,\nhelp us smashing it by providing a detailed and welcomed feedback.\n\nCredits\n=======\n\nImages\n------\n\n* Odoo Community Association: `Icon `_.\n\nContributors\n------------\n\n* Christoph Giesel \n* Jordi Ballester \n* Serpent Consulting Services Pvt. Ltd. \n\nMaintainer\n----------\n\n.. image:: https://odoo-community.org/logo.png\n :alt: Odoo Community Association\n :target: https://odoo-community.org\n\nThis module is maintained by the OCA.\n\nOCA, or the Odoo Community Association, is a nonprofit organization whose\nmission is to support the collaborative development of Odoo features and\npromote its widespread use.\n\nTo contribute to this module, please visit https://odoo-community.org.\n\n\n", "description_content_type": "", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://odoo-community.org/", "keywords": "", "license": "AGPL-3", "maintainer": "", "maintainer_email": "", "name": "odoo9-addon-base-search-fuzzy", "package_url": "https://pypi.org/project/odoo9-addon-base-search-fuzzy/", "platform": "", "project_url": "https://pypi.org/project/odoo9-addon-base-search-fuzzy/", "project_urls": { "Homepage": "https://odoo-community.org/" }, "release_url": "https://pypi.org/project/odoo9-addon-base-search-fuzzy/9.0.1.0.0.99.dev14/", "requires_dist": [ "odoo (<9.1a,>=9.0a)" ], "requires_python": "~=2.7", "summary": "Fuzzy search with the PostgreSQL trigram extension", "version": "9.0.1.0.0.99.dev14" }, "last_serial": 5086206, "releases": { "9.0.1.0.0.99.dev1": [ { "comment_text": "", "digests": { "md5": "bdc141800be5cc20a0ab27d64e94a522", "sha256": "e2a9607f97a3b870d2db31bbdb4a0eba31dc7af24c43049f7377ee8881b95db8" }, "downloads": -1, "filename": "odoo9_addon_base_search_fuzzy-9.0.1.0.0.99.dev1-py2-none-any.whl", "has_sig": false, "md5_digest": "bdc141800be5cc20a0ab27d64e94a522", "packagetype": "bdist_wheel", "python_version": "py2", "requires_python": null, "size": 97931, "upload_time": "2017-04-11T18:20:42", "url": "https://files.pythonhosted.org/packages/77/78/a5e52b2770d94ddccf67d22b5cdce5aadacd328091c28dd904ceebcfac60/odoo9_addon_base_search_fuzzy-9.0.1.0.0.99.dev1-py2-none-any.whl" } ], "9.0.1.0.0.99.dev10": [ { "comment_text": "", "digests": { "md5": "f99d2369dab286cd172dabf2d027f815", "sha256": "263451f3d94f13941282a38d616ba1320f8266847c99ad116f0d21d5a1ce2390" }, "downloads": -1, "filename": "odoo9_addon_base_search_fuzzy-9.0.1.0.0.99.dev10-py2-none-any.whl", "has_sig": false, "md5_digest": "f99d2369dab286cd172dabf2d027f815", "packagetype": "bdist_wheel", "python_version": "py2", "requires_python": "~=2.7", "size": 113547, "upload_time": "2018-03-04T05:52:48", "url": "https://files.pythonhosted.org/packages/28/9e/1ea1427cc131309d61e1c06f7960dd19a159a3b741ea20ff7e4e9ed74d69/odoo9_addon_base_search_fuzzy-9.0.1.0.0.99.dev10-py2-none-any.whl" } ], "9.0.1.0.0.99.dev11": [ { "comment_text": "", "digests": { "md5": "2edeaba07998c15e709f50157aba00ba", "sha256": "96c1832039d2308bc934daab76f80350fe6f5c9c01cee5df0bd9a7a6ca81e6df" }, "downloads": -1, "filename": "odoo9_addon_base_search_fuzzy-9.0.1.0.0.99.dev11-py2-none-any.whl", "has_sig": false, "md5_digest": "2edeaba07998c15e709f50157aba00ba", "packagetype": "bdist_wheel", "python_version": "py2", "requires_python": "~=2.7", "size": 112421, "upload_time": "2018-06-16T05:21:00", "url": "https://files.pythonhosted.org/packages/5a/de/511bc8e83ab564ebf1945547b45e55124c4077cc4dfe3bd67b3ea3ec3def/odoo9_addon_base_search_fuzzy-9.0.1.0.0.99.dev11-py2-none-any.whl" } ], "9.0.1.0.0.99.dev12": [ { "comment_text": "", "digests": { "md5": "1c9b772229870ad7fa813ccb6649f8e1", "sha256": "87a18aed100bee90d6896a2b82b49d56d3f5293752e3e7b65953184129ab0dbb" }, "downloads": -1, "filename": "odoo9_addon_base_search_fuzzy-9.0.1.0.0.99.dev12-py2-none-any.whl", "has_sig": false, "md5_digest": "1c9b772229870ad7fa813ccb6649f8e1", "packagetype": "bdist_wheel", "python_version": "py2", "requires_python": "~=2.7", "size": 113478, "upload_time": "2018-06-25T05:03:18", "url": "https://files.pythonhosted.org/packages/82/80/f5024c46debcbf4b2cd3471b6f75f446d7b9bf43ed5616b24a02bbd93edf/odoo9_addon_base_search_fuzzy-9.0.1.0.0.99.dev12-py2-none-any.whl" } ], "9.0.1.0.0.99.dev13": [ { "comment_text": "", "digests": { "md5": "5f14ad8e7c5ae5e3bfa4c17a2de5f89b", "sha256": "31cecb98034ce51948f4ffc80612df50c2b12f64b441b58ff05aafbf3fc555e9" }, "downloads": -1, "filename": "odoo9_addon_base_search_fuzzy-9.0.1.0.0.99.dev13-py2-none-any.whl", "has_sig": false, "md5_digest": "5f14ad8e7c5ae5e3bfa4c17a2de5f89b", "packagetype": "bdist_wheel", "python_version": "py2", "requires_python": "~=2.7", "size": 113508, "upload_time": "2018-07-05T04:51:58", "url": "https://files.pythonhosted.org/packages/18/97/105b9cf1f4eb5b42674c5088e3e52532583b066d439266b9cae32377af5c/odoo9_addon_base_search_fuzzy-9.0.1.0.0.99.dev13-py2-none-any.whl" } ], "9.0.1.0.0.99.dev14": [ { "comment_text": "", "digests": { "md5": "ade7c604a205d1c38f3bc271bd80f4c5", "sha256": "10aba2b441d9eb1b7402891497d700b681a238c9b3c3d1bc38bce8b7f741f916" }, "downloads": -1, "filename": "odoo9_addon_base_search_fuzzy-9.0.1.0.0.99.dev14-py2-none-any.whl", "has_sig": false, "md5_digest": "ade7c604a205d1c38f3bc271bd80f4c5", "packagetype": "bdist_wheel", "python_version": "py2", "requires_python": "~=2.7", "size": 120405, "upload_time": "2019-04-03T06:03:23", "url": "https://files.pythonhosted.org/packages/d3/58/5c0b9a24003ab980fc7a96eee26e4a1db2104cba2ca209afb5cec41ff8e2/odoo9_addon_base_search_fuzzy-9.0.1.0.0.99.dev14-py2-none-any.whl" } ], "9.0.1.0.0.99.dev2": [ { "comment_text": "", "digests": { "md5": "a8c4d9461d8406c00fa36985084933c9", "sha256": "d2e8c0a28d04d2b7b587d260f65269ac9bc920abe3b099dc41fc9cfea6aa4513" }, "downloads": -1, "filename": "odoo9_addon_base_search_fuzzy-9.0.1.0.0.99.dev2-py2-none-any.whl", "has_sig": false, "md5_digest": "a8c4d9461d8406c00fa36985084933c9", "packagetype": "bdist_wheel", "python_version": "py2", "requires_python": null, "size": 110266, "upload_time": "2017-04-11T18:20:46", "url": "https://files.pythonhosted.org/packages/40/9a/46fffe9272bed27251cb648137a99403c0a166014e5349ce7ba1ad6cc25f/odoo9_addon_base_search_fuzzy-9.0.1.0.0.99.dev2-py2-none-any.whl" } ], "9.0.1.0.0.99.dev3": [ { "comment_text": "", "digests": { "md5": "70cb5fbe94b2ad588f0a772466ff4bf0", "sha256": "67b1daa29f058a75778d9eac8c57527f063a1d9b7ea23c36223f1e990c2cf737" }, "downloads": -1, "filename": "odoo9_addon_base_search_fuzzy-9.0.1.0.0.99.dev3-py2-none-any.whl", "has_sig": false, "md5_digest": "70cb5fbe94b2ad588f0a772466ff4bf0", "packagetype": "bdist_wheel", "python_version": "py2", "requires_python": null, "size": 110256, "upload_time": "2017-04-11T18:20:50", "url": "https://files.pythonhosted.org/packages/e4/0c/31e23921a32f02445dab5d827351dcbf13a0c9f8119ab21f73c6e970e530/odoo9_addon_base_search_fuzzy-9.0.1.0.0.99.dev3-py2-none-any.whl" } ], "9.0.1.0.0.99.dev4": [ { "comment_text": "", "digests": { "md5": "a49f6f0b254b42f61e3ccf5c471d5a78", "sha256": "44d28cfa0d0e780e0bcdfd24d6c709acc42b084468b644d33145ded9ee58fe6d" }, "downloads": -1, "filename": "odoo9_addon_base_search_fuzzy-9.0.1.0.0.99.dev4-py2-none-any.whl", "has_sig": false, "md5_digest": "a49f6f0b254b42f61e3ccf5c471d5a78", "packagetype": "bdist_wheel", "python_version": "py2", "requires_python": null, "size": 110315, "upload_time": "2017-04-11T18:20:54", "url": "https://files.pythonhosted.org/packages/70/81/167eb3b699bb01de7674b938cac2afb00d54e3ebcd55f79c38fc5a7c3a57/odoo9_addon_base_search_fuzzy-9.0.1.0.0.99.dev4-py2-none-any.whl" } ], "9.0.1.0.0.99.dev5": [ { "comment_text": "", "digests": { "md5": "f75e5ac3c45263f41b110eb392784281", "sha256": "1b11b05dc590a20023aa473b38a5264bda5014b495c55aa494333a54fff57371" }, "downloads": -1, "filename": "odoo9_addon_base_search_fuzzy-9.0.1.0.0.99.dev5-py2-none-any.whl", "has_sig": false, "md5_digest": "f75e5ac3c45263f41b110eb392784281", "packagetype": "bdist_wheel", "python_version": "py2", "requires_python": null, "size": 110374, "upload_time": "2017-04-11T18:20:58", "url": "https://files.pythonhosted.org/packages/65/81/2624b4c4ad729503b552c0a95fc38e152325d871b2c535134ef8b4ebc44c/odoo9_addon_base_search_fuzzy-9.0.1.0.0.99.dev5-py2-none-any.whl" } ], "9.0.1.0.0.99.dev6": [ { "comment_text": "", "digests": { "md5": "84f94fd071db64e1d30a4b80d4b3f325", "sha256": "d54cc72f98611cd457121730b4d8f5a332b4c8ebf365873dae3caec821811394" }, "downloads": -1, "filename": "odoo9_addon_base_search_fuzzy-9.0.1.0.0.99.dev6-py2-none-any.whl", "has_sig": false, "md5_digest": "84f94fd071db64e1d30a4b80d4b3f325", "packagetype": "bdist_wheel", "python_version": "py2", "requires_python": null, "size": 110394, "upload_time": "2017-04-11T18:21:02", "url": "https://files.pythonhosted.org/packages/28/fe/f23ff8c08ebe289c1e3b32998ffea96a695a46e55c38b29d16fd9301198c/odoo9_addon_base_search_fuzzy-9.0.1.0.0.99.dev6-py2-none-any.whl" } ], "9.0.1.0.0.99.dev7": [ { "comment_text": "", "digests": { "md5": "c1b0f58ec9170f3c9077f9a8fe913364", "sha256": "9900e61995b43f6334a8241c70b24ac979301362521e98c52dd5a266fae3abe8" }, "downloads": -1, "filename": "odoo9_addon_base_search_fuzzy-9.0.1.0.0.99.dev7-py2-none-any.whl", "has_sig": false, "md5_digest": "c1b0f58ec9170f3c9077f9a8fe913364", "packagetype": "bdist_wheel", "python_version": "py2", "requires_python": null, "size": 110760, "upload_time": "2017-05-02T05:16:39", "url": "https://files.pythonhosted.org/packages/a4/e8/04973e934f50bde3eb33d14a7b8ccf9738c12fb1abe15c00c059c900c3f1/odoo9_addon_base_search_fuzzy-9.0.1.0.0.99.dev7-py2-none-any.whl" } ], "9.0.1.0.0.99.dev8": [ { "comment_text": "", "digests": { "md5": "a2264ee0a4adf8b629ce0a4c81f42c7d", "sha256": "29ab6c897ecac3ab117205b980c909b1abf16eee43fa90d642376c246f7ca23f" }, "downloads": -1, "filename": "odoo9_addon_base_search_fuzzy-9.0.1.0.0.99.dev8-py2-none-any.whl", "has_sig": false, "md5_digest": "a2264ee0a4adf8b629ce0a4c81f42c7d", "packagetype": "bdist_wheel", "python_version": "py2", "requires_python": null, "size": 112090, "upload_time": "2017-07-02T09:23:54", "url": "https://files.pythonhosted.org/packages/ab/48/8fe69e95348868cc94c272dc7d0acf402a500ab875883793dc57b479e6ca/odoo9_addon_base_search_fuzzy-9.0.1.0.0.99.dev8-py2-none-any.whl" } ], "9.0.1.0.0.99.dev9": [ { "comment_text": "", "digests": { "md5": "e64effc12623814b60ac53d12cf48926", "sha256": "59d535907f99b0f522eccc308f88599e9811a40d2145f91befccf8a7ff585579" }, "downloads": -1, "filename": "odoo9_addon_base_search_fuzzy-9.0.1.0.0.99.dev9-py2-none-any.whl", "has_sig": false, "md5_digest": "e64effc12623814b60ac53d12cf48926", "packagetype": "bdist_wheel", "python_version": "py2", "requires_python": null, "size": 112170, "upload_time": "2017-09-03T04:39:06", "url": "https://files.pythonhosted.org/packages/76/77/f0d4178f3f8dab62c075611d06affb5fc3711ae2704c97c05465124fd639/odoo9_addon_base_search_fuzzy-9.0.1.0.0.99.dev9-py2-none-any.whl" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "ade7c604a205d1c38f3bc271bd80f4c5", "sha256": "10aba2b441d9eb1b7402891497d700b681a238c9b3c3d1bc38bce8b7f741f916" }, "downloads": -1, "filename": "odoo9_addon_base_search_fuzzy-9.0.1.0.0.99.dev14-py2-none-any.whl", "has_sig": false, "md5_digest": "ade7c604a205d1c38f3bc271bd80f4c5", "packagetype": "bdist_wheel", "python_version": "py2", "requires_python": "~=2.7", "size": 120405, "upload_time": "2019-04-03T06:03:23", "url": "https://files.pythonhosted.org/packages/d3/58/5c0b9a24003ab980fc7a96eee26e4a1db2104cba2ca209afb5cec41ff8e2/odoo9_addon_base_search_fuzzy-9.0.1.0.0.99.dev14-py2-none-any.whl" } ] }