search

HappenApps / Quiver

Quiver documentation and issue tracker
2.26k stars 109 forks source link

Migrate "Favorites" #1431

Open FullStackAlex opened 4 years ago

FullStackAlex commented 4 years ago

Does anyone know where the Favorites are saved in the Library? I have just made a clean install of Catalina and imported my last backup of Quiver but the Favorites weren't saved :( But I still have a backup of the old machine, so maybe I can find them anywhere in the ~/Library directory as a file?

neerajbadlani commented 4 years ago

Should be here : ~/Library/Containers/com.happenapps.Quiver/Data/Library/Application\ Support/Quiver/cache.db You can use sqlite to inspect the DB and find out your favorites . Favorites arent saved in Quivers Data unfortunately .

FullStackAlex commented 4 years ago

Wow, thanx man. Wouldn't be never able to find it on my own.

I've opened the backup file in JetBrains' DataGrip and could get the ID's of the favourite notes via the SQL command: select uuid from note where is_favorite=true; Than I've just run this command on the live db file to set the favorites:

update note set is_favorite=true where uuid IN (
    "9E79AB06-C9E6-4700-95F8-D25A2B5BA072",
    "8A22718F-AFA6-49EA-ABB4-F4F4CB4B4831",
    "04D2C200-D14C-4600-939B-30479FBDDB23",
    (...)                                        
)

I don't get why it's so complicated to include this in the Quiver backup functionality...

neerajbadlani commented 4 years ago

I dont think its complicated , just maybe a missed functionality in released product .