28 lines
1021 B
Bash
28 lines
1021 B
Bash
cd /mnt/hdd/opds
|
|
|
|
# 1. Создать таблицы и индексы
|
|
docker compose exec opds python -c "
|
|
import psycopg2
|
|
conn = psycopg2.connect('dbname=books user=postgres password=Karabas@Barabas host=172.20.0.4')
|
|
cur = conn.cursor()
|
|
for f in ['/app/sql/01_create_tables.sql', '/app/sql/02_create_indexes.sql']:
|
|
with open(f) as fp:
|
|
cur.execute(fp.read())
|
|
conn.commit()
|
|
conn.close()
|
|
print('Schema created')
|
|
"
|
|
|
|
# 2. Загрузить жанры
|
|
docker compose exec opds python /app/scripts/parse_genres.py \
|
|
/app/data/genres.xml \
|
|
"dbname=books user=postgres password=Karabas@Barabas host=172.20.0.4"
|
|
|
|
# 3. Импортировать книги
|
|
docker compose exec opds python /app/scripts/parse_inpx.py \
|
|
"/mnt/hdd/share/Torrents/Downloaded/Libruks/Библиотека Либрусек для архивов 18-09-2026.inpx" \
|
|
"dbname=books user=postgres password=Karabas@Barabas host=172.20.0.4" \
|
|
"lib.rus.ec"
|
|
|
|
# 4. Следить за прогрессом
|
|
docker compose logs opds --tail 20 |