package main

import "github.com/mxk/go-sqlite/sqlite3"

type User struct {
    id int
    name string
    isAdmin bool
}

func createUser(db *sqlite3.Conn, name string, isAdmin bool) {

    //Check if a user with this name already exists
    if (getUserForName(db, name).id == 0) {
        args := sqlite3.NamedArgs{"$a": name, "$b": isAdmin}
        sql := "INSERT INTO users (name, admin) VALUES ($a, $b)"

        db.Exec(sql, args)
    }

}

func getUserForId(db *sqlite3.Conn, id int) User {

    args := sqlite3.NamedArgs{"$a": id}
    sql := "SELECT * FROM users WHERE id = $a"
    s, err := db.Query(sql, args)
    row := make(sqlite3.RowMap)
    
    for ; err == nil ; err = s.Next() {
        var rowid int
        s.Scan(&rowid, row)     // Assigns 1st column to rowid, the rest to row

        user := User{id:rowid, name:row["name"].(string), isAdmin:row["admin"].(bool)}
        return user
    }

    //If we get here there are no matching users
    return User{id:0, name:"", isAdmin:false}

}

func getUserForName(db *sqlite3.Conn, name string) User {

    args := sqlite3.NamedArgs{"$a": name}
    sql := "SELECT * FROM users WHERE name = $a"
    s, err := db.Query(sql, args)
    row := make(sqlite3.RowMap)
    
    for ; err == nil ; err = s.Next() {
        var rowid int
        s.Scan(&rowid, row)

        user := User{id:rowid, name:row["name"].(string), isAdmin:row["admin"].(bool)}
        return user
    }

    //If we get here there are no matching users
    return User{id:0, name:"", isAdmin:false}

}