Secure Database Access | Dataford Interview Questions

Review a code snippet that opens a database connection with credentials embedded in the code and suggest improvements.

This was asked in the AI interview during the code review stage. Focus on secure credential handling and connection management.

Implement review_connection_code(code), which accepts a Python source string and returns a list of unique issue codes in this order: embedded_credentials, unsafe_secret_source, and unmanaged_connection.

embedded_credentials applies when credential-like values are string literals. unsafe_secret_source applies when credentials are supplied directly to a connection call without environment or configuration lookup. unmanaged_connection applies when a connection is opened without a context manager or an evident close() call.

Constraints

1 <= len(code) <= 100000
The input is a Python source string
Matching is case-insensitive
Return issue codes in the specified order without duplicates
The function must not execute the supplied source code

Function Signature

def review_connection_code(code):

Your question is Secure Database Access. Start with the requirements in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem