Pathena and co

• Panda Tools https://twiki.cern.ch/twiki/bin/view/Atlas/PandaTools
  • Pathena https://twiki.cern.ch/twiki/bin/view/Atlas/PandaAthena
  • Prun https://twiki.cern.ch/twiki/bin/view/Atlas/PandaRun
  • Psequencer https://twiki.cern.ch/twiki/bin/view/Atlas/PandaSequencer
  • Pbook https://twiki.cern.ch/twiki/bin/view/Atlas/PandaBook

Pbook/Pathena job DB

    def createTable(self):
        # ver 0_1_1
        sql  = "CREATE TABLE %s (" % self.tablename
        sql += "'id'             INTEGER PRIMARY KEY,"
        sql += "'JobID'          INTEGER,"
        sql += "'PandaID'        TEXT,"
        sql += "'jobStatus'      TEXT,"
        sql += "'site'           VARCHAR(128),"
        sql += "'cloud'          VARCHAR(20),"
        sql += "'jobType'        VARCHAR(20),"
        sql += "'jobName'        VARCHAR(128),"
        sql += "'inDS'           TEXT,"
        sql += "'outDS'          TEXT,"
        sql += "'libDS'          VARCHAR(255),"
        sql += "'jobParams'      TEXT,"
        sql += "'retryID'        INTEGER,"        
        sql += "'provenanceID'   INTEGER,"
        sql += "'creationTime'   TIMESTAMP,"
        sql += "'lastUpdate'     TIMESTAMP,"
        sql += "'dbStatus'       VARCHAR(20),"
        sql += "'buildStatus'    VARCHAR(20),"
        sql += "'commandToPilot' VARCHAR(20),"        
        sql = sql[:-1]
        sql += ")"
        # execute