Note that this will cause the syncing mechanism to get confused. Much better to use Mnemosyne's Python API for that. There is a search and replace example script in the repository.
Cheers, Peter Gwern Branwen <[email protected]> wrote: >On Thu, Nov 1, 2012 at 11:21 AM, Gnome <[email protected]> wrote: >> After doing some cleaning in 'default.db_media' i have renamed one >> directory. Can I just search and replace the path name in >'default.db', >> after taking backup of course? > >I ran into a similar problem: on ~150 flashcards, I had written >"<sound src=" rather than "<audio src=". Too many to fix by hand. I >think the following `sqlite3 default.db` transcript illustrates how >one could successfully update a deck: > > sqlite> .table > card_types data_for_fact global_variables partnerships > cards fact_views log tags > criteria facts media tags_for_card > sqlite> > sqlite> .schema cards > CREATE TABLE cards( > _id integer primary key, > id text, > card_type_id text, > _fact_id integer, > fact_view_id text, > > question text, > answer text, > tags text, > > grade integer, > next_rep integer, > last_rep integer, > easiness real, > acq_reps integer, > ret_reps integer, > lapses integer, > acq_reps_since_lapse integer, > ret_reps_since_lapse integer, > creation_time integer, > modification_time integer, > extra_data text default "", > scheduler_data integer default 0, > active boolean default 1 > ); > CREATE INDEX i_cards on cards (id); > CREATE INDEX i_cards_2 on cards (fact_view_id); > CREATE INDEX i_cards_3 on cards (_fact_id); > sqlite> > sqlite> SELECT question FROM cards WHERE question like '%<sound %'; > <small><small>define:</small></small> extant (adj.) <sound >src="english/extant_1.ogg"/><sound src="english/extant_2.ogg"/><sound >src="english/extant_3.ogg"/><sound src="english/extant_4.ogg"/><sound >src="english/extant_5.ogg"/> > > <small><small>define:</small></small> gamut <sound >src="english/gamut_1.ogg"/><sound src="english/gamut_2.ogg"/><sound >src="english/gamut_3.ogg"/><sound src="english/gamut_4.ogg"/> > > <small><small>define:</small></small> glabrous >(<i>/'glæbɹəs/</i>; adj.) <sound src="english/glabrous_1.ogg"/><sound >src="english/glabrous_2.ogg"/><sound src="english/glabrous_3.ogg"/> > ... > sqlite> >sqlite> UPDATE cards SET question = replace(question, '<sound', >'<audio'); > sqlite> SELECT question FROM cards WHERE question like '%<sound%'; > sqlite> > sqlite> UPDATE cards SET answer = replace(answer, '<sound', '<audio'); > sqlite> SELECT answer FROM cards WHERE answer like '%<sound%'; > >-- >gwern >http://www.gwern.net > >-- >You received this message because you are subscribed to the Google >Groups "mnemosyne-proj-users" group. >To unsubscribe from this group and stop receiving emails from it, send >an email to [email protected]. >To post to this group, send email to >[email protected]. >For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups "mnemosyne-proj-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
