#! /bin/sh

# The lessons are transient, so it is safe to delete them from the
# database.
sqlite3 learn.db <<ZZZ
DELETE FROM lesson;
DELETE FROM list;
ZZZ

g() {
	cargo r -- import --db learn.db \
		../typey/$1
}

g /fundamentals/introduction/lesson.txt
g /fundamentals/one-syllable-words-with-simple-keys/lesson.txt
g /fundamentals/one-syllable-words-with-more-consonants/lesson.txt
g /fundamentals/one-syllable-words-with-f-as-v-or-s/lesson.txt
g /fundamentals/one-syllable-words-with-unstressed-vowels/lesson.txt
g /fundamentals/one-syllable-words-with-inversion/lesson.txt
g /fundamentals/one-syllable-words-with-short-i-vowel/lesson.txt
g /fundamentals/one-syllable-words-with-short-vowels/lesson.txt
g /fundamentals/one-syllable-words-with-long-vowels/lesson.txt
g /fundamentals/one-syllable-words-with-diphthongs/lesson.txt
g /fundamentals/one-syllable-words-with-vowel-disambiguators/lesson.txt
g /fundamentals/one-syllable-words-with-left-hand-consonants-with-multiple-keys/lesson.txt
g /fundamentals/one-syllable-words-with-right-hand-consonants-with-multiple-keys/lesson.txt
g /fundamentals/one-syllable-words-with-digraphs/lesson.txt
g /fundamentals/one-syllable-words-with-compound-clusters/lesson.txt
g /fundamentals/one-syllable-words-with-multiple-strokes/lesson.txt
g /fundamentals/multi-syllable-words-with-compound-clusters/lesson.txt
g /fundamentals/multi-syllable-words-with-inversion/lesson.txt
g /fundamentals/multi-syllable-words-with-briefs/lesson.txt
g /fundamentals/multi-syllable-words-with-prefixes/lesson.txt
g /fundamentals/multi-syllable-words-with-suffixes/lesson.txt
g /fundamentals/multi-syllable-words-with-doubled-consonant-letters/lesson.txt
g /fundamentals/multi-syllable-words-with-multiple-strokes/lesson.txt
g /fundamentals/fingerspelling/lesson.txt
g /fundamentals/punctuation/lesson.txt
g /fundamentals/numbers/lesson.txt
g /fundamentals/roman-numerals/lesson.txt

g /drills/top-100-words/lesson.txt
g /drills/top-200-words-spoken-on-tv/lesson.txt
g /drills/top-1000-words/lesson.txt
g /drills/top-10000-project-gutenberg-words/lesson.txt