1. 1
2. 2
3. 3
4. 4
5. 5
6. 6
7. 7
8. 8
9. 9
10. 10
11. 11
12. 12
13. 13
14. 14
15. 15
16. 16
17. 17
18. 18
19. 19
20. 20
21. 21
22. 22
23. 23
24. 24
25. 25
26. 26
27. 27
28. 28
29. 29
30. 30
31. 31
32. 32
33. 33
34. 34
35. 35
36. 36
37. 37
38. 38
39. 39
40. 40
41. 41
42. 42
43. 43
44. 44
45. 45
46. 46
47. 47
48. 48
49. 49
50. 50
51. 51
52. 52
53. 53
54. 54
55. 55
56. 56
57. 57
58. 58
59. 59
60. 60
61. 61

package main

import (
	"bufio"
	"database/sql"
	"flag"
	"fmt"
	"os"
	"strings"

	_ "modernc.org/sqlite"
)

/*
https://en.wiktionary.org/wiki/Appendix:Mandarin_Frequency_lists/1-1000
https://lingua.mtsu.edu/chinese-computing/statistics/char/list.php?Which=MO
https://jslearnchinese.wordpress.com/2018/07/24/the-1000-most-used-characters-in-chinese/
*/

var (
	verbose = flag.Bool("v", false, "debug output")
	file    = flag.String("f", "cards", "cards file")
)

func main() {
	flag.Parse()

	db, err := sql.Open("sqlite", *file)
	if err != nil {
		panic(err)
	}

	// Create table
	_, err = db.Exec("CREATE TABLE IF NOT EXISTS cards (idx INTEGER PRIMARY KEY, weight INTEGER, key STRING, val STRING)")
	if err != nil {
		panic(err)
	}

	f, err := os.Open("list")
	if err != nil {
		panic(err)
	}
	defer f.Close()

	scanner := bufio.NewScanner(f)

	i := 0
	for scanner.Scan() {
		line := strings.Split(scanner.Text(), "|")
		key := line[2]
		val := line[3] + " " + strings.Split(line[4], " {")[0]

		if *verbose {
			fmt.Println(key)
			fmt.Println(val)
		}

		_, err = db.Exec("INSERT INTO cards VALUES(?, ?, ?, ?)", i, 1<<(20-i/50), key, val)
		i++
	}
}