iframe-proxy | Sunbelt Computer Software

Repository navigation

History

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

import streamlit as st

from src.connections import ConnectionManager

# Page config - MUST be first Streamlit command

st.set_page_config(

page_title="Travel Recommender - System Check",

page_icon="🌍",

layout="wide",

initial_sidebar_state="collapsed" # Hide sidebar initially

)

# Initialize session state for authentication

if 'authenticated' not in st.session_state:

st.session_state.authenticated = False

if 'user' not in st.session_state:

st.session_state.user = None

if 'connection_status' not in st.session_state:

st.session_state.connection_status = {

'neo4j': None,

'snowflake': None

}

# Custom CSS

st.markdown("""

<style>

/* Hide default Streamlit elements */

#MainMenu {visibility: hidden;}

footer {visibility: hidden;}

/* Main container */

.main .block-container {

padding-top: 3rem;

max-width: 900px;

}

/* Header styling */

.app-header {

text-align: center;

padding: 2rem 0;

margin-bottom: 2rem;

}

.app-title {

font-size: 48px;

font-weight: 700;

background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);

-webkit-background-clip: text;

-webkit-text-fill-color: transparent;

margin-bottom: 0.5rem;

}

.app-subtitle {

font-size: 18px;

color: #6b7280;

margin-bottom: 1rem;

}

/* Connection status cards */

.status-container {

display: grid;

grid-template-columns: 1fr 1fr;

gap: 20px;

margin: 2rem 0;

}

.status-card {

background: white;

border: 2px solid #e5e7eb;

border-radius: 12px;

padding: 24px;

text-align: center;

transition: all 0.3s;

}

.status-card:hover {

box-shadow: 0 4px 12px rgba(0, 0, 0, 0.1);

transform: translateY(-2px);

}

.status-card.success {

border-color: #10b981;

background: #f0fdf4;

}

.status-card.error {

border-color: #ef4444;

background: #fef2f2;

}

.status-card.pending {

border-color: #f59e0b;

background: #fffbeb;

}

.status-icon {

font-size: 48px;

margin-bottom: 12px;

}

.status-title {

font-size: 20px;

font-weight: 600;

color: #111827;

margin-bottom: 8px;

}

.status-message {

font-size: 14px;

color: #6b7280;

}

/* Buttons */

.stButton > button {

width: 100%;

border-radius: 8px;

font-weight: 600;

padding: 12px 24px;

font-size: 16px;

transition: all 0.2s;

}

/* Info box */

.info-box {

background: #eff6ff;

border-left: 4px solid #3b82f6;

padding: 16px;

border-radius: 8px;

margin: 2rem 0;

}

.info-box h4 {

color: #1e40af;

margin-bottom: 8px;

}

.info-box ul {

margin: 0;

padding-left: 20px;

}

.info-box li {

color: #1e3a8a;

margin-bottom: 4px;

}

</style>

""", unsafe_allow_html=True)

# Header

st.markdown("""

<div class="app-title">🌍 AI Travel Companion</div>

<div class="app-subtitle">Intelligent travel recommendations powered by Knowledge Graphs</div>

</div>

""", unsafe_allow_html=True)

# Welcome message

st.markdown("""

<h4>Welcome to Travel Recommender System</h4>

<ul>

<li><strong>Explore</strong> destinations using our Neo4j Knowledge Graph</li>

<li><strong>Chat</strong> with AI to get personalized recommendations</li>

<li><strong>Plan</strong> your itinerary with data backed by Snowflake and Neo4j</li>

</ul>

</div>

""", unsafe_allow_html=True)

# System Status Section

st.markdown("### 🔌 System Status Check")

st.markdown("Verify that all required services are connected before proceeding.")

# Connection check button

col1, col2, col3 = st.columns([1, 2, 1])

with col2:

if st.button("🔍 Check Connections", type="primary", use_container_width=True):

with st.spinner("Checking connections..."):

# Test Neo4j

neo4j_driver = ConnectionManager.get_neo4j_driver()

if neo4j_driver:

try:

with neo4j_driver.session() as session:

result = session.run("RETURN 1 AS num")

result.single()

st.session_state.connection_status['neo4j'] = True

neo4j_driver.close()

except Exception as e:

st.session_state.connection_status['neo4j'] = False

else:

st.session_state.connection_status['neo4j'] = False

# Test Snowflake

snow_conn = ConnectionManager.get_snowflake_connection()

if snow_conn:

try:

cur = snow_conn.cursor()

cur.execute("SELECT CURRENT_VERSION()")

cur.fetchone()

st.session_state.connection_status['snowflake'] = True

cur.close()

except Exception as e:

st.session_state.connection_status['snowflake'] = False

else:

st.session_state.connection_status['snowflake'] = False

# Display connection status

if st.session_state.connection_status['neo4j'] is not None:

st.markdown("---")

col1, col2 = st.columns(2)

with col1:

neo4j_status = st.session_state.connection_status['neo4j']

status_class = "success" if neo4j_status else "error"

icon = "✅" if neo4j_status else "❌"

message = "Connected successfully" if neo4j_status else "Connection failed"

st.markdown(f"""

<div class="status-title">Neo4j Database</div>

<div class="status-message">{message}</div>

</div>

""", unsafe_allow_html=True)

with col2:

snowflake_status = st.session_state.connection_status['snowflake']

status_class = "success" if snowflake_status else "error"

icon = "✅" if snowflake_status else "❌"

message = "Connected successfully" if snowflake_status else "Connection failed"

st.markdown(f"""

<div class="status-title">Snowflake Warehouse</div>

<div class="status-message">{message}</div>

</div>

""", unsafe_allow_html=True)

# Show detailed status

if neo4j_status and snowflake_status:

st.success("🎉 All systems operational! You can proceed to login.")

elif not snowflake_status:

st.error("⚠️ Snowflake connection is required for authentication. Please check your configuration.")

elif not neo4j_status:

st.warning("⚠️ Neo4j connection failed. Some features may be limited, but you can still login.")

# Login button (always available)

st.markdown("---")

st.markdown("### 🚀 Ready to Start?")

col1, col2, col3 = st.columns([1, 2, 1])

with col2:

if st.button("🔐 Login to System", type="primary", use_container_width=True):

# Navigate to landing page

st.switch_page("pages/8_🔐_Login.py")

# Footer info

st.markdown("---")

st.markdown("""

<p>💡 <strong>First time here?</strong> Check connections first, then login to access all features.</p>

<p style="font-size: 12px; margin-top: 8px;">Travel Recommender v1.0 | Powered by Neo4j & Snowflake</p>

</div>

""", unsafe_allow_html=True)

Sunbelt Computer Software

PL/B Language Development and Support

Navigation Menu

Repository navigation

app.py

app.py

Sunbelt Computer Software

PL/B Language Development and Support

FilesExpand file tree

app.py

Latest commit

History

app.py

File metadata and controls