Merge branch 'master' of https://github.com/martin-pabst/SQL-IDE

martin-pabst · martin-pabst · commit 6d34e6e46c94 · 2024-11-26T21:41:22.000+01:00
diff --git a/src/client/compiler/parser/Parser.ts b/src/client/compiler/parser/Parser.ts
@@ -769,6 +769,9 @@ export class Parser {
             switch (this.tt) {
                 //@ts-ignore
                 case TokenType.keywordCascade:
+                    fki[kind] = <string>this.cct.value;
+                    this.nextToken();
+                    break;
                 //@ts-ignore
                 case TokenType.keywordRestrict:
                     fki[kind] = <string>this.cct.value;
diff --git a/src/client/compiler/parser/StatementCleaner.ts b/src/client/compiler/parser/StatementCleaner.ts
@@ -132,6 +132,12 @@ export class StatementCleaner {
             let c: string = fki.referencesColumn;
             if (fki.referencesTable) c = this.escapeIdentifier(fki.referencesTable) + "(" + this.escapeIdentifier(c) + ")";
             st += " references " + c;
+            if(fki.onDelete){
+                st += " on delete " + fki.onDelete;
+            }
+            if(fki.onUpdate){
+                st += " on update " + fki.onUpdate;
+            }
         }
         if (column.collate != null) {
             let collate = column.collate.toLocaleLowerCase();
