diff options
Diffstat (limited to 'backend/data/eol/genImagesListDb.sh')
| -rwxr-xr-x | backend/data/eol/genImagesListDb.sh | 2 |
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); |
