sql

type EmailMetadata struct {
	Validated bool
	Added     int64 // unix timestamp
	Data      map[string]interface{}
}

type EmailRecord struct {
	Email string
	EmailMetadata
}

type PrefsBlob struct {
	DisplayName string                 `json:"dn,omitempty"`
	Data        map[string]interface{} `json:"d,omitempty"`
}

type User struct {
	// primary key
	Guid int64

	// goog, fb, twit, etc.
	Social []UserSocial

	// Local Username must be unique across local users
	Username string
	Password []byte

	// lost password recovery, notifications
	Email []EmailRecord

	// What we show them when we talk to them. "Hi, ____"
	// Need not be unique.
	DisplayName string

	// Serialized by encoding/json or similar
	Data map[string]interface{}
}

type UserDB interface {
	// Setup will create or mirgate tables
	Setup() error

	PutNewUser(nu *User) (*User, error)

	GetUser(guid int64) (*User, error)
	GetLocalUser(username string) (*User, error)
	GetSocialUser(service, id string) (*User, error)

	// copy misc data out of User struct into preferences
	SetUserPrefs(user *User) error
	SetUserPassword(user *User) error

	// Set local login for a social-login user
	SetLogin(user *User, username, password string) error

	AddEmail(user *User, email EmailRecord) error
	DelEmail(user *User, email string) error

	Feedback(user *User, now int64, text string) error
}

type UserSocial struct {
	Service string
	Id      string
	Data    interface{}
}