This commit removes the commented out code for locking in the `RmFileHandle` class. The code was originally used to lock a record, but it has been disabled by commenting it out. Since the code is no longer needed, it is safe to remove it completely. This cleanup improves code readability and reduces unnecessary clutter.

Refactor code to remove commented out locking code in `RmFileHandle`.

This commit removes unnecessary debug output statements in the `log_manager.h` and `log_recovery.cpp` files. The debug output statements were printing the length of log records and the name of indexes, which are not needed for the final implementation. Removing these statements improves the code readability and reduces noise in the output.

Refactor code to remove unnecessary debug output.

Fixes #789

This commit updates the `log_recovery.h` file to use `std::map` instead of `std::unordered_map` for the `att_` (active transactions) member variable. This change ensures that the active transactions are stored in a sorted order based on the transaction ID. The use of `std::map` provides better performance for operations that require iterating or searching through the active transactions.

Refactor `log_recovery.h` to use `std::map` for active transactions.

This commit adds support for handling index insert and delete log records in the `LogBuffer` and `RecoveryManager` classes. It introduces new cases for `LogType::INDEX_INSERT` and `LogType::INDEX_DELETE` in the switch statements, creating instances of `IndexInsertLogRecord` and `IndexDeleteLogRecord` respectively. The log records are properly deserialized and processed in the `LogBuffer::next` and `RecoveryManager::analyze` functions. Additionally, the `RecoveryManager::redo` function is updated to handle index insert and delete log records, performing the necessary actions on the index handles.

Refactor code to support index insert and delete log records.

This commit refactors the `RecoveryManager::redo` function in `log_recovery.cpp` to improve the recovery process. It adds support for handling different types of log records, including `BeginLogRecord`, `CommitLogRecord`, `AbortLogRecord`, `InsertLogRecord`, `DeleteLogRecord`, and `UpdateLogRecord`. The code now properly handles each log record type and performs the necessary actions, such as inserting, deleting, or updating records in the file handle.

Refactor the `RecoveryManager::redo` function to handle different log record types.

Fixes #456

refactor: Improve lock_manager.cpp by adding utility functions for lock mode comparison and conversion

This commit modifies the `SmManager::close_db` function to also close all index handles (`ihs_`). This ensures that all resources are properly released when closing the database. The change improves the overall reliability and stability of the system.

Refactor the code to close all index handles in `SmManager::close_db`.

Fixes #123

refactor: Remove debug print statements and unused code in transaction_manager.cpp and lock_manager.cpp

refactor: Add lock_exclusive_on_record and lock_exclusive_on_table methods in TransactionManager and RmFileHandle

refactor: Fix transaction abort issue and improve code readability in transaction_manager.cpp and lock_manager.cpp