dsa

create procedure tbl_capacity_and_monthly( )  
   begin
  declare i bigint default  UNIX_TIMESTAMP(now());
  declare j int default 0;
  declare k int  default 8;
  declare totle_capacity double  default 50;
  declare used_capacity double default 30;
  declare used0 double default 0;
  loop_label:loop
 insert into tbl_capacity_disk   (RESOURCE_ID,TOTAL_CAPACITY,USED_CAPACITY,UPDATE_TIME)
   values ( '1111111',totle_capacity,used_capacity,i);
insert into tbl_capacity_disk_monthly   (RESOURCE_ID,TOTAL_CAPACITY,USED_CAPACITY,AGGREGATED_TIME)
   values ( '22222222',totle_capacity,used_capacity,i);

insert into tbl_capacity_lun   (RESOURCE_ID,TOTAL_CAPACITY,USED_CAPACITY,UPDATE_TIME)
   values ( '22222222',totle_capacity,used_capacity,i);
 insert into tbl_capacity_lun_monthly   (RESOURCE_ID,TOTAL_CAPACITY,USED_CAPACITY,TIRE0_USED_CAPACITY,TIRE1_USED_CAPACITY,TIRE2_USED_CAPACITY,AGGREGATED_TIME)
   values ( '22222222',totle_capacity,used_capacity,used0,used0,used0,i);

 insert into tbl_capacity_raidgroup   (RESOURCE_ID,TOTAL_CAPACITY,USED_CAPACITY,UPDATE_TIME)
   values ( '22222222',totle_capacity,used_capacity,i);
  insert into tbl_capacity_raidgroup_monthly   (RESOURCE_ID,TOTAL_CAPACITY,USED_CAPACITY,AGGREGATED_TIME)
   values ( '22222222',totle_capacity,used_capacity,i);

  insert into tbl_capacity_storagearray   (RESOURCE_ID,TOTAL_CAPACITY,USED_CAPACITY,MAPPED_LUN_CAPACITY,UNMAPPED_LUN_CAPACITY,UPDATE_TIME)
   values ( '22222222',totle_capacity,used_capacity,used0,used0,i);
  insert into tbl_capacity_storagearray_monthly   (RESOURCE_ID,TOTAL_CAPACITY,USED_CAPACITY,MAPPED_LUN_CAPACITY,UNMAPPED_LUN_CAPACITY,AGGREGATED_TIME)
   values ( '22222222',totle_capacity,used_capacity,used0,used0,i);

insert into tbl_capacity_storagepool   (RESOURCE_ID,TOTAL_CAPACITY,USED_CAPACITY,UPDATE_TIME)
   values ( '22222222',totle_capacity,used_capacity,i);
 insert into tbl_capacity_storagepool_monthly   (RESOURCE_ID,TOTAL_CAPACITY,USED_CAPACITY,TIRE0_USED_CAPACITY,TIRE1_USED_CAPACITY,TIRE2_USED_CAPACITY,AGGREGATED_TIME)
   values ( '22222222',totle_capacity,used_capacity,used0,used0,used0,i);
    set i=UNIX_TIMESTAMP( date_sub( now(), interval k hour)) ; 
    set j=j+1;
    set k=k+8;
    set totle_capacity=totle_capacity+50;
    set  used_capacity= used_capacity+15;
   set  used0= used0+5;
   if j>=25  then
        leave loop_label;
      end if;
     end loop;
   end;

   --调用：
call   tbl_capacity_and_monthly   ()