package main
import (
"database/sql"
"github.com/rgamba/goql"
"fmt"
_ "strings"
_ "testing"
_ "github.com/mattn/go-sqlite3"
)
type User struct {
Id int64 `db:"id" pk:"true"`
Username string `db:"username"`
Password string `db:"password"`
Email string
Total string `db:"total" sql:"COUNT(col)"`
}
func main(){
user :=&User{}
db, err := sql.Open("sqlite3", "goql.db")
query := goql.QueryBuilder{}
query.Select("username,email").From("user").Where("id = $?", 1).QueryAndScan(db, &user)
fmt.Println(user,err)
}
