(三)play之yabe项目【数据模型】

创建项目

 play new yabe

 What is the application name? [yabe] Blog Engine

 play eclipsify yabe

 play run yabe

 

Eclipse引入项目

file -> import -> General ->Existing Projects into Workspaces -> select root directory ...

 

设置数据库

选择一个内存数据库

打开yabe/conf/application.conf，去掉下面这行的注释

db=mem #使用内存数据库，使用HSQL

【hsql 数据库是一款纯Java编写的免费数据库，体积小，才563kb。仅一个hsqldb.jar文件就包括了数据库引擎，数据库驱动，还有其他用户界面操作等内容。纯Java设计，又支持 SQL99，SQL2003大部分的标准】

 

************************************************************************************************************

 

增加模型User

package models;import javax.persistence.Entity;import play.db.jpa.Model;@Entity
public class User extends Model {public String email;public String password;public String fullname;public boolean isAdmin;public User(String email,String password, String fullname) {this.email = email;this.password = password;this.fullname = fullname;}
}

 

 

使用JUNIT进行单元测试

 

打开命令行，切换到测试模式

play  test yabe

 

play提供了默认的测试文件，打开yabe\test\BasicTest.java

删除aVeryImportantThingToTest，新建一个测试

import org.junit.*;
import java.util.*;
import play.test.*;
import models.*;/*** 测试单元 extends UnitTest* @author lenovo**/
public class BasicTest extends UnitTest {@Testpublic void createAndRetriveUser() {//Create a User and savenew User("zs@162.com","******","ZS").save();//retrieve User by emialUser user1 = User.find("email", "zs@162.com").first();//两种写法都可以 匹配email="zs@162.com"的User对象User user2 = User.find("byEmail", "zs@162.com").first();assertNotNull(user1);assertNotNull(user2);assertEquals(user1, user2);assertEquals("ZS", user1.fullname);assertEquals("ZS", user2.fullname);}}

 

打开http://localhost:9000/@tests

运行BasicTest，即上面写的测试单元，点击Start !   进行测试

结果应该为绿色！

 

接下来测试User的email和password是否正确的方法

通过email和password两个条件来找到User对象

打开User.java，添加connect()：

package models;import javax.persistence.Entity;import play.db.jpa.Model;@Entity
public class User extends Model {public String email;public String password;public String fullname;public boolean isAdmin;public User(String email,String password, String fullname) {this.email = email;this.password = password;this.fullname = fullname;}/*** 联合email和password两个条件查询User* @param email* @param password* @return*/public static User connect(String email, String password) {return find("byEmailAndPassword", email, password).first();}
}

 在BasicTest.java里添加测试方法

 

import org.junit.*;
import java.util.*;
import play.test.*;
import models.*;/*** 测试单元 extends UnitTest* @author lenovo**/
public class BasicTest extends UnitTest {/*** 测试用户的创建和查找*/@Testpublic void createAndRetriveUser() {//Create a User and savenew User("zs@162.com","******","ZS").save();//retrieve User by emialUser user1 = User.find("email", "zs@162.com").first();//两种写法都可以 匹配email="zs@162.com"的User对象User user2 = User.find("byEmail", "zs@162.com").first();assertNotNull(user1);assertNotNull(user2);assertEquals(user1, user2);assertEquals("ZS", user1.fullname);assertEquals("ZS", user2.fullname);}/*** 测试联合条件查询*/@Testpublic void tryConnectUser() {//Create a user and save itnew User("zs@1.com", "123", "zhangsan").save();//TestassertNotNull(User.connect("zs@1.com", "123"));assertNull(User.connect("zs@1.com", "234"));assertNull(User.connect("zs@2.com", "234"));}}

 http://localhost:9000/@tests

 

测试BasicTest项，应该全部通过！

 

增加模型Post

Post类作为博客的实体类，与User之间为多对一的关系

package models;import java.util.Date;import javax.persistence.Entity;
import javax.persistence.Lob;
import javax.persistence.ManyToOne;import play.db.jpa.Model;@Entity
public class Post extends Model {public String title;public Date postedAt;//@Lob标注：声明这是一个超大文本数据类型，用于存储发布的博客内容@Lobpublic String content;//@ManyToOne：声明Post与User之间是多对一的关系//一个用户可以发布多个博客，一个博客只能被一个用户所发布@ManyToOnepublic User author;public Post(String title, String content, User author) {this.title = title;this.content = content;this.author = author;this.postedAt = new Date();}}

对Post类进行测试

import org.junit.*;
import java.util.*;
import play.test.*;
import models.*;/*** 测试单元 extends UnitTest* @author lenovo**/
public class BasicTest extends UnitTest {/*** 清空数据库中的数据，释放内存空间* Fixtures帮助在测试期间管理数据库*/@Beforepublic void setup() {Fixtures.deleteDatabase();}/*** 测试用户的创建和查找*/@Testpublic void createAndRetriveUser() {//Create a User and savenew User("zs@162.com","******","ZS").save();//retrieve User by emialUser user1 = User.find("email", "zs@162.com").first();//两种写法都可以 匹配email="zs@162.com"的User对象User user2 = User.find("byEmail", "zs@162.com").first();assertNotNull(user1);assertNotNull(user2);assertEquals(user1, user2);assertEquals("ZS", user1.fullname);assertEquals("ZS", user2.fullname);}/*** 测试联合条件查询*/@Testpublic void tryConnectUser() {//Create a user and save itnew User("zs@1.com", "123", "zhangsan").save();//TestassertNotNull(User.connect("zs@1.com", "123"));assertNull(User.connect("zs@1.com", "234"));assertNull(User.connect("zs@2.com", "234"));}/*** 测试Post类*/@Testpublic void createPost() {//Create a User and save it User Mike = new User("ls@1.com", "111", "Mike").save();//Create 2 Postnew Post("First Blog", "first", Mike).save();new Post("Second Blog", "second", Mike).save();//测试是否成功创建了2个Post对象assertEquals(2, Post.count());//获取lisi发布的所有博客List<Post> posts = Post.find("byAuthor", Mike).fetch();assertEquals(2, posts.size());assertNotNull(posts.get(0));assertNotNull(posts.get(1));assertEquals(Mike, posts.get(0).author);assertEquals("First Blog", posts.get(0).title);assertEquals("second", posts.get(1).content);assertNotNull(posts.get(1).postedAt);}}

 

 

 增加模型Comment

Comment 与 Post 之间为多对一的关系，多条评论对应一篇博客

package models;import java.util.Date;import javax.persistence.Entity;
import javax.persistence.Lob;
import javax.persistence.ManyToOne;import play.db.jpa.Model;@Entity
public class Comment extends Model {public String author;public Date postedAt;@Lobpublic String content;//一篇博客对应多条评论，一个评论属于一篇博客//评论与博客的关系：多对一@ManyToOnepublic Post post;public Comment(String author, String content, Post post) {super();this.author = author;this.content = content;this.post = post;this.postedAt = new Date();}}

 

 

修改模型Post，增加Comment属性

注：上面的User类也可以持有一个关于Post的集合，方法与此类似。

package models;import java.util.ArrayList;
import java.util.Date;
import java.util.List;import javax.persistence.CascadeType;
import javax.persistence.Entity;
import javax.persistence.Lob;
import javax.persistence.ManyToOne;
import javax.persistence.OneToMany;import play.db.jpa.Model;@Entity
public class Post extends Model {public String title;public Date postedAt;//@Lob标注：声明这是一个超大文本数据类型，用于存储发布的博客内容@Lobpublic String content;//@ManyToOne：声明Post与User之间是多对一的关系//一个用户可以发布多个博客，一个博客只能被一个用户所发布@ManyToOnepublic User author;//1篇博客对应多个评论//删除某篇博客，则级联删除其评论@OneToMany(mappedBy="post", cascade=CascadeType.ALL)public List<Comment> comments;public Post(String title, String content, User author) {this.comments = new ArrayList<Comment>(0);this.title = title;this.content = content;this.author = author;this.postedAt = new Date();}/*** 在Post中实现评论的添加保存操作* 同时更新Post所持有的Comment的集合！*/public Post addComment(String author, String content) {//保存对方Comment newComment = new Comment(author, content, this).save();//把对方加入到自己管理的集合中this.comments.add(newComment);//同步到数据库this.save();return this;}
}

 

 

 所有的测试代码

import org.junit.*;
import java.util.*;
import play.test.*;
import models.*;/*** 测试单元 extends UnitTest* @author lenovo**/
public class BasicTest extends UnitTest {/*** 清空数据库中的数据，释放内存空间* Fixtures帮助在测试期间管理数据库*/@Beforepublic void setup() {Fixtures.deleteDatabase();}/*** 测试用户的创建和查找*/@Testpublic void createAndRetriveUser() {//Create a User and savenew User("zs@162.com","******","ZS").save();//retrieve User by emialUser user1 = User.find("email", "zs@162.com").first();//两种写法都可以 匹配email="zs@162.com"的User对象User user2 = User.find("byEmail", "zs@162.com").first();assertNotNull(user1);assertNotNull(user2);assertEquals(user1, user2);assertEquals("ZS", user1.fullname);assertEquals("ZS", user2.fullname);}/*** 测试联合条件查询*/@Testpublic void tryConnectUser() {//Create a user and save itnew User("zs@1.com", "123", "zhangsan").save();//TestassertNotNull(User.connect("zs@1.com", "123"));assertNull(User.connect("zs@1.com", "234"));assertNull(User.connect("zs@2.com", "234"));}/*** 测试Post类*/@Testpublic void createPost() {//Create a User and save it User Mike = new User("ls@1.com", "111", "Mike").save();//Create 2 Postnew Post("First Blog", "first", Mike).save();new Post("Second Blog", "second", Mike).save();//测试是否成功创建了2个Post对象assertEquals(2, Post.count());//获取lisi发布的所有博客List<Post> posts = Post.find("byAuthor", Mike).fetch();assertEquals(2, posts.size());assertNotNull(posts.get(0));assertNotNull(posts.get(1));assertEquals(Mike, posts.get(0).author);assertEquals("First Blog", posts.get(0).title);assertEquals("second", posts.get(1).content);assertNotNull(posts.get(1).postedAt);}/*** 测试Post与User的多对一关系*/@Testpublic void testPost2User() {User Mike = new User("ls@1.com", "111", "Mike").save();Mike.addPost("First Blog", "first");Mike.addPost("Second Blog", "second");assertNotNull(Mike);assertEquals(2, Post.count());//从新查询UserMike = User.connect("ls@1.com", "111");//直接从User中获取Post的集合assertEquals(2, Mike.posts.size());assertEquals("first", Mike.posts.get(0).content);assertEquals("second", Mike.posts.get(1).content);}/*** 测试Comment类* 单向，由Comment得到Post*/@Testpublic void testComment() {User Mike = new User("ls@1.com", "111", "Mike").save();Post post = new Post("First Blog", "first", Mike).save();new Comment("jeff", "nice post", post).save();new Comment("henrry", "good post", post).save();//获取博客的所有评论List<Comment> comments = Comment.find("byPost", post).fetch();assertEquals(2, comments.size());Comment firstComment = comments.get(0);assertNotNull(firstComment);assertEquals("jeff", firstComment.author);assertEquals("nice post", firstComment.content);assertNotNull(firstComment.postedAt);Comment secondComment = comments.get(1);assertNotNull(secondComment);assertEquals("henrry", secondComment.author);assertEquals("good post", secondComment.content);assertNotNull(firstComment.postedAt);}/*** 测试Comment与Post的多对一关系* 双向，由Post直接得到与此关联的Comment集合*/@Testpublic void testComment2PostRelation() {//UserUser bob = new User("bob@123.com","111","Bob well").save();//PostPost post = new Post("First post","hello kelly",bob).save();//Commentpost.addComment("jeff", "Nice Post!");post.addComment("Tom", "I knew that!");assertEquals(1, User.count());assertEquals(1, Post.count());assertEquals(2, Comment.count());//Retrieve Bob's postpost = Post.find("byAuthor", bob).first();assertNotNull(post);//Navigation to commentsassertEquals(2, post.comments.size());assertEquals("jeff", post.comments.get(0).author);//delete Postpost.delete();//check that all commonts have been deletedassertEquals(1, User.count());assertEquals(0, Post.count());assertEquals(0, Comment.count());}}