23385248069

Committed 21 Mar 2026 05:50PM UTC coverage: 73.202% (-2.5%) from 75.69%

Build # 23385248069

Build Type

push

github

Committed by

RustyBower

Commit Message

Fix test to match DB fallback behavior for missing output files

The endpoint now returns check.output from DB (200) instead of 404
when the on-disk file doesn't exist.

Coverage Stats

3726 of 5090 relevant lines covered (73.2%)

0.73 hits per line

Source File
Press 'n' to go to next uncovered line, 'b' for previous

21.43

/scoring_engine/db.py

from flask_sqlalchemy import SQLAlchemy
from sqlalchemy.exc import OperationalError, ProgrammingError

# Initialize Flask-SQLAlchemy
# This will be configured by the Flask app
db = SQLAlchemy()


def delete_db():
    """Drop all database tables"""
    dialect = db.engine.dialect.name
    with db.engine.connect() as conn:
        if dialect == "mysql":
            conn.execute(db.text("SET FOREIGN_KEY_CHECKS = 0"))
        elif dialect == "sqlite":
            conn.execute(db.text("PRAGMA foreign_keys = OFF"))
        conn.commit()
    db.drop_all()
    with db.engine.connect() as conn:
        if dialect == "mysql":
            conn.execute(db.text("SET FOREIGN_KEY_CHECKS = 1"))
        elif dialect == "sqlite":
            conn.execute(db.text("PRAGMA foreign_keys = ON"))
        conn.commit()


def init_db():
    """Create all database tables"""
    db.create_all()


def verify_db_ready():
    """Verify the database is ready and accessible"""
    ready = True
    try:
        from scoring_engine.models.user import User

        db.session.get(User, 1)
    except (OperationalError, ProgrammingError):
        ready = False
    return ready

1	from flask_sqlalchemy import SQLAlchemy	1✔
2	from sqlalchemy.exc import OperationalError, ProgrammingError	1✔
3
4	# Initialize Flask-SQLAlchemy
5	# This will be configured by the Flask app
6	db = SQLAlchemy()	1✔
7
8
9	def delete_db():	1✔
10	"""Drop all database tables"""
11	dialect = db.engine.dialect.name	×
12	with db.engine.connect() as conn:	×
13	if dialect == "mysql":	×
14	conn.execute(db.text("SET FOREIGN_KEY_CHECKS = 0"))	×
15	elif dialect == "sqlite":	×
16	conn.execute(db.text("PRAGMA foreign_keys = OFF"))	×
17	conn.commit()	×
18	db.drop_all()	×
19	with db.engine.connect() as conn:	×
20	if dialect == "mysql":	×
21	conn.execute(db.text("SET FOREIGN_KEY_CHECKS = 1"))	×
22	elif dialect == "sqlite":	×
23	conn.execute(db.text("PRAGMA foreign_keys = ON"))	×
24	conn.commit()	×
25
26
27	def init_db():	1✔
28	"""Create all database tables"""
29	db.create_all()	×
30
31
32	def verify_db_ready():	1✔
33	"""Verify the database is ready and accessible"""
34	ready = True	×
35	try:	×
36	from scoring_engine.models.user import User	×
37
38	db.session.get(User, 1)	×
39	except (OperationalError, ProgrammingError):	×
40	ready = False	×
41	return ready	×

scoringengine / scoringengine / 23385248069

Source File Press 'n' to go to next uncovered line, 'b' for previous

Source File
Press 'n' to go to next uncovered line, 'b' for previous