Something went wrong. Try again.
forked from tangled.org/core
Something went wrong. Try again.
Go
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104package db
import ( "encoding/json" "time")
func AddPublicKey(e Execer, did, name, key, rkey string) error { _, err := e.Exec( `insert or ignore into public_keys (did, name, key, rkey) values (?, ?, ?, ?)`, did, name, key, rkey) return err}
func DeletePublicKey(e Execer, did, name, key string) error { _, err := e.Exec(` delete from public_keys where did = ? and name = ? and key = ?`, did, name, key) return err}
func DeletePublicKeyByRkey(e Execer, did, rkey string) error { _, err := e.Exec(` delete from public_keys where did = ? and rkey = ?`, did, rkey) return err}
type PublicKey struct { Did string `json:"did"` Key string `json:"key"` Name string `json:"name"` Rkey string `json:"rkey"` Created *time.Time}
func (p PublicKey) MarshalJSON() ([]byte, error) { type Alias PublicKey return json.Marshal(&struct { Created string `json:"created"` *Alias }{ Created: p.Created.Format(time.RFC3339), Alias: (*Alias)(&p), })}
func GetAllPublicKeys(e Execer) ([]PublicKey, error) { var keys []PublicKey
rows, err := e.Query(`select key, name, did, rkey, created from public_keys`) if err != nil { return nil, err } defer rows.Close()
for rows.Next() { var publicKey PublicKey var createdAt string if err := rows.Scan(&publicKey.Key, &publicKey.Name, &publicKey.Did, &publicKey.Rkey, &createdAt); err != nil { return nil, err } createdAtTime, _ := time.Parse(time.RFC3339, createdAt) publicKey.Created = &createdAtTime keys = append(keys, publicKey) }
if err := rows.Err(); err != nil { return nil, err }
return keys, nil}
func GetPublicKeys(e Execer, did string) ([]PublicKey, error) { var keys []PublicKey
rows, err := e.Query(`select did, key, name, rkey, created from public_keys where did = ?`, did) if err != nil { return nil, err } defer rows.Close()
for rows.Next() { var publicKey PublicKey var createdAt string if err := rows.Scan(&publicKey.Did, &publicKey.Key, &publicKey.Name, &publicKey.Rkey, &createdAt); err != nil { return nil, err } createdAtTime, _ := time.Parse(time.RFC3339, createdAt) publicKey.Created = &createdAtTime keys = append(keys, publicKey) }
if err := rows.Err(); err != nil { return nil, err }
return keys, nil}