Package org.milowski.db

Examples of org.milowski.db.DBConnection

134
135
136
137
138
139
140
141
142
143
144
145
146
   }
  
   public boolean removePermission(final Permission p)
      throws SQLException
   {
      DBConnection connection = db.getConnection();
      try {
         connection.update(AuthDB.DELETE_ROLE_PERMISSION, new DBUpdateHandler() {
            public void prepare(PreparedStatement s)
               throws SQLException
            {
               s.setInt(1, id);
               s.setInt(2, p.getId());
View Full Code Here
54
55
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
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
   }
  
   public void delete()
      throws SQLException
   {
      DBConnection connection = db.getConnection();
      try {
         connection.deleteById(AuthDB.DELETE_GROUP_MEMBERS, id);
         connection.deleteById(AuthDB.DELETE_GROUP_ROLES, id);
         connection.deleteById(AuthDB.DELETE_GROUP, id);
         db.realmGroupCaches.get(realm).remove(id);
      } finally {
         db.release(connection);
      }
   }
View Full Code Here
111
112
113
114
115
116
117
118
119
120
121
122
123
      throws SQLException
   {
      if (roles.contains(role)) {
         return true;
      }
      DBConnection connection = db.getConnection();
      try {
         connection.update(AuthDB.CREATE_GROUP_ROLE, new DBUpdateHandler() {
            public void prepare(PreparedStatement s)
               throws SQLException
            {
               s.setInt(1,id);
               s.setInt(2,role.getId());
View Full Code Here
131
132
133
134
135
136
137
138
139
140
141
142
143
   }
  
   public boolean removeRole(final Role role)
      throws SQLException
   {
      DBConnection connection = db.getConnection();
      try {
         return connection.update(AuthDB.DELETE_GROUP_ROLE, new DBUpdateHandler() {
            public void prepare(PreparedStatement s)
               throws SQLException
            {
               s.setInt(1,id);
               s.setInt(2,role.getId());
View Full Code Here
169
170
171
172
173
174
175
176
177
178
179
180
181
   }
  
   public void addMember(final RealmUser user)
      throws SQLException
   {
      DBConnection connection = db.getConnection();
      try {
         connection.update(AuthDB.CREATE_GROUP_MEMBER, new DBUpdateHandler() {
            public void prepare(PreparedStatement s)
               throws SQLException
            {
               s.setInt(1,id);
               s.setInt(2,user.getId());
View Full Code Here
187
188
189
190
191
192
193
194
195
196
197
198
199
   }
  
   public boolean removeMember(final RealmUser user)
      throws SQLException
   {
      DBConnection connection = db.getConnection();
      try {
         return connection.update(AuthDB.DELETE_GROUP_MEMBER, new DBUpdateHandler() {
            public void prepare(PreparedStatement s)
               throws SQLException
            {
               s.setInt(1,id);
               s.setInt(2,user.getId());
View Full Code Here
206
207
208
209
210
211
212
213
214
215
216
217
218
  
   public boolean hasMember(final RealmUser user)
      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
232
233
234
235
236
237
238
239
240
241
242
243
244
   public Iterator<RealmUser> getMembers()
      throws SQLException
   {
      final Slot<Iterator<RealmUser>> result = new Slot<Iterator<RealmUser>>();
      final DBCache<UUID,RealmUser> cache = db.realmUserCaches.get(realm);
      final DBConnection connection = db.getConnection();
      try {
         connection.query(AuthDB.GROUP_MEMBERS, new DBQueryHandler() {
            public boolean shouldClose() { return false; }
            public void prepare(PreparedStatement s)
               throws SQLException
            {
               s.setInt(1, id);
View Full Code Here
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
   }
  
   public void delete()
      throws SQLException
   {
      DBConnection connection = db.getConnection();
      try {
         db.LOG.info("Delete id "+id);
         connection.deleteById(AuthDB.DELETE_REALM_USER_ALIAS, id);
         connection.deleteById(AuthDB.DELETE_REALM_USER_GROUPS, id);
         connection.deleteById(AuthDB.DELETE_REALM_USER, id);
         db.realmUserCaches.get(realm).remove(id);
      } finally {
         db.release(connection);
      }
   }
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.