Determine filtering method

[Albert221]

In the sidebar, there is filter input which will filter databases and/or tables on the list. We have to determine the format that will be expected in this input and the expected behavior. There could be many ways of filtering, the most proper I can think of are (brackets mean optional):

1. string - displays all databases (with tables) whose names consist of string AND all databases that have tables whose names consist of string (with tables whose names consist of that string). string can represent both database's and table's name.

2. [[string1].]string2 - this format can take three forms: i. database ii. database.table iii. .table

   and displays exactly what users want: (i.) databases whose names consist of string2; (ii.) tables whose names consist of string2 in databases whose names consist of string1; (iii.) tables whose names consist of string2 in any database.

First one is IMO more convenient and more intuitive, but the second one is more precise if one wants to search exactly databases or tables.

I need your opinion @Sobak

[Sobak]

Combine both approaches.

• foobar - looks for databases consisting of foobar AND tables consisting of foobar
• .foobar - looks for the table consisting of foobar, not especially starting with it - so that table superfoobaro should be matched as well
• database.foobar - looks for exact match

That's my idea

[Albert221]

Yes, let's add one more thing and that would be it.

• database. - looks for database consisting of database

What do you mean by exact match? Exact names and not consisting of the phrases?

[Sobak]

"database.table" not *database.table* or with any other placeholders elsewhere

[Sobak]

BTW: good idea for database.

[Albert221]

Hmmm, IMO that inconsistency is not good. Every syntax looking NOT for exact match but this one looking for exact. What if one wants to search for a table in a big (in terms of tables number) database?

[Albert221]

I think of a modifier for each of two parts of syntax which would eventually turn strict filtering on, and that would be searching for exact name as the phrase, not LIKE the phrase.

[Sobak]

Overcomplicated, imho. Unless you want to use quotes as a such modifier what is long established practice. This would do the trick

[Albert221]

OK. In sum, there would be four possible formats for filtering databases, tables and both with one modifier.

• foobar for databases that consist of foobar AND for tables that consist of foobar
• database. for databases that consist of database
• .table for tables that consist of table
• database.table. for tables that consist of table in databases that consist of database

If one wants to filter for exact phrases, i.e. for tables consisting of table EXACTLY in database database one will had to use strict modifier which is two quotation marks (") surrounding the part we want to mark for strict search. I.e.:

• "database".wp_ for all wordpress tables in database database
• ."user" for all user tables across all databases
• "database". for only one database

[Albert221]

Implemented 1bfe173d17c4fa3e88eff921d881da224e4b1023