Ticket #9389: cutlisttrans.txt

 

def generateProjectXCutlist(chanid, starttime, folder):
    """generate cutlist_x.txt for ProjectX"""

    sqlstatement  = """SELECT mark FROM recordedmarkup 
                    WHERE chanid = '%s' AND starttime = '%s' 
                    AND type IN (0,1) ORDER BY mark""" % (chanid, starttime)

    db = getDatabaseConnection()
    cursor = db.cursor()
    cursor.execute(sqlstatement)
    result = cursor.fetchall()
    numrows = int(cursor.rowcount)

    #We must have at least one row returned for this recording
    if numrows==0:
        write("No cutlist in the DB for chanid %s, starttime %s" % chanid, starttime)
        db.close()
        del db
        del cursor
        return False   

    sqlstatement  = """SELECT mark FROM recordedmarkup 
                    WHERE chanid = '%s' AND starttime = '%s' 
                    AND type 1 ORDER BY mark LIMIT 1 """ % (chanid, starttime)

    cursor.execute(sqlstatement)
    firstcut = cursor.fetchall()   

    sqlstatement  = """SELECT mark FROM recordedmarkup 
                    WHERE chanid = '%s' AND starttime = '%s' 
                    AND type IN (0,1) ORDER BY mark LIMIT 1 """ % (chanid, starttime)

    cursor.execute(sqlstatement)
    firstedit = cursor.fetchall()

    cutlist_f=open(os.path.join(folder, "cutlist_x.txt"), 'w')
    cutlist_f.write("CollectionPanel.CutMode=2\n")

    if firstcut == firstedit:
         cutlist_f.write("0\n")

    # iterate through resultset
    for i in range(len(result)):
        if result[i][0] != "" and result[i][0] <> 0:
            cutlist_f.write("%d\n" % result[i])

    cutlist_f.close()

    return True