0
|
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 }
|