func (sreg *sqlStorageRegistration) NewAuthorization(auth types.Authorization) (i.StorageAuthorization, error) {
export, err := auth.Export(sreg.storage.lastPassword())
if nil != err {
return nil, err
}
_, err = sreg.storage.db.Exec(
`INSERT INTO authorization (registration_id, dnsName, location, status, expires, jsonPem) VALUES
($1, $2, $3, $4, $5, $6)`,
sreg.id, string(auth.Resource.DNSIdentifier), auth.Location,
string(auth.Resource.Status), auth.Resource.Expires, export.JsonPem)
if nil != err {
return nil, err
}
return sreg.LoadAuthorization(auth.Location)
}
func (storage *sqlStorage) saveAuthorization(id int64, registration_id int64, auth types.Authorization) error {
export, err := auth.Export(storage.lastPassword())
if nil != err {
return err
}
_, err = storage.db.Exec(
`UPDATE authorization SET
registration_id = $1, dnsName = $2, location = $3,
status = $4, expires = $5, jsonPem = $6
WHERE id = $7`,
registration_id,
string(auth.Resource.DNSIdentifier), auth.Location,
string(auth.Resource.Status), auth.Resource.Expires, export.JsonPem,
id)
return err
}
