Package com.pv.sdm.user.db.model

Examples of com.pv.sdm.user.db.model.User

29
30
31
32
33
34
35
36
37
   ////
  
  
   public void buildTest(){
      IUpdateOrmBuilder p = null;
      User u = p.mock(User.class);
      p.execute();
     
   }
View Full Code Here
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
  
   @Test
   public void buildSelect() {
     
      SelectBuilder builder = (SelectBuilder)_annotationFactory.select();
      User user = builder.mock(User.class);
     
      builder.columns(user.getId(), user.getUserName());
     
      builder.and(user.getId(), 1L);
     
      IQuery statment = builder.build();
      Assert.assertEquals(
            "SELECT user.id,user.userName FROM user_mx_14.user WHERE user.id = ?",
            statment.getSql());
View Full Code Here
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
   @Test
   @Ignore
   public void buildSelect_MultiObject() {
     
      SelectBuilder builder = (SelectBuilder)_annotationFactory.select();
      User user = builder.mock(User.class);
     
      builder.columns(user.getId(), user.getUserName());
      builder.and(user.getId(), 1L);
     
      user = builder.mock(User.class);
     
      Assert.assertEquals("pvxuser", user.getUserName());
     
//      Assert.assertEquals("SELECT id FROM user_mx_14.user WHERE  id = ?  ", statment);
//      Assert.assertArrayEquals(new Object[] {1L}, sql.getParameters());
   }
View Full Code Here
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
   }
  
   @Test
   public void columns() {
      SelectBuilder builder = (SelectBuilder)_annotationFactory.select();
      User user = builder.mock(User.class);
     
      builder.columns(user.getId(), user.getUserName());
      Set<ColumnMetadata> columns = builder.getQuery().getColumns();
      Assert.assertEquals(2, columns.size());
      Assert.assertTrue(columns.contains(
            new ColumnMetadata(User.ID)));
      Assert.assertTrue(columns.contains(
            new ColumnMetadata(User.USER_NAME)));
     
      builder.columns(user.getPassword());
      columns = builder.getQuery().getColumns();
      Assert.assertEquals(3, columns.size());
      Assert.assertTrue(columns.contains(
            new ColumnMetadata(User.PASSWORD)));
   }
View Full Code Here
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
  
   @Test
   @Ignore
   public void columnsMultiline() {
      SelectBuilder builder = (SelectBuilder)_annotationFactory.select();
      User user = builder.mock(User.class);
     
      user.getId();
      user.getUserName();
      builder.columns();
     
      Set<ColumnMetadata> columns = builder.getQuery().getColumns();
      Assert.assertEquals(2, columns.size());
      Assert.assertTrue(columns.contains(
            new ColumnMetadata(User.ID)));
      Assert.assertTrue(columns.contains(
            new ColumnMetadata(User.USER_NAME)));
     
      user.getPassword();
      builder.columns();
      columns = builder.getQuery().getColumns();
      Assert.assertEquals(3, columns.size());
      Assert.assertTrue(columns.contains(
            new ColumnMetadata(User.PASSWORD)));
View Full Code Here
136
137
138
139
140
141
142
143
144
145
146
    * settings.
    */
   @Test
   public void columnsEmpty_pass() {
      SelectBuilder builder = (SelectBuilder)_annotationFactory.select();
      User user = builder.mock(User.class);
     
      user = builder.mock(User.class);
     
      builder.columns();
   }
View Full Code Here
151
152
153
154
155
156
157
158
159
160
161
    */
   @Test(expected=IllegalStateException.class)
   @Ignore
   public void columnsEmpty_fail() {
      SelectBuilder builder = (SelectBuilder)_annotationFactory.select();
      User user = builder.mock(User.class);
     
      user = builder.mock(User.class);
     
      builder.columns();
   }
View Full Code Here
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
  
   @Test
   public void columnsOneToOne() {
      SelectBuilder builder = (SelectBuilder)_annotationFactory.select();
      builder.setCascade(Boolean.TRUE);
      User user = builder.mock(User.class);
     
      builder.columns(user.getId(), user.getUserDetails().getEmail());
     
      builder.and(user.getId(), 1L);
     
      IQuery statment = builder.build();
      Assert.assertEquals(
            "SELECT user_details.email,user.id FROM user_mx_14.user_role,user_mx_14.user_details,user_mx_14.user WHERE user_role.userId = ? AND user_details.userId = ? AND user.id = ?",
            statment.getSql());
View Full Code Here
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
  
   @Test
   public void columnsOneToMany() {
      SelectBuilder builder = (SelectBuilder)_annotationFactory.select();
      builder.setCascade(Boolean.TRUE);
      User user = builder.mock(User.class);
      UserRoleTestVO userRole = builder.mock(UserRoleTestVO.class);
//     
      builder.columns(user.getId(), userRole.getRoleId(),
            userRole.getUserId());
     
//      builder.columns(user.getId(),
//            builder.normalize(user.getRoles()).getRoleId(),
//            builder.normalize(user.getRoles()).getUserId());
     
      builder.and(user.getId(), 1L);
     
      IQuery statment = builder.build();
      Assert.assertEquals(
//            "SELECT user_role.roleId,user_role.userId,user.id FROM user_mx_14.user_role,user_mx_14.user WHERE user_role.userId = ? AND user.id = ?",
            "SELECT user.id,user_role.userId,user_role.roleId FROM user_mx_14.user_role,user_mx_14.user_details,user_mx_14.user WHERE user_role.userId = ? AND user_details.userId = ? AND user.id = ?",
View Full Code Here
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
   }
  
   @Test
   public void and() {
      SelectBuilder builder = (SelectBuilder)_annotationFactory.select();
      User user = builder.mock(User.class);
     
      builder.columns(user.getId(), user.getUserName());
     
      builder.and(user.getId(),new Long(1L));
     
      IQuery statment = builder.build();
      Assert.assertEquals(
            "SELECT user.id,user.userName FROM user_mx_14.user WHERE user.id = ?",
            statment.getSql());
View Full Code Here
TOP

Related Classes of com.pv.sdm.user.db.model.User

  • com.pv.mf.db.mock.impl.MockBuilderSettersTest
  • com.pv.mf.db.mock.impl.MockBuilderTest
    • 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.