File size: 687 Bytes
d323d4b
 
 
 
 
 
 
 
 
 
 
 
9b97a5a
ef81816
 
 
d323d4b
ef81816
d323d4b
ef81816
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
import streamlit as st
import pymongo
import os

@st.cache_resource
def init_conn():
         # Try to get from environment variable first, fall back to secrets
        uri = os.getenv('MONGO_URI')
        if not uri:
            uri = st.secrets['mongo_uri']
        client = pymongo.MongoClient(uri, retryWrites=True, serverSelectionTimeoutMS=500000)
        nfl_db = client["NFL_Database"]
        salaries_db = client['Contest_Information']
        nba_db = client["NBA_Database"]
        mlb_db = client["MLB_Database"]
        nhl_db = client["NHL_Database"]

        return nfl_db, salaries_db, nba_db, mlb_db, nhl_db
    
nfl_db, salaries_db, nba_db, mlb_db, nhl_db = init_conn()