package db

import (
	"database/sql"

	"tangled.org/core/appview/models"
)

func GetPunchcardPreference(e Execer, did string) (models.PunchcardPreference, error) {
	preference := models.PunchcardPreference{
		Did: did,
	}

	hideMine := 0
	hideOthers := 0

	err := e.QueryRow(
		`select id, hide_mine, hide_others from punchcard_preferences where user_did = ?`,
		did,
	).Scan(&preference.ID, &hideMine, &hideOthers)
	if err == sql.ErrNoRows {
		return preference, nil
	}

	preference.HideMine = hideMine > 0
	preference.HideOthers = hideOthers > 0

	if err != nil {
		return preference, err
	}

	return preference, nil
}

func UpsertPunchcardPreference(e Execer, did string, hideMine, hideOthers bool) error {
	_, err := e.Exec(
		`insert or replace into punchcard_preferences (
			user_did,
			hide_mine,
		 	hide_others
		)
		values (?, ?, ?)`,
		did,
		hideMine,
		hideOthers,
	)
	if err != nil {
		return err
	}

	return nil
}

func GetKnotPreference(e Execer, did string) (*models.KnotPreference, error) {
	var knotPreference models.KnotPreference

	err := e.QueryRow(
		`select id, user_did, default_knot from knot_preferences where user_did = ?`,
		did,
	).Scan(&knotPreference.ID, &knotPreference.Did, &knotPreference.DefaultKnot)
	if err == sql.ErrNoRows {
		return nil, nil
	}

	if err != nil {
		return nil, err
	}

	return &knotPreference, nil
}

func UpsertKnotPreference(e Execer, did, defaultKnot string) error {
	_, err := e.Exec(
		`insert or replace into knot_preferences (
			user_did,
			default_knot
		)
		values (?, ?)`,
		did,
		defaultKnot,
	)
	if err != nil {
		return err
	}

	return nil
}