• Home
• net.oschina.durcframework
• easymybatis
• 1.8.5
• source code
• postgresql.vm

×

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.

easymybatis.tpl.postgresql.vm Maven / Gradle / Ivy

#set($jq="$")



    
    #foreach($column in $allColumns)
        
    #end
    
    
    
    
    	#set ($i=0) 
        #foreach($column in $columns)                         
        	#if($i > 0),#end t."${column.columnName}"
			#set($i=$i +1)             
        #end
    
    
    
    
		SELECT
			
		FROM "${table.tableName}" t
		
        
            
            #if(${table.hasLogicDeleteColumn})
              AND t.${table.logicDeleteColumn.columnName} = ${table.logicDeleteColumn.logicNotDeleteValueString}
            #end
         
		
		
		
			ORDER BY ${jq}{order}
		
	
	
	
    
		SELECT 
			
		FROM "${table.tableName}" t
		
        
            
            #if(${table.hasLogicDeleteColumn})
              AND t.${table.logicDeleteColumn.columnName} = ${table.logicDeleteColumn.logicNotDeleteValueString}
            #end
        
		
		
			LIMIT #{limit} OFFSET #{start}
		
	
	
    
		SELECT 
			
		FROM "${table.tableName}" t
		
        
            
            #if(${table.hasLogicDeleteColumn})
              AND t.${table.logicDeleteColumn.columnName} = ${table.logicDeleteColumn.logicNotDeleteValueString}
            #end
        
			
	

	
    
		SELECT ${countExpression} FROM "${table.tableName}" t
		
        
            
            #if(${table.hasLogicDeleteColumn})
              AND t.${table.logicDeleteColumn.columnName} = ${table.logicDeleteColumn.logicNotDeleteValueString}
            #end
        
    

	
    
		SELECT 
        	
		FROM "${table.tableName}" t
		WHERE "${pk.columnName}" = #{${pk.javaFieldName}}
		#if(${table.hasLogicDeleteColumn})
          AND t.${table.logicDeleteColumn.columnName} = ${table.logicDeleteColumn.logicNotDeleteValueString}
        #end
		LIMIT 1
	
    
    
    
		SELECT
						
		FROM "${table.tableName}" t
		
        
            
            #if(${table.hasLogicDeleteColumn})
              AND t.${table.logicDeleteColumn.columnName} = ${table.logicDeleteColumn.logicNotDeleteValueString}
            #end
        
		
		LIMIT 1
	
	
	
	
		SELECT
			
		FROM "${table.tableName}" t
		WHERE t."${jq}{column}" = #{value}
		#if(${table.hasLogicDeleteColumn})
          AND t.${table.logicDeleteColumn.columnName} = ${table.logicDeleteColumn.logicNotDeleteValueString}
        #end
		LIMIT 1
	
	
	
	
		SELECT
			
		FROM "${table.tableName}" t
		WHERE t."${jq}{column}"= #{value}
		#if(${table.hasLogicDeleteColumn})
          AND t.${table.logicDeleteColumn.columnName} = ${table.logicDeleteColumn.logicNotDeleteValueString}
        #end
	
	

	
    
#if(${pk.isUuid})
	
            SELECT UUID()
    
#end
	INSERT INTO "${table.tableName}"
         (
 #set ($i=0) 
        #foreach($column in $columns) 
            #if(!${column.isIdentityPk})               
        #if($i > 0),#end "${column.columnName}"
#set($i=$i +1)
            #end          
        #end
          )
	VALUES (
 #set ($i=0) 
        #foreach($column in $columns) 
            #if(!${column.isIdentityPk})               
        #if($i > 0),#end ${column.mybatisInsertValue}
#set($i=$i +1)
            #end          
        #end
 
        )
	
    
    
    
        #if(${pk.isUuid})
	
            SELECT UUID()
    
	#end
        INSERT INTO "${table.tableName}"
    
        	 

            #foreach($column in $columns) 
                #if(!${column.isIdentityPk}) 
                    #if(${column.hasTypeHandlerInsert})
                        "${column.columnName}",
                    #else
                        
                       "${column.columnName}",
                        
                    #end
                #end          
            #end
        
                    
            #foreach($column in $columns) 
                #if(!${column.isIdentityPk})  
                    #if(${column.hasTypeHandlerInsert})
                        ${column.mybatisInsertValue},
                    #else
                        
                        ${column.mybatisInsertValue},
                        
                    #end
                #end          
            #end
        
    

	
    
		INSERT INTO "${table.tableName}" 
		(
 #set ($i=0) 
        #foreach($column in $columns) 
            #if(!${column.isIdentityPk})               
        #if($i > 0),#end "${column.columnName}"
#set($i=$i +1)
            #end          
        #end
          )
		VALUES 
		
        ( #set ($i=0)
        #foreach($column in $columns) 
            #if(!${column.isIdentityPk})               
         	#if($i > 0),#end ${column.mybatisInsertValuePrefix}
         	#set($i=$i +1)
            #end          
        #end
        )
		
	


	 
    
		INSERT INTO "${table.tableName}"
		
			${jq}{column.columnName}
		
		VALUES 
		
        ( 
        	
        		#{entity.${column.alias} ${column.typeHandler}}
        	
        )
        
	
	
	
    
		INSERT INTO "${table.tableName}" 
		(
 #set ($i=0) 
        #foreach($column in $columns) 
            #if(!${column.isIdentityPk})               
        #if($i > 0),#end "${column.columnName}"
#set($i=$i +1)
            #end          
        #end
          )
		
        SELECT  #set ($i=0)
        #foreach($column in $columns) 
            #if(!${column.isIdentityPk})               
         	#if($i > 0),#end ${column.mybatisInsertValuePrefix}
         	#set($i=$i +1)
            #end          
        #end        
		
	
	
	
    
		INSERT INTO "${table.tableName}"
		
			"${jq}{column.columnName}"
		
		
        SELECT  
        	
        		#{entity.${column.alias} ${column.typeHandler}}
        	
        
	

	
    
    UPDATE "${table.tableName}"
     		
     #foreach($column in $columns) 
         #if(!${column.isPk})               
         "${column.columnName}"=${column.mybatisUpdateValue},
         #end          
     #end
     	
    WHERE "${pk.columnName}" = #{${pk.javaFieldName}}
    #if(${table.hasVersionColumn})
		AND "${table.versionColumn.columnName}" = #{${table.versionColumn.javaFieldName}} 
    #end
    
    
    
    
    UPDATE "${table.tableName}"
    
    	#foreach($column in $columns) 
            #if(!${column.isPk})  
                #if(${column.hasTypeHandlerUpdate})
                    "${column.columnName}"=${column.mybatisUpdateValue},
                #else
                    
                    "${column.columnName}"=${column.mybatisUpdateValue},
                    
                #end
            #end          
        #end
    
    WHERE "${pk.columnName}" = #{${pk.javaFieldName}}
    #if(${table.hasVersionColumn})
		AND "${table.versionColumn.columnName}" = #{${table.versionColumn.javaFieldName}} 
    #end
    
    
    
    
    UPDATE "${table.tableName}"
    
    	#foreach($column in $columns) 
            #if(!${column.isPk})  
                #if(${column.hasTypeHandlerUpdate})
                    "${column.columnName}"=${column.mybatisUpdateValuePrefix},
                #else
                    
                    "${column.columnName}"=${column.mybatisUpdateValuePrefix},
                    
                #end
            #end          
        #end
    
    
    	
	
	
	
		#if(${table.hasLogicDeleteColumn})            
            UPDATE ${table.tableName}
            
                #foreach($column in $columns) 
                    #if(${column.isPk})  
                    #elseif(${column.isLogicDelete})
                        ${table.logicDeleteColumn.columnName} = ${table.logicDeleteColumn.logicDeleteValueString},
                    #else
                        
                            ${column.columnName}=${column.mybatisUpdateValue},
                        
                    #end          
                #end
            
            WHERE ${pk.columnName} = #{${pk.javaFieldName}}
            AND ${table.logicDeleteColumn.columnName} = ${table.logicDeleteColumn.logicNotDeleteValueString}
            #if(${table.hasVersionColumn})
                AND ${table.versionColumn.columnName} = #{${table.versionColumn.javaFieldName}} 
            #end    
       #else
            DELETE FROM ${table.tableName}
            WHERE ${pk.columnName} = #{${pk.javaFieldName}}
       #end
	    
    
    
    
		DELETE FROM "${table.tableName}"