CREATE TABLE `test_gazette` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `grower_id` bigint(20) DEFAULT NULL,
  `crop_day` bigint(20) DEFAULT NULL,
  `uuid` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQUE` (`uuid`)
) ENGINE=InnoDB AUTO_INCREMENT=6601 DEFAULT CHARSET=utf8

----------------------------------------
    def generateGazetteWithNewAlgorithmeImplementation(){

        // Get Grower list of this UNIT
        Mill mill = Mill.findById(18); //Mill.findById(18);
        Unit unit = Unit.findById(1112); // Unit.findById(1112);
        List<Grower> growers = Grower.findAllByMillAndUnit(mill, unit);

        def sql = new Sql(dataSource)

        //Create Config Object
        Config config = new Config(55, 6, 2, 5, 5, 15,
                20, 7, 10, 12, 18);

        GazetteGenerator gazetteGenerator = new GazetteGenerator(unit.id, unit.name, getAlgorithmSensitiveGrowerList(unit.name, growers), config)
        long[][] cropdayWiseGrowersList = gazetteGenerator.getGazetteAsGrowerIdArray();

        String sqlString ="insert into test_gazette(grower_id, crop_day, uuid) ";

        StringBuilder stringBuilder = new StringBuilder(sqlString);

        for(int i=0; i<cropdayWiseGrowersList.length; i++) {
//                System.out.println("Crop day--" + (i + 1));
            long[] a = cropdayWiseGrowersList[i];
            for (int j = 0; j < a.length; j++) {
               stringBuilder.append("values(");
                stringBuilder.append(cropdayWiseGrowersList[i][j]);
                stringBuilder.append(",");
                stringBuilder.append(i);
                stringBuilder.append(",");
                stringBuilder.append("UUID()");
                stringBuilder.append(")");
                if(j != a.length - 1){
                    stringBuilder.append(",")
                }
            }
        }

        System.out.println(stringBuilder);

        sql.execute(stringBuilder.toString());
        /*def updateCounts = sql.withBatch('insert into test_gazette(grower_id, crop_day, uuid) values (?, ?, UUID())') { ps ->

            for(int i=0; i<cropdayWiseGrowersList.length; i++) {
//                System.out.println("Crop day--" + (i + 1));
                long[] a = cropdayWiseGrowersList[i];
                for (int j = 0; j < a.length; j++) {
                    ps.addBatch([cropdayWiseGrowersList[i][j], i]);
                }
            }
        }*/



        for(int i=0; i<cropdayWiseGrowersList.length; i++) {
            System.out.println("Crop day-- "+ (i));
            long[] a = cropdayWiseGrowersList[i];
            for(int j=0; j<a.length; j++) {
                System.out.print(cropdayWiseGrowersList[i][j] + "\t");
            }
            System.out.println("");
        }


    }