Having problems getting testSave() and testRemove() methods to work properly
from my CropActionTest class.
For testSave(), I can see the select statement where the Crop object is
getting loaded. When I modify the crop name on the object and attempt to
save, I don't see a subsequent update statement.
For testRemove(), I don't see a delete statement being executed.
Both of the test cases pass, another thing that is disturbing.
The majority of the sql that goes to the console comes from the
onSetUpBeforeTransaction() and onTearDownAfterTransaction() methods.
I have even put breakpoints before the onTearDownAfterTransaction() method
is called and cannot see the database activity performed on the affected
table.
testSave()
[eseed] DEBUG [main] CropActionTest.onSetUpBeforeTransaction(17)
[eseed] DEBUG [main] SQL.log(401) | insert into Crop (crop_name, species)
values (?, ?)
[eseed] DEBUG [main] CropActionTest.startNewTransaction(392) | Began
transaction (1):transaction manager
[org.springframework.orm.hibernate3.hibernatetransactionmana...@c12474];
rollback [true].
[eseed] DEBUG [main] CropActionTest.testSave(66) | initialize
[eseed] DEBUG [main] SQL.log(401) | select this_.cropId as cropId7_0_,
this_.crop_name as crop2_7_0_, this_.species as species7_0_ from Crop crop0_
where crop0_.cropId=?
[eseed] DEBUG [main] CropActionTest.testSave(72) | cropNameOld = Romaine
[eseed] DEBUG [main] CropActionTest.testSave(74) | update crop name and
save
[eseed] DEBUG [main] CropActionTest.testSave(78) | cropNameNew =
ActionSaveCrop
[eseed] DEBUG [main] CropActionTest.endTransaction(360) | Rolled back
transaction after execution of test [testSearch].
[eseed] DEBUG [main] CropActionTest.onTearDownAfterTransaction(35)
[eseed] DEBUG [main] SQL.log(401) | select crop0_.cropId as cropId7_0_,
crop0_.crop_name as crop2_7_0_, from Crop crop0_ where crop0_.cropId=?
[eseed] DEBUG [main] SQL.log(401) | delete from Crop where cropId=?
testRemove()
[eseed] DEBUG [main] CropActionTest.onSetUpBeforeTransaction(17)
[eseed] DEBUG [main] SQL.log(401) | insert into Crop (crop_name, species)
values (?, ?)
[eseed] DEBUG [main] CropActionTest.startNewTransaction(392) | Began
transaction (1): transaction manager
[org.springframework.orm.hibernate3.hibernatetransactionmana...@c713d2];
rollback [true].
[eseed] DEBUG [main] CropActionTest.testRemove(85) - initialize
[eseed] DEBUG [main] CropActionTest.testRemove(100) - delete crop
[eseed] DEBUG [main] SQL.log(401) | select crop0_.cropId as cropId7_0_,
crop0_.crop_name as crop2_7_0_, crop0_.species as species7_0_ from Crop
crop0_ where crop0_.cropId=?
[eseed] DEBUG [main] CropActionTest.endTransaction(360) | Rolled back
transaction after execution of test [testRemove].
[eseed] DEBUG [main] CropActionTest.onTearDownAfterTransaction(35) |
CropActionTest = onTearDownAfterTransaction
[eseed] DEBUG [main] SQL.log(401) | select crop0_.cropId as cropId7_0_,
crop0_.crop_name as crop2_7_0_, crop0_.species as species7_0_ from Crop
crop0_ where crop0_.cropId=?
[eseed] DEBUG [main] SQL.log(401) | delete from Crop where cropId=?
Here is the CropActionTest code. I would have expected to see an update and
select statements for testSave() along with select and remove statements
with testRemove().
public void testSave() throws Exception {
log.debug("initialize");
MockHttpServletRequest request = new MockHttpServletRequest();
ServletActionContext.setRequest(request);
action.setCropId(1L);
assertEquals("success", action.edit());
assertNotNull(action.getCrop());
log.debug("cropNameOld = " + action.getCrop().getCropName());
log.debug("update crop name and save");
action.getCrop().setCropName("ActionSaveCrop");
assertEquals("input", action.save());
assertEquals("ActionSaveCrop", action.getCrop().getCropName());
log.debug("cropNameNew = " + action.getCrop().getCropName());
assertFalse(action.hasActionErrors());
assertFalse(action.hasFieldErrors());
assertNotNull(request.getSession().getAttribute("messages"));
}
public void testRemove() throws Exception {
log.debug("initialize");
MockHttpServletRequest request = new MockHttpServletRequest();
ServletActionContext.setRequest(request);
log.debug("delete crop");
action.setDelete("");
Crop crop = new Crop();
crop.setCropId(2L);
action.setCrop(crop);
assertEquals("success", action.delete());
assertNotNull(request.getSession().getAttribute("messages"));
}
How come my update and delete queries aren't getting executed. Thanks in
advance.
--
View this message in context:
http://www.nabble.com/ActionTest---Not-executing-sql-queries-on-Action.class-tp23680254s2369p23680254.html
Sent from the AppFuse - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@appfuse.dev.java.net
For additional commands, e-mail: users-h...@appfuse.dev.java.net
