Formed in 2009, the Archive Team (not to be confused with the archive.org Archive-It Team) is a rogue archivist collective dedicated to saving copies of rapidly dying or deleted websites for the sake of history and digital heritage. The group is 100% composed of volunteers and interested parties, and has expanded into a large amount of related projects for saving online and digital history.
Join GitHub today
GitHub is home to over 50 million developers working together to host and review code, manage projects, and build software together.
Sign upSupport Foreign Key ON UPDATE CASCADE #985
Closed
Comments
|
JSqlParser supports only ON DELETE (at the moment). Pull requests are welcome. |
gitmotte
added a commit
to gitmotte/JSqlParser
that referenced
this issue
Jul 26, 2020
gitmotte
added a commit
to gitmotte/JSqlParser
that referenced
this issue
Jul 26, 2020
gitmotte
added a commit
to gitmotte/JSqlParser
that referenced
this issue
Jul 26, 2020
* add more unittest-assertions JSQLParser#985
gitmotte
added a commit
to gitmotte/JSqlParser
that referenced
this issue
Jul 29, 2020
gitmotte
added a commit
to gitmotte/JSqlParser
that referenced
this issue
Jul 30, 2020
matter JSQLParser#985
wumpz
pushed a commit
that referenced
this issue
Aug 9, 2020
* #985 * add 2 unit-tests for given statements #985 * fix formating (line width) #985 * * fix nullpointerexceptions * add more unittest-assertions #985 * change order to match the same order as in ForeignKeyIndex * byAction should not throw an exception (is used by deprecated string-setters) * add unit-tests for ReferentialAction within AlterExpression * fix toString (added bug on refactoring) * javadoc * test set from get on null-values too * refactoring: add and use ReferentialAction() to evaluate enum #985 * refactoring: fix parser that order of referential actions does not matter #985 * add empty constructor
|
@wumpz this is merged already an can be closed. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Two more statements to check ( ON UPDATE [RESTRICT | CASCADE | SET NULL | NO ACTION | SET DEFAULT})
ALTER TABLE
textoADD CONSTRAINT
texto_autor_id_foreignFOREIGN KEY (autor_id) REFERENCESusers(id) ON UPDATE CASCADE,ADD CONSTRAINT
texto_tipotexto_id_foreignFOREIGN KEY (tipotexto_id) REFERENCEStipotexto(id) ON UPDATE CASCADEEncountered unexpected token: "UPDATE" "UPDATE"
at line 2, column 97.
ALTER TABLE
texto_ficheroADD CONSTRAINT
texto_fichero_fichero_id_foreignFOREIGN KEY (fichero_id) REFERENCESfichero(id) ON DELETE CASCADE ON UPDATE CASCADE,ADD CONSTRAINT
texto_fichero_texto_id_foreignFOREIGN KEY (texto_id) REFERENCEStexto(id) ON DELETE CASCADE ON UPDATE CASCADEEncountered unexpected token: "ON" "ON"
at line 2, column 126.