Function writeNote

pkg/cli/cmd/add/add.go:144–198

(ctx context.DnoteCtx, bookLabel string, content string, ts int64)

}

func writeNote(ctx context.DnoteCtx, bookLabel string, content string, ts int64) (int, error) {
	tx, err := ctx.DB.Begin()
	if err != nil {
		return 0, errors.Wrap(err, "beginning a transaction")
	}

	var bookUUID string
	err = tx.QueryRow("SELECT uuid FROM books WHERE label = ?", bookLabel).Scan(&bookUUID)
	if err == sql.ErrNoRows {
		bookUUID, err = utils.GenerateUUID()
		if err != nil {
			return 0, errors.Wrap(err, "generating uuid")
		}

		b := database.NewBook(bookUUID, bookLabel, 0, false, true)
		err = b.Insert(tx)
		if err != nil {
			tx.Rollback()
			return 0, errors.Wrap(err, "creating the book")
		}
	} else if err != nil {
		return 0, errors.Wrap(err, "finding the book")
	}

	noteUUID, err := utils.GenerateUUID()
	if err != nil {
		return 0, errors.Wrap(err, "generating uuid")
	}

	n := database.NewNote(noteUUID, bookUUID, content, ts, 0, 0, false, true)

	err = n.Insert(tx)
	if err != nil {
		tx.Rollback()
		return 0, errors.Wrap(err, "creating the note")
	}

	var noteRowID int
	err = tx.QueryRow(`SELECT notes.rowid
			FROM notes
			WHERE notes.uuid = ?`, noteUUID).
		Scan(&noteRowID)
	if err != nil {
		tx.Rollback()
		return noteRowID, errors.Wrap(err, "getting the note rowid")
	}

	err = tx.Commit()
	if err != nil {
		tx.Rollback()
		return noteRowID, errors.Wrap(err, "committing a transaction")
	}

	return noteRowID, nil
}