Mercurial > hg > ooxml

annotate sample2_1.sql @ 57:a783afa2b109

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
much richer annotatation as json-formatted comment
author Henry S. Thompson <ht@markup.co.uk>
date Wed, 31 May 2017 17:41:18 +0100
parents 05cf88c20cc5
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
55
05cf88c20cc5 sample I/O pair, with range annotations
Henry S. Thompson <ht@markup.co.uk>
parents:
diff changeset
1 CREATE TABLE sample2_1_raw
05cf88c20cc5 sample I/O pair, with range annotations
Henry S. Thompson <ht@markup.co.uk>
parents:
diff changeset
2 (
05cf88c20cc5 sample I/O pair, with range annotations
Henry S. Thompson <ht@markup.co.uk>
parents:
diff changeset
3 date date,
05cf88c20cc5 sample I/O pair, with range annotations
Henry S. Thompson <ht@markup.co.uk>
parents:
diff changeset
4 offered int,
05cf88c20cc5 sample I/O pair, with range annotations
Henry S. Thompson <ht@markup.co.uk>
parents:
diff changeset
5 batch int primary key,
05cf88c20cc5 sample I/O pair, with range annotations
Henry S. Thompson <ht@markup.co.uk>
parents:
diff changeset
6 completed int,
05cf88c20cc5 sample I/O pair, with range annotations
Henry S. Thompson <ht@markup.co.uk>
parents:
diff changeset
7 rejected int,
05cf88c20cc5 sample I/O pair, with range annotations
Henry S. Thompson <ht@markup.co.uk>
parents:
diff changeset
8 directory text,
05cf88c20cc5 sample I/O pair, with range annotations
Henry S. Thompson <ht@markup.co.uk>
parents:
diff changeset
9 AMT_label text
05cf88c20cc5 sample I/O pair, with range annotations
Henry S. Thompson <ht@markup.co.uk>
parents:
diff changeset
10 );
05cf88c20cc5 sample I/O pair, with range annotations
Henry S. Thompson <ht@markup.co.uk>
parents:
diff changeset
11
05cf88c20cc5 sample I/O pair, with range annotations
Henry S. Thompson <ht@markup.co.uk>
parents:
diff changeset
12 CREATE VIEW sample2_1
05cf88c20cc5 sample I/O pair, with range annotations
Henry S. Thompson <ht@markup.co.uk>
parents:
diff changeset
13 (date, offered,
05cf88c20cc5 sample I/O pair, with range annotations
Henry S. Thompson <ht@markup.co.uk>
parents:
diff changeset
14 target,
05cf88c20cc5 sample I/O pair, with range annotations
Henry S. Thompson <ht@markup.co.uk>
parents:
diff changeset
15 batch, completed, rejected,
05cf88c20cc5 sample I/O pair, with range annotations
Henry S. Thompson <ht@markup.co.uk>
parents:
diff changeset
16 reject_percent,
05cf88c20cc5 sample I/O pair, with range annotations
Henry S. Thompson <ht@markup.co.uk>
parents:
diff changeset
17 directory, AMT_label)
05cf88c20cc5 sample I/O pair, with range annotations
Henry S. Thompson <ht@markup.co.uk>
parents:
diff changeset
18 AS SELECT
05cf88c20cc5 sample I/O pair, with range annotations
Henry S. Thompson <ht@markup.co.uk>
parents:
diff changeset
19 date, offered,
05cf88c20cc5 sample I/O pair, with range annotations
Henry S. Thompson <ht@markup.co.uk>
parents:
diff changeset
20 offered-rejected,
05cf88c20cc5 sample I/O pair, with range annotations
Henry S. Thompson <ht@markup.co.uk>
parents:
diff changeset
21 batch, completed, rejected,
05cf88c20cc5 sample I/O pair, with range annotations
Henry S. Thompson <ht@markup.co.uk>
parents:
diff changeset
22 rejected/completed,
05cf88c20cc5 sample I/O pair, with range annotations
Henry S. Thompson <ht@markup.co.uk>
parents:
diff changeset
23 directory, AMT_label
05cf88c20cc5 sample I/O pair, with range annotations
Henry S. Thompson <ht@markup.co.uk>
parents:
diff changeset
24 FROM sample2_1_raw;
05cf88c20cc5 sample I/O pair, with range annotations
Henry S. Thompson <ht@markup.co.uk>
parents:
diff changeset
25
05cf88c20cc5 sample I/O pair, with range annotations
Henry S. Thompson <ht@markup.co.uk>
parents:
diff changeset
26 INSERT INTO sample2_1_raw VALUES
05cf88c20cc5 sample I/O pair, with range annotations
Henry S. Thompson <ht@markup.co.uk>
parents:
diff changeset
27 ('2010-04-02', 100, 6126, 12, NULL, 'ssq', '*Semantic Search Relevance 2'),
05cf88c20cc5 sample I/O pair, with range annotations
Henry S. Thompson <ht@markup.co.uk>
parents:
diff changeset
28 ('2010-04-09', 200, 6247, 17, 0, 'ssq', '*Semantic Search Relevance final'),
05cf88c20cc5 sample I/O pair, with range annotations
Henry S. Thompson <ht@markup.co.uk>
parents:
diff changeset
29 ('2010-04-09', 1, 6251, 1, NULL, 'ssq', '*submit test'),
05cf88c20cc5 sample I/O pair, with range annotations
Henry S. Thompson <ht@markup.co.uk>
parents:
diff changeset
30 ('2010-04-09', 1, 6252, 1, NULL, 'ssq', '*submit test'),
05cf88c20cc5 sample I/O pair, with range annotations
Henry S. Thompson <ht@markup.co.uk>
parents:
diff changeset
31 ('2010-04-09', 60, 6256, 24, 0, 'ssq', '*Semantic Search Relevance final'),
05cf88c20cc5 sample I/O pair, with range annotations
Henry S. Thompson <ht@markup.co.uk>
parents:
diff changeset
32 ('2010-04-12', 60, 6278, 0, NULL, 'ssq', '*Semantic Search Relevance final'),
05cf88c20cc5 sample I/O pair, with range annotations
Henry S. Thompson <ht@markup.co.uk>
parents:
diff changeset
33 ('2010-04-12', 86, 222547, 86, 26, 'ssq/upload3.csv', 'Semantic Search Relevance');