• Home
• org.nakeduml
• metamodel
• 1.0.0.3
• source code
• CleanOrphans.vsl

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

templates.Model.CleanOrphans.vsl Maven / Gradle / Ivy

#set($shouldGenerate=true)
#foreach($entity in $model.entities)
#foreach($fk in $entity.allNakedAttributes)
#if($fk.baseType.classifierKind.isEntity())
#if($fk.isOne() && !$fk.isInverse())
update (${entity.mappingInfo.persistentName} left outer join ${fk.baseType.mappingInfo.persistentName}
   on ${entity.mappingInfo.persistentName}.${fk.mappingInfo.persistentName}=${fk.baseType.mappingInfo.persistentName}.id) 
   set ${entity.mappingInfo.persistentName}.${fk.mappingInfo.persistentName}= ${fk.baseType.mappingInfo.persistentName}.id;
#elseif(${fk.isManyToMany()})
delete ${fk.association.mappingInfo.persistentName} from (${fk.association.mappingInfo.persistentName} left outer join ${fk.baseType.mappingInfo.persistentName}
   on ${fk.association.mappingInfo.persistentName}.${fk.mappingInfo.persistentName}=${fk.baseType.mappingInfo.persistentName}.id)
   where ${fk.baseType.mappingInfo.persistentName}.id is null;
#end
#end
#end
#end
##TODO not-null values