eOrbitor_Pulse/run.sh at main · balahero03/eOrbitor_Pulse · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
#!/bin/bash

# eOrbitor Pulse - One-Click Project Runner

set -e

RED='\033[0;31m'
GREEN='\033[0;32m'
YELLOW='\033[1;33m'
BLUE='\033[0;34m'
CYAN='\033[0;36m'
NC='\033[0m'

DB_URL='postgresql://eorbitor:YourStrongDatabasePassword123!@localhost:5432/eorbitor_pulse'
PROJECT_DIR="$(cd "$(dirname "${BASH_SOURCE[0]}")" && pwd)"

ok()   { echo -e "${GREEN}[OK]${NC} $1"; }
step() { echo -e "${BLUE}[..] $1${NC}"; }
warn() { echo -e "${YELLOW}[!!]${NC} $1"; }
fail() { echo -e "${RED}[ERR]${NC} $1"; exit 1; }

echo -e "${CYAN}"
echo "  eOrbitor Pulse CRM - Startup"
echo "======================================"
echo -e "${NC}"

cd "$PROJECT_DIR"

# Prerequisites
step "Checking Node.js..."
command -v node &>/dev/null || fail "Node.js not installed. Run: sudo apt install nodejs"
ok "Node.js $(node -v)"

step "Checking PostgreSQL..."
command -v psql &>/dev/null || fail "PostgreSQL not installed. Run: sudo apt install postgresql"
ok "PostgreSQL installed"

# Start PostgreSQL
step "Starting PostgreSQL service..."
sudo systemctl is-active --quiet postgresql || sudo systemctl start postgresql
ok "PostgreSQL running"

# Database setup
step "Checking database connection..."
if ! PGPASSWORD='YourStrongDatabasePassword123!' psql -U eorbitor -h localhost -d eorbitor_pulse -c "SELECT 1;" &>/dev/null; then
    warn "Database not found. Setting up..."
    sudo -u postgres psql -c "CREATE USER eorbitor WITH PASSWORD 'YourStrongDatabasePassword123!';" 2>/dev/null || true
    sudo -u postgres psql -c "CREATE DATABASE eorbitor_pulse OWNER eorbitor;" 2>/dev/null || true
    sudo -u postgres psql -c "GRANT ALL PRIVILEGES ON DATABASE eorbitor_pulse TO eorbitor;" 2>/dev/null || true
    PGPASSWORD='YourStrongDatabasePassword123!' psql -U eorbitor -h localhost -d eorbitor_pulse -c "SELECT 1;" &>/dev/null || fail "Database setup failed"
fi
ok "Database connection OK"

# .env.local
step "Checking environment config..."
[ -f ".env.local" ] || cp .env.local.example .env.local
ok ".env.local ready"

# Dependencies
step "Checking dependencies..."
if [ ! -d "node_modules" ]; then
    step "Installing npm packages..."
    npm install
fi
ok "Dependencies ready"

# Prisma
step "Generating Prisma client..."
DATABASE_URL="$DB_URL" npm run prisma:generate --silent
ok "Prisma client generated"

step "Syncing database schema..."
DATABASE_URL="$DB_URL" npm run db:push --silent
ok "Schema synced"

# Seed if empty
USER_COUNT=$(PGPASSWORD='YourStrongDatabasePassword123!' psql -U eorbitor -h localhost -d eorbitor_pulse -tAc 'SELECT COUNT(*) FROM "User";' 2>/dev/null || echo "0")
if [ "$USER_COUNT" = "0" ]; then
    step "Seeding database..."
    DATABASE_URL="$DB_URL" npm run db:seed
    ok "Database seeded"
else
    ok "Database has data ($USER_COUNT users)"
fi

# Free port 3000
if lsof -ti:3000 &>/dev/null; then
    warn "Port 3000 in use, freeing it..."
    lsof -ti:3000 | xargs kill -9 2>/dev/null || true
    sleep 1
fi

echo ""
echo -e "${GREEN}======================================"
echo "  Ready! Starting eOrbitor Pulse..."
echo "======================================"
echo -e "${NC}"
echo -e "  URL:      ${CYAN}http://localhost:3000${NC}"
echo -e "  Login:    admin@company.local"
echo -e "  Password: password"
echo ""
echo -e "${YELLOW}  Press Ctrl+C to stop${NC}"
echo ""

DATABASE_URL="$DB_URL" npm run dev