use test;

drop table if exists wtemp;

create temporary table wtemp (
  dir   double,
  speed double,
  color varchar(255), 
  label varchar(255)
);

-- the data labels
-- 0 to 1 = 135
-- 0.1 = 13.5
insert into wtemp
  values
    (225, 78,  'rgb(0,0,0,0)', '0'),
    (225+ (2 * 13.5), 78,  'rgb(0,0,0,0)', '0.2'),
    (225+ (4 * 13.5), 78,  'rgb(0,0,0,0)', '0.4'),
    (225+ (6 * 13.5), 78,  'rgb(0,0,0,0)', '0.6'),
    (225+ (8 * 13.5), 78,  'rgb(0,0,0,0)', '0.8'),
    (360, 78,  'rgb(0,0,0,0)', '1.0'),

    (135, 78,  'rgb(0,0,0,0)',  '2.0')
;
 
insert into wtemp
-- this line can be used for testing:
-- select 
--   (((75 * 270.0)/120.0) + 225.0) % 360, 75, 'scarletred', null

 select 
   (((precip_hr * 270.0)/2.0) + 225.0) % 360, 75, 'red', null
   from raws_bl
   where gmt = (select max(gmt) from raws_bl)
;


/*
set @time = (select max(gmt) from raws_bl);

set @curr =  
   (select temp
     from raws_bl
     where gmt = @time)
;

set @max = (select max(temp) from raws_bl
              where gmt > date_sub(@time, interval 1 day));

set @min = (select min(temp) from raws_bl
              where gmt > date_sub(@time, interval 1 day));
*/

plot radarchart
  length, direction, color override, datalabels
  with
	note " "
    note "Precipitation"
    font 'sans serif' plain 14
    zerobased
    no labels y
    no labels x 
    scale x 225 135 13.5
--    page 0 0 300 300
    scale y 0 75 25

    framecolor very light gray
--    background very light blue
    page 0 0 210 180
    frame 40 15 150 155
select SPEED, dir, color, label
  from wtemp
;