Giter Club home page Giter Club logo

beetl-go's Introduction

Beetl-go

数据库模板引擎,适用于Golang。

介绍

核心**来源于https://gitee.com/xiandafu/beetl

安装

go get -u github.com/guangzhou-meta/beetl-go

示例

1. 添加脚本文件

/resources/sql/DemoTest.md

DemoTest
===
```sql
select #{page('*')} from sys_user 
where 1=1
-- @if(!isEmpty(name)){
 and name=#{name}
-- @}
-- @pageIgnoreTag(){
 order by createTime
-- @}
```[实际可参考 test/resources/sql/DemoTest.md]

DemoTest2
===
```sql
select #{page('*')} from sys_user 
where 1=1
-- @if(!isEmpty(name)){
 and name=#{name}
-- @}
-- @pageIgnoreTag(){
 order by createTime
-- @}
```[实际可参考 test/resources/sql/DemoTest.md]

2. 添加默认配置文件

/resources/beetl-default.properties

参考 resources/beetl-default.properties

3. 添加模板抽象Struct

package dao

import (
	"github.com/guangzhou-meta/beetl-go/common"
	"github.com/guangzhou-meta/beetl-go/engine"
	"github.com/guangzhou-meta/beetl-go/template"
)

type DemoTest struct {
	DemoTest func(params engine.RenderParamsI) ([]common.SqlResultI, error)
}

func (*DemoTest) TemplateName() string {
	return "DemoTest"
}

4. 初始化引擎

package main

import (
	"fmt"
	"os"
)

import (
	"github.com/guangzhou-meta/beetl-go/engine"
	"github.com/guangzhou-meta/beetl-go/template"
)

func init() {
	root, err := os.Getwd()
	if err != nil {
		fmt.Println(err)
		return
	}
	templateEngine := engine.NewEngine().
		SetTemplateDir(root + "/resources/sql"). // 模板扫描地址
		SetPropertiesFilePath(nil). // 自定义配置文件路径
		Build()          
}

5. 注册模板

package main

import (
	"dao"
)

var demoTestInstance *dao.DemoTest

func register() {
	demoTestInstance = &dao.DemoTest{}
	templateEngine.RegisterTemplate(demoTestInstance)
}

6. 调用模板

package main

import (
	"dao"
	"fmt"
)

import (
	"github.com/guangzhou-meta/beetl-go/engine"
	"github.com/guangzhou-meta/beetl-go/template"
)

var demoTestInstance *dao.DemoTest

type DemoTestDTO struct {
	Name *string `json:"name"`
}

func main()  {
    register() // 注册模板
	
	name := "Unizone"
	params := &DemoTestDTO{
		Name: &name,
	}
	sqlList, err := demoTestInstance.DemoTest(engine.NewRenderPageParams().SetObject(params))
	if err != nil {
		fmt.Printf("Render Fail: %v\n", err)
		return
	}
	for _, sql := range sqlList {
		fmt.Println(sql.GetSqlType(), ": ", sql)
	}
}

特别鸣谢

beetl-go's People

Contributors

changedenczd avatar

Stargazers

 avatar  avatar

Watchers

 avatar

Forkers

xwinie

beetl-go's Issues

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.