Mercurial > hg > ooxml
changeset 55:05cf88c20cc5
sample I/O pair, with range annotations
| author | Henry S. Thompson <ht@markup.co.uk> |
|---|---|
| date | Tue, 30 May 2017 09:52:49 +0100 |
| parents | 191c95187e87 |
| children | 6f62777aaecf |
| files | notes.txt sample2_1.sql sample2y.xlsx |
| diffstat | 3 files changed, 70 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- a/notes.txt Tue May 16 19:54:19 2017 +0100 +++ b/notes.txt Tue May 30 09:52:49 2017 +0100 @@ -1,3 +1,4 @@ + Tokenisation patterns, derived from parse.py, derived from https://sites.google.com/site/e90e50/random-topics/tool-for-parsing-formulas-in-excel and @@ -240,3 +241,39 @@ We could _either_ add a class of operators, or a class of numbers? +============== +Python : sys.version_info(major=2, minor=7, micro=13, releaselevel='final', serial=0) +lxml.etree : (3, 6, 4, 0) +libxml used : (2, 9, 2) +libxml compiled : (2, 9, 2) +libxslt used : (1, 1, 29) +libxslt compiled : (1, 1, 29) + +testa works +---------- +Python : sys.version_info(major=2, minor=7, micro=13, releaselevel='final', serial=0) +lxml.etree : (3, 7, 3, 0) +libxml used : (2, 9, 2) +libxml compiled : (2, 9, 2) +libxslt used : (1, 1, 29) +libxslt compiled : (1, 1, 29) + +testa works +--------- +Python : sys.version_info(major=2, minor=7, micro=13, releaselevel='final', serial=0) +lxml.etree : (3, 7, 3, 0) +libxml used : (2, 9, 4) +libxml compiled : (2, 9, 4) +libxslt used : (1, 1, 29) +libxslt compiled : (1, 1, 29) + +testa fails +----------- +Python : sys.version_info(major=2, minor=7, micro=13, releaselevel='final', serial=0) +lxml.etree : (3, 7, 3, 0) +libxml used : (2, 9, 3) +libxml compiled : (2, 9, 3) +libxslt used : (1, 1, 29) +libxslt compiled : (1, 1, 29) + +testa works
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/sample2_1.sql Tue May 30 09:52:49 2017 +0100 @@ -0,0 +1,33 @@ +CREATE TABLE sample2_1_raw +( + date date, + offered int, + batch int primary key, + completed int, + rejected int, + directory text, + AMT_label text +); + +CREATE VIEW sample2_1 +(date, offered, + target, + batch, completed, rejected, + reject_percent, + directory, AMT_label) + AS SELECT + date, offered, + offered-rejected, + batch, completed, rejected, + rejected/completed, + directory, AMT_label + FROM sample2_1_raw; + +INSERT INTO sample2_1_raw VALUES +('2010-04-02', 100, 6126, 12, NULL, 'ssq', '*Semantic Search Relevance 2'), +('2010-04-09', 200, 6247, 17, 0, 'ssq', '*Semantic Search Relevance final'), +('2010-04-09', 1, 6251, 1, NULL, 'ssq', '*submit test'), +('2010-04-09', 1, 6252, 1, NULL, 'ssq', '*submit test'), +('2010-04-09', 60, 6256, 24, 0, 'ssq', '*Semantic Search Relevance final'), +('2010-04-12', 60, 6278, 0, NULL, 'ssq', '*Semantic Search Relevance final'), +('2010-04-12', 86, 222547, 86, 26, 'ssq/upload3.csv', 'Semantic Search Relevance');