#!/bin/env python3
#
# Script to set the "status" for the run in RCDB  
# usage:   ./set_coda_run_status.py [RCDB password] [run number] [status]
# example: ./set_coda_run_status.py dummy_password 30730 0

import os,sys
import rcdb
from rcdb.model import ConditionType, Condition, Run


# entry point
if __name__ == "__main__":
    try:
        db = rcdb.RCDBProvider("mysql://rcdb:%s@gluondb1/rcdb2"%sys.argv[1])
        run = int(sys.argv[2])
        status_to_set = int(sys.argv[3])
        db.add_condition(run, "status", status_to_set, True)
    except  Exception as e:
        print("Exception occurred:", type(e).__name__, e)