Package com.bleujin.framework.db.procedure

Examples of com.bleujin.framework.db.procedure.IUserCommand

28
29
30
31
32
33
34
35
36
37
  }
 
  public void testRowsPageMethod2() throws Exception {
    String query = "select * from copy_sample" ;
   
    IUserCommand cmd = dc.createUserCommand(query) ;
    cmd.setPage(Page.create(1, 1)) ;
    Rows rows = cmd.execQuery() ;
    assertEquals(1, rows.getRowCount()) ;
  }
View Full Code Here
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
  }

 
  public void testInsert() throws Exception {
    dc.createUserCommand("truncate table lob_sample") ;
    IUserCommand cmd = dc.createUserCommand("insert into lob_sample(a, b, c, d, e) values(:a, :b, :c, :d, :e)") ;
    cmd.addParam("a", 1) ;
    cmd.addClob("b", "abcdefg") ;
    cmd.addClob("c", FileUtils.readFileToString(k100File, "UTF-8")) ;
    cmd.addBlob("d", new FileInputStream(k100File)) ;
    cmd.addParam("e", "12345") ;
    int result = cmd.execUpdate() ;
   
    assertEquals(1, result) ;
   
    Rows rows = dc.getRows("select a, b, c, d, e from lob_sample where a = 1") ;
   
View Full Code Here
15
16
17
18
19
20
21
22
23
24
25
26
    dc.execUpdate("delete from update_sample") ;
    dc.execUpdate("truncate table performance_sample") ;
  }
 
  public void testNamedParameter() throws Exception {
    IUserCommand cmd = dc.createUserCommand("select * from copy_sample where no1 >= :no1 and no1 <= :no1") ;
    cmd.addParam("no1", 20) ;
   
    Rows rows = cmd.execQuery() ;
    assertEquals(1, rows.getRowCount()) ;
 
  }
View Full Code Here
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
 
  }

  public void testNamedParameterConflict() throws Exception {
    try {
      IUserCommand cmd = dc.createUserCommand("select ':abc' from copy_sample where no1 >= :no1 and no1 <= :no1") ;
      cmd.addParam("no1", 20) ;
      cmd.execQuery() ;
      fail() ;
    } catch (IllegalArgumentException ignore){}

    IUserCommand cmd = dc.createUserCommand("select 'a:1' from copy_sample where no1 >= :no1 and no1 <= :no1") ;
    cmd.addParam("no1", 20) ;

    Rows rows = cmd.execQuery() ;
    assertEquals(1, rows.getRowCount()) ;
  }
View Full Code Here
39
40
41
42
43
44
45
46
47
48
49
50
    Rows rows = cmd.execQuery() ;
    assertEquals(1, rows.getRowCount()) ;
  }

  public void testNamedParameter2() throws Exception {
    IUserCommand cmd = dc.createUserCommand("select * from copy_sample where no1 >= ? and no1 <= :no1") ;
    cmd.addParam(0, 19) ;
    cmd.addParam("no1", 20) ;
   
    Rows rows = cmd.execQuery() ;
    assertEquals(2, rows.getRowCount()) ;
  }
View Full Code Here
53
54
55
56
57
58
59
60
61
62
    Page page = Page.create(10, 1) ;
    assertEquals(0, page.getStartLoc()) ;
  }
 
  public void testDefault() throws Exception {
    IUserCommand cmd = dc.createUserCommand("select * from copy_tblc") ;
    Rows rows = cmd.execQuery();

    assertEquals(true, rows.getRowCount() > 10) ;
  }
View Full Code Here
61
62
63
64
65
66
67
68
69
70
71
    assertEquals(true, rows.getRowCount() > 10) ;
  }


  public void testPage() throws Exception {
    final IUserCommand cmd = dc.createUserCommand("select * from millon_tblt") ;
    cmd.setPage(Page.TEN) ;
    Rows rows = cmd.execQuery();
   
    assertEquals(10, rows.getRowCount()) ;
  } 
View Full Code Here
77
78
79
80
81
82
83
84
85
86
87
    Rows rows = cmd.execQuery();
    assertEquals(10, rows.getRowCount()) ;
  }
 
  public void testHandleBean() throws Exception {
    IUserCommand cmd = dc.createUserCommand("select * from copy_tblc") ;
    cmd.setPage(Page.TEN) ;
   
    List<TestBean> beans =  (List<TestBean>)(cmd.execQuery().toHandle(new BeanListHandler(TestBean.class))) ;
    assertEquals(10, beans.size()) ;
  }
View Full Code Here
104
105
106
107
108
109
110
111
112
113
114
115
    Debug.debug(rows) ;
  }
 
  public void testUserProcedures() throws Exception {
    UserProcedures upts = dc.createUserProcedures("composite") ;
    IUserCommand cmd = dc.createUserCommand("select * from copy_tblc") ;
    cmd.setPage(Page.TEN) ;

    IUserProcedure upt = dc.createUserProcedure("common@testBy()") ;
    upt.setPage(Page.create(10, 2)) ;
   
    upts.add(cmd).add(upt) ;
View Full Code Here
120
121
122
123
124
125
126
127
128
129
130
131
132
133
    Rows nextRows = rows.getNextRows() ;
    assertEquals(10, nextRows.getRowCount()) ;
  }
 
  public void testNextPage() throws Exception {
    IUserCommand cmd = dc.createUserCommand("select * from copy_tblc") ;
    cmd.setPage(Page.TEN) ;

    Rows rows = cmd.execQuery();
    assertEquals(10, rows.getRowCount()) ;
   
   
    Rows nextPageRows = rows.nextPageRows() ;
    assertEquals(11, nextPageRows.firstRow().getInt(2)) ;
View Full Code Here
TOP

Related Classes of com.bleujin.framework.db.procedure.IUserCommand

  • com.bleujin.framework.db.DBController
  • com.bleujin.framework.db.function.TestPage
  • com.bleujin.framework.db.function.TestPlan
  • com.bleujin.framework.db.function.TestUserCommand
  • com.bleujin.framework.db.function.TestUserProcedures
  • com.bleujin.framework.db.mssql.TestFirst
  • com.bleujin.framework.db.mysql.TestFirst
  • com.bleujin.framework.db.mysql.TestPage
  • com.bleujin.framework.db.mysql.TestPlan
  • com.bleujin.framework.db.mysql.TestUserCommand
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.