package main

import (
	"fmt"
	"github.com/aacanakin/qb"
	"github.com/nu7hatch/gouuid"
)

type User struct {
	ID       string `db:"_id" qb:"type:uuid; constraints:primary_key"`
	Email    string `qb:"constraints:unique, notnull"`
	FullName string `qb:"constraints:notnull"`
	Bio      string `qb:"type:text; constraints:null"`
}

func main() {

	db, err := qb.New("postgres", "user=postgres dbname=qb_test sslmode=disable")
	if err != nil {
		panic(err)
	}

	defer db.Close()

	// add table to metadata
	db.AddTable(User{})

	// create all tables registered to metadata
	db.CreateAll()

	userID, _ := uuid.NewV4()
	db.Add(&User{
		ID:       userID.String(),
		Email:    "robert@de-niro.com",
		FullName: "Robert De Niro",
	})

	err = db.Commit() // insert user
	if err != nil {
	    fmt.Println(err)
	    return
	}

	var user User
	db.Find(&User{ID: userID.String()}).One(&user)

	fmt.Println("id", user.ID)
	fmt.Println("email", user.Email)
	fmt.Println("full_name", user.FullName)

	db.DropAll() // drops all tables

}

package main

import (
	"fmt"
	"github.com/aacanakin/qb"
)

func main() {
	db, _ := qb.New("sqlite3", ":memory:")
	defer db.Close()

	db.Dialect().SetEscaping(true)

	actors := qb.Table(
		"actor",
		qb.Column("id", qb.Varchar().Size(36)),
		qb.Column("name", qb.Varchar().NotNull()),
		qb.PrimaryKey("id"),
	)

	db.Metadata().AddTable(actors)
	err := db.CreateAll()
	if err != nil {
		panic(err)
	}

	ins := actors.Insert().Values(map[string]interface{}{
		"id":   "3af82cdc-4d21-473b-a175-cbc3f9119eda",
		"name": "Robert De Niro",
	})

	_, err = db.Engine().Exec(ins)
	if err != nil {
		panic(err)
	}

	sel := actors.
		Select(actors.C("name"), actors.C("id")).
		Where(actors.C("name").Eq("Robert De Niro"))

	var name string
	var id string

	db.Engine().QueryRow(sel).Scan(&name, &id)
	fmt.Printf("<User name=%s id=%s/>\n", name, id)

	// outputs
	// <User name=Robert De Niro id=3af82cdc-4d21-473b-a175-cbc3f9119eda/>
}