This change refactors database session management and aligns unit
tests with the production DB context handling.
- Replace _session_for_read() and _session_for_write() helpers with
@main_context_manager.reader / @main_context_manager.writer decorators
to simplify and standardize DB access.
- Update DB API methods to use context.session directly and rely on
centralized transaction management through enginefacade.
- Switch tests to use cyborg.context.RequestContext instead of
oslo_context.RequestContext for consistent context propagation.
Closes-Bug: #2061130
Change-Id: Idf7714ec9fa57b4885bd5679f431cdeac2ad1497
Signed-off-by: Sooyoung Kim <sykim.etri@gmail.com>