Usint Flask Application

This repository contains the Python Flask application supporting the Usint Website.

For information related to the web server backend, support, and development of this application, consult the Flask/Usint folder in the MTA shared drive.

Structure

• usint / usint.py
  Python script for instantiating the Flask application. Navigating to this file in a web browser starts the application.

• config.py
  Configuration file.

• localhost
  A tcsh shell script used for quickly starting a localhost test of the application using the /data/mta4/CUS/ska3-cus-r2d2-v environment.

• instance/
  Instance folder for storing application-specific files such as logs and the usint.db database.

  • logs/
    Contains ocat.log files for logging application runtime information. Used by web server processes.

• cus_app/
  Main Flask application folder containing relevant page generation scripts:

  • __init__.py — Application instantiation script
  • emailing.py — Email-related functions for notifications
  • models.py — SQLAlchemy ORM models for interfacing with the Usint Revision database

  Submodules

  • chkupdata/ — Parameter check page scripts
  • errors/ — Error handler scripts
  • express/ — Express sign-off page scripts
  • ocatdatapage/ — Ocat data page scripts
  • orupdate/ — Parameter status page scripts
  • scheduler/ — TOO duty scheduler page scripts
  • supple/ — Supplemental Python scripts

  Static Files (static/)

  • color.json — Maps color names to RGB values
  • labels.json — Maps Ocat parameters to visual labels
  • parameter_selections.json — Parameter group mappings used across the application
  • usint.js — jQuery library for the Ocat data page
  • ocat_style.css — CSS styles
  • ocatdatapage/ — Static files for the Ocat data page
  • orupdate/ — Static files for the parameter status page
  • scheduler/ — Static files for the scheduler page

  Templates (templates/)

  • base.html — Base template
  • index.html — Main index page
  • Additional page-specific templates (see sections below)

---

chkupdata

Displays original, requested, and current parameter values for a given <obsid>.<rev>.

Files

• routes.py — Main logic
• forms.py — WTForms definitions
• __init__.py — Module setup

Templates

• index.html — Main page
• provide_obsidrev.html — Shown when <obsid>.<rev> is not found
• macros.html — Template macros

---

errors

Application error handling.

Files

• handlers.py — Main error handling logic
• __init__.py — Module setup

Templates

• 404.html — Not found page
• 500.html — Server error page

---

express

Express sign-off / approval workflow.

Files

• routes.py — Main logic
• forms.py — WTForms definitions
• __init__.py — Module setup

Templates

• index.html — Main page
• confirm.html — Confirmation page
• macros.html — Template macros

---

ocatdatapage

Ocat data page used for updating parameter values.

Files

• routes.py — Main logic
• forms.py — WTForms definitions
• format_ocat_data.py — Data formatting utilities
• __init__.py — Module setup

Additional Data

• <obs_ss>/mp_long_term — Planned roll angle from MP site
• <obs_ss>/scheduled_obs_list — Scheduled observations

Templates

• index.html — Main update page
• macros.html — Template macros
• confirm.html — Update confirmation page
• finalize.html — Job completion page
• provide_obsid.html — Shown when <obsid> is not found

---

orupdate

Target parameter status page.

Files

• routes.py — Main logic
• forms.py — WTForms definitions
• __init__.py — Module setup

Templates

• index.html — Main page
• macros.html — Template macros

Note:
This page refreshes every 3 minutes to display the latest data. This ensures consistency when multiple users are updating the database simultaneously.

---

rm_submission

Remove accidental submissions.

Files

• routes.py — Main logic
• forms.py — WTForms definitions
• __init__.py — Module setup

Templates

• index.html — Main page
• macros.html — Template macros

---

scheduler

POC duty sign-up sheet.

Files

• routes.py — Main logic
• forms.py — WTForms definitions
• __init__.py — Module setup

Templates

• index.html — Main page
• macros.html — Template macros

---

supple

Supplemental scripts used across the application.

Files

• database_interface.py — SQLAlchemy interface for the Usint Revision SQLite database
• helper_functions.py — General helper utilities
• read_ocat_data.py — Fetches and formats Ocat Sybase data via the ska_dbi SQSH interface

Data Sources

• CXC Ocat Sybase database (via read_ocat_data.py)
• Usint Revision SQLite database (via database_interface.py)