aboutsummaryrefslogtreecommitdiff
path: root/backend/data/eol/genImagesListDb.sh
diff options
context:
space:
mode:
authorTerry Truong <terry06890@gmail.com>2022-06-22 23:16:42 +1000
committerTerry Truong <terry06890@gmail.com>2022-06-22 23:16:42 +1000
commitabb936f5d76f7fe5cec1e8948d287da86643d504 (patch)
treef07b9eaadf5ae91363fdbac9d81b74e1fb0a436f /backend/data/eol/genImagesListDb.sh
parente78c4df403e5f98afa08f7a0841ff233d5f6d05b (diff)
Refactor backend scriptsextended-db
Diffstat (limited to 'backend/data/eol/genImagesListDb.sh')
-rwxr-xr-xbackend/data/eol/genImagesListDb.sh2
1 files changed, 2 insertions, 0 deletions
diff --git a/backend/data/eol/genImagesListDb.sh b/backend/data/eol/genImagesListDb.sh
index 3a8ced7..87dd840 100755
--- a/backend/data/eol/genImagesListDb.sh
+++ b/backend/data/eol/genImagesListDb.sh
@@ -1,7 +1,9 @@
#!/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);