Expand source code
import mysql.connector
from mysql.connector import MySQLConnection
import sys
DATABASE_HOST = 'cassiope-ephemeris.phys.ucalgary.ca'
DATABASE_PORT = 3306
DATABASE_NAME = 'cassiope_ephemeris'
DATABASE_USER = 'ephemeris_user'
DATABASE_PASSWORD = 'nokxw2'
def _connect_to_database() -> MySQLConnection:
'''
Connect to CASSIOPE Ephemeris Database
'''
try:
connection = mysql.connector.connect(user=DATABASE_USER,
password=DATABASE_PASSWORD,
host=DATABASE_HOST,
port=DATABASE_PORT,
database=DATABASE_NAME,
use_pure=True)
except mysql.connector.Error as err:
print("Error: Could not connect to cassiope_ephemeris database.", file=sys.stderr)
return connection