add operator "NOT LIKE"

martin-pabst · martin-pabst · commit ea073745dcf9 · 2025-11-27T16:40:03.000+01:00
diff --git a/embedded.html b/embedded.html
@@ -8,9 +8,9 @@
     <meta name='viewport' content='width=device-width, initial-scale=1'>
 
     <link rel='stylesheet' type='text/css' media='screen' href='assets/fonts/fonts.css'>
-    <script src="lib/pako/pako.js"></script>
+    <!-- <script src="lib/pako/pako.js"></script>
     <script src="lib/zip.js/zip.min.js"></script>
-    <script src="lib/markdownit/markdownit.min.js"></script>
+    <script src="lib/markdownit/markdownit.min.js"></script> -->
 
     <script type="module" src="src/client/embedded/EmbeddedStarter.ts"></script>
 
@@ -34,8 +34,7 @@ <h1>Erstes Beispiel</h1>
     <h1>Zweites Beispiel</h1>
 
     <div class="sql-online" style="width: calc(100% - 10px); height: 600px; margin-left: 5px" data-sql-online="{
-        'id': 'abcde',
-        'databaseURL': 'assets/databases/world1.sqLite'
+        'id': 'abcde'
     }">
         <script type="text/plain" title="Test1.sql" data-type="sql">
 select * from test;
diff --git a/src/client/compiler/lexer/Lexer.ts b/src/client/compiler/lexer/Lexer.ts
@@ -42,6 +42,7 @@ export class Lexer {
     tokenTypesToMerge: { first: TokenType, second: TokenType, merged: TokenType }[] = [
         { first: TokenType.keywordNotIn, second: TokenType.keywordIn, merged: TokenType.keywordNotIn },
         { first: TokenType.keywordNot, second: TokenType.keywordBetween, merged: TokenType.keywordNotBetween },
+        { first: TokenType.keywordNot, second: TokenType.keywordLike, merged: TokenType.keywordNotLike },
         { first: TokenType.keywordIs, second: TokenType.keywordNot, merged: TokenType.isNot },
         { first: TokenType.isNot, second: TokenType.keywordNull, merged: TokenType.isNotNull },
         { first: TokenType.keywordIs, second: TokenType.keywordNull, merged: TokenType.isNull },
diff --git a/src/client/compiler/lexer/Token.ts b/src/client/compiler/lexer/Token.ts
@@ -61,6 +61,7 @@ export enum TokenType {
     keywordEnum,
     keywordBetween,
     keywordNotBetween,
+    keywordNotLike,
 
     keywordOr,
     keywordAnd,
@@ -238,7 +239,8 @@ export var TokenTypeReadable: {[tt: number]: string} = {
     [TokenType.keywordView]: "view",
     [TokenType.keywordEnum]: "enum",
     [TokenType.keywordBetween]: "between",
-    [TokenType.keywordNotBetween]: "not between",
+    [TokenType.keywordNotBetween]: "not between", 
+    [TokenType.keywordNotLike]: "not like", 
 
 
     [TokenType.keywordAnd]: "and",
@@ -448,7 +450,7 @@ export var keywordList: {[keyword: string]:TokenType} = {
     "offset": TokenType.keywordOffset,
     "in": TokenType.keywordIn,
     "not in": TokenType.keywordNotIn,
-    "not between": TokenType.keywordNotBetween,
+    "not between": TokenType.keywordNotBetween, 
     "like": TokenType.keywordLike,
     "collate": TokenType.keywordCollate,
     "default": TokenType.keywordDefault,
diff --git a/src/client/compiler/parser/Parser.ts b/src/client/compiler/parser/Parser.ts
@@ -22,7 +22,7 @@ export class Parser {
     static operatorPrecedence: TokenType[][] = [
         [TokenType.keywordOr], [TokenType.keywordAnd],
         [TokenType.keywordBetween, TokenType.keywordNotBetween],
-        [TokenType.lower, TokenType.lowerOrEqual, TokenType.greater, TokenType.greaterOrEqual, TokenType.equal, TokenType.notEqual, TokenType.keywordLike],
+        [TokenType.lower, TokenType.lowerOrEqual, TokenType.greater, TokenType.greaterOrEqual, TokenType.equal, TokenType.notEqual, TokenType.keywordLike, TokenType.keywordNotLike],
         [TokenType.concatenation, TokenType.plus, TokenType.minus], [TokenType.multiplication, TokenType.division, TokenType.modulo],
         [TokenType.keywordIn, TokenType.keywordNotIn]
     ];
diff --git a/src/client/compiler/parser/SQLTypes.ts b/src/client/compiler/parser/SQLTypes.ts
@@ -403,6 +403,10 @@ varcharType.addBinaryOperation(TokenType.keywordLike, varcharType, booleanType);
 varcharType.addBinaryOperation(TokenType.keywordLike, textType, booleanType);
 textType.addBinaryOperation(TokenType.keywordLike, textType, booleanType);
 
+varcharType.addBinaryOperation(TokenType.keywordNotLike, varcharType, booleanType);
+varcharType.addBinaryOperation(TokenType.keywordNotLike, textType, booleanType);
+textType.addBinaryOperation(TokenType.keywordNotLike, textType, booleanType);
+
 charType.addBinaryOperation(TokenType.concatenation, charType, charType);
 charType.addBinaryOperation(TokenType.concatenation, varcharType, charType);
 charType.addBinaryOperation(TokenType.concatenation, textType, textType);
@@ -411,6 +415,10 @@ charType.addBinaryOperation(TokenType.keywordLike, charType, booleanType);
 charType.addBinaryOperation(TokenType.keywordLike, textType, booleanType);
 textType.addBinaryOperation(TokenType.keywordLike, textType, booleanType);
 
+charType.addBinaryOperation(TokenType.keywordNotLike, charType, booleanType);
+charType.addBinaryOperation(TokenType.keywordNotLike, textType, booleanType);
+textType.addBinaryOperation(TokenType.keywordNotLike, textType, booleanType);
+
 booleanType.addBinaryOperation(TokenType.equal, booleanType, booleanType);
 
 let numericBinaryOperators: TokenType[] = [TokenType.plus, TokenType.minus, TokenType.multiplication, TokenType.division, TokenType.modulo];
