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 }