diff options
| author | Bibiko <bibiko@eva.mpg.de> | 2009-09-28 10:41:24 +0000 |
|---|---|---|
| committer | Bibiko <bibiko@eva.mpg.de> | 2009-09-28 10:41:24 +0000 |
| commit | 020cfd249c9022a2b84ae64786cdcbed42102217 (patch) | |
| tree | 9ca5cde48ed30641427fb14b3b9cd97de581ac38 /Resources | |
| parent | cc0c0a7842e3bff325fa29c71f5115361981797d (diff) | |
| download | sequelpro-020cfd249c9022a2b84ae64786cdcbed42102217.tar.gz sequelpro-020cfd249c9022a2b84ae64786cdcbed42102217.tar.bz2 sequelpro-020cfd249c9022a2b84ae64786cdcbed42102217.zip | |
• rewrote the content filter logic:
- all default filters come from "ContentFilters.plist" which can be localized
main structure:
<plist>
<dict>
<key>number</key>
<array/>
<key>string</key>
<array/>
<key>date</key>
<array/>
</dict>
</plist>
filter item structure: [ ${} is a place holder for an argument ]
<dict>
<key>MenuLabel</key>
<string>BETWEEN</string>
<key>Tooltip>
<string>a tooltip</string>
<key>NumberOfArguments</key>
<integer>2</integer>
<key>ConjunctionLabels</key>
<array>
<string>AND</string>
</array>
<key>Clause</key>
<string>BETWEEN '${}' AND '${}'</string>
</dict>
- if NumberOfArguments == 0 then start filtering automatically
- now one can save his/her own filters in SP's preferences.plist (GUI follows soon)
- fixed issue for filters requiring two arguments that pressing RETURN if one is in the second argument input field invokes "Filter"
- added string operators: "IS EMPTY" and "IS NOT EMPTY"
- fixed issue that now one is able to look for eg \n in string fields
Diffstat (limited to 'Resources')
| -rw-r--r-- | Resources/English.lproj/ContentFilters.plist | 270 | ||||
| -rw-r--r-- | Resources/PreferenceDefaults.plist | 9 |
2 files changed, 274 insertions, 5 deletions
diff --git a/Resources/English.lproj/ContentFilters.plist b/Resources/English.lproj/ContentFilters.plist index 4768f16b..2f52c6af 100644 --- a/Resources/English.lproj/ContentFilters.plist +++ b/Resources/English.lproj/ContentFilters.plist @@ -1,7 +1,269 @@ -<?xml version="1.0" encoding="UTF-8"?> -<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd"> -<plist version="1.0"> +<?xml version='1.0' encoding='UTF-8'?> +<!DOCTYPE plist PUBLIC '-//Apple//DTD PLIST 1.0//EN' 'http://www.apple.com/DTDs/PropertyList-1.0.dtd'> +<plist version='1.0'> <dict> - + <key>number</key> + <array> + <dict> + <key>MenuLabel</key> + <string>=</string> + <key>NumberOfArguments</key> + <integer>1</integer> + <key>Clause</key> + <string>= '${}'</string> + </dict> + <dict> + <key>MenuLabel</key> + <string>≠</string> + <key>NumberOfArguments</key> + <integer>1</integer> + <key>Clause</key> + <string>!= '${}'</string> + </dict> + <dict> + <key>MenuLabel</key> + <string>></string> + <key>NumberOfArguments</key> + <integer>1</integer> + <key>Clause</key> + <string>> '${}'</string> + </dict> + <dict> + <key>MenuLabel</key> + <string><</string> + <key>NumberOfArguments</key> + <integer>1</integer> + <key>Clause</key> + <string>< '${}'</string> + </dict> + <dict> + <key>MenuLabel</key> + <string>≥</string> + <key>NumberOfArguments</key> + <integer>1</integer> + <key>Clause</key> + <string>>= '${}'</string> + </dict> + <dict> + <key>MenuLabel</key> + <string>≤</string> + <key>NumberOfArguments</key> + <integer>1</integer> + <key>Clause</key> + <string><= '${}'</string> + </dict> + <dict> + <key>MenuLabel</key> + <string>IN</string> + <key>NumberOfArguments</key> + <integer>1</integer> + <key>Clause</key> + <string>IN (${})</string> + </dict> + <dict> + <key>MenuLabel</key> + <string>LIKE</string> + <key>NumberOfArguments</key> + <integer>1</integer> + <key>Clause</key> + <string>LIKE '${}'</string> + </dict> + <dict> + <key>MenuLabel</key> + <string>BETWEEN</string> + <key>NumberOfArguments</key> + <integer>2</integer> + <key>ConjunctionLabels</key> + <array> + <string>AND</string> + </array> + <key>Clause</key> + <string>BETWEEN '${}' AND '${}'</string> + </dict> + <dict> + <key>MenuLabel</key> + <string>IS NULL</string> + <key>NumberOfArguments</key> + <integer>0</integer> + <key>Clause</key> + <string>IS NULL</string> + </dict> + <dict> + <key>MenuLabel</key> + <string>IS NOT NULL</string> + <key>NumberOfArguments</key> + <integer>0</integer> + <key>Clause</key> + <string>IS NOT NULL</string> + </dict> + </array> + <key>string</key> + <array> + <dict> + <key>MenuLabel</key> + <string>IS</string> + <key>NumberOfArguments</key> + <integer>1</integer> + <key>Clause</key> + <string>LIKE '${}'</string> + </dict> + <dict> + <key>MenuLabel</key> + <string>IS NOT</string> + <key>NumberOfArguments</key> + <integer>1</integer> + <key>Clause</key> + <string>NOT LIKE '${}'</string> + </dict> + <dict> + <key>MenuLabel</key> + <string>contains</string> + <key>NumberOfArguments</key> + <integer>1</integer> + <key>Clause</key> + <string>LIKE '%${}%'</string> + </dict> + <dict> + <key>MenuLabel</key> + <string>contains not</string> + <key>NumberOfArguments</key> + <integer>1</integer> + <key>Clause</key> + <string>NOT LIKE '%${}%'</string> + </dict> + <dict> + <key>MenuLabel</key> + <string>IN</string> + <key>NumberOfArguments</key> + <integer>1</integer> + <key>Clause</key> + <string>IN (${})</string> + <key>Tooltip</key> + <string>Do quote strings manually.</string> + </dict> + <dict> + <key>MenuLabel</key> + <string>BETWEEN</string> + <key>NumberOfArguments</key> + <integer>2</integer> + <key>ConjunctionLabels</key> + <array> + <string>AND</string> + </array> + <key>Clause</key> + <string>BETWEEN '${}' AND '${}'</string> + </dict> + <dict> + <key>MenuLabel</key> + <string>IS NULL</string> + <key>NumberOfArguments</key> + <integer>0</integer> + <key>Clause</key> + <string>IS NULL</string> + </dict> + <dict> + <key>MenuLabel</key> + <string>IS NOT NULL</string> + <key>NumberOfArguments</key> + <integer>0</integer> + <key>Clause</key> + <string>IS NOT NULL</string> + </dict> + <dict> + <key>MenuLabel</key> + <string>IS EMPTY</string> + <key>NumberOfArguments</key> + <integer>0</integer> + <key>Clause</key> + <string>LIKE ''</string> + </dict> + <dict> + <key>MenuLabel</key> + <string>IS NOT EMPTY</string> + <key>NumberOfArguments</key> + <integer>0</integer> + <key>Clause</key> + <string>NOT LIKE ''</string> + </dict> + </array> + <key>date</key> + <array> + <dict> + <key>MenuLabel</key> + <string>IS</string> + <key>NumberOfArguments</key> + <integer>1</integer> + <key>Clause</key> + <string>= '${}'</string> + </dict> + <dict> + <key>MenuLabel</key> + <string>IS NOT</string> + <key>NumberOfArguments</key> + <integer>1</integer> + <key>Clause</key> + <string>!= '${}'</string> + </dict> + <dict> + <key>MenuLabel</key> + <string>is after</string> + <key>NumberOfArguments</key> + <integer>1</integer> + <key>Clause</key> + <string>> '${}'</string> + </dict> + <dict> + <key>MenuLabel</key> + <string>is before</string> + <key>NumberOfArguments</key> + <integer>1</integer> + <key>Clause</key> + <string>< '${}'</string> + </dict> + <dict> + <key>MenuLabel</key> + <string>is after or equal to</string> + <key>NumberOfArguments</key> + <integer>1</integer> + <key>Clause</key> + <string>>= '${}'</string> + </dict> + <dict> + <key>MenuLabel</key> + <string>is before or equal to</string> + <key>NumberOfArguments</key> + <integer>1</integer> + <key>Clause</key> + <string><= '${}'</string> + </dict> + <dict> + <key>MenuLabel</key> + <string>BETWEEN</string> + <key>NumberOfArguments</key> + <integer>2</integer> + <key>ConjunctionLabels</key> + <array> + <string>AND</string> + </array> + <key>Clause</key> + <string>BETWEEN '${}' AND '${}'</string> + </dict> + <dict> + <key>MenuLabel</key> + <string>IS NULL</string> + <key>NumberOfArguments</key> + <integer>0</integer> + <key>Clause</key> + <string>IS NULL</string> + </dict> + <dict> + <key>MenuLabel</key> + <string>IS NOT NULL</string> + <key>NumberOfArguments</key> + <integer>0</integer> + <key>Clause</key> + <string>IS NOT NULL</string> + </dict> + </array> </dict> </plist> diff --git a/Resources/PreferenceDefaults.plist b/Resources/PreferenceDefaults.plist index 33964fbb..e6b1c52e 100644 --- a/Resources/PreferenceDefaults.plist +++ b/Resources/PreferenceDefaults.plist @@ -109,6 +109,13 @@ <key>QuickLookTypes</key> <array/> <key>ContentFilters</key> - <array/> + <dict> + <key>number</key> + <array/> + <key>string</key> + <array/> + <key>date</key> + <array/> + </dict> </dict> </plist> |