From a6ca0fa635e3a3816f9f11d529f22f4896b3bae7 Mon Sep 17 00:00:00 2001
From: emkael <emkael@tlen.pl>
Date: Sat, 7 Oct 2023 21:23:45 +0200
Subject: Importing dumps uploaded via Dropbox and FTP

---
 dumps/fetch-dropbox.sh | 3 +++
 dumps/fetch-local.sh   | 9 +++++++++
 2 files changed, 12 insertions(+)
 create mode 100755 dumps/fetch-dropbox.sh
 create mode 100755 dumps/fetch-local.sh

(limited to 'dumps')

diff --git a/dumps/fetch-dropbox.sh b/dumps/fetch-dropbox.sh
new file mode 100755
index 0000000..99db29e
--- /dev/null
+++ b/dumps/fetch-dropbox.sh
@@ -0,0 +1,3 @@
+#!/bin/bash
+dbxcli ls -l "${LIGA_DROPBOX_DUMP_FOLDER}" | awk -F"ago" '{print $2}' | sed -e 's/^[[:space:]]*//' -e 's/[[:space:]]*$//' |
+    xargs -I{} dbxcli get {} dumps/sync
diff --git a/dumps/fetch-local.sh b/dumps/fetch-local.sh
new file mode 100755
index 0000000..01616a7
--- /dev/null
+++ b/dumps/fetch-local.sh
@@ -0,0 +1,9 @@
+#!/bin/bash
+
+find http -path */spedytor/*.sql | sort | uniq | cut -d/ -f 1-4 | uniq | while read LOCAL_DUMP_DIR
+do
+    LOCAL_DUMP=$(find ${LOCAL_DUMP_DIR} -name *.sql -exec ls -t1 {} + | head -n1 | cut -d' ' -f 10)
+    TARGET_DUMP=$(basename ${LOCAL_DUMP})
+    TARGET_DUMP=${TARGET_DUMP%%-*}
+    cp "${LOCAL_DUMP}" dumps/sync/${TARGET_DUMP}.sql
+done
-- 
cgit v1.2.3