{"action":"created","comment":{"url":"https://api.github.com/repos/ezScrum/ezScrum/pulls/comments/23668463","id":23668463,"diff_hunk":"@@ -78,4 +82,101 @@ public void testCreateProject() throws SQLException{\n \t\t\tassertEquals(projectInfo.attachFileSize, project.getAttachFileSize());\n \t\t}\n \t}\n+\t\n+\tpublic void testUpdateProject() throws SQLException{\n+\t\t// project data\n+\t\tProjectInfo projectInfo = new ProjectInfo();\n+\t\tprojectInfo.name = \"TEST_PROJECT_NAME\";\n+\t\tprojectInfo.displayName = \"TEST_PROJECT_DISPLAYNAME\";\n+\t\tprojectInfo.common = \"TEST_PROJECT_COMMON\";\n+\t\tprojectInfo.manager = \"TEST_PROJECT_MANAGER\";\n+\t\tprojectInfo.attachFileSize = 2048L;\n+\t\t\n+\t\t// create project\n+\t\tlong projectId = mProjectMapper.createProject(projectInfo.name, projectInfo);\n+\t\tassertTrue(projectId > 0);\n+\t\t\n+\t\t// new project data\n+\t\tprojectInfo.displayName = \"TEST_PROJECT_DISPLAYNAME_NEW\";\n+\t\tprojectInfo.common = \"TEST_PROJECT_COMMON_NEW\";\n+\t\tprojectInfo.manager = \"TEST_PROJECT_MANAGER_NEW\";\n+\t\tprojectInfo.attachFileSize = 1024L;\n+\t\t\n+\t\t// update project\n+\t\tmProjectMapper.updateProject(projectId, projectInfo);\n+\t\t\n+\t\t// get project using query\n+\t\tIQueryValueSet valueSet = new MySQLQuerySet();\n+\t\tvalueSet.addTableName(ProjectEnum.TABLE_NAME);\n+\t\tvalueSet.addEqualCondition(ProjectEnum.ID, projectId);\n+\t\tString query = valueSet.getSelectQuery();\n+\t\tResultSet resultSet = mControl.executeQuery(query);\n+\t\tif (resultSet.next()) {\n+\t\t\tProjectObject project = ProjectDAO.getInstance().convertProject(resultSet);\n+\t\t\tassertEquals(projectInfo.displayName, project.getDisplayName());\n+\t\t\tassertEquals(projectInfo.common, project.getComment());\n+\t\t\tassertEquals(projectInfo.manager, project.getManager());\n+\t\t\tassertEquals(projectInfo.attachFileSize, project.getAttachFileSize());\n+\t\t}\n+\t}\n+\t\n+\tpublic void testDeleteProject() throws SQLException{\n+\t\t// project data\n+\t\tProjectInfo projectInfo = new ProjectInfo();\n+\t\tprojectInfo.name = \"TEST_PROJECT_NAME\";\n+\t\tprojectInfo.displayName = \"TEST_PROJECT_DISPLAYNAME\";\n+\t\tprojectInfo.common = \"TEST_PROJECT_COMMON\";\n+\t\tprojectInfo.manager = \"TEST_PROJECT_MANAGER\";\n+\t\tprojectInfo.attachFileSize = 2048L;\n+\t\t\n+\t\t// create project\n+\t\tlong projectId = mProjectMapper.createProject(projectInfo.name, projectInfo);","path":"test/ntut/csie/ezScrum/web/mapper/ProjectMapperTest.java","position":79,"original_position":79,"commit_id":"b931485c78c8e5d4957112e213ae15721ea9b813","original_commit_id":"b931485c78c8e5d4957112e213ae15721ea9b813","user":{"login":"Jay-Liao","id":7368076,"avatar_url":"https://avatars.githubusercontent.com/u/7368076?v=3","gravatar_id":"","url":"https://api.github.com/users/Jay-Liao","html_url":"https://github.com/Jay-Liao","followers_url":"https://api.github.com/users/Jay-Liao/followers","following_url":"https://api.github.com/users/Jay-Liao/following{/other_user}","gists_url":"https://api.github.com/users/Jay-Liao/gists{/gist_id}","starred_url":"https://api.github.com/users/Jay-Liao/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Jay-Liao/subscriptions","organizations_url":"https://api.github.com/users/Jay-Liao/orgs","repos_url":"https://api.github.com/users/Jay-Liao/repos","events_url":"https://api.github.com/users/Jay-Liao/events{/privacy}","received_events_url":"https://api.github.com/users/Jay-Liao/received_events","type":"User","site_admin":false},"body":"avoid use other method","created_at":"2015-01-28T06:41:17Z","updated_at":"2015-01-28T06:41:17Z","html_url":"https://github.com/ezScrum/ezScrum/pull/51#discussion_r23668463","pull_request_url":"https://api.github.com/repos/ezScrum/ezScrum/pulls/51","_links":{"self":{"href":"https://api.github.com/repos/ezScrum/ezScrum/pulls/comments/23668463"},"html":{"href":"https://github.com/ezScrum/ezScrum/pull/51#discussion_r23668463"},"pull_request":{"href":"https://api.github.com/repos/ezScrum/ezScrum/pulls/51"}}},"pull_request":{"url":"https://api.github.com/repos/ezScrum/ezScrum/pulls/51","id":28171411,"html_url":"https://github.com/ezScrum/ezScrum/pull/51","diff_url":"https://github.com/ezScrum/ezScrum/pull/51.diff","patch_url":"https://github.com/ezScrum/ezScrum/pull/51.patch","issue_url":"https://api.github.com/repos/ezScrum/ezScrum/issues/51","number":51,"state":"open","locked":false,"title":"補完 ProjectMapper UT","user":{"login":"cutecool","id":5761419,"avatar_url":"https://avatars.githubusercontent.com/u/5761419?v=3","gravatar_id":"","url":"https://api.github.com/users/cutecool","html_url":"https://github.com/cutecool","followers_url":"https://api.github.com/users/cutecool/followers","following_url":"https://api.github.com/users/cutecool/following{/other_user}","gists_url":"https://api.github.com/users/cutecool/gists{/gist_id}","starred_url":"https://api.github.com/users/cutecool/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cutecool/subscriptions","organizations_url":"https://api.github.com/users/cutecool/orgs","repos_url":"https://api.github.com/users/cutecool/repos","events_url":"https://api.github.com/users/cutecool/events{/privacy}","received_events_url":"https://api.github.com/users/cutecool/received_events","type":"User","site_admin":false},"body":"","created_at":"2015-01-28T06:32:05Z","updated_at":"2015-01-28T06:41:17Z","closed_at":null,"merged_at":null,"merge_commit_sha":"a2ebfbc9d9f7a21cd7c253e0685d560a46a8db4b","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/ezScrum/ezScrum/pulls/51/commits","review_comments_url":"https://api.github.com/repos/ezScrum/ezScrum/pulls/51/comments","review_comment_url":"https://api.github.com/repos/ezScrum/ezScrum/pulls/comments/{number}","comments_url":"https://api.github.com/repos/ezScrum/ezScrum/issues/51/comments","statuses_url":"https://api.github.com/repos/ezScrum/ezScrum/statuses/b931485c78c8e5d4957112e213ae15721ea9b813","head":{"label":"ezScrum:story_7103_new_project","ref":"story_7103_new_project","sha":"b931485c78c8e5d4957112e213ae15721ea9b813","user":{"login":"ezScrum","id":5744174,"avatar_url":"https://avatars.githubusercontent.com/u/5744174?v=3","gravatar_id":"","url":"https://api.github.com/users/ezScrum","html_url":"https://github.com/ezScrum","followers_url":"https://api.github.com/users/ezScrum/followers","following_url":"https://api.github.com/users/ezScrum/following{/other_user}","gists_url":"https://api.github.com/users/ezScrum/gists{/gist_id}","starred_url":"https://api.github.com/users/ezScrum/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ezScrum/subscriptions","organizations_url":"https://api.github.com/users/ezScrum/orgs","repos_url":"https://api.github.com/users/ezScrum/repos","events_url":"https://api.github.com/users/ezScrum/events{/privacy}","received_events_url":"https://api.github.com/users/ezScrum/received_events","type":"Organization","site_admin":false},"repo":{"id":13950021,"name":"ezScrum","full_name":"ezScrum/ezScrum","owner":{"login":"ezScrum","id":5744174,"avatar_url":"https://avatars.githubusercontent.com/u/5744174?v=3","gravatar_id":"","url":"https://api.github.com/users/ezScrum","html_url":"https://github.com/ezScrum","followers_url":"https://api.github.com/users/ezScrum/followers","following_url":"https://api.github.com/users/ezScrum/following{/other_user}","gists_url":"https://api.github.com/users/ezScrum/gists{/gist_id}","starred_url":"https://api.github.com/users/ezScrum/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ezScrum/subscriptions","organizations_url":"https://api.github.com/users/ezScrum/orgs","repos_url":"https://api.github.com/users/ezScrum/repos","events_url":"https://api.github.com/users/ezScrum/events{/privacy}","received_events_url":"https://api.github.com/users/ezScrum/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/ezScrum/ezScrum","description":"An open source project for scrum","fork":false,"url":"https://api.github.com/repos/ezScrum/ezScrum","forks_url":"https://api.github.com/repos/ezScrum/ezScrum/forks","keys_url":"https://api.github.com/repos/ezScrum/ezScrum/keys{/key_id}","collaborators_url":"https://api.github.com/repos/ezScrum/ezScrum/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/ezScrum/ezScrum/teams","hooks_url":"https://api.github.com/repos/ezScrum/ezScrum/hooks","issue_events_url":"https://api.github.com/repos/ezScrum/ezScrum/issues/events{/number}","events_url":"https://api.github.com/repos/ezScrum/ezScrum/events","assignees_url":"https://api.github.com/repos/ezScrum/ezScrum/assignees{/user}","branches_url":"https://api.github.com/repos/ezScrum/ezScrum/branches{/branch}","tags_url":"https://api.github.com/repos/ezScrum/ezScrum/tags","blobs_url":"https://api.github.com/repos/ezScrum/ezScrum/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/ezScrum/ezScrum/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/ezScrum/ezScrum/git/refs{/sha}","trees_url":"https://api.github.com/repos/ezScrum/ezScrum/git/trees{/sha}","statuses_url":"https://api.github.com/repos/ezScrum/ezScrum/statuses/{sha}","languages_url":"https://api.github.com/repos/ezScrum/ezScrum/languages","stargazers_url":"https://api.github.com/repos/ezScrum/ezScrum/stargazers","contributors_url":"https://api.github.com/repos/ezScrum/ezScrum/contributors","subscribers_url":"https://api.github.com/repos/ezScrum/ezScrum/subscribers","subscription_url":"https://api.github.com/repos/ezScrum/ezScrum/subscription","commits_url":"https://api.github.com/repos/ezScrum/ezScrum/commits{/sha}","git_commits_url":"https://api.github.com/repos/ezScrum/ezScrum/git/commits{/sha}","comments_url":"https://api.github.com/repos/ezScrum/ezScrum/comments{/number}","issue_comment_url":"https://api.github.com/repos/ezScrum/ezScrum/issues/comments/{number}","contents_url":"https://api.github.com/repos/ezScrum/ezScrum/contents/{+path}","compare_url":"https://api.github.com/repos/ezScrum/ezScrum/compare/{base}...{head}","merges_url":"https://api.github.com/repos/ezScrum/ezScrum/merges","archive_url":"https://api.github.com/repos/ezScrum/ezScrum/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/ezScrum/ezScrum/downloads","issues_url":"https://api.github.com/repos/ezScrum/ezScrum/issues{/number}","pulls_url":"https://api.github.com/repos/ezScrum/ezScrum/pulls{/number}","milestones_url":"https://api.github.com/repos/ezScrum/ezScrum/milestones{/number}","notifications_url":"https://api.github.com/repos/ezScrum/ezScrum/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/ezScrum/ezScrum/labels{/name}","releases_url":"https://api.github.com/repos/ezScrum/ezScrum/releases{/id}","created_at":"2013-10-29T08:16:22Z","updated_at":"2014-11-13T08:04:38Z","pushed_at":"2015-01-28T06:27:02Z","git_url":"git://github.com/ezScrum/ezScrum.git","ssh_url":"git@github.com:ezScrum/ezScrum.git","clone_url":"https://github.com/ezScrum/ezScrum.git","svn_url":"https://github.com/ezScrum/ezScrum","homepage":"","size":103819,"stargazers_count":5,"watchers_count":5,"language":"JavaScript","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":3,"mirror_url":null,"open_issues_count":8,"forks":3,"open_issues":8,"watchers":5,"default_branch":"master"}},"base":{"label":"ezScrum:story_7103_new","ref":"story_7103_new","sha":"730664c1c53fc7a94e0527b2cce10664828f02c8","user":{"login":"ezScrum","id":5744174,"avatar_url":"https://avatars.githubusercontent.com/u/5744174?v=3","gravatar_id":"","url":"https://api.github.com/users/ezScrum","html_url":"https://github.com/ezScrum","followers_url":"https://api.github.com/users/ezScrum/followers","following_url":"https://api.github.com/users/ezScrum/following{/other_user}","gists_url":"https://api.github.com/users/ezScrum/gists{/gist_id}","starred_url":"https://api.github.com/users/ezScrum/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ezScrum/subscriptions","organizations_url":"https://api.github.com/users/ezScrum/orgs","repos_url":"https://api.github.com/users/ezScrum/repos","events_url":"https://api.github.com/users/ezScrum/events{/privacy}","received_events_url":"https://api.github.com/users/ezScrum/received_events","type":"Organization","site_admin":false},"repo":{"id":13950021,"name":"ezScrum","full_name":"ezScrum/ezScrum","owner":{"login":"ezScrum","id":5744174,"avatar_url":"https://avatars.githubusercontent.com/u/5744174?v=3","gravatar_id":"","url":"https://api.github.com/users/ezScrum","html_url":"https://github.com/ezScrum","followers_url":"https://api.github.com/users/ezScrum/followers","following_url":"https://api.github.com/users/ezScrum/following{/other_user}","gists_url":"https://api.github.com/users/ezScrum/gists{/gist_id}","starred_url":"https://api.github.com/users/ezScrum/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ezScrum/subscriptions","organizations_url":"https://api.github.com/users/ezScrum/orgs","repos_url":"https://api.github.com/users/ezScrum/repos","events_url":"https://api.github.com/users/ezScrum/events{/privacy}","received_events_url":"https://api.github.com/users/ezScrum/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/ezScrum/ezScrum","description":"An open source project for scrum","fork":false,"url":"https://api.github.com/repos/ezScrum/ezScrum","forks_url":"https://api.github.com/repos/ezScrum/ezScrum/forks","keys_url":"https://api.github.com/repos/ezScrum/ezScrum/keys{/key_id}","collaborators_url":"https://api.github.com/repos/ezScrum/ezScrum/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/ezScrum/ezScrum/teams","hooks_url":"https://api.github.com/repos/ezScrum/ezScrum/hooks","issue_events_url":"https://api.github.com/repos/ezScrum/ezScrum/issues/events{/number}","events_url":"https://api.github.com/repos/ezScrum/ezScrum/events","assignees_url":"https://api.github.com/repos/ezScrum/ezScrum/assignees{/user}","branches_url":"https://api.github.com/repos/ezScrum/ezScrum/branches{/branch}","tags_url":"https://api.github.com/repos/ezScrum/ezScrum/tags","blobs_url":"https://api.github.com/repos/ezScrum/ezScrum/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/ezScrum/ezScrum/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/ezScrum/ezScrum/git/refs{/sha}","trees_url":"https://api.github.com/repos/ezScrum/ezScrum/git/trees{/sha}","statuses_url":"https://api.github.com/repos/ezScrum/ezScrum/statuses/{sha}","languages_url":"https://api.github.com/repos/ezScrum/ezScrum/languages","stargazers_url":"https://api.github.com/repos/ezScrum/ezScrum/stargazers","contributors_url":"https://api.github.com/repos/ezScrum/ezScrum/contributors","subscribers_url":"https://api.github.com/repos/ezScrum/ezScrum/subscribers","subscription_url":"https://api.github.com/repos/ezScrum/ezScrum/subscription","commits_url":"https://api.github.com/repos/ezScrum/ezScrum/commits{/sha}","git_commits_url":"https://api.github.com/repos/ezScrum/ezScrum/git/commits{/sha}","comments_url":"https://api.github.com/repos/ezScrum/ezScrum/comments{/number}","issue_comment_url":"https://api.github.com/repos/ezScrum/ezScrum/issues/comments/{number}","contents_url":"https://api.github.com/repos/ezScrum/ezScrum/contents/{+path}","compare_url":"https://api.github.com/repos/ezScrum/ezScrum/compare/{base}...{head}","merges_url":"https://api.github.com/repos/ezScrum/ezScrum/merges","archive_url":"https://api.github.com/repos/ezScrum/ezScrum/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/ezScrum/ezScrum/downloads","issues_url":"https://api.github.com/repos/ezScrum/ezScrum/issues{/number}","pulls_url":"https://api.github.com/repos/ezScrum/ezScrum/pulls{/number}","milestones_url":"https://api.github.com/repos/ezScrum/ezScrum/milestones{/number}","notifications_url":"https://api.github.com/repos/ezScrum/ezScrum/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/ezScrum/ezScrum/labels{/name}","releases_url":"https://api.github.com/repos/ezScrum/ezScrum/releases{/id}","created_at":"2013-10-29T08:16:22Z","updated_at":"2014-11-13T08:04:38Z","pushed_at":"2015-01-28T06:27:02Z","git_url":"git://github.com/ezScrum/ezScrum.git","ssh_url":"git@github.com:ezScrum/ezScrum.git","clone_url":"https://github.com/ezScrum/ezScrum.git","svn_url":"https://github.com/ezScrum/ezScrum","homepage":"","size":103819,"stargazers_count":5,"watchers_count":5,"language":"JavaScript","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":3,"mirror_url":null,"open_issues_count":8,"forks":3,"open_issues":8,"watchers":5,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/ezScrum/ezScrum/pulls/51"},"html":{"href":"https://github.com/ezScrum/ezScrum/pull/51"},"issue":{"href":"https://api.github.com/repos/ezScrum/ezScrum/issues/51"},"comments":{"href":"https://api.github.com/repos/ezScrum/ezScrum/issues/51/comments"},"review_comments":{"href":"https://api.github.com/repos/ezScrum/ezScrum/pulls/51/comments"},"review_comment":{"href":"https://api.github.com/repos/ezScrum/ezScrum/pulls/comments/{number}"},"commits":{"href":"https://api.github.com/repos/ezScrum/ezScrum/pulls/51/commits"},"statuses":{"href":"https://api.github.com/repos/ezScrum/ezScrum/statuses/b931485c78c8e5d4957112e213ae15721ea9b813"}}}}