notesdb

package

v1.0.1 Latest Latest Go to latest Published: Mar 20, 2025 License: MIT Imports: 7 Imported by: 0

Details

View Source

const (
	CONTENT_SQL = 1
)

View Source

var (
	//go:embed files/create_notes_tables.sql
	CREATE_NOTES_TABLES_SQL string
)

func DeleteNote(db *sql.DB, id int64) error

func GetNoteContents(db *sql.DB, id int64) ([]byte, error)

func Initialize(path string) (*sql.DB, error)

func SetNoteContents(db *sql.DB, id int64, content []byte) error

func UpdateNote(db *sql.DB, id int64, title string) error

type IndexEntry struct {
	*notes.Note
	ContentType int `json:"-"`
}

func GetNote(db *sql.DB, id int64) (*IndexEntry, error)

func GetNotes(db *sql.DB) ([]*IndexEntry, error)

func NewNote(db *sql.DB, title string) (*IndexEntry, error)

type IndexEntryWithPreview struct {
	*IndexEntry
	ContentPreview string `json:"content_preview"`
}

func GetNotesWithPreview(db *sql.DB, previewLength int) ([]*IndexEntryWithPreview, error)