Package org.milowski.db

Examples of org.milowski.db.DBQueryHandler

47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
   {
      final DBCache<UUID,Group> groupCache = db.realmGroupCaches.get(this);
      final DBCache<UUID,RealmUser> userCache = db.realmUserCaches.get(this);
      DBConnection connection = db.getConnection();
      try {
         connection.query(AuthDB.GROUP_BY_REALM,new DBQueryHandler() {
            public void prepare(PreparedStatement s)
               throws SQLException
            {
               s.setInt(1,id);
            }
            public void onResults(ResultSet set)
               throws SQLException
            {
               while (set.next()) {
                  Group group = groupCache.get(set.getInt(1));
                  group.delete();
               }
            }
         });
         connection.query(AuthDB.REALM_USER_BY_REALM,new DBQueryHandler() {
            public void prepare(PreparedStatement s)
               throws SQLException
            {
               s.setInt(1,id);
            }
View Full Code Here
113
114
115
116
117
118
119
120
121
122
123
      DBConnection connection = db.getConnection();
      try {
         connection.deleteById(AuthDB.DELETE_USER_ROLES_BY_USER, id);
         connection.deleteById(AuthDB.DELETE_AUTHENTICATION_BY_USER, id);
         connection.deleteById(AuthDB.DELETE_USER_ALIAS_BY_USER, id);
         connection.query(AuthDB.REALM_USERS_BY_USER, new DBQueryHandler() {
            public void prepare(PreparedStatement s)
               throws SQLException
            {
               s.setInt(1, id);
            }
View Full Code Here
199
200
201
202
203
204
205
206
207
208
209
   {
     
      final Slot<Boolean> hasRole = new Slot<Boolean>(false);
      DBConnection connection = db.getConnection();
      try {
         connection.query(AuthDB.USER_HAS_ROLE, new DBQueryHandler() {
            public void prepare(PreparedStatement s)
               throws SQLException
            {
               s.setInt(1,id);
               s.setInt(2,role.getId());
View Full Code Here
255
256
257
258
259
260
261
262
263
264
265
      throws SQLException
   {
      final Slot<Iterator<Role>> result = new Slot<Iterator<Role>>();
      final DBConnection connection = db.getConnection();
      try {
         connection.query(AuthDB.USER_ROLES, new DBQueryHandler() {
         public boolean shouldClose() { return false; }
            public void prepare(PreparedStatement s)
               throws SQLException
            {
               s.setInt(1,id);
View Full Code Here
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
   {
      final Slot<Authenticated> retval = new Slot<Authenticated>();
      if (realm==null) {
         DBConnection connection = db.getConnection();
         try {
            connection.query(AuthDB.USER_AUTHENTICATED, new DBQueryHandler() {
               public void prepare(PreparedStatement s)
                  throws SQLException
               {
                  s.setInt(1,id);
                  s.setString(2,session.toString());
               }
               public void onResults(ResultSet set)
                  throws SQLException
               {
                  if (set.next()) {
                     Timestamp created = set.getTimestamp(2);
                     Timestamp expiration = set.getTimestamp(3);
                     Authenticated auth = new Authenticated(db,set.getInt(1),session,created,expiration,User.this,realm);
                     retval.set(auth);
                  }
               }
            });
            if (retval.get().isExpired()) {
               // the session has expired
               retval.get().delete();
               retval.set(null);
            }
           
         } finally {
            db.release(connection);
         }
      } else {
         DBConnection connection = db.getConnection();
         try {
            connection.query(AuthDB.REALM_USER_AUTHENTICATED, new DBQueryHandler() {
               public void prepare(PreparedStatement s)
                  throws SQLException
               {
                  s.setInt(1,id);
                  s.setInt(2,realm.getId());
View Full Code Here
657
658
659
660
661
662
663
664
665
666
667
   {
      final Slot<Boolean> found = new Slot<Boolean>(false);
      final String encrypted = md5Password(password);
      DBConnection connection = db.getConnection();
      try {
         connection.query(AuthDB.CHECK_PASSWORD, new DBQueryHandler() {
            public void prepare(PreparedStatement s)
               throws SQLException
            {
               s.setInt(1,id);
               s.setString(2,encrypted);
View Full Code Here
682
683
684
685
686
687
688
689
690
691
692
      throws SQLException
   {
      final Slot<String> found = new Slot<String>();
      DBConnection connection = db.getConnection();
      try {
         connection.query(AuthDB.ENCRYPTED_PASSWORD, new DBQueryHandler() {
            public void prepare(PreparedStatement s)
               throws SQLException
            {
               s.setInt(1,id);
            }
View Full Code Here
51
52
53
54
55
56
57
58
59
60
61
      throws SQLException
   {
     
      DBConnection connection = db.getConnection();
      try {
         connection.query(AuthDB.ROLE_PERMISSIONS, new DBQueryHandler() {
            public void prepare(PreparedStatement s)
               throws SQLException
            {
               s.setInt(1, id);
            }
View Full Code Here
56
57
58
59
60
61
62
63
64
65
66
   protected void init()
      throws SQLException
   {
      DBConnection connection = db.getConnection();
      try {
         connection.query(AuthDB.GROUP_ROLES, new DBQueryHandler() {
            public void prepare(PreparedStatement s)
               throws SQLException
            {
               s.setInt(1, id);
            }
View Full Code Here
208
209
210
211
212
213
214
215
216
217
218
      throws SQLException
   {
      final Slot<Boolean> member = new Slot<Boolean>(false);
      DBConnection connection = db.getConnection();
      try {
         connection.query(AuthDB.GROUP_MEMBER, new DBQueryHandler() {
            public void prepare(PreparedStatement s)
               throws SQLException
            {
               s.setInt(1,id);
               s.setInt(2,user.getId());
View Full Code Here
TOP

Related Classes of org.milowski.db.DBQueryHandler

  • 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.Realm
  • org.atomojo.auth.service.db.RealmUser
  • org.atomojo.auth.service.db.Role
  • org.atomojo.auth.service.db.User
    • 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.