Published
Edited
Jul 11, 2021
Importers
function diff (a,b,path='') {
if (path != '') {
for (const p of path.split('.')) {
a = a[p]
b = b[p]
}
}
if (_.isEqual(a,b)) return md`${path} is equal in both states !`
const akeys = _.keys(a)
const bkeys = _.keys(b)
const changed_values = [] // in arrays
const changed_row_count = []
const changed = []
const equalKeys = _.intersection(akeys,bkeys)
const deleted = _.difference(akeys,bkeys)
const added = _.difference(bkeys,akeys)
let candidates = equalKeys.filter(key => !_.isEqual(a[key],b[key]))
for (const key of candidates) {
if (Array.isArray(a[key]) && Array.isArray(b[key])) {
const arra = a[key]
const arrb = b[key]
if (arra.length == arrb.length) { // samma längd
const n = arra.length
for (const i in _.range(n)) {
if (arra[i] != arrb[i] && changed_values.length<5) {
changed_values.push([key,i,arra[i],arrb[i]])
//changed_values = changed_values.concat(diff(arra[i],arrb[i]))
}
}
} else { // olika längd
changed_row_count.push(key)
}
} else {
changed.push(key)
}
}
const result = {DIFF:path}
deleted.forEach(key => result['DEL ' + key] = a[key])
added.forEach(key => result['ADD ' + key] = b[key])
changed.forEach(key => result['CHG ' + key] = diff2(a[key],b[key]))
changed_row_count.forEach(key => result['ROW count changed for ' + key] = {old:a[key],new:b[key]})
for (const [key,i,a,b] of changed_values) result['CELL changed for ' + key + ' at index ' + i] = {old:a,new:b}
return result
}
diff2 = (a,b) => {
const akeys = _.keys(a)
const bkeys = _.keys(b)
//console.log('diff2',akeys,bkeys)
const equalKeys = _.intersection(akeys,bkeys)
const deleted = _.difference(akeys,bkeys)
const added = _.difference(bkeys,akeys)
let changed = equalKeys.filter(key => !_.isEqual(a[key],b[key]))
let changed_row_count = []
if (typeof a == 'Object' && typeof b == 'Object') {
changed_row_count = equalKeys.filter(key => !_.isEqual(a[key].length,b[key].length))
}
changed = _.difference(changed,changed_row_count)
const result = {}
deleted.forEach(key => result['DEL ' + key] = a[key])
added.forEach(key => result['ADD ' + key] = b[key])
changed.forEach(key => result['CHG ' + key] = {old:a[key],new:b[key]})
changed_row_count.forEach(key => result['ROW count changed for ' + key] = {old:a[key],new:b[key]})
return result
}
dropCols = (cols,df) => {
cols.forEach(col => df = Z.dropCol(col,df))
return df
}
Immer = require("immer")
original = Immer.original
produce = Immer.produce
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
