X-Git-Url: http://www.average.org/gitweb/?p=pulsecounter.git;a=blobdiff_plain;f=test.sql;fp=test.sql;h=f4e929ec96bf917fd09937698b9721b7cf31fc6f;hp=0000000000000000000000000000000000000000;hb=5faa8ead391b2fc6c07a10ca1bbeea1b6690f8d8;hpb=0afe015d8ca980e92c5c13baf4aebab5f3ca8c82

diff --git a/test.sql b/test.sql
new file mode 100644
index 0000000..f4e929e
--- /dev/null
+++ b/test.sql
@@ -0,0 +1,21 @@
+drop table if exists adjustment;
+drop table if exists counter;
+create table adjustment (timestamp datetime, value int);
+create table counter    (timestamp datetime, value int);
+
+insert into adjustment values ('2016-01-07 00:00:00', 10);
+insert into counter    values ('2016-01-07 00:00:01', 5);
+insert into counter    values ('2016-01-07 00:00:02', 10);
+insert into counter    values ('2016-01-07 00:00:03', 15);
+insert into adjustment values ('2016-01-07 00:00:04', 30);
+insert into counter    values ('2016-01-07 00:00:05', 0);
+insert into counter    values ('2016-01-07 00:00:06', 5);
+insert into counter    values ('2016-01-07 00:00:07', 10);
+
+select timestamp, value+adj as value from
+  (select c.timestamp timestamp, c.value value, 
+                (select value from adjustment a
+                        where a.timestamp <= c.timestamp
+                        order by timestamp desc limit 1) adj from counter c
+  ) t;
+