Changeset 40290 for trunk/psLib/src/db/psDB.c

Timestamp:

Dec 13, 2017, 8:53:30 AM (8 years ago)

Author:

eugene

Message:

add -data_state and -comment-skip as options to chiptool; define new db comparison NOTLKE (NOT LIKE) in psDB code

File:

• trunk/psLib/src/db/psDB.c (modified) (1 diff)

trunk/psLib/src/db/psDB.c

@@ -2425 +2425 @@
                 // used in a where clause...
                 psStringAppend(&query, "%s LIKE '%s'", itemName, item->data.str);
+            } else if (item->comment && psStrcasestr(item->comment, "NOTLKE")) {
+                // XXX ASC NOTE: we should have a better match for
+                // char & varchar columns than this.  LIKE is OK for
+                // very large TEXT columns that really shouldn't be
+                // used in a where clause...
+                psStringAppend(&query, "%s NOT LIKE '%s'", itemName, item->data.str);
             } else {
                 psStringAppend(&query, "%s %s '%s'", itemName, opStr, item->data.str);