Show using camel to loop over rows X rows at a time.

Shows off
sql:{{sqlstmt.selectOrder}}?dataSource=#dataSource&template.maxRows=10&consumer.onConsume={{sqlstmt.markOrder}}
works
Shoot!  consumer.onConsume={{sqlstmt.markOrder}} is not working! #$%@!
YAY!   Now that table updates as the rows are processed.  See
UpdateOrdersTest.
Added extra check showing if no rows come from select, the route does
not continue.
Yay!  InsertReturningTest works
Added AllTestsSuite
changed orders.amount to int and added a shipments table.
Changed orders.id to orders.order_id
AssignOrdersToShipmentsTest passes.
Added report at end of test.  Need to change code to make report have
contents.
Report works!  Need to validate the report.
Output the report from AssignOrdersToShipmentsTest to stdout and it
looks good.   Looks like this:

{SHIPMENT_ID=1, ORDER_ID=9}
{SHIPMENT_ID=1, ORDER_ID=8}
{SHIPMENT_ID=1, ORDER_ID=7}
{SHIPMENT_ID=1, ORDER_ID=6}
{SHIPMENT_ID=1, ORDER_ID=5}
{SHIPMENT_ID=1, ORDER_ID=4}
{SHIPMENT_ID=1, ORDER_ID=3}
{SHIPMENT_ID=1, ORDER_ID=2}
{SHIPMENT_ID=1, ORDER_ID=1}
{SHIPMENT_ID=2, ORDER_ID=18}
{SHIPMENT_ID=2, ORDER_ID=17}
{SHIPMENT_ID=2, ORDER_ID=16}
{SHIPMENT_ID=2, ORDER_ID=15}
{SHIPMENT_ID=2, ORDER_ID=14}
{SHIPMENT_ID=2, ORDER_ID=13}
{SHIPMENT_ID=2, ORDER_ID=12}
{SHIPMENT_ID=2, ORDER_ID=11}
{SHIPMENT_ID=2, ORDER_ID=10}
{SHIPMENT_ID=3, ORDER_ID=27}
{SHIPMENT_ID=3, ORDER_ID=26}
{SHIPMENT_ID=3, ORDER_ID=25}
{SHIPMENT_ID=3, ORDER_ID=24}
{SHIPMENT_ID=3, ORDER_ID=23}
{SHIPMENT_ID=3, ORDER_ID=22}
{SHIPMENT_ID=3, ORDER_ID=21}
{SHIPMENT_ID=3, ORDER_ID=20}
{SHIPMENT_ID=3, ORDER_ID=19}
{SHIPMENT_ID=4, ORDER_ID=36}
{SHIPMENT_ID=4, ORDER_ID=35}
{SHIPMENT_ID=4, ORDER_ID=34}
{SHIPMENT_ID=4, ORDER_ID=33}
{SHIPMENT_ID=4, ORDER_ID=32}
{SHIPMENT_ID=4, ORDER_ID=31}
{SHIPMENT_ID=4, ORDER_ID=30}
{SHIPMENT_ID=4, ORDER_ID=29}
{SHIPMENT_ID=4, ORDER_ID=28}
{SHIPMENT_ID=5, ORDER_ID=45}
{SHIPMENT_ID=5, ORDER_ID=44}
{SHIPMENT_ID=5, ORDER_ID=43}
{SHIPMENT_ID=5, ORDER_ID=42}
{SHIPMENT_ID=5, ORDER_ID=41}
{SHIPMENT_ID=5, ORDER_ID=40}
{SHIPMENT_ID=5, ORDER_ID=39}
{SHIPMENT_ID=5, ORDER_ID=38}
{SHIPMENT_ID=5, ORDER_ID=37}
{SHIPMENT_ID=6, ORDER_ID=54}
{SHIPMENT_ID=6, ORDER_ID=53}
{SHIPMENT_ID=6, ORDER_ID=52}
{SHIPMENT_ID=6, ORDER_ID=51}
{SHIPMENT_ID=6, ORDER_ID=50}
{SHIPMENT_ID=6, ORDER_ID=49}
{SHIPMENT_ID=6, ORDER_ID=48}
{SHIPMENT_ID=6, ORDER_ID=47}
{SHIPMENT_ID=6, ORDER_ID=46}
{SHIPMENT_ID=7, ORDER_ID=63}
{SHIPMENT_ID=7, ORDER_ID=62}
{SHIPMENT_ID=7, ORDER_ID=61}
{SHIPMENT_ID=7, ORDER_ID=60}
{SHIPMENT_ID=7, ORDER_ID=59}
{SHIPMENT_ID=7, ORDER_ID=58}
{SHIPMENT_ID=7, ORDER_ID=57}
{SHIPMENT_ID=7, ORDER_ID=56}
{SHIPMENT_ID=7, ORDER_ID=55}
{SHIPMENT_ID=8, ORDER_ID=72}
{SHIPMENT_ID=8, ORDER_ID=71}
{SHIPMENT_ID=8, ORDER_ID=70}
{SHIPMENT_ID=8, ORDER_ID=69}
{SHIPMENT_ID=8, ORDER_ID=68}
{SHIPMENT_ID=8, ORDER_ID=67}
{SHIPMENT_ID=8, ORDER_ID=66}
{SHIPMENT_ID=8, ORDER_ID=65}
{SHIPMENT_ID=8, ORDER_ID=64}
{SHIPMENT_ID=9, ORDER_ID=81}
{SHIPMENT_ID=9, ORDER_ID=80}
{SHIPMENT_ID=9, ORDER_ID=79}
{SHIPMENT_ID=9, ORDER_ID=78}
{SHIPMENT_ID=9, ORDER_ID=77}
{SHIPMENT_ID=9, ORDER_ID=76}
{SHIPMENT_ID=9, ORDER_ID=75}
{SHIPMENT_ID=9, ORDER_ID=74}
{SHIPMENT_ID=9, ORDER_ID=73}
{SHIPMENT_ID=10, ORDER_ID=90}
{SHIPMENT_ID=10, ORDER_ID=89}
{SHIPMENT_ID=10, ORDER_ID=88}
{SHIPMENT_ID=10, ORDER_ID=87}
{SHIPMENT_ID=10, ORDER_ID=86}
{SHIPMENT_ID=10, ORDER_ID=85}
{SHIPMENT_ID=10, ORDER_ID=84}
{SHIPMENT_ID=10, ORDER_ID=83}
{SHIPMENT_ID=10, ORDER_ID=82}
{SHIPMENT_ID=11, ORDER_ID=99}
{SHIPMENT_ID=11, ORDER_ID=98}
{SHIPMENT_ID=11, ORDER_ID=97}
{SHIPMENT_ID=11, ORDER_ID=96}
{SHIPMENT_ID=11, ORDER_ID=95}
{SHIPMENT_ID=11, ORDER_ID=94}
{SHIPMENT_ID=11, ORDER_ID=93}
{SHIPMENT_ID=11, ORDER_ID=92}
{SHIPMENT_ID=11, ORDER_ID=91}
{SHIPMENT_ID=12, ORDER_ID=100}