Module ephemeris_library.database

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