41 lines
1.3 KiB
Bash
41 lines
1.3 KiB
Bash
#!/bin/bash
|
|
set -e
|
|
|
|
echo "---STEP 1: Move files---"
|
|
cd /opt/yuyueguahao
|
|
ls uploads/ 2>/dev/null || mkdir -p uploads
|
|
if [ -d "server/uploads" ] && [ "$(ls -A server/uploads 2>/dev/null)" ]; then
|
|
mv server/uploads/* uploads/
|
|
rmdir server/uploads
|
|
fi
|
|
ls -la uploads/ | head -6
|
|
echo
|
|
|
|
echo "---STEP 2: Restart PM2---"
|
|
pm2 restart yuyueguahao-api 2>&1 | tail -3
|
|
sleep 3
|
|
echo
|
|
|
|
echo "---STEP 3: Test 80 (Nginx)---"
|
|
curl -I http://localhost/uploads/1781403331659-1cac3cac.png 2>&1 | head -3
|
|
echo
|
|
|
|
echo "---STEP 4: Test 3000 (Express)---"
|
|
curl -I http://localhost:3000/uploads/1781403331659-1cac3cac.png 2>&1 | head -3
|
|
echo
|
|
|
|
echo "---STEP 5: Fix DB URLs (strip absolute host)---"
|
|
mysql -uyygh_app -p'Yygh@2026#App' yuyueguahao -e "
|
|
UPDATE banners SET image = REPLACE(image, 'http://124.221.67.199:3000', '') WHERE image LIKE 'http%';
|
|
UPDATE centers SET image = REPLACE(image, 'http://124.221.67.199:3000', '') WHERE image LIKE 'http%';
|
|
UPDATE home_intro SET image = REPLACE(image, 'http://124.221.67.199:3000', '') WHERE image LIKE 'http%';
|
|
UPDATE hospital_images SET image = REPLACE(image, 'http://124.221.67.199:3000', '') WHERE image LIKE 'http%';
|
|
" 2>&1
|
|
echo
|
|
|
|
echo "---STEP 6: Verify DB---"
|
|
mysql -uyygh_app -p'Yygh@2026#App' yuyueguahao -e 'SELECT id, image FROM banners LIMIT 3; SELECT id, image FROM home_intro;' 2>&1
|
|
|
|
echo
|
|
echo "---DONE---"
|