manager for a specific DataSource Further resources 18. DAO support Introduction Consistent exception hierarchy Annotations used for configuring DAO or Repository classes 19. Data access with JDBC Introduction connections Using a single CCI connection Using Spring’s CCI access support Record conversion CciTemplate DAO support Automatic output record generation Summary Using a CCI Connection and Interaction directly integration testing Spring components org.springframework spring-tx Transaction infrastructure, including DAO support and JCA integration org.springframework spring-web Foundational web support, including web

manager for a specific DataSource Further Resources 18. DAO support Introduction Consistent exception hierarchy Annotations used for configuring DAO or Repository classes 19. Data access with JDBC Introduction Using a single CCI connection Using Spring’s CCI access support Record conversion the CciTemplate DAO support Automatic output record generation Summary Using a CCI Connection and Interaction directly integration testing Spring components org.springframework spring-tx Transaction infrastructure, including DAO support and JCA integration org.springframework spring-web Web support packages, including client

__init__(self, dao): self._dao = dao def on_get(self, req, resp, game_id): pass def on_post(self, req, resp, game_id): pass class GameState(object): def __init__(self, dao): self._dao = dao def on_get(self, req, resp, game_id): pass def on_post(self, req, resp, game_id): pass api = falcon.API() # Game and GameState are closely related, and so it # layer. game_dao = myapp.DAL.Game(myconfig) api.add_route('/game/ping', Ping()) api.add_route('/game/{game_id}', Game(game_dao)) api.add_route('/game/{game_id}/state', GameState(game_dao)) Alternatively

__init__(self, dao): self._dao = dao def on_get(self, req, resp, game_id): pass def on_post(self, req, resp, game_id): pass class GameState: def __init__(self, dao): self._dao = dao def on_get(self, req, resp, game_id): pass def on_post(self, req, resp, game_id): pass app = falcon.App() # Game and GameState are closely related, and so it # # layer. game_dao = myapp.DAL.Game(myconfig) app.add_route('/game/ping', Ping()) app.add_route('/game/{game_id}', Game(game_dao)) app.add_route('/game/{game_id}/state', GameState(game_dao)) Alternatively

__init__(self, dao): self._dao = dao def on_get(self, req, resp, game_id): pass def on_post(self, req, resp, game_id): pass class GameState: def __init__(self, dao): self._dao = dao def on_get(self, req, resp, game_id): pass def on_post(self, req, resp, game_id): pass app = falcon.App() # Game and GameState are closely related, and so it # # layer. game_dao = myapp.DAL.Game(myconfig) app.add_route('/game/ping', Ping()) app.add_route('/game/{game_id}', Game(game_dao)) app.add_route('/game/{game_id}/state', GameState(game_dao)) Alternatively

__init__(self, dao): self._dao = dao def on_get(self, req, resp, game_id): pass def on_post(self, req, resp, game_id): pass class GameState: def __init__(self, dao): self._dao = dao def on_get(self, req, resp, game_id): pass def on_post(self, req, resp, game_id): pass app = falcon.App() # Game and GameState are closely related, and so it # # layer. game_dao = myapp.DAL.Game(myconfig) app.add_route('/game/ping', Ping()) app.add_route('/game/{game_id}', Game(game_dao)) app.add_route('/game/{game_id}/state', GameState(game_dao)) Alternatively

__init__(self, dao): self._dao = dao def on_get(self, req, resp, game_id): pass def on_post(self, req, resp, game_id): pass class GameState: def __init__(self, dao): self._dao = dao def on_get(self, req, resp, game_id): pass def on_post(self, req, resp, game_id): pass app = falcon.App() # Game and GameState are closely related, and so it # # layer. game_dao = myapp.DAL.Game(myconfig) app.add_route('/game/ping', Ping()) app.add_route('/game/{game_id}', Game(game_dao)) app.add_route('/game/{game_id}/state', GameState(game_dao)) Alternatively

__init__(self, dao): self._dao = dao def on_get(self, req, resp, game_id): pass def on_post(self, req, resp, game_id): pass class GameState: def __init__(self, dao): self._dao = dao def on_get(self, req, resp, game_id): pass def on_post(self, req, resp, game_id): pass app = falcon.App() # Game and GameState are closely related, and so it # # layer. game_dao = myapp.DAL.Game(myconfig) app.add_route('/game/ping', Ping()) app.add_route('/game/{game_id}', Game(game_dao)) app.add_route('/game/{game_id}/state', GameState(game_dao)) Alternatively

__init__(self, dao): self._dao = dao def on_get(self, req, resp, game_id): pass def on_post(self, req, resp, game_id): pass class GameState: def __init__(self, dao): self._dao = dao def on_get(self, req, resp, game_id): pass def on_post(self, req, resp, game_id): pass app = falcon.App() # Game and GameState are closely related, and so it # # layer. game_dao = myapp.DAL.Game(myconfig) app.add_route('/game/ping', Ping()) app.add_route('/game/{game_id}', Game(game_dao)) app.add_route('/game/{game_id}/state', GameState(game_dao)) Alternatively

__init__(self, dao): self._dao = dao def on_get(self, req, resp, game_id): pass def on_post(self, req, resp, game_id): pass class GameState: def __init__(self, dao): self._dao = dao def on_get(self, req, resp, game_id): pass def on_post(self, req, resp, game_id): pass app = falcon.App() # Game and GameState are closely related, and so it # layer. game_dao = myapp.DAL.Game(myconfig) app.add_route('/game/ping', Ping()) app.add_route('/game/{game_id}', Game(game_dao)) app.add_route('/game/{game_id}/state', GameState(game_dao)) Alternatively