DirectoryAnswer getDA(DirectoryRequest dr) throws P2PDDSQLException {
String sql =
"select addresses, timestamp, strftime('%Y%m%d%H%M%fZ',timestamp,'unixepoch') from registered where global_peer_ID = ?;";
ArrayList<ArrayList<Object>> adr = db_dir.select(sql, new String[] {dr.globalID}, DEBUG);
if (DEBUG) System.out.println("Query: " + sql + " with ?= " + Util.trimmed(dr.globalID));
if (DEBUG) System.out.println("Found addresses #: " + adr.size());
DirectoryAnswer da = new DirectoryAnswer();
da.version = dr.version;
if (adr.size() != 0) {
Integer time = Util.Ival(adr.get(0).get(1));
if (time == null) {
time = new Integer(0);
out.println("EMPTY TIME. WHY?");
}
Date date = new Date();
date.setTime(time.longValue());
da.date.setTime(date);
String addresses = (String) adr.get(0).get(0);
if (DEBUG) System.out.println("This address: " + addresses);
String a[] = Address.split(addresses);
for (int k = 0; k < a.length; k++) {
if ((a[k] == null) || ("".equals(a[k])) || ("null".equals(a[k]))) continue;
if (DEBUG) System.out.println("This address [" + k + "]" + a[k]);
da.addresses.add(new Address(a[k]));
}
} else {
if (DEBUG) out.print("Empty ");
}
return da;
}
public class constituent {
public static final String constituent_ID = "constituent_ID";
public static final String submitter_ID = "submitter_ID";
public static final String global_constituent_ID = "global_constituent_ID";
public static final String global_constituent_ID_hash = "global_constituent_ID_hash";
public static final String hash_constituent_alg = "hash_constituent_alg";
public static final String hash_constituent = "hash_constituent";
public static final String sign = "sign";
public static final String cert_hash_alg = "cert_hash_alg";
public static final String certChain = "certChain";
public static final String certificate = "certificate";
public static final String certRequest = "certRequest";
public static final String email = "email";
public static final String external = "external";
public static final String forename = "forename";
public static final String languages = "languages";
public static final String name = "name";
public static final String neighborhood_ID = "neighborhood_ID";
public static final String organization_ID = "organization_ID";
public static final String slogan = "slogan";
public static final String picture = "picture";
public static final String weight="weight";
public static final String op = "op";
public static final String revoked = "revoked";
public static final String version = "version";
public static final String hidden = "hidden";
public static final String peer_transmitter_ID = "peer_transmitter_ID"; // who gave it to me
public static final String creation_date = "creation_date";
public static final String arrival_date = "arrival_date";
public static final String blocked = "blocked";
public static final String requested = "requested";
public static final String broadcasted = "broadcasted";
public static final String TNAME = "constituent";
public static final String INIT_SLOGAN = util.Util._("I have just arrived");
public static final String fields_constituents_no_ID =
" "+global_constituent_ID+
", "+global_constituent_ID_hash+
", "+hash_constituent_alg+
//", "+hash_constituent+
", "+certChain+
", "+certificate+
", "+certRequest+
", "+creation_date+
", "+email+
", "+external+
", "+forename+
", "+languages+
", "+name+
", "+neighborhood_ID+
", "+organization_ID+
", "+slogan+
", "+picture+
", "+arrival_date+
", "+op+
", "+cert_hash_alg+
", "+weight+
", "+sign+
", "+submitter_ID+
", "+blocked+
", "+requested+
", "+broadcasted+
", "+revoked+
", "+version+
", "+hidden+
", "+peer_transmitter_ID+
" ";
public static final String fields_constituents =
fields_constituents_no_ID+", "+constituent_ID+
" ";
public static final int CONST_COL_GID = 0;
public static final int CONST_COL_GID_HASH = 1;
public static final int CONST_COL_HASH_ALG = 2;
//public static final int CONST_COL_HASH = 2; // hash of fields signed by user
public static final int CONST_COL_CERT_CHAIN = 3;
public static final int CONST_COL_CERTIF = 4;
public static final int CONST_COL_CERREQ = 5;
public static final int CONST_COL_DATE = 6;
public static final int CONST_COL_EMAIL = 7;
public static final int CONST_COL_EXTERNAL = 8;
public static final int CONST_COL_FORENAME = 9;
public static final int CONST_COL_LANG = 10;
public static final int CONST_COL_SURNAME = 11;
public static final int CONST_COL_NEIGH = 12;
public static final int CONST_COL_ORG = 13;
public static final int CONST_COL_SLOGAN = 14;
public static final int CONST_COL_PICTURE = 15;
public static final int CONST_COL_ARRIVAL = 16;
public static final int CONST_COL_OP = 17;
public static final int CONST_COL_CERT_HASH_ALG = 18;
public static final int CONST_COL_WEIGHT = 19;
public static final int CONST_COL_SIGNATURE = 20;
public static final int CONST_COL_SUBMITTER = 21;
public static final int CONST_COL_BLOCKED = 22;
public static final int CONST_COL_REQUESTED = 23;
public static final int CONST_COL_BROADCASTED = 24;
public static final int CONST_COL_REVOKED = 25;
public static final int CONST_COL_VERSION = 26;
public static final int CONST_COL_HIDDEN = 27;
public static final int CONST_COL_PEER_TRANSMITTER_ID = 28;
public static final int CONST_COL_ID = 29;
public static final String CURRENT_HASH_CONSTITUENT_ALG = "V1";
public static final String[] fields_constituents_no_ID_list = Util.trimmed(table.constituent.fields_constituents_no_ID.split(Pattern.quote(",")));
public static final String[] fields_constituents_list = Util.trimmed(table.constituent.fields_constituents.split(Pattern.quote(",")));
public static final int CONST_COLs_NOID = fields_constituents_no_ID_list.length;
public static final int CONST_COLs = fields_constituents_list.length;
public static final String SEP_languages = ":";
public static final String INIT_EXTERNAL_SLOGAN = util.Util._("I may not be aware that I am listed here!");
}