package main

import (
    "database/sql"
    "github.com/tada-team/lorm"
)

func init() {
    connStr := "dbname=... user=... password=... host=... port=... sslmode=..."
    conn, err := sql.Open("postgres", connStr)
    if err != nil {
        panic(err)
    }
    lorm.SetConn(conn)
}

user := UserTable.MustGet(42) // same as UserTable.Filter().Id(42).MustGet() 
if user == nil {
    panic("user not found")
}

user.IsArchive = false
if err := user.Save(); err != nil {
    panic(err)
}

if err := user.Delete(); err != nil {
    panic(err)
}

for _, user := range UserTable.Filter().IsAdmin(false).CreatedGt(dt).MustList() {
    fmt.Println(user.login)
}

package main

import (
    "github.com/tada-team/lorm"
    "github.com/tada-team/lorm/op"
)

func ExampleQuery(i, j int) (int, error) {
    args := op.NewArgs()
    query := op.RawQuery("SELECT", args.Next(i), "*", args.Next(j))
    
    var res int    
    err := lorm.TxScan(nil, query, args, &res)

    return res, err
}

args := op.Args{i, j}
query := "SELECT $1 * $2"

args := op.NewArgs()
query := op.Select(
    UserTable.Id(),
    UserTable.Created(),
).From(
    UserTable,
).OrderBy(
    UserTable.Created(),
).Where( // .Where() arguments concatenated with "AND" statement
    UserTable.Created().Gt(args.Next(time.Now().Add(-time.Hour))),
    op.Or(
        UserTable.IsArchive(),        
        op.Not(UserTable.IsAdmin()),
        UserTable.GroupId().InSubquery( // wow, subqueries!
            op.Select(
                GroupTable.Id(),
            ).From(
                GroupTable,
            ).Where(
                // HasPrefix is shortcut for "...%"
                GroupTable.Title().ILike(args.Next(op.HasPrefix("aaaaa"))),
            ),
        ),
    ),
).Limit(
    args.Next(10),
)

args := op.NewArgs()
query := op.Insert(t, op.Set{
    op.Column("date"): op.Raw("CURRENT_DATE"),
    op.Column("value"): args.Next(1),
}, op.Set{
    op.Column("date"): op.Raw("CURRENT_DATE"),
    op.Column("value"): args.Next(2),
})

package main

import (
    "github.com/tada-team/lorm"
    "github.com/tada-team/lorm/op"
)

func ExampleTransaction(i, j int) (int, error) {
    args := op.NewArgs()
    query := op.RawQuery("SELECT", args.Next(i), "*", args.Next(j))
    
    var res int    
    if err := lorm.Atomic(func(tx *lorm.Tx) error {
        return lorm.TxScan(tx, query, args, &res)    	
    }); err != nil {
        return res, err
    }

    return res, nil
}