Something went wrong. Try again.
This repository has no description
Something went wrong. Try again.
931 B · 52 lines
Go
at master
1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253package 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}