CREATE DEFINER = `root` @`localhost` PROCEDURE `kurzy`() BEGIN #deklarace promennych
declare dt datetime;

declare m1 double;

declare m2 double;

declare m3 double;

declare m4 double;

declare m5 double;

declare m6 double;

declare m7 double;

declare m8 double;

declare m9 double;

declare m10 double;

declare id integer;

#bool pro konec cyklu
declare v_notfound BOOL default FALSE;

#kurzor
declare csr_emp cursor for
select
        *
from
        #oldDB.kurzy
WHERE
        #oldDB.kurzy.dt < '2008-03-25 16:44:00'
;

#udalost pro konec cyklu
declare continue handler for not found
set
        v_notfound = TRUE;

#udalost pro chybu
declare exit handler for sqlexception close csr_emp;

#pociatocna hodnota indexu
set
        id = 0;

#vytvorim kurzor
open csr_emp;

cursor_loop: loop #nacitam dataset do promennych
fetch csr_emp into dt,
m1,
m2,
m3,
m4,
m5,
m6,
m7,
m8,
m9,
m10;

#osetreni konce datasetu
if v_notfound then leave cursor_loop;

end if;

#vkladam riadky do DB
#1 mena
insert into
        #newDB.cis_rates
values
        (id, 'EUR', dt, m1);

#2 mena
insert into
        #newDB.cis_rates
values
        (id, 'USD', dt, m2);

#3 mena
insert into
        #newDB.cis_rates
values
        (id, 'SKK', dt, m3);

#4 mena
insert into
        #newDB.cis_rates
values
        (id, 'GBP', dt, m4);

#5 mena
insert into
        #newDB.cis_rates
values
        (id, 'CHF', dt, m5);

#6 mena
insert into
        #newDB.cis_rates
values
        (id, 'JPY', dt, m6);

end loop;

#uvolneni kurzoru
close csr_emp;

END