Package gwtappcontainer.shared.apps.insight

Examples of gwtappcontainer.shared.apps.insight.Center

28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
        if (centerId == 0)
          sql = "select center_id, center from centers where center = ?";
        else
          sql = "select center_id, center from centers where center_id = ?";
          
            Center center = null;
          
            try (Connection connection = DriverManager.getConnection(Utils.getCloudSqlURL())) {
                  
                try (PreparedStatement ps = connection.prepareStatement(sql)) {
                   
                  if (centerId == 0)
                    ps.setString(1, centerName.toLowerCase());
                  else
                    ps.setLong(1, centerId);
                  
                    try (ResultSet resultSet = ps.executeQuery()) {                                       
                        while (resultSet.next()) {
                            center = new Center();
                            center.id = resultSet.getInt(1);
                            center.name = resultSet.getString(2);
                        }
                    }
                }
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
               
                 ps.executeUpdate();                                   
             }
         }
       
         Center center = get(centerName);       
         return center;
           
     } catch (Exception ex) {
         throw new RuntimeException(ex);
     }             
View Full Code Here
85
86
87
88
89
90
91
92
93
94
95
     }             
   }

  public static void delete(String centerName) {
        
       Center center = get(centerName);
     
       if (null == center)
           throw new APIException(Status.ERROR_RESOURCE_DOES_NOT_EXIST,
                           "Center [" + centerName + "] does not exist");
                                             
View Full Code Here
120
121
122
123
124
125
126
127
128
129
130
                            
              try (PreparedStatement ps = connection.prepareStatement(sql)) {                                     
                
                  try (ResultSet resultSet = ps.executeQuery()) {                                       
                      while (resultSet.next()) {
                          Center center = new Center();
                          center.id = resultSet.getInt(1);
                          center.name = resultSet.getString(2);
                         
                          centers.add(center);
                      }
View Full Code Here
96
97
98
99
100
101
102
103
104
105
106
            try (PreparedStatement ps = connection.prepareStatement(sql)) {  
              ps.setLong(1, member.id);
              
                try (ResultSet resultSet = ps.executeQuery()) {                                       
                    while (resultSet.next()) {
                       Center center = new Center();
                       center.id = resultSet.getInt(1);
                       center.name = resultSet.getString(2);
                      
                       boolean owningCenter = resultSet.getBoolean(3);
                       if (owningCenter)
View Full Code Here
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
    helper.tearDown();
  }
 
  @Test
  public void getTest() {
    Center sgp = CenterRepository.add("singapore");
   
    ContactDetails contactDetails = new ContactDetails();
    contactDetails.firstName = "sathya";
    contactDetails.email = "sathya.t@ishafoundation.org";
   
    MemberRepository.add(contactDetails, sgp.id, SUPER_USER);
   
    Member member = MemberRepository.get("sathya.t@ishafoundation.org", "sathya.t@ishafoundation.org");
       
    assertTrue(member != null);
    assertTrue(member.id != 0);
    assertTrue(member.contactDetails.firstName.equals("sathya"));
    assertTrue(member.contactDetails.email.equals("sathya.t@ishafoundation.org"));
    assertTrue(member.owningCenter.id == sgp.id);
    assertTrue(member.owningCenter.name.equals("singapore"));
   
    //cannot get by non existant email or id
    assertTrue(null == MemberRepository.get("nonexistant@email.com", SUPER_USER));
    assertTrue(null == MemberRepository.get(1093890, SUPER_USER));
   
    Center penang = CenterRepository.add("penang");
    Center kl = CenterRepository.add("kl");
    MemberRepository.addCenter(member.id, penang.id, USER_WITH_EDITMEMBER_PRIVILEGE);
    MemberRepository.addCenter(member.id, kl.id, USER_WITH_EDITMEMBER_PRIVILEGE);
   
    member = MemberRepository.get(member.id, SUPER_USER);
    assertTrue(member.id != 0);
View Full Code Here
107
108
109
110
111
112
113
114
115
116
117
    member = MemberRepository.get("sathya.t@ishafoundation.org", "sathya.t@ishafoundation.org");
  }
 
  @Test
  public void addTest() {
    Center sgp = CenterRepository.add("singapore");
   
    ContactDetails contactDetails = new ContactDetails();
    contactDetails.firstName = "sathya";   
    contactDetails.email = "invalid email";
   
View Full Code Here
168
169
170
171
172
173
174
175
176
177
178
    //no exception
  }
 
  @Test
  public void updateContactDetailsTest() {
    Center sgp = CenterRepository.add("singapore");
   
    ContactDetails contactDetails = new ContactDetails();
    contactDetails.firstName = "sathya";
    contactDetails.email = "sathya.isha@gmail.com";       
   
View Full Code Here
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
  }
 
  @Test
  public void addCenterTest() {
    CenterRepository.add("sgp");
    Center sgp = CenterRepository.get("sgp");
    CenterRepository.add("kl");
    Center kl = CenterRepository.get("kl");
    CenterRepository.add("penang");
    Center penang = CenterRepository.get("penang");
   
    ContactDetails contactDetails = new ContactDetails();
    contactDetails.firstName = "sathya";
    contactDetails.email = "sathya.t@ishafoundation.org";
   
View Full Code Here
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
 
  @Test
  public void deleteCenterTest() {

    CenterRepository.add("singapore");
    Center sgp = CenterRepository.get("singapore");
    CenterRepository.add("kl");
    Center kl = CenterRepository.get("kl");
    CenterRepository.add("penang");
    Center penang = CenterRepository.get("penang");
   
    ContactDetails contactDetails = new ContactDetails();
    contactDetails.firstName = "sathya";   
    contactDetails.email = "sathya.t@ishafoundation.org";
   
View Full Code Here
TOP

Related Classes of gwtappcontainer.shared.apps.insight.Center

  • gwtappcontainer.server.apps.insight.CenterRepository
  • gwtappcontainer.server.apps.insight.CenterRepositoryTest
  • gwtappcontainer.server.apps.insight.MemberRepository
  • gwtappcontainer.server.apps.insight.MemberRepositoryTest
    • 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.