30 lines
1.3 KiB
Bash
30 lines
1.3 KiB
Bash
#!/bin/bash
|
|
echo "=== Verificando estructura en Raspberry ==="
|
|
echo ""
|
|
echo "1. Templates _gkachele:"
|
|
sshpass -p 'Gdk1983gdk45@' ssh -p 2222 -o StrictHostKeyChecking=no pi@192.168.1.134 'ls -la /home/pi/gkachele-saas/themes/_gkachele/'
|
|
|
|
echo ""
|
|
echo "2. Función render_gkachele_template:"
|
|
sshpass -p 'Gdk1983gdk45@' ssh -p 2222 -o StrictHostKeyChecking=no pi@192.168.1.134 'grep -c "def render_gkachele_template" /home/pi/gkachele-saas/app.py && echo "✅ Función encontrada" || echo "❌ Función NO encontrada"'
|
|
|
|
echo ""
|
|
echo "3. Tablas en base de datos:"
|
|
sshpass -p 'Gdk1983gdk45@' ssh -p 2222 -o StrictHostKeyChecking=no pi@192.168.1.134 'python3 << EOF
|
|
import sqlite3
|
|
conn = sqlite3.connect("/home/pi/gkachele-saas/database/main.db")
|
|
c = conn.cursor()
|
|
c.execute("SELECT name FROM sqlite_master WHERE type=\"table\"")
|
|
tables = [r[0] for r in c.fetchall()]
|
|
print("Tablas:", ", ".join(tables))
|
|
if "menus" in tables and "widgets" in tables:
|
|
print("✅ Tablas menus y widgets creadas")
|
|
else:
|
|
print("⚠️ Faltan tablas menus o widgets")
|
|
conn.close()
|
|
EOF'
|
|
|
|
echo ""
|
|
echo "4. Estado del servicio:"
|
|
sshpass -p 'Gdk1983gdk45@' ssh -p 2222 -o StrictHostKeyChecking=no pi@192.168.1.134 'sudo systemctl is-active gkachele-saas && echo "✅ Servicio activo" || echo "❌ Servicio inactivo"'
|