gistfile1.py

    def get_cruise_type_ticket_type_price_id_by_cruise_type_id_and_ticket_type_id(cruise_type_id, ticket_type_id):
        with session_scope() as session:
            result = session.execute('''
                SELECT id
                    FROM cruise_type_ticket_type
                    WHERE cruise_type_id = :cruise_type_id
                      AND ticket_type_id = :ticket_type_id
            ''', {
                'cruise_type_id': cruise_type_id,
                'ticket_type_id': ticket_type_id
            })