This topic is used for testing the DBIStoreContrib. Note that this topic, and the DBIStoreTestForm topic, have to be present in the database cache for the tests to work.

To reset the cache, click on https://wiki-laue.biochem.mpg.de/System/DBIStoreTest?dbistore_init=1 (slow)

To reload this topic, click on https://wiki-laue.biochem.mpg.de/System/DBIStoreTest?dbistore_update=1

To reload the companion form topic, click on https://wiki-laue.biochem.mpg.de/System/DBIStoreTestForm?dbistore_update=1

• False: OK
• True: OK
• > literal: OK
• < literal: FAIL
• Simple regex: OK
• Numeric Field: OK
• Boolean field: OK
• Field cmp: OK
• Field cmp: OK
• Field uop: OK
• Array: OK
• Table.selector: OK
• Simple LIKE: OK
• Simple AND: OK
• Simple OR: OK
• Const-table cmp: OK
• Table-const cmp: OK
• Simple ref true: OK
• Simple ref false: OK
• Complex re: OK
• Constant op field: OK
• Complex conjunction: OK
• name=undefined: OK
• undefined=name: OK
• undefined=undefined: OK
• Length(num): OK
• Length(str): OK
• Deep where: FAIL
• No such field: OK
• Numeric index %#TA% 1 %#TB% "fields[0].name='number'" %#TC%
• Table Ref OK
• Complex ref OK
• Escapes IF{ " 0 =0 Could not perform search. Error was: Bad regular expression ''

" else=" $percntRED$percnt FAIL $percntENDCOLOR$percnt " then="OK" }: Missing operator in ' 0 =0 Could not perform search. Error was: Bad regular expression '' '

• Escapes IF{ " 0 =0 Could not perform search. Error was: Bad regular expression '\.x.y'

" else=" $percntRED$percnt FAIL $percntENDCOLOR$percnt " then="OK" }: Missing operator in ' 0 =0 Could not perform search. Error was: Bad regular expression '\.x.y' '

• Table=Table %#TA% 0 %#TB% "fields=attachments" %#TC%
• Non-query: %XA 2 %XB "1" topic="DBIStoreTest*" nonoise="on" format="" footer="$ntopics" separator=""}%" then="OK" else=" $percntRED$percnt FAIL $percntENDCOLOR$percnt "}%

%META:PREFERENCE{nqme="Red" value="0"}%