gin web server + db

main.go

package main

import (

	"fmt"
	"github.com/HouzuoGuo/tiedot/db"
	"github.com/gin-gonic/gin"
)

func main() {
	gin.SetMode(gin.ReleaseMode)
	r := gin.Default()

	mydb, err := db.OpenDB("test.db")
	checkerr(err)

	cols := mydb.AllCols()
	if !contains(cols, "jobs") {
		err = mydb.Create("jobs")
		checkerr(err)
	}

	col := mydb.Use("jobs")

	_, err = col.Insert(map[string]interface{}{
		"A": 3,
		"B": 4,
	})
	checkerr(err)
	
	col.Index([]string{"A"})


	//r.Static("/assets", "./files")
	//r.LoadHTMLGlob("templates/*")


	r.GET("/ping", func(c *gin.Context) {
		query:= []interface{}{
			map[string]interface{}{
			"eq":"3",
			"in":[]interface{}{"A"},
			},
		}
		
		queryResult := make(map[int]struct{})
		
		err :=db.EvalQuery(query,col,&queryResult)
		
		if err !=nil{
			c.String(200,err.Error())
		}else{
			c.String(200,fmt.Sprintf("%#v",queryResult))
			}
	})

	r.GET("/", func(c *gin.Context) {
		c.HTML(200, "index.tmpl", gin.H{
			"title": "Main website",
		})
	})

	r.Run(":8080")
}

func contains(strs []string, str string) bool {
	for _, v := range strs {
		if v == str {
			return true
		}
	}
	return false
}

func checkerr(err error) {
	if err != nil {
		panic(err)
	}
}