Overview
| Artifact ID: | d4461fc3fa24cea71e455a8211ce0afd1c90679e |
|---|---|
| Page Name: | Refdb |
| Date: | 2015-10-05 03:18:33 |
| Original User: | matt |
| Parent: | 5908d7d42bdcd7df8c5e6479fc89f876ba3b198e (diff) |
| Next | f5e59b53e2e1790fdfc66c323140bf3d40ee2d43 |
Content
RefDB
(note: this website is a fossil scm repository, learn more at fossil-scm.org)
... is a tool for storing a three level deep hierarchical key store in flat text files while being able to edit the data with a spreadsheet. The flat files generated by refdb are quite resistant to conflicts on branch and merge in source control tools such as Fossil or Git.
Motive
Storing configuration data, test control data and so forth can be very convenient in a spreadsheet but spreadsheets cannot be easily modified in parallel and branched and merged in tools like fossil or git.
Information
Installation
- Install chicken scheme from: www.call-cc.org
- Install the refdb egg: chicken-install refdb
Data format
Files with extension .dat contain the data for each sheet.
[column header] rowlabel value
Run refdb for quick help
Run refdb from the commandline to get quick help:> refdb Usage: refdb action params ... Note: refdbdir is a path to the directory containg sheet-names.cfg import filename.gnumeric refdbdir : Import a gnumeric file into a txt db directory export refdbdir filename.gnumeric : Export a refdb to a gnumeric file edit refdbdir : Edit a refdbdir using gnumeric. ls refdbdir : List the keys for specified level lookup refdbdir sheetname row col : Look up a value in the text db getrownames refdbdir sheetname : Get a list of row titles getcolnames refdbdir sheetname : Get a list of column titles getrow refdbdir sheetname rowname : Get the column-value pairs for given row getcol refdbdir sheetname colname : Get the row-value pairs for given column dump2sqlite3 refdbdir fname.db : dump refdb to sqlite3 dump2csv refdbdir sheetname [csvfile] : dump refdb sheet to csv set refdbdir sheetname row col val : set value To export to other formats; first export to gnumeric then use ssconvert. e.g. refdb export mydata mydata.gnumeric ssconvert -T Gnumeric_html:html40 mydata.gnumeric mydata.html Part of the Megatest tool suite. Learn more at http://www.kiatoa.com/fossils/megatest Version: 1.03