Mercurial Hosting > nabble

comparison src/nabble/modules/hacks/UserHack.java @ 0:7ecd1a4ef557

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
add content
author Franklin Schmidt <fschmidt@gmail.com>
date Thu, 21 Mar 2019 19:15:52 -0600
parents
children
comparison
equal deleted inserted replaced
-1:000000000000 0:7ecd1a4ef557
1 package nabble.modules.hacks;
2
3 import nabble.model.Db;
4 import nabble.model.ExtensionFactory;
5 import nabble.model.ModelHome;
6 import nabble.model.User;
7
8 import java.sql.Connection;
9 import java.sql.PreparedStatement;
10 import java.sql.ResultSet;
11 import java.sql.SQLException;
12
13 public class UserHack {
14
15 private static final ExtensionFactory<User,UserHack> FACTORY = ModelHome.standardExtensionFactory(HacksModule.INSTANCE.getName(),User.class,UserHack.class);
16
17 public static UserHack of(User user) {
18 return user.getExtension(FACTORY);
19 }
20
21 private final User user;
22
23 public UserHack(User user) {
24 this.user = user;
25 }
26
27 private int registrationSequence = -1;
28
29 public int getRegistrationSequence() {
30 if (user.isRegistered() && registrationSequence == -1) {
31 try {
32 Connection con = user.getSite().getDb().getConnection();
33 PreparedStatement stmt = con.prepareStatement(
34 "select count(1) as n from user_ where user_id <= ?"
35 );
36 stmt.setLong(1,user.getId());
37 ResultSet rs = stmt.executeQuery();
38 rs.next();
39 registrationSequence = rs.getInt("n");
40 stmt.close();
41 con.close();
42 } catch(SQLException e) {
43 throw new RuntimeException(e);
44 }
45 }
46 return registrationSequence;
47 }
48 }