From 5fe71ea7b9d9a5d2dc6e8e5ce5b9193629eed74d Mon Sep 17 00:00:00 2001
From: Terry Truong <terry06890@gmail.com>
Date: Mon, 11 Jul 2022 01:54:08 +1000
Subject: Make backend dev server script serve the image files

Previously, image files in backend/data/img were moved to, or
symlinked from, public/. This needed to be changed before each
build, otherwise vite would end up copying gigabytes of images.
---
 backend/tolData/eol/genImagesListDb.sh | 12 ++++++++++++
 1 file changed, 12 insertions(+)
 create mode 100755 backend/tolData/eol/genImagesListDb.sh

(limited to 'backend/tolData/eol/genImagesListDb.sh')

diff --git a/backend/tolData/eol/genImagesListDb.sh b/backend/tolData/eol/genImagesListDb.sh
new file mode 100755
index 0000000..87dd840
--- /dev/null
+++ b/backend/tolData/eol/genImagesListDb.sh
@@ -0,0 +1,12 @@
+#!/bin/bash
+set -e
+
+# Combine CSV files into one, skipping header lines
+cat imagesList/media_*_{1..58}.csv | tail -n +2 > imagesList.csv
+# Create database, and import the CSV file
+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
-- 
cgit v1.2.3