sp_examples.sql

-- Stored procedures usage

-- `order_books_by` examples

CALL order_books_by("id_publisher", "ASC");
CALL order_books_by("id_book", "DESC");

-- `insert_or_delete_book_category` examples

CALL insert_or_delete_book_category("INSERT", 1, 1);
CALL insert_or_delete_book_category("DELETE", 1, 1);

-- insert_book_category examples

CALL insert_book_category(1, 1);
CALL insert_book_category(2, 2);

-- delete_book_category examples

CALL delete_book_category(1, 1);
CALL delete_book_category(2, 2);

SELECT * FROM book_category; -- to see changes

-- update_book_status examples

CALL update_book_status(1, 3);

SELECT * FROM book_inventory WHERE id_book_inventory = 1; -- to see changes

-- log_into_log_loan_table examples

CALL log_into_log_loan_table(1, 3);

SELECT * FROM log_loan; -- to see changes