org.skife.jdbi.v2.Query.cleanupHandle()方法的使用及代码示例

x33g5p2x  于2022-01-28 转载在 其他  
字(10.0k)|赞(0)|评价(0)|浏览(138)

本文整理了Java中org.skife.jdbi.v2.Query.cleanupHandle方法的一些代码示例，展示了Query.cleanupHandle的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台，是从一些精选项目中提取出来的代码，具有较强的参考意义，能在一定程度帮忙到你。Query.cleanupHandle方法的具体详情如下：
包路径：org.skife.jdbi.v2.Query
类名称：Query
方法名：cleanupHandle

Query.cleanupHandle介绍

暂无

代码示例

代码示例来源：origin: org.jdbi/jdbi

  1. @Test
  2. public void testNonPathologicalJustNext() throws Exception {
  3.   h.createStatement("insert into something (id, name) values (1, 'eric')").execute();
  4.   // Yes, you *should* use first(). But sometimes, an iterator is passed 17 levels deep and then
  5.   // used in this way (Hello Jackson!).
  6.   final Map<String, Object> result = h.createQuery("select * from something order by id")
  7.     .cleanupHandle()
  8.     .iterator()
  9.     .next();
  10.   assertEquals(1, result.get("id"));
  11.   assertEquals("eric", result.get("name"));
  12. }

代码示例来源：origin: org.kill-bill.commons/killbill-jdbi

  1. @Test
  2. public void testNonPathologicalJustNext() throws Exception {
  3.   h.createStatement("insert into something (id, name) values (1, 'eric')").execute();
  4.   // Yes, you *should* use first(). But sometimes, an iterator is passed 17 levels deep and then
  5.   // used in this way (Hello Jackson!).
  6.   final Map<String, Object> result = h.createQuery("select * from something order by id")
  7.     .cleanupHandle()
  8.     .iterator()
  9.     .next();
  10.   assertEquals(1, result.get("id"));
  11.   assertEquals("eric", result.get("name"));
  12. }

代码示例来源：origin: org.jdbi/jdbi

  1. @Test
  2. public void testClosing() throws Exception {
  3.   h.createStatement("insert into something (id, name) values (1, 'eric')").execute();
  4.   h.createStatement("insert into something (id, name) values (2, 'brian')").execute();
  5.   List<Map<String, Object>> results = h.createQuery("select * from something order by id")
  6.     .cleanupHandle()
  7.     .list();
  8.   assertEquals(2, results.size());
  9.   Map<String, Object> first_row = results.get(0);
  10.   assertEquals("eric", first_row.get("name"));
  11.   assertTrue(h.isClosed());
  12. }

代码示例来源：origin: org.jdbi/jdbi

  1. @Test
  2. public void testEmptyWorksToo() throws Exception {
  3.   ResultIterator<Map<String, Object>> it = h.createQuery("select * from something order by id")
  4.     .cleanupHandle()
  5.     .iterator();
  6.   assertFalse(it.hasNext());
  7. }

代码示例来源：origin: org.kill-bill.commons/killbill-jdbi

  1. @Test
  2. public void testClosing() throws Exception {
  3.   h.createStatement("insert into something (id, name) values (1, 'eric')").execute();
  4.   h.createStatement("insert into something (id, name) values (2, 'brian')").execute();
  5.   List<Map<String, Object>> results = h.createQuery("select * from something order by id")
  6.     .cleanupHandle()
  7.     .list();
  8.   assertEquals(2, results.size());
  9.   Map<String, Object> first_row = results.get(0);
  10.   assertEquals("eric", first_row.get("name"));
  11.   assertTrue(h.isClosed());
  12. }

代码示例来源：origin: org.jdbi/jdbi

  1. @Test
  2. public void testEmptyExplosion() throws Exception {
  3.   ResultIterator<Map<String, Object>> it = h.createQuery("select * from something order by id")
  4.     .cleanupHandle()
  5.     .iterator();
  6.   try {
  7.     it.next();
  8.     fail("Expected IllegalStateException did not show up!");
  9.   }
  10.   catch (IllegalStateException iae) {
  11.     // TestCase does not deal with the annotations...
  12.   }
  13. }

代码示例来源：origin: org.kill-bill.commons/killbill-jdbi

  1. @Test
  2. public void testEmptyWorksToo() throws Exception {
  3.   ResultIterator<Map<String, Object>> it = h.createQuery("select * from something order by id")
  4.     .cleanupHandle()
  5.     .iterator();
  6.   assertFalse(it.hasNext());
  7. }

代码示例来源：origin: org.kill-bill.commons/killbill-jdbi

  1. @Test
  2. public void testEmptyExplosion() throws Exception {
  3.   ResultIterator<Map<String, Object>> it = h.createQuery("select * from something order by id")
  4.     .cleanupHandle()
  5.     .iterator();
  6.   try {
  7.     it.next();
  8.     fail("Expected IllegalStateException did not show up!");
  9.   }
  10.   catch (IllegalStateException iae) {
  11.     // TestCase does not deal with the annotations...
  12.   }
  13. }

代码示例来源：origin: org.kill-bill.commons/killbill-jdbi

  1. @Test
  2. public void testBasicCleanupIterator()
  3.   throws Exception
  4. {
  5.   final Handle handle = dbi.open();
  6.   final Query<Integer> q = handle.createQuery("SELECT COUNT(1) FROM something")
  7.     .cleanupHandle()
  8.     .map(IntegerMapper.FIRST);
  9.   final ResultIterator<Integer> it = q.iterator();
  10.   assertEquals(COUNT, Iterators.getOnlyElement(it).intValue());
  11.   assertFalse(it.hasNext());
  12.   assertTrue(handle.getConnection().isClosed());
  13. }

代码示例来源：origin: org.jdbi/jdbi

  1. @Test
  2. public void testBasicCleanupIterator()
  3.   throws Exception
  4. {
  5.   final Handle handle = dbi.open();
  6.   final Query<Integer> q = handle.createQuery("SELECT COUNT(1) FROM something")
  7.     .cleanupHandle()
  8.     .mapTo(Integer.class);
  9.   final ResultIterator<Integer> it = q.iterator();
  10.   assertEquals(COUNT, Iterators.getOnlyElement(it).intValue());
  11.   assertFalse(it.hasNext());
  12.   assertTrue(handle.getConnection().isClosed());
  13. }

代码示例来源：origin: org.jdbi/jdbi

  1. @Test
  2. public void testJustNext() throws Exception {
  3.   h.createStatement("insert into something (id, name) values (1, 'eric')").execute();
  4.   h.createStatement("insert into something (id, name) values (2, 'brian')").execute();
  5.   h.createStatement("insert into something (id, name) values (3, 'john')").execute();
  6.   ResultIterator<Map<String, Object>> it = h.createQuery("select * from something order by id")
  7.     .cleanupHandle()
  8.     .iterator();
  9.   it.next();
  10.   it.next();
  11.   it.next();
  12. }

代码示例来源：origin: org.kill-bill.commons/killbill-jdbi

  1. @Test
  2. public void testJustNext() throws Exception {
  3.   h.createStatement("insert into something (id, name) values (1, 'eric')").execute();
  4.   h.createStatement("insert into something (id, name) values (2, 'brian')").execute();
  5.   h.createStatement("insert into something (id, name) values (3, 'john')").execute();
  6.   ResultIterator<Map<String, Object>> it = h.createQuery("select * from something order by id")
  7.     .cleanupHandle()
  8.     .iterator();
  9.   it.next();
  10.   it.next();
  11.   it.next();
  12. }

代码示例来源：origin: org.jdbi/jdbi

  1. @Test
  2. public void testIterateAllTheWay() throws Exception {
  3.   h.createStatement("insert into something (id, name) values (1, 'eric')").execute();
  4.   h.createStatement("insert into something (id, name) values (2, 'brian')").execute();
  5.   ResultIterator<Map<String, Object>> it = h.createQuery("select * from something order by id")
  6.     .cleanupHandle()
  7.     .iterator();
  8.   int cnt = 0;
  9.   while(it.hasNext()) {
  10.     cnt++;
  11.     it.next();
  12.   }
  13.   assertEquals(2, cnt);
  14.   assertTrue(h.isClosed());
  15. }

代码示例来源：origin: org.kill-bill.commons/killbill-jdbi

  1. @Test
  2. public void testIterateAllTheWay() throws Exception {
  3.   h.createStatement("insert into something (id, name) values (1, 'eric')").execute();
  4.   h.createStatement("insert into something (id, name) values (2, 'brian')").execute();
  5.   ResultIterator<Map<String, Object>> it = h.createQuery("select * from something order by id")
  6.     .cleanupHandle()
  7.     .iterator();
  8.   int cnt = 0;
  9.   while(it.hasNext()) {
  10.     cnt++;
  11.     it.next();
  12.   }
  13.   assertEquals(2, cnt);
  14.   assertTrue(h.isClosed());
  15. }

代码示例来源：origin: org.jdbi/jdbi

  1. @Test
  2. public void testNext() throws Exception {
  3.   h.createStatement("insert into something (id, name) values (1, 'eric')").execute();
  4.   h.createStatement("insert into something (id, name) values (2, 'brian')").execute();
  5.   h.createStatement("insert into something (id, name) values (3, 'john')").execute();
  6.   ResultIterator<Map<String, Object>> it = h.createQuery("select * from something order by id")
  7.     .cleanupHandle()
  8.     .iterator();
  9.   assertTrue(it.hasNext());
  10.   it.next();
  11.   it.next();
  12.   it.next();
  13.   assertFalse(it.hasNext());
  14. }

代码示例来源：origin: org.kill-bill.commons/killbill-jdbi

  1. @Test
  2. public void testNext() throws Exception {
  3.   h.createStatement("insert into something (id, name) values (1, 'eric')").execute();
  4.   h.createStatement("insert into something (id, name) values (2, 'brian')").execute();
  5.   h.createStatement("insert into something (id, name) values (3, 'john')").execute();
  6.   ResultIterator<Map<String, Object>> it = h.createQuery("select * from something order by id")
  7.     .cleanupHandle()
  8.     .iterator();
  9.   assertTrue(it.hasNext());
  10.   it.next();
  11.   it.next();
  12.   it.next();
  13.   assertFalse(it.hasNext());
  14. }

代码示例来源：origin: org.jdbi/jdbi

  1. @Test
  2. public void testTwoOne() throws Exception {
  3.   h.createStatement("insert into something (id, name) values (1, 'eric')").execute();
  4.   h.createStatement("insert into something (id, name) values (2, 'brian')").execute();
  5.   h.createStatement("insert into something (id, name) values (3, 'john')").execute();
  6.   ResultIterator<Map<String, Object>> it = h.createQuery("select * from something order by id")
  7.     .cleanupHandle()
  8.     .iterator();
  9.   assertTrue(it.hasNext());
  10.   it.next();
  11.   it.next();
  12.   assertTrue(it.hasNext());
  13.   it.next();
  14.   assertFalse(it.hasNext());
  15. }

代码示例来源：origin: org.kill-bill.commons/killbill-jdbi

  1. @Test
  2. public void testTwoOne() throws Exception {
  3.   h.createStatement("insert into something (id, name) values (1, 'eric')").execute();
  4.   h.createStatement("insert into something (id, name) values (2, 'brian')").execute();
  5.   h.createStatement("insert into something (id, name) values (3, 'john')").execute();
  6.   ResultIterator<Map<String, Object>> it = h.createQuery("select * from something order by id")
  7.     .cleanupHandle()
  8.     .iterator();
  9.   assertTrue(it.hasNext());
  10.   it.next();
  11.   it.next();
  12.   assertTrue(it.hasNext());
  13.   it.next();
  14.   assertFalse(it.hasNext());
  15. }

代码示例来源：origin: org.kill-bill.commons/killbill-jdbi

  1. @Test
  2. public void testTwoTwo() throws Exception {
  3.   h.createStatement("insert into something (id, name) values (1, 'eric')").execute();
  4.   h.createStatement("insert into something (id, name) values (2, 'brian')").execute();
  5.   h.createStatement("insert into something (id, name) values (3, 'john')").execute();
  6.   ResultIterator<Map<String, Object>> it = h.createQuery("select * from something order by id")
  7.     .cleanupHandle()
  8.     .iterator();
  9.   it.next();
  10.   it.next();
  11.   assertTrue(it.hasNext());
  12.   assertTrue(it.hasNext());
  13.   it.next();
  14.   assertFalse(it.hasNext());
  15.   assertFalse(it.hasNext());
  16. }

代码示例来源：origin: org.jdbi/jdbi

  1. @Test
  2. public void testTwoTwo() throws Exception {
  3.   h.createStatement("insert into something (id, name) values (1, 'eric')").execute();
  4.   h.createStatement("insert into something (id, name) values (2, 'brian')").execute();
  5.   h.createStatement("insert into something (id, name) values (3, 'john')").execute();
  6.   ResultIterator<Map<String, Object>> it = h.createQuery("select * from something order by id")
  7.     .cleanupHandle()
  8.     .iterator();
  9.   it.next();
  10.   it.next();
  11.   assertTrue(it.hasNext());
  12.   assertTrue(it.hasNext());
  13.   it.next();
  14.   assertFalse(it.hasNext());
  15.   assertFalse(it.hasNext());
  16. }

内容来源于网络，如有侵权，请联系作者删除！

query

相关文章

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新文章

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com