def METHOD_NAME(self):
    """
    SELECT tid, username, description, extension,
        FROM transaction
        WHERE tid >= 0
    """
    transaction = Schema.transaction
    stmt = transaction.select(
        transaction.c.tid,
        transaction.c.username,
        transaction.c.description,
        transaction.c.extension,
        transaction.c.packed
    ).where(
        transaction.c.tid >= 0
    )
    stmt = stmt.bind(Context)
    self.assertEqual(
        str(stmt),
        'SELECT tid, username, description, extension, '
        "CASE WHEN packed = 'Y' THEN 1 ELSE 0 END "
        'FROM transaction WHERE (tid >= 0)'
    )