Module: Model implementation

Learn to implement persistent models using the MySQL relational database management system.

Learning Outcomes

Use RDBMS effectively

You can use relational database management systems such as MySQL to effectively and efficiently implement persistance for your applications.

Readings

Introduction to model implementation

MySQL, eBean ORM, and the play-example-mysql application

Screencast 18 min

MySQL tutorial

Connecting, disconnecting, queries, databases, batch mode, query examples

play-example-mysql

Connecting, disconnecting, queries, databases, batch mode, query examples

Play for Java, Chapter 7

Modeling and persistence

EBean ORM Readings

Links for getting started with EBean object-relational manager

MySQL Clients

Links to open source MySQL clients for Windows, Mac, and Unix

Model implementation guidelines

Standards for model implementation in this class

Experiential Learning

play-example-mysql

Learn to install MySQL, a MySQL client, and configure a Play application to connect to a local and cloud-based MySQL instance.

A25: play-example-mysql Technical Essay

Write a technical essay summarizing your experience with the play-example-mysql system.

Practice WOD: DigitsMySQL

Implement back-end persistence for your Digits application

Practice WOD: DigitsCloudBees

Deploy your Digits application using CloudBees MySQL.

A26: Model Implementation Technical Essay

Write a technical essay summarizing your experience doing the Model Implementation practice WODs.

Assessments

Group WOD: play-example-login MySQL

Outcomes assessed: Acquire capability with the Eclipse IDE, Write code efficiently, Design using Play Framework, Use cloud-based hosting effectively, Work effectively in a group, Use RDBMS effectively

Rx: < 60 min Av: < 60 min Sd: < 60 min DNF: 60+ min or incorrect

Students worked in groups in-class to add a MySQL backend to the play-example-login system and deploy it to the cloud.

Discussion:

  • This WOD requires about an hour to implement for Rx time; thus the groups either finished or DNF’d with Rx time because classtime ran out after an hour. Ideally, groups would have had up to 90 minutes to complete this WOD.

Model Implementation Technical Essay

Outcomes assessed: Create high quality technical writing

This assessment evaluated the ability of students to write a high quality technical essay summarizing their experiences doing the Model Implementation practice WODs.

Discussion:

  • Students continue to be able to consistently create satisfactory technical essays on the topics presented in this course.