Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DELIMITER //
- CREATE PROCEDURE rezerwuj(idPas INT(8), nazwiskoPas VARCHAR(15), numer INT(4))
- BEGIN
- SET @istniejePasazer = (SELECT idPasazera FROM pasazer WHERE idPasazera = idPas);
- IF(@istniejePasazer is NULL) THEN
- BEGIN
- INSERT INTO pasazer(idPasazera, Nazwisko) VALUES(idPas, nazwiskoPas);
- END;
- END IF;
- SET @isteniejeIlot = (SELECT nriLotu FROM ilot WHERE nriLotu = numer);
- SET @miejscaZajete = (SELECT COUNT(nriLotu) FROM `pasazer_ilot` WHERE nriLotu = numer);
- SET @pojemnosc = (SELECT LMiejsc FROM samolot JOIN ilot ON ilot.nrSamolotu = samolot.nrSamolotu WHERE ilot.nriLotu = numer);
- IF(@isteniejeIlot IS NOT NULL AND @pojemnosc - @miejscaZajete > 0) THEN
- BEGIN
- INSERT INTO pasazer_ilot(nriLotu, idPasazera) VALUES(numer, idPas);
- SELECT nrLotu, data FROM ilot WHERE nriLotu = numer;
- SELECT nazwaLL FROM lot JOIN ilot ON ilot.nrLotu = lot.nrLotu WHERE ilot.nriLotu = numer;
- SELECT trasa.kodLotniskaS, trasa.kodLotniskaD FROM trasa JOIN lot ON lot.nrTrasy = trasa.nrtrasy JOIN ilot ON ilot.nrLotu = lot.nrLotu WHERE ilot.nriLotu = numer;
- END;
- END IF;
- END//
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement