addCamera.py 文件源码

def update_camera_id(db):
    print '---------------------------------------------------------------------------------'
    print "STEP 6 : update camera IDs in info_source, camera table"
    cursor= db.cursor()
    sql = "UPDATE info_source, camera SET camera_id = id WHERE camera_key = snapshot_url"
    print sql
    print '---------------------------------------------------------------------------------'
    isSuccess =True
    try:
        print "Updating IDs.."
        cursor.execute(sql)
        num_record = cursor.rowcount
        print "%d row affected"%(int(num_record))
    except MySQLdb.Error, e:
        print "MySQL Error [%d]: %s" % (e.args[0], e.args[1])
        isSuccess = False
    except MySQLdb.Warning,e:
        print "MYSQL Warning : %s"%e
        isSuccess = False

    return isSuccess