1e56357baee99a5fa02d54df0db476c58258ffbf,plantcv-pipeline.py,,db_connect,#Any#,368

Before Change

    if not args.create:
        // Get the last run ID
        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"]

After Change

    // Delete the existing database if create is true
    if args.create:
        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
        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()
        // Run and image IDs
        args.run_id = 0
        args.image_id = 0

    return args


//////////////////////////////////////////////////////////////////////////////////////

Instances