Package org.milowski.db

Examples of org.milowski.db.DBConnection

1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
  
   public User findUserByEmail(final String email)
      throws SQLException
   {
      final Slot<User> user = new Slot<User>();
      final DBConnection connection = getConnection();
      try {
         connection.query(USER_BY_EMAIL, new DBQueryHandler() {
            public void prepare(PreparedStatement s)
               throws SQLException
            {
               s.setString(1, email);
            }
View Full Code Here
1059
1060
1061
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
  
   public Iterator<User> getUsers(boolean all)
      throws SQLException
   {
      final Slot<Iterator<User>> result = new Slot<Iterator<User>>();
      final DBConnection connection = getConnection();
      try {
         connection.query(all ? USERS : GLOBAL_USERS, new DBQueryHandler() {
            public boolean shouldClose() { return false; }
            public void onResults(ResultSet set)
               throws SQLException
            {
               result.set(new DBIterator<User>(set,new DBResultConstructor<User>() {
View Full Code Here
1088
1089
1090
1091
1092
1093
1094
1095
1096
1097
1098
1099
1100
   {
      DBCache<UUID,Group> cache = realmGroupCaches.get(realm);
      if (cache.getNamed(alias)!=null) {
         return null;
      }
      DBConnection connection = getConnection();
      try {
         int id = connection.create(CREATE_GROUP,LAST_ID_FROM_GROUPS, new DBUpdateHandler() {
            public void prepare(PreparedStatement s)
               throws SQLException
            {
               s.setInt(1,realm.getId());
               s.setString(2,uuid.toString());
View Full Code Here
1123
1124
1125
1126
1127
1128
1129
1130
1131
1132
1133
1134
1135
   public Iterator<Group> getGroups(final Realm realm)
      throws SQLException
   {
      final Slot<Iterator<Group>> result = new Slot<Iterator<Group>>();
      final DBCache<UUID,Group> cache = realmGroupCaches.get(realm);
      final DBConnection connection = getConnection();
      try {
         connection.query(GROUPS, new DBQueryHandler() {
            public boolean shouldClose() { return false; }
            public void prepare(PreparedStatement s)
               throws SQLException
            {
               s.setInt(1,realm.getId());
View Full Code Here
1157
1158
1159
1160
1161
1162
1163
1164
1165
1166
1167
1168
1169
1170
1171
1172
1173
1174
1175
1176
1177
1178
1179
1180
1181
1182
1183
1184
1185
1186
1187
1188
1189
1190
1191
1192
1193
1194
1195
1196
1197
1198
1199
1200
1201
1202
1203
1204
1205
1206
1207
1208
1209
1210
1211
   {
      // Check for realm conflicts with specified alias
      final Slot<Boolean> found = new Slot<Boolean>(false);
      if (alias!=null) {
         // check realm against alias
         DBConnection connection = getConnection();
         try {
            connection.query(REALM_USER_BY_ALIAS, new DBQueryHandler() {
               public void prepare(PreparedStatement s)
                  throws SQLException
               {
                  s.setInt(1,realm.getId());
                  s.setString(2,alias);
               }
               public void onResults(ResultSet set)
                  throws SQLException
               {
                  found.set(set.next());
               }
            });
            if (found.get()) {
               return false;
            }
            // check inherited aliases
            connection.query(REALM_USER_HAS_INHERITED_ALIAS, new DBQueryHandler() {
               public void prepare(PreparedStatement s)
                  throws SQLException
               {
                  s.setInt(1,realm.getId());
                  s.setString(2,alias);
               }
               public void onResults(ResultSet set)
                  throws SQLException
               {
                  found.set(set.next());
               }
            });
            if (found.get()) {
               return false;
            }
         } finally {
            release(connection);
         }
      }
      //
      if (alias==null) {
         // Check inherited alias against local aliases
         DBConnection connection = getConnection();
         try {
            connection.query(REALM_USER_BY_ALIAS, new DBQueryHandler() {
               public void prepare(PreparedStatement s)
                  throws SQLException
               {
                  s.setInt(1,realm.getId());
                  s.setString(2,user.getAlias());
View Full Code Here
1231
1232
1233
1234
1235
1236
1237
1238
1239
1240
1241
1242
1243
   {
      if (!isRealmUserAliasAvailable(realm,user,alias)) {
         return null;
      }
      final Timestamp tstamp = new Timestamp((new Date()).getTime());
      DBConnection connection = getConnection();
      try {
         int id = connection.create(CREATE_REALM_USER,LAST_ID_FROM_REALM_USERS, new DBUpdateHandler() {
            public void prepare(PreparedStatement s)
               throws SQLException
            {
               s.setInt(1,realm.getId());
               s.setInt(2,user.getId());
View Full Code Here
1289
1290
1291
1292
1293
1294
1295
1296
1297
1298
1299
1300
1301
1302
1303
1304
1305
1306
1307
1308
1309
1310
1311
1312
1313
1314
1315
1316
1317
1318
1319
1320
1321
  
   public RealmUser findRealmUserByEmail(final Realm realm,final String email)
      throws SQLException
   {
      final Slot<RealmUser> ruser = new Slot<RealmUser>();
      final DBConnection connection = getConnection();
      try {
         connection.query(REALM_USER_BY_EMAIL, new DBQueryHandler() {
            public void prepare(PreparedStatement s)
               throws SQLException
            {
               s.setInt(1,realm.getId());
               s.setString(2, email);
            }
            public void onResults(ResultSet set)
               throws SQLException
            {
               if (set.next()) {
                  ruser.set(realmUserCaches.get(realm).get(set.getInt(1)));
               }
            }
         });
         if (ruser.get()!=null) {
            return ruser.get();
         }
         final User user = findUserByEmail(email);
         if (user!=null) {
            connection.query(REALM_USER_BY_USER, new DBQueryHandler() {
               public void prepare(PreparedStatement s)
                  throws SQLException
               {
                  s.setInt(1,realm.getId());
                  s.setInt(2, user.getId());
View Full Code Here
1346
1347
1348
1349
1350
1351
1352
1353
1354
1355
1356
1357
1358
   public Iterator<RealmUser> getRealmUsers(final Realm realm)
      throws SQLException
   {
      final DBCache<UUID,RealmUser> cache = realmUserCaches.get(realm);
      final Slot<Iterator<RealmUser>> result = new Slot<Iterator<RealmUser>>();
      final DBConnection connection = getConnection();
      try {
         connection.query(REALM_USERS, new DBQueryHandler() {
            public boolean shouldClose() { return false; }
            public void prepare(PreparedStatement s)
               throws SQLException
            {
               s.setInt(1,realm.getId());
View Full Code Here
1381
1382
1383
1384
1385
1386
1387
1388
1389
1390
1391
1392
1393
    */
   public User.Authenticated isAuthenticated(final Realm realm,final UUID session)
      throws SQLException
   {
      final Slot<User.Authenticated> retval = new Slot<User.Authenticated>();
      DBConnection connection = getConnection();
      try {
         connection.query(USER_SESSION, new DBQueryHandler() {
            public void prepare(PreparedStatement s)
               throws SQLException
            {
               s.setString(1,session.toString());
            }
View Full Code Here
1418
1419
1420
1421
1422
1423
1424
1425
1426
1427
1428
1429
1430
   }
  
   public void expireSession(final UUID session)
      throws SQLException
   {
      DBConnection connection = getConnection();
      try {
         connection.update(DELETE_SESSION, new DBUpdateHandler() {
            public void prepare(PreparedStatement s)
               throws SQLException
            {
               s.setString(1,session.toString());
            }
View Full Code Here
TOP

Related Classes of org.milowski.db.DBConnection

  • org.atomojo.auth.service.db.AuthDB
  • org.atomojo.auth.service.db.AuthDB$GroupCache
  • org.atomojo.auth.service.db.AuthDB$RealmUserCache
  • org.atomojo.auth.service.db.Group
  • org.atomojo.auth.service.db.Permission
  • org.atomojo.auth.service.db.Realm
  • org.atomojo.auth.service.db.RealmUser
  • org.atomojo.auth.service.db.Role
  • org.atomojo.auth.service.db.User
  • org.atomojo.auth.service.db.User$Authenticated
    • 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.