blob: 3a8ced7731c0189b3f5d66a248ad0d78d2342067 (
plain)
1
2
3
4
5
6
7
8
9
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
|
