Example code to show refactoring opportunity

refactoring_candidate.py

class Portfolio(object):
    ...
    def get_portfolio(self, portfolio_code):
        ...
        stmt = """SELECT id FROM portfolios WHERE code=?"""
        cursor.execute(stmt, (portfolio_code,))
        portfolio_id = cursor.fetchone()[0]
        ...
    def add_value(self, portfolio_code, ...):
	...
        stmt = """SELECT id FROM portfolios WHERE code=?"""
        cursor.execute(stmt, (portfolio_code,))
        portfolio_id = cursor.fetchone()[0]
        ...