storage

type Note struct {
	ID          string    `json:"id"`
	Filename    string    `json:"filename"`
	Title       string    `json:"title"`
	Path        string    `json:"path"`
	Folder      string    `json:"folder"`
	ContentHash string    `json:"content_hash"`
	WordCount   int       `json:"word_count"`
	CreatedAt   time.Time `json:"created_at"`
	ModifiedAt  time.Time `json:"modified_at"`
	Archived    bool      `json:"archived"`
	Pinned      bool      `json:"pinned"`
	Content     string    `json:"-"` // full text for FTS indexing (not stored in notes table)
	Tags        []string  `json:"tags"`
}

type NoteStore struct {
	// contains filtered or unexported fields
}

type Store interface {
	Init() error
	CreateNote(note *Note) error
	GetNote(id string) (*Note, error)
	FindNoteByFilename(filename string) (*Note, error)
	UpdateNote(note *Note) error
	DeleteNote(id string) error
	ListNotes() ([]*Note, error)
	ListNotesByTag(tag string) ([]*Note, error)
	SearchNotes(query string) ([]*Note, error)
	Close() error

	GetSyncState(noteID, backend string) (*SyncState, error)
	UpsertSyncState(state *SyncState) error
	DeleteSyncState(noteID, backend string) error
	ListSyncStates() ([]*SyncState, error)
	ListSyncStatesByStatus(status string) ([]*SyncState, error)
	EnqueueSyncJob(noteID string, backends []string, direction string, attempts int) error
	DequeueSyncJob() (*SyncQueueItem, error)
	QueueLength() (int, error)
	AddSyncHistory(entry *SyncHistoryEntry) error
	ListSyncHistory(noteID string) ([]*SyncHistoryEntry, error)
	SaveVersion(noteID string, content string, trigger string) (*Version, error)
	ListVersions(noteID string) ([]*Version, error)
	GetVersion(noteID string, versionNum int) (*Version, error)
}

type SyncHistoryEntry struct {
	ID        int64     `json:"id"`
	NoteID    string    `json:"note_id"`
	Backend   string    `json:"backend"`
	Direction string    `json:"direction"`
	Status    string    `json:"status"`
	SyncedAt  time.Time `json:"synced_at"`
	Hash      string    `json:"hash,omitempty"`
}

type SyncQueueItem struct {
	ID        int64     `json:"id"`
	NoteID    string    `json:"note_id"`
	Backends  []string  `json:"backends"`
	Direction string    `json:"direction"`
	QueuedAt  time.Time `json:"queued_at"`
	Attempts  int       `json:"attempts"`
	LastError string    `json:"last_error,omitempty"`
}

type SyncState struct {
	NoteID     string    `json:"note_id"`
	Backend    string    `json:"backend"`
	RemoteID   string    `json:"remote_id,omitempty"`
	LastSyncAt time.Time `json:"last_sync_at,omitempty"`
	LastHash   string    `json:"last_hash,omitempty"`
	Status     string    `json:"status"`
	ErrorMsg   string    `json:"error_msg,omitempty"`
}

type Version struct {
	ID         int64     `json:"id"`
	NoteID     string    `json:"note_id"`
	VersionNum int       `json:"version_num"`
	Content    string    `json:"content"`
	SavedAt    time.Time `json:"saved_at"`
	Trigger    string    `json:"trigger"`
}