sticker/Match: add inequality operators

1 files changed, 18 insertions, 0 deletions

diff --git a/src/sticker/StickerDatabase.cxx b/src/sticker/StickerDatabase.cxx
index bd809c1d3..df6dc22dd 100644
--- a/src/sticker/StickerDatabase.cxx
+++ b/src/sticker/StickerDatabase.cxx
@@ -44,6 +44,8 @@ enum sticker_sql {
 	STICKER_SQL_DELETE_VALUE,
 	STICKER_SQL_FIND,
 	STICKER_SQL_FIND_VALUE,
+	STICKER_SQL_FIND_LT,
+	STICKER_SQL_FIND_GT,
 };
 
 static const char *const sticker_sql[] = {
@@ -64,6 +66,12 @@ static const char *const sticker_sql[] = {
 
 	//[STICKER_SQL_FIND_VALUE] =
 	"SELECT uri,value FROM sticker WHERE type=? AND uri LIKE (? || '%') AND name=? AND value=?",
+
+	//[STICKER_SQL_FIND_LT] =
+	"SELECT uri,value FROM sticker WHERE type=? AND uri LIKE (? || '%') AND name=? AND value<?",
+
+	//[STICKER_SQL_FIND_GT] =
+	"SELECT uri,value FROM sticker WHERE type=? AND uri LIKE (? || '%') AND name=? AND value>?",
 };
 
 static const char sticker_sql_create[] =
@@ -392,6 +400,16 @@ BindFind(const char *type, const char *base_uri, const char *name,
 		return BindAllOrNull(error,
 				     sticker_stmt[STICKER_SQL_FIND_VALUE],
 				     type, base_uri, name, value);
+
+	case StickerOperator::LESS_THAN:
+		return BindAllOrNull(error,
+				     sticker_stmt[STICKER_SQL_FIND_LT],
+				     type, base_uri, name, value);
+
+	case StickerOperator::GREATER_THAN:
+		return BindAllOrNull(error,
+				     sticker_stmt[STICKER_SQL_FIND_GT],
+				     type, base_uri, name, value);
 	}
 
 	assert(false);