Fix forgetting to commit imagesList.db generator script

1 files changed, 10 insertions, 0 deletions

diff --git a/backend/data/eol/genImagesListDb.sh b/backend/data/eol/genImagesListDb.sh
new file mode 100755
index 0000000..3a8ced7
--- /dev/null
+++ b/backend/data/eol/genImagesListDb.sh
@@ -0,0 +1,10 @@
+#!/bin/bash
+set -e
+
+cat imagesList/media_*_{1..58}.csv | tail -n +2 > imagesList.csv
+sqlite3 imagesList.db <<END
+CREATE TABLE images (
+	content_id INT PRIMARY KEY, page_id INT, source_url TEXT, copy_url TEXT, license TEXT, copyright_owner TEXT);
+.mode csv
+.import 'imagesList.csv' images
+END