From e44e2fe070484e06d384a31ef2699c3a2d5d474e Mon Sep 17 00:00:00 2001
From: RaindropsSys <raindrops@equestria.dev>
Date: Thu, 13 Jun 2024 15:46:03 +0200
Subject: GitHub migration

---
 sql/doall.sh | 15 +++++++++++++++
 1 file changed, 15 insertions(+)
 create mode 100755 sql/doall.sh

(limited to 'sql/doall.sh')

diff --git a/sql/doall.sh b/sql/doall.sh
new file mode 100755
index 0000000..89594f8
--- /dev/null
+++ b/sql/doall.sh
@@ -0,0 +1,15 @@
+#!/bin/bash
+PATH=/opt/homebrew/Cellar/postgresql@16/16.2_1/bin:$PATH
+brew services start postgresql@16
+rm -f $HOME/.db.pgdump
+wget $1 -O $HOME/.db.pgdump
+dropdb --if-exists derpibooru
+#sudo -u postgres dropdb --if-exists derpibooru
+createdb derpibooru
+#sudo -u postgres createdb derpibooru
+pg_restore -v -O -d derpibooru $HOME/.db.pgdump
+#sudo -u postgres pg_restore -v -O -d derpibooru $HOME/.db.pgdump
+python3 main.py
+#sudo -u postgres bash -c "cd $PATH && python3 main.py"
+brew services stop postgresql@16
+rm -f $HOME/.db.pgdump
-- 
cgit