[wp-trac] [WordPress Trac] #39691: wpLink autocomplete search improvement

[WordPress Trac]

#39691: wpLink autocomplete search improvement
-------------------------------+-----------------------------
 Reporter:  enrico.sorcinelli  |      Owner:
     Type:  enhancement        |     Status:  new
 Priority:  normal             |  Milestone:  Awaiting Review
Component:  Editor             |    Version:  trunk
 Severity:  normal             |   Keywords:
  Focuses:                     |
-------------------------------+-----------------------------
 This patch offers a small improvement to wpLink (and tinymce plugin)
 autocomplete search in order to reduce requests to the server.

 It normalizes the search terms by make it lowercase (based on DB collate
 setting) and trims / removes redundant blank spaces before to send a new
 one search.

 I know, this way (for example by putting two words separate by several
 blank spaces), it can skip the first `CASE`/`WHEN` in the `ORDER BY`
 clause, since the exact query is used into a `LIKE` statement to determine
 the order value.

 The patch also exposes `dbcollate` JavaScript variabile in the admin
 header that is used to check case insensitive DB setting. I think that it
 could be useful also in other situations.

 Feedback and suggestions are appreciated

 Regards

 PS: I haven't seen any tests (phpunit/qunit) related to wpLink so
 currently I haven't provided a new one.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/39691>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform