Diff and patch tables
Want to see pretty graphs? Log in now!
npm install coopyhx
|42||downloads in the last month|
|Last Published By|
|Version||1.0.0 last updated 3 months ago|
|Keywords||table, diff, patch|
For a live demo, see:
Get the core library here:
Or with node:
npm install coopyhx
The diff format used by coopyhx is specified here:
This library is a stripped down version of the coopy toolbox (see http://share.find.coop). To compare tables from different origins, or with automatically generated IDs, or other complications, check out the coopy toolbox.
There is a commandline utility wrapping the core functions of the library:
$ coopyhx The coopyhx utility can produce and apply tabular diffs. Call coopyhx as: coopyhx diff [--output OUTPUT.csv] a.csv b.csv coopyhx diff [--output OUTPUT.csv] parent.csv a.csv b.csv coopyhx diff [--output OUTPUT.jsonbook] a.jsonbook b.jsonbook coopyhx patch [--output OUTPUT.csv] source.csv patch.csv coopyhx trim [--output OUTPUT.csv] source.csv coopyhx render [--output OUTPUT.html] diff.csv If you need more control, here is the full list of flags: coopyhx diff [--output OUTPUT.csv] [--context NUM] [--all] [--act ACT] a.csv b.csv --context NUM: show NUM rows of context --all: do not prune unchanged rows --act ACT: show only a certain kind of change (update, insert, delete) coopyhx render [--output OUTPUT.html] [--css CSS.css] [--fragment] [--plain] diff.csv --css CSS.css: generate a suitable css file to go with the html --fragment: generate just a html fragment rather than a page --plain: do not use fancy utf8 characters to make arrows prettier
coopyhx.js on a webpage:
Or with nodejs:
var coopy = require('coopyhx');
For concreteness, assume we have two versions of a table,
var data1 = [ ['Country','Capital'], ['Ireland','Dublin'], ['France','Paris'], ['Spain','Barcelona'] ]; var data2 = [ ['Country','Code','Capital'], ['Ireland','ie','Dublin'], ['France','fr','Paris'], ['Spain','es','Madrid'], ['Germany','de','Berlin'] ];
To make those tables accessible to the library, we wrap them
var table1 = new coopy.CoopyTableView(data1); var table2 = new coopy.CoopyTableView(data2);
We can now compute the alignment between the rows and columns in the two tables:
var alignment = coopy.compareTables(table1,table2).align();
To produce a diff from the alignment, we first need a table for the output:
var data_diff = ; var table_diff = new coopy.CoopyTableView(data_diff);
Using default options for the diff:
var flags = new coopy.CompareFlags(); var highlighter = new coopy.TableDiff(alignment,flags); highlighter.hilite(table_diff);
The diff is now in
data_diff in highlighter format, see
[ [ '!', '', '+++', '' ], [ '@@', 'Country', 'Code', 'Capital' ], [ '+', 'Ireland', 'ie', 'Dublin' ], [ '+', 'France', 'fr', 'Paris' ], [ '->', 'Spain', 'es', 'Barcelona->Madrid' ], [ '+++', 'Germany', 'de', 'Berlin' ] ]
For visualization, you may want to convert this to a HTML table with appropriate classes on cells so you can color-code inserts, deletes, updates, etc. You can do this with:
var diff2html = new coopy.DiffRender(); diff2html.render(table_diff); var table_diff_html = diff2html.html();
For 3-way differences (that is, comparing two tables given knowledge
of a common ancestor) use
coopy.compareTables3 (give ancestor
table as the first argument).
Here is how to apply that difference as a patch:
var patcher = new coopy.HighlightPatch(table1,table_diff); patcher.apply(); // table1 should now equal table2
coopyhx library is written in Haxe, which
can be translated reasonably well into at least the following languages:
make js make php make java make cs make cpp
- http://dataprotocols.org/tabular-diff-format/ : a specification of the diff format coopyhx uses.
- http://theodi.org/blog/adapting-git-simple-data : discusses using coopyhx with gitlab.
- http://okfnlabs.org/blog/2013/08/08/diffing-and-patching-data.html : a summary of where coopyhx came from.
- http://blog.okfn.org/2013/07/02/git-and-github-for-data/ : a post about storing small data in git/github.
- http://blog.ouseful.info/2013/08/27/diff-or-chop-github-csv-data-files-and-openrefine/ : counterpoint - a post discussing tracked-changes rather than diffs.
Coopyhx is distributed under the MIT License.