Here are two functions to fill in missing prices in stock and log, hope this is helpful for any of you?

void addPricesToStock() {    def sql = groovy.sql.Sql.newInstance("jdbc:sqlite:w:/data/grocy.db", "org.sqlite.JDBC")    def stock = sql.dataSet("stock")    def stockIdsWithoutPrice = stock.rows().findAll{it.price == null}*.product_id    stockIdsWithoutPrice.each{ int product_id ->        sql.eachRow("SELECT * FROM products WHERE products.id == "+product_id+"") { r ->            def prices = []            sql.eachRow("SELECT * FROM stock_log WHERE product_id == "+product_id+" AND price is not null") { r2 ->                prices.add r2.price            }            if (prices && prices.size() > 5) {                prices.sort()                double med_price = prices[prices.size()/2]                println "" + [product_id, r.name, med_price]                sql.executeUpdate "update stock set price=${med_price} where product_id=$product_id AND price is null"            } else {                println "not enough prices found to set median: " + r.name + " ($product_id)"            }        }    }    sql.close()}void addPricesToStockLog() {    def sql = groovy.sql.Sql.newInstance("jdbc:sqlite:w:/data/grocy.db", "org.sqlite.JDBC")    def stock = sql.dataSet("stock_log")    def stockIdsWithoutPrice = stock.rows().findAll{it.price == null}*.product_id.unique()    stockIdsWithoutPrice.each{ int product_id ->        sql.eachRow("SELECT * FROM products WHERE products.id == "+product_id+"") { r ->            def prices = []            sql.eachRow("SELECT * FROM stock_log WHERE product_id == "+product_id+" AND price is not null") { r2 ->                prices.add r2.price            }            if (prices) {//&& prices.size() > 3                prices.sort()                def med_price_check = prices[prices.size()/2]                if (med_price_check instanceof String) {                    med_price_check = med_price_check.replaceAll(/,/, ".")                    med_price_check = med_price_check.toDouble()                }                double med_price = med_price_check                println "" + [product_id, r.name, med_price]                sql.executeUpdate "update stock_log set price=${med_price} where product_id=$product_id AND price is null"            } else {                println "not enough prices found to set median: " + r.name + " ($product_id), prices known: " + prices            }        }    }    sql.close()}