25bdfd7ca876bf714309c84648317b4a3f7227ce,plantcv-pipeline.py,,db_connect,#Any#,370

Before Change

        if os.path.isfile(args.db):
            os.remove(args.db)

    if os.path.isfile(args.db):
        args.connect = sqlite3.connect(args.db)
        // Replace the row_factory result constructor with a dictionary constructor
        args.connect.row_factory = dict_factory
        // Change the text output format from unicode to UTF-8
        args.connect.text_factory = str
        // Database handler
        args.sq = args.connect.cursor()

        for row in args.sq.execute("SELECT MAX(run_id) AS max FROM runinfo"):
            if row["max"] is not None:
                args.run_id = row["max"]

        // Get the last run ID
        for row in args.sq.execute("SELECT MAX(image_id) AS max FROM metadata"):
            if row["max"] is not None:
                args.image_id = row["max"]

    if os.path.isfile(args.db) == False:
        // Connect to the database
        args.connect = sqlite3.connect(args.db)
        // Replace the row_factory result constructor with a dictionary constructor

After Change

    // then we have data in the database and can increment run_id and image_id
    runinfo = False
    metadata = False
    for row in args.sq.execute("SELECT name FROM sqlite_master WHERE type="table""):
        if row["name"] == "runinfo":
            runinfo = True
        elif row["name"] == "metadata":
            metadata = True

    if runinfo is True and metadata is True:
        for row in args.sq.execute("SELECT MAX(run_id) AS max FROM runinfo"):
            if row["max"] is not None:
                args.run_id = row["max"]

Instances