You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-dev@db.apache.org by tv...@apache.org on 2016/04/08 10:09:39 UTC
svn commit: r1738219 - in
/db/torque/torque4/trunk/torque-templates/src/main/resources/org/apache/torque/templates/sql/templates/ddl/derby:
foreignKey.groovy foreignKey.vm
Author: tv
Date: Fri Apr 8 08:09:38 2016
New Revision: 1738219
URL: http://svn.apache.org/viewvc?rev=1738219&view=rev
Log:
Fix foreign key references for Derby
Modified:
db/torque/torque4/trunk/torque-templates/src/main/resources/org/apache/torque/templates/sql/templates/ddl/derby/foreignKey.groovy
db/torque/torque4/trunk/torque-templates/src/main/resources/org/apache/torque/templates/sql/templates/ddl/derby/foreignKey.vm
Modified: db/torque/torque4/trunk/torque-templates/src/main/resources/org/apache/torque/templates/sql/templates/ddl/derby/foreignKey.groovy
URL: http://svn.apache.org/viewvc/db/torque/torque4/trunk/torque-templates/src/main/resources/org/apache/torque/templates/sql/templates/ddl/derby/foreignKey.groovy?rev=1738219&r1=1738218&r2=1738219&view=diff
==============================================================================
--- db/torque/torque4/trunk/torque-templates/src/main/resources/org/apache/torque/templates/sql/templates/ddl/derby/foreignKey.groovy (original)
+++ db/torque/torque4/trunk/torque-templates/src/main/resources/org/apache/torque/templates/sql/templates/ddl/derby/foreignKey.groovy Fri Apr 8 08:09:38 2016
@@ -30,6 +30,11 @@ if (foreignKey.onUpdate == "setnull")
result += """
ON UPDATE SET NULL"""
}
+else if (foreignKey.onUpdate == "none")
+{
+ result += """
+ ON UPDATE NO ACTION"""
+}
else if (foreignKey.onUpdate)
{
result += """
@@ -41,6 +46,12 @@ if (foreignKey.onDelete == "setnull")
ON DELETE SET NULL"""
}
+else if (foreignKey.onDelete == "none")
+{
+ result += """
+
+ ON DELETE NO ACTION"""
+}
else if (foreignKey.onDelete)
{
result += """
Modified: db/torque/torque4/trunk/torque-templates/src/main/resources/org/apache/torque/templates/sql/templates/ddl/derby/foreignKey.vm
URL: http://svn.apache.org/viewvc/db/torque/torque4/trunk/torque-templates/src/main/resources/org/apache/torque/templates/sql/templates/ddl/derby/foreignKey.vm?rev=1738219&r1=1738218&r2=1738219&view=diff
==============================================================================
--- db/torque/torque4/trunk/torque-templates/src/main/resources/org/apache/torque/templates/sql/templates/ddl/derby/foreignKey.vm (original)
+++ db/torque/torque4/trunk/torque-templates/src/main/resources/org/apache/torque/templates/sql/templates/ddl/derby/foreignKey.vm Fri Apr 8 08:09:38 2016
@@ -21,6 +21,9 @@ ALTER TABLE $torqueGen.getParent().getAt
#if ($onUpdate == "setnull")
ON UPDATE SET NULL##
+#elseif ($onUpdate == "none")
+
+ ON UPDATE NO ACTION##
#elseif ($onUpdate)
ON UPDATE ${onUpdate.toUpperCase()}##
@@ -28,6 +31,9 @@ ALTER TABLE $torqueGen.getParent().getAt
#if ($onDelete == "setnull")
ON DELETE SET NULL##
+#elseif ($onDelete == "none")
+
+ ON DELETE NO ACTION##
#elseif ($onDelete)
ON DELETE ${onDelete.toUpperCase()}##
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org