package main

import (
	"github.com/jinzhu/gorm"
	_ "github.com/jinzhu/gorm/dialects/sqlite"
	"fmt"
	"crypto/md5"
)

type User struct{
	gorm.Model
	Email		string
	Username	string
	Password	string
}

func main(){
	db, err := gorm.Open("sqlite3", "sqlite.db")
	if err != nil {
		panic("failed to connect database")
	}
	defer db.Close()

	db.AutoMigrate(&User{})

	user := User{Email:"ntossapo@gmail.com", Username:"ntossapo", Password:fmt.Sprintf("%x", md5.Sum([]byte("password")))}
	db.Save(&user)

	PrintUser(db)

	var users []User
	db.Find(&users, "email = ?", "ntossapo@gmail.com").Update("email", "tspn@gmail.com")

	PrintUser(db)
}

func PrintUser(db *gorm.DB){
	var users []User
	db.Find(&users)
	for _, user := range users{
		fmt.Println(user.Email, user.Username, user.Password)
	}
}