# HG changeset patch
# User Henry S. Thompson <ht@markup.co.uk>
# Date 1496134369 -3600
# Node ID 05cf88c20cc59387460a38925a4933f967db668e
# Parent  191c95187e87864e9706d0fd256a17d91e284956
sample I/O pair, with range annotations

diff -r 191c95187e87 -r 05cf88c20cc5 notes.txt
--- 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
diff -r 191c95187e87 -r 05cf88c20cc5 sample2_1.sql
--- /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');
diff -r 191c95187e87 -r 05cf88c20cc5 sample2y.xlsx
Binary file sample2y.xlsx has changed