func setServerConfig(d *Daemon, key string, value string) error { tx, err := shared.DbBegin(d.db) if err != nil { return err } _, err = tx.Exec("DELETE FROM config WHERE key=?", key) if err != nil { tx.Rollback() return err } if value != "" { str := `INSERT INTO config (key, value) VALUES (?, ?);` stmt, err := tx.Prepare(str) if err != nil { tx.Rollback() return err } defer stmt.Close() _, err = stmt.Exec(key, value) if err != nil { tx.Rollback() return err } } err = shared.TxCommit(tx) if err != nil { return err } return nil }
func dbInsertImage(d *Daemon, fp string, fname string, sz int64, public int, arch int, properties map[string]string) error { tx, err := shared.DbBegin(d.db) if err != nil { return err } stmt, err := tx.Prepare(`INSERT INTO images (fingerprint, filename, size, public, architecture, upload_date) VALUES (?, ?, ?, ?, ?, strftime("%s"))`) if err != nil { tx.Rollback() return err } defer stmt.Close() result, err := stmt.Exec(fp, fname, sz, public, arch) if err != nil { tx.Rollback() return err } if len(properties) > 0 { id64, err := result.LastInsertId() if err != nil { tx.Rollback() return err } id := int(id64) pstmt, err := tx.Prepare(`INSERT INTO images_properties (image_id, type, key, value) VALUES (?, 0, ?, ?)`) if err != nil { tx.Rollback() return err } defer pstmt.Close() for k, v := range properties { // we can assume, that there is just one // value per key _, err = pstmt.Exec(id, k, v) if err != nil { tx.Rollback() return err } } } if err := shared.TxCommit(tx); err != nil { return err } return nil }
func containerReplaceConfig(d *Daemon, ct *lxdContainer, name string, newConfig containerConfigReq) error { /* check to see that the config actually applies to the container * successfully before saving it. in particular, raw.lxc and * raw.apparmor need to be parsed once to make sure they make sense. */ if err := ct.applyConfig(newConfig.Config, false); err != nil { return err } tx, err := shared.DbBegin(d.db) if err != nil { return err } /* Update config or profiles */ if err = dbClearContainerConfig(tx, ct.id); err != nil { shared.Debugf("Error clearing configuration for container %s\n", name) tx.Rollback() return err } if err = dbInsertContainerConfig(tx, ct.id, newConfig.Config); err != nil { shared.Debugf("Error inserting configuration for container %s\n", name) tx.Rollback() return err } /* handle profiles */ if emptyProfile(newConfig.Profiles) { _, err := tx.Exec("DELETE from containers_profiles where container_id=?", ct.id) if err != nil { tx.Rollback() return err } } else { if err := dbInsertProfiles(tx, ct.id, newConfig.Profiles); err != nil { tx.Rollback() return err } } err = AddDevices(tx, "container", ct.id, newConfig.Devices) if err != nil { tx.Rollback() return err } return shared.TxCommit(tx) }
func imageDelete(d *Daemon, r *http.Request) Response { fingerprint := mux.Vars(r)["fingerprint"] imgInfo, err := dbImageGet(d.db, fingerprint, false) if err != nil { return SmartError(err) } fname := shared.VarPath("images", imgInfo.Fingerprint) err = os.Remove(fname) if err != nil { shared.Debugf("Error deleting image file %s: %s\n", fname, err) } vgname, vgnameIsSet, err := getServerConfigValue(d, "core.lvm_vg_name") if err != nil { return InternalError(fmt.Errorf("Error checking server config: %v", err)) } if vgnameIsSet { err = shared.LVMRemoveLV(vgname, imgInfo.Fingerprint) if err != nil { return InternalError(fmt.Errorf("Failed to remove deleted image LV: %v", err)) } lvsymlink := fmt.Sprintf("%s.lv", fname) err = os.Remove(lvsymlink) if err != nil { return InternalError(fmt.Errorf("Failed to remove symlink to deleted image LV: '%s': %v", lvsymlink, err)) } } else if d.BackingFs == "btrfs" { subvol := fmt.Sprintf("%s.btrfs", fname) exec.Command("btrfs", "subvolume", "delete", subvol).Run() } tx, err := shared.DbBegin(d.db) if err != nil { return InternalError(err) } _, _ = tx.Exec("DELETE FROM images_aliases WHERE image_id=?", imgInfo.Id) _, _ = tx.Exec("DELETE FROM images_properties WHERE image_id?", imgInfo.Id) _, _ = tx.Exec("DELETE FROM images WHERE id=?", imgInfo.Id) if err := shared.TxCommit(tx); err != nil { return InternalError(err) } return EmptySyncResponse }
func dbProfileDelete(db *sql.DB, name string) error { tx, err := shared.DbBegin(db) if err != nil { return err } _, err = tx.Exec("DELETE FROM profiles WHERE name=?", name) if err != nil { tx.Rollback() return err } err = shared.TxCommit(tx) return err }
func profilesPost(d *Daemon, r *http.Request) Response { req := profilesPostReq{} if err := json.NewDecoder(r.Body).Decode(&req); err != nil { return BadRequest(err) } if req.Name == "" { return BadRequest(fmt.Errorf("No name provided")) } name := req.Name tx, err := shared.DbBegin(d.db) if err != nil { return InternalError(err) } result, err := tx.Exec("INSERT INTO profiles (name) VALUES (?)", name) if err != nil { tx.Rollback() return SmartError(err) } id64, err := result.LastInsertId() if err != nil { tx.Rollback() return InternalError(fmt.Errorf("Error inserting %s into database", name)) } id := int(id64) err = addProfileConfig(tx, id, req.Config) if err != nil { tx.Rollback() return SmartError(err) } err = AddDevices(tx, "profile", id, req.Devices) if err != nil { tx.Rollback() return SmartError(err) } err = shared.TxCommit(tx) if err != nil { return InternalError(err) } return EmptySyncResponse }
func saveCert(d *Daemon, host string, cert *x509.Certificate) error { tx, err := shared.DbBegin(d.db) if err != nil { return err } fingerprint := shared.GenerateFingerprint(cert) stmt, err := tx.Prepare("INSERT INTO certificates (fingerprint,type,name,certificate) VALUES (?, ?, ?, ?)") if err != nil { tx.Rollback() return err } defer stmt.Close() _, err = stmt.Exec(fingerprint, 1, host, pem.EncodeToMemory(&pem.Block{Type: "CERTIFICATE", Bytes: cert.Raw})) if err != nil { tx.Rollback() return err } return shared.TxCommit(tx) }
func imagePut(d *Daemon, r *http.Request) Response { fingerprint := mux.Vars(r)["fingerprint"] imageRaw := imagePutReq{} if err := json.NewDecoder(r.Body).Decode(&imageRaw); err != nil { return BadRequest(err) } imgInfo, err := dbImageGet(d.db, fingerprint, false) if err != nil { return SmartError(err) } tx, err := shared.DbBegin(d.db) if err != nil { return InternalError(err) } _, err = tx.Exec(`DELETE FROM images_properties WHERE image_id=?`, imgInfo.Id) stmt, err := tx.Prepare(`INSERT INTO images_properties (image_id, type, key, value) VALUES (?, ?, ?, ?)`) if err != nil { tx.Rollback() return InternalError(err) } for key, value := range imageRaw.Properties { _, err = stmt.Exec(imgInfo.Id, 0, key, value) if err != nil { tx.Rollback() return InternalError(err) } } if err := shared.TxCommit(tx); err != nil { return InternalError(err) } return EmptySyncResponse }
func profilePut(d *Daemon, r *http.Request) Response { name := mux.Vars(r)["name"] req := profilesPostReq{} if err := json.NewDecoder(r.Body).Decode(&req); err != nil { return BadRequest(err) } tx, err := shared.DbBegin(d.db) if err != nil { return InternalError(err) } rows, err := tx.Query("SELECT id FROM profiles WHERE name=?", name) if err != nil { tx.Rollback() return SmartError(err) } var id int for rows.Next() { var i int err = rows.Scan(&i) if err != nil { shared.Debugf("DBERR: profilePut: scan returned error %q\n", err) tx.Rollback() return InternalError(err) } id = i } rows.Close() err = rows.Err() if err != nil { shared.Debugf("DBERR: profilePut: Err returned an error %q\n", err) tx.Rollback() return InternalError(err) } err = dbClearProfileConfig(tx, id) if err != nil { tx.Rollback() return InternalError(err) } err = addProfileConfig(tx, id, req.Config) if err != nil { tx.Rollback() return SmartError(err) } err = AddDevices(tx, "profile", id, req.Devices) if err != nil { tx.Rollback() return SmartError(err) } err = shared.TxCommit(tx) if err != nil { return InternalError(err) } return EmptySyncResponse }