1 files changed, 15 insertions, 0 deletions
diff --git a/update-sqlite3 b/update-sqlite3
new file mode 100755
index 0000000..da86baf
--- /dev/null
+++ b/update-sqlite3
@@ -0,0 +1,15 @@
+#!/bin/sh
+# Downloads latest OpenRussian MySQL database dump and convert
+# it to Sqlite3.
+#
+# NOTE: unzip cannot read from stdin yet. bsdtar could in principle,
+# but does not allow extracting to stdout.
+
+TMPFILE=`mktemp`
+
+wget -O $TMPFILE https://en.openrussian.org/downloads/openrussian-sql.zip
+unzip -p $TMPFILE openrussian.sql | \
+~/working-copies/mysql2sqlite/mysql2sqlite - | \
+sqlite3 openrussian-sqlite3.db
+
+rm $TMPFILE