package com.common.core.utils

import com.jfinal.plugin.activerecord.Db
import com.jfinal.plugin.activerecord.Record

import java.util.stream.Collectors

/**
 *
 * @author 廖振钦
 * @date 2021-02-09
 * @company deloitte
 * */
class TemplateUtils {
    def static generateTemp(def text, def params){
        def template = new groovy.text.StreamingTemplateEngine().createTemplate(text)
        return template.make(params).toString()
    }

    def static ExecuteSqlToList(def sql, def params){
        List<Record> recordList= Db.find(TemplateUtils.generateTemp(sql, params))
        def list = recordList.stream().map({ record -> record.getColumns() }).collect(Collectors.toList())
        return list
    }

    def static ExecuteSqlToMapEntity(def sql, def params){
        Record record= Db.findFirst(TemplateUtils.generateTemp(sql, params))
        if(null == record){
            return null
        }else {
            def map = record.getColumns();
            return map
        }
    }

    def static ExecuteSqlToEntity(def sql, def params){
        Record record= Db.findFirst(TemplateUtils.generateTemp(sql, params))
        if(null == record){
            return null
        }else {
            def map = record.getColumns().values();
            if (map.size() == 1) {
                return map[0]
            }
            return map
        }
    }
}