public String buildInterfaceTable(String rule, String[] serviceList) throws FilterParseException {
StringBuffer buffer = new StringBuffer();
Filter filter = new Filter();
Map interfaces = filter.getIPServiceMap(rule);
Iterator i = interfaces.keySet().iterator();
while (i.hasNext()) {
String key = (String) i.next();
buffer.append("<tr><td valign=\"top\">").append(key).append("</td>");
buffer.append("<td>");
if (serviceList != null && serviceList.length != 0) {
Map services = (Map) interfaces.get(key);
Iterator j = services.keySet().iterator();
while (j.hasNext()) {
String svc = (String) j.next();
for (int idx = 0; idx < serviceList.length; idx++) {
if (svc.equals(serviceList[idx])) {
buffer.append(svc).append("<br>");
}
}
}
} else {
buffer.append("All services");
}
buffer.append("</td>");
buffer.append("</tr>");
}
return buffer.toString();
}
@Override
public Map<String, Object> saveMap(Map<String, Object> object, Class clazz) throws Exception {
StringBuilder sql = new StringBuilder();
EntityInfo entityInfo = ClassUtils.getEntityInfoByClazz(clazz);
sql.append("INSERT INTO ");
sql.append(entityInfo.getTableName());
sql.append("(");
List<String> columns = new ArrayList<String>();
List<Object> values = new ArrayList<Object>();
Map<String, String> ptcMap = ClassUtils.propToColumnMap.get(entityInfo.getClazzName());
for (Map.Entry<String, Object> entry : object.entrySet()) {
columns.add(ptcMap.get(entry.getKey()));
values.add(entry.getValue());
}
sql.append(StringUtils.join(columns, ","));
sql.append(") VALUES(");
String[] params = new String[values.size()];
Arrays.fill(params, "?");
sql.append(StringUtils.join(params, ","));
sql.append(")");
if (entityInfo.getStrategy().equals(GenerationType.IDENTITY)) {
Long id = addReutrnId(sql.toString(), values);
if (id != null) {
object.put(entityInfo.getPkName(), id);
}
} else {
add(sql.toString(), values);
}
return object;
}
private Counter getCounterFromVerificationData(Map<String, String> verificationData) {
String sizeAndSymbol = verificationData.get(Constants.COUNTER_SIZE_AND_SYMBOL);
String[] parts = sizeAndSymbol.split(" ");
if (parts.length < Constants.MIN_LENGTH) {
throw new NoSuchElementException();
}
String standardSize = parts[0] + " " + parts[1];
String symbol = parts[2];
if (parts.length > Constants.MIN_LENGTH) {
for (int i = Constants.MIN_LENGTH; i < parts.length; i++) {
symbol += " " + parts[i];
}
}
CounterType counterType =
counterTypeService.findOneBySymbolAndStandardSize(symbol, standardSize);
if (counterType == null) {
throw new NoSuchElementException();
}
Counter counter =
new Counter(
verificationData.get(Constants.YEAR),
verificationData.get(Constants.COUNTER_NUMBER),
counterType,
verificationData.get(Constants.STAMP));
return counter;
}
public ICFAccTaxObj readTaxByUNameIdx(long TenantId, String Name, boolean forceRead) {
if (indexByUNameIdx == null) {
indexByUNameIdx = new HashMap<CFAccTaxByUNameIdxKey, ICFAccTaxObj>();
}
CFAccTaxByUNameIdxKey key =
((ICFAccSchema) schema.getBackingStore()).getFactoryTax().newUNameIdxKey();
key.setRequiredTenantId(TenantId);
key.setRequiredName(Name);
ICFAccTaxObj obj = null;
if ((!forceRead) && indexByUNameIdx.containsKey(key)) {
obj = indexByUNameIdx.get(key);
} else {
CFAccTaxBuff buff =
((ICFAccSchema) schema.getBackingStore())
.getTableTax()
.readDerivedByUNameIdx(schema.getAuthorization(), TenantId, Name);
if (buff != null) {
obj = schema.getTaxTableObj().newInstance();
obj.setPKey(((ICFAccSchema) schema.getBackingStore()).getFactoryTax().newPKey());
obj.setBuff(buff);
obj = (ICFAccTaxObj) obj.realize();
} else if (schema.getCacheMisses()) {
indexByUNameIdx.put(key, null);
}
}
return (obj);
}
public void forgetTaxByTenantIdx(long TenantId) {
if (indexByTenantIdx == null) {
return;
}
CFAccTaxByTenantIdxKey key =
((ICFAccSchema) schema.getBackingStore()).getFactoryTax().newTenantIdxKey();
key.setRequiredTenantId(TenantId);
if (indexByTenantIdx.containsKey(key)) {
Map<CFAccTaxPKey, ICFAccTaxObj> mapTenantIdx = indexByTenantIdx.get(key);
if (mapTenantIdx != null) {
List<ICFAccTaxObj> toForget = new LinkedList<ICFAccTaxObj>();
ICFAccTaxObj cur = null;
Iterator<ICFAccTaxObj> iter = mapTenantIdx.values().iterator();
while (iter.hasNext()) {
cur = iter.next();
toForget.add(cur);
}
iter = toForget.iterator();
while (iter.hasNext()) {
cur = iter.next();
cur.forget(true);
}
}
indexByTenantIdx.remove(key);
}
}
public void deleteSecDeviceByUserIdx(UUID SecUserId) {
CFSecuritySecDeviceByUserIdxKey key =
((ICFSecuritySchema) schema.getBackingStore()).getFactorySecDevice().newUserIdxKey();
key.setRequiredSecUserId(SecUserId);
if (indexByUserIdx == null) {
indexByUserIdx =
new HashMap<
CFSecuritySecDeviceByUserIdxKey,
Map<CFSecuritySecDevicePKey, ICFSecuritySecDeviceObj>>();
}
if (indexByUserIdx.containsKey(key)) {
Map<CFSecuritySecDevicePKey, ICFSecuritySecDeviceObj> dict = indexByUserIdx.get(key);
((ICFSecuritySchema) schema.getBackingStore())
.getTableSecDevice()
.deleteSecDeviceByUserIdx(schema.getAuthorization(), SecUserId);
Iterator<ICFSecuritySecDeviceObj> iter = dict.values().iterator();
ICFSecuritySecDeviceObj obj;
List<ICFSecuritySecDeviceObj> toForget = new LinkedList<ICFSecuritySecDeviceObj>();
while (iter.hasNext()) {
obj = iter.next();
toForget.add(obj);
}
iter = toForget.iterator();
while (iter.hasNext()) {
obj = iter.next();
obj.forget(true);
}
indexByUserIdx.remove(key);
} else {
((ICFSecuritySchema) schema.getBackingStore())
.getTableSecDevice()
.deleteSecDeviceByUserIdx(schema.getAuthorization(), SecUserId);
}
}
public static boolean isZero(List list, String col) {
if (list == null) {
return false;
}
boolean b = false;
int i, num = 0;
String v = null;
Map m = null;
double dv = 0;
num = list.size();
for (i = 0; i < num; i++) {
m = (Map) list.get(i);
v = (String) m.get(col);
// if(f.empty(v)){return true;}
if (f.empty(v)) {
continue;
}
// System.out.println(v);
v = f.v(v);
dv = f.getDouble(v, 0);
// if(dv==0){return true;}
if (dv > 0) {
return false;
}
b = true;
}
return b;
}
/**
* 构建ResultMap对象
*
* @param id
* @param clazz
* @param configuration
* @return
*/
private ResultMap buildResultMap(String id, Class<?> clazz, Configuration configuration) {
// 判断是否已经存在缓存里
if (configuration.hasResultMap(id)) {
return configuration.getResultMap(id);
}
List<ResultMapping> resultMappings = Lists.newArrayList();
Map<String, Field> columns = EntityUtil.getFields(clazz);
for (Map.Entry<String, Field> column : columns.entrySet()) {
Field field = column.getValue();
String fieldName = field.getName();
Class<?> columnTypeClass = resolveResultJavaType(clazz, fieldName, null);
List<ResultFlag> flags = Lists.newArrayList();
if (field.isAnnotationPresent(Id.class)) {
flags.add(ResultFlag.ID);
}
String columnName = column.getKey();
resultMappings.add(
buildResultMapping(configuration, fieldName, columnName, columnTypeClass, flags));
}
// 构建ResultMap
ResultMap.Builder resultMapBuilder =
new ResultMap.Builder(configuration, id, clazz, resultMappings);
ResultMap rm = resultMapBuilder.build();
// 放到缓存中
configuration.addResultMap(rm);
return rm;
}
SqlDialect get(DataSource dataSource) {
Connection connection = null;
try {
connection = dataSource.getConnection();
DatabaseMetaData metaData = connection.getMetaData();
String productName = metaData.getDatabaseProductName();
String productVersion = metaData.getDatabaseProductVersion();
List key = Arrays.asList(productName, productVersion);
SqlDialect dialect = map.get(key);
if (dialect == null) {
final SqlDialect.DatabaseProduct product =
SqlDialect.getProduct(productName, productVersion);
dialect = new SqlDialect(product, productName, metaData.getIdentifierQuoteString());
map.put(key, dialect);
}
connection.close();
connection = null;
return dialect;
} catch (SQLException e) {
throw new RuntimeException(e);
} finally {
if (connection != null) {
try {
connection.close();
} catch (SQLException e) {
// ignore
}
}
}
}
public void deleteTSecGroupMemberByUUserIdx(long TenantId, int TSecGroupId, UUID SecUserId) {
if (indexByUUserIdx == null) {
indexByUUserIdx =
new HashMap<CFSecurityTSecGroupMemberByUUserIdxKey, ICFSecurityTSecGroupMemberObj>();
}
CFSecurityTSecGroupMemberByUUserIdxKey key =
((ICFCrmSchema) schema.getBackingStore()).getFactoryTSecGroupMember().newUUserIdxKey();
key.setRequiredTenantId(TenantId);
key.setRequiredTSecGroupId(TSecGroupId);
key.setRequiredSecUserId(SecUserId);
ICFSecurityTSecGroupMemberObj obj = null;
if (indexByUUserIdx.containsKey(key)) {
obj = indexByUUserIdx.get(key);
((ICFCrmSchema) schema.getBackingStore())
.getTableTSecGroupMember()
.deleteTSecGroupMemberByUUserIdx(
schema.getAuthorization(), TenantId, TSecGroupId, SecUserId);
obj.forget(true);
} else {
((ICFCrmSchema) schema.getBackingStore())
.getTableTSecGroupMember()
.deleteTSecGroupMemberByUUserIdx(
schema.getAuthorization(), TenantId, TSecGroupId, SecUserId);
}
}
public CFSecuritySecSessionBuff[] readDerivedByFinishIdx(
CFSecurityAuthorization Authorization, UUID SecUserId, Calendar Finish) {
final String S_ProcName = "CFSecurityRamSecSession.readDerivedByFinishIdx";
CFSecuritySecSessionByFinishIdxKey key = schema.getFactorySecSession().newFinishIdxKey();
key.setRequiredSecUserId(SecUserId);
key.setOptionalFinish(Finish);
CFSecuritySecSessionBuff[] recArray;
if (dictByFinishIdx.containsKey(key)) {
Map<CFSecuritySecSessionPKey, CFSecuritySecSessionBuff> subdictFinishIdx =
dictByFinishIdx.get(key);
recArray = new CFSecuritySecSessionBuff[subdictFinishIdx.size()];
Iterator<CFSecuritySecSessionBuff> iter = subdictFinishIdx.values().iterator();
int idx = 0;
while (iter.hasNext()) {
recArray[idx++] = iter.next();
}
} else {
Map<CFSecuritySecSessionPKey, CFSecuritySecSessionBuff> subdictFinishIdx =
new HashMap<CFSecuritySecSessionPKey, CFSecuritySecSessionBuff>();
dictByFinishIdx.put(key, subdictFinishIdx);
recArray = new CFSecuritySecSessionBuff[0];
}
return (recArray);
}
public CFBamDelSubDep3Buff[] readDerivedByContDelDep2Idx(
CFBamAuthorization Authorization, long ContTenantId, long ContDelDep2Id) {
final String S_ProcName = "CFBamRamDelSubDep3.readDerivedByContDelDep2Idx() ";
CFBamDelSubDep3ByContDelDep2IdxKey key = schema.getFactoryDelSubDep3().newContDelDep2IdxKey();
key.setRequiredContTenantId(ContTenantId);
key.setRequiredContDelDep2Id(ContDelDep2Id);
CFBamDelSubDep3Buff[] recArray;
if (dictByContDelDep2Idx.containsKey(key)) {
Map<CFBamScopePKey, CFBamDelSubDep3Buff> subdictContDelDep2Idx =
dictByContDelDep2Idx.get(key);
recArray = new CFBamDelSubDep3Buff[subdictContDelDep2Idx.size()];
Iterator<CFBamDelSubDep3Buff> iter = subdictContDelDep2Idx.values().iterator();
int idx = 0;
while (iter.hasNext()) {
recArray[idx++] = iter.next();
}
} else {
Map<CFBamScopePKey, CFBamDelSubDep3Buff> subdictContDelDep2Idx =
new HashMap<CFBamScopePKey, CFBamDelSubDep3Buff>();
dictByContDelDep2Idx.put(key, subdictContDelDep2Idx);
recArray = new CFBamDelSubDep3Buff[0];
}
return (recArray);
}
public ICFSecurityISOCountryCurrencyObj readISOCountryCurrency(
CFSecurityISOCountryCurrencyPKey pkey, boolean forceRead) {
ICFSecurityISOCountryCurrencyObj obj = null;
if ((!forceRead) && members.containsKey(pkey)) {
obj = members.get(pkey);
} else {
CFSecurityISOCountryCurrencyBuff readBuff =
((ICFInternetSchema) schema.getBackingStore())
.getTableISOCountryCurrency()
.readDerivedByIdIdx(
schema.getAuthorization(),
pkey.getRequiredISOCountryId(),
pkey.getRequiredISOCurrencyId());
if (readBuff != null) {
obj = schema.getISOCountryCurrencyTableObj().newInstance();
obj.setPKey(
((ICFInternetSchema) schema.getBackingStore())
.getFactoryISOCountryCurrency()
.newPKey());
obj.setBuff(readBuff);
obj = (ICFSecurityISOCountryCurrencyObj) obj.realize();
} else if (schema.getCacheMisses()) {
members.put(pkey, null);
}
}
return (obj);
}
public void forgetISOCountryCurrencyByCurrencyIdx(short ISOCurrencyId) {
if (indexByCurrencyIdx == null) {
return;
}
CFSecurityISOCountryCurrencyByCurrencyIdxKey key =
((ICFInternetSchema) schema.getBackingStore())
.getFactoryISOCountryCurrency()
.newCurrencyIdxKey();
key.setRequiredISOCurrencyId(ISOCurrencyId);
if (indexByCurrencyIdx.containsKey(key)) {
Map<CFSecurityISOCountryCurrencyPKey, ICFSecurityISOCountryCurrencyObj> mapCurrencyIdx =
indexByCurrencyIdx.get(key);
if (mapCurrencyIdx != null) {
List<ICFSecurityISOCountryCurrencyObj> toForget =
new LinkedList<ICFSecurityISOCountryCurrencyObj>();
ICFSecurityISOCountryCurrencyObj cur = null;
Iterator<ICFSecurityISOCountryCurrencyObj> iter = mapCurrencyIdx.values().iterator();
while (iter.hasNext()) {
cur = iter.next();
toForget.add(cur);
}
iter = toForget.iterator();
while (iter.hasNext()) {
cur = iter.next();
cur.forget(true);
}
}
indexByCurrencyIdx.remove(key);
}
}
@Test
public void getDistinctKeysAndCounts_SortByKeyDescending() {
Connection connection = null;
ResultSet resultSet = null;
try {
ConnectionManager connectionManager = temporaryFileDatabase.getConnectionManager(true);
initWithTestData(connectionManager);
connection = connectionManager.getConnection(null);
resultSet = DBQueries.getDistinctKeysAndCounts(true, NAME, connection);
Map<String, Integer> resultSetToMap = resultSetToMap(resultSet);
assertEquals(3, resultSetToMap.size());
Iterator<Map.Entry<String, Integer>> entriesIterator = resultSetToMap.entrySet().iterator();
Map.Entry entry = entriesIterator.next();
assertEquals("gps", entry.getKey());
assertEquals(1, entry.getValue());
entry = entriesIterator.next();
assertEquals("airbags", entry.getKey());
assertEquals(1, entry.getValue());
entry = entriesIterator.next();
assertEquals("abs", entry.getKey());
assertEquals(2, entry.getValue());
} finally {
DBUtils.closeQuietly(resultSet);
DBUtils.closeQuietly(connection);
}
}
public ICFSecuritySecGroupIncludeObj readSecGroupInclude(
CFSecuritySecGroupIncludePKey pkey, boolean forceRead) {
ICFSecuritySecGroupIncludeObj obj = null;
if ((!forceRead) && members.containsKey(pkey)) {
obj = members.get(pkey);
} else {
CFSecuritySecGroupIncludeBuff readBuff =
((ICFInternetSchema) schema.getBackingStore())
.getTableSecGroupInclude()
.readDerivedByIdIdx(
schema.getAuthorization(),
pkey.getRequiredClusterId(),
pkey.getRequiredSecGroupIncludeId());
if (readBuff != null) {
obj = schema.getSecGroupIncludeTableObj().newInstance();
obj.setPKey(
((ICFInternetSchema) schema.getBackingStore()).getFactorySecGroupInclude().newPKey());
obj.setBuff(readBuff);
obj = (ICFSecuritySecGroupIncludeObj) obj.realize();
} else if (schema.getCacheMisses()) {
members.put(pkey, null);
}
}
return (obj);
}
public ICFSecuritySecGroupIncludeObj readSecGroupIncludeByUIncludeIdx(
long ClusterId, int SecGroupId, int IncludeGroupId, boolean forceRead) {
if (indexByUIncludeIdx == null) {
indexByUIncludeIdx =
new HashMap<CFSecuritySecGroupIncludeByUIncludeIdxKey, ICFSecuritySecGroupIncludeObj>();
}
CFSecuritySecGroupIncludeByUIncludeIdxKey key =
((ICFInternetSchema) schema.getBackingStore())
.getFactorySecGroupInclude()
.newUIncludeIdxKey();
key.setRequiredClusterId(ClusterId);
key.setRequiredSecGroupId(SecGroupId);
key.setRequiredIncludeGroupId(IncludeGroupId);
ICFSecuritySecGroupIncludeObj obj = null;
if ((!forceRead) && indexByUIncludeIdx.containsKey(key)) {
obj = indexByUIncludeIdx.get(key);
} else {
CFSecuritySecGroupIncludeBuff buff =
((ICFInternetSchema) schema.getBackingStore())
.getTableSecGroupInclude()
.readDerivedByUIncludeIdx(
schema.getAuthorization(), ClusterId, SecGroupId, IncludeGroupId);
if (buff != null) {
obj = schema.getSecGroupIncludeTableObj().newInstance();
obj.setPKey(
((ICFInternetSchema) schema.getBackingStore()).getFactorySecGroupInclude().newPKey());
obj.setBuff(buff);
obj = (ICFSecuritySecGroupIncludeObj) obj.realize();
} else if (schema.getCacheMisses()) {
indexByUIncludeIdx.put(key, null);
}
}
return (obj);
}
public ICFSecurityTSecGroupMemberObj readTSecGroupMember(
CFSecurityTSecGroupMemberPKey pkey, boolean forceRead) {
ICFSecurityTSecGroupMemberObj obj = null;
if ((!forceRead) && members.containsKey(pkey)) {
obj = members.get(pkey);
} else {
CFSecurityTSecGroupMemberBuff readBuff =
((ICFCrmSchema) schema.getBackingStore())
.getTableTSecGroupMember()
.readDerivedByIdIdx(
schema.getAuthorization(),
pkey.getRequiredTenantId(),
pkey.getRequiredTSecGroupMemberId());
if (readBuff != null) {
obj = schema.getTSecGroupMemberTableObj().newInstance();
obj.setPKey(
((ICFCrmSchema) schema.getBackingStore()).getFactoryTSecGroupMember().newPKey());
obj.setBuff(readBuff);
obj = (ICFSecurityTSecGroupMemberObj) obj.realize();
} else if (schema.getCacheMisses()) {
members.put(pkey, null);
}
}
return (obj);
}
public ICFSecurityTSecGroupMemberObj readTSecGroupMemberByUUserIdx(
long TenantId, int TSecGroupId, UUID SecUserId, boolean forceRead) {
if (indexByUUserIdx == null) {
indexByUUserIdx =
new HashMap<CFSecurityTSecGroupMemberByUUserIdxKey, ICFSecurityTSecGroupMemberObj>();
}
CFSecurityTSecGroupMemberByUUserIdxKey key =
((ICFCrmSchema) schema.getBackingStore()).getFactoryTSecGroupMember().newUUserIdxKey();
key.setRequiredTenantId(TenantId);
key.setRequiredTSecGroupId(TSecGroupId);
key.setRequiredSecUserId(SecUserId);
ICFSecurityTSecGroupMemberObj obj = null;
if ((!forceRead) && indexByUUserIdx.containsKey(key)) {
obj = indexByUUserIdx.get(key);
} else {
CFSecurityTSecGroupMemberBuff buff =
((ICFCrmSchema) schema.getBackingStore())
.getTableTSecGroupMember()
.readDerivedByUUserIdx(schema.getAuthorization(), TenantId, TSecGroupId, SecUserId);
if (buff != null) {
obj = schema.getTSecGroupMemberTableObj().newInstance();
obj.setPKey(
((ICFCrmSchema) schema.getBackingStore()).getFactoryTSecGroupMember().newPKey());
obj.setBuff(buff);
obj = (ICFSecurityTSecGroupMemberObj) obj.realize();
} else if (schema.getCacheMisses()) {
indexByUUserIdx.put(key, null);
}
}
return (obj);
}
private static void setValues(
byte[][] values,
int[] pkSlotIndex,
int[] columnIndexes,
PTable table,
Map<ImmutableBytesPtr, Map<PColumn, byte[]>> mutation) {
Map<PColumn, byte[]> columnValues = Maps.newHashMapWithExpectedSize(columnIndexes.length);
byte[][] pkValues = new byte[table.getPKColumns().size()][];
// If the table uses salting, the first byte is the salting byte, set to an empty arrary
// here and we will fill in the byte later in PRowImpl.
if (table.getBucketNum() != null) {
pkValues[0] = new byte[] {0};
}
for (int i = 0; i < values.length; i++) {
byte[] value = values[i];
PColumn column = table.getColumns().get(columnIndexes[i]);
if (SchemaUtil.isPKColumn(column)) {
pkValues[pkSlotIndex[i]] = value;
} else {
columnValues.put(column, value);
}
}
ImmutableBytesPtr ptr = new ImmutableBytesPtr();
table.newKey(ptr, pkValues);
mutation.put(ptr, columnValues);
}
public void deleteISOCurrency(CFBamAuthorization Authorization, CFBamISOCurrencyBuff Buff) {
final String S_ProcName = "CFBamRamISOCurrencyTable.deleteISOCurrency() ";
CFBamISOCurrencyPKey pkey = schema.getFactoryISOCurrency().newPKey();
pkey.setRequiredId(Buff.getRequiredId());
CFBamISOCurrencyBuff existing = dictByPKey.get(pkey);
if (existing == null) {
return;
}
if (existing.getRequiredRevision() != Buff.getRequiredRevision()) {
throw CFLib.getDefaultExceptionFactory()
.newCollisionDetectedException(getClass(), "deleteISOCurrency", pkey);
}
CFBamISOCurrencyByCcyCdIdxKey keyCcyCdIdx = schema.getFactoryISOCurrency().newCcyCdIdxKey();
keyCcyCdIdx.setRequiredISOCode(existing.getRequiredISOCode());
CFBamISOCurrencyByCcyNmIdxKey keyCcyNmIdx = schema.getFactoryISOCurrency().newCcyNmIdxKey();
keyCcyNmIdx.setRequiredName(existing.getRequiredName());
// Validate reverse foreign keys
// Delete is valid
schema
.getTableISOCountryCurrency()
.deleteISOCountryCurrencyByCurrencyIdx(Authorization, Buff.getRequiredId());
Map<CFBamISOCurrencyPKey, CFBamISOCurrencyBuff> subdict;
dictByPKey.remove(pkey);
dictByCcyCdIdx.remove(keyCcyCdIdx);
dictByCcyNmIdx.remove(keyCcyNmIdx);
}
@Override
public String get(Object key) {
if (JdbcIndexDefinition.this.identifier.equals(key)) return identifier;
if (keys.containsKey(key)) return keys.get(key);
check();
return map.get(key);
}
public void forgetSecDeviceByUserIdx(UUID SecUserId) {
if (indexByUserIdx == null) {
return;
}
CFSecuritySecDeviceByUserIdxKey key =
((ICFSecuritySchema) schema.getBackingStore()).getFactorySecDevice().newUserIdxKey();
key.setRequiredSecUserId(SecUserId);
if (indexByUserIdx.containsKey(key)) {
Map<CFSecuritySecDevicePKey, ICFSecuritySecDeviceObj> mapUserIdx = indexByUserIdx.get(key);
if (mapUserIdx != null) {
List<ICFSecuritySecDeviceObj> toForget = new LinkedList<ICFSecuritySecDeviceObj>();
ICFSecuritySecDeviceObj cur = null;
Iterator<ICFSecuritySecDeviceObj> iter = mapUserIdx.values().iterator();
while (iter.hasNext()) {
cur = iter.next();
toForget.add(cur);
}
iter = toForget.iterator();
while (iter.hasNext()) {
cur = iter.next();
cur.forget(true);
}
}
indexByUserIdx.remove(key);
}
}
@Override
public boolean containsKey(Object key) {
if (JdbcIndexDefinition.this.identifier.equals(key)) return true;
if (keys.containsKey(key)) return true;
check();
return map.containsKey(key);
}
public CFSecurityTSecGroupMemberBuff[] readDerivedByGroupIdx(
CFSecurityAuthorization Authorization, long TenantId, int TSecGroupId) {
final String S_ProcName = "CFSecurityRamTSecGroupMember.readDerivedByGroupIdx";
CFSecurityTSecGroupMemberByGroupIdxKey key =
schema.getFactoryTSecGroupMember().newGroupIdxKey();
key.setRequiredTenantId(TenantId);
key.setRequiredTSecGroupId(TSecGroupId);
CFSecurityTSecGroupMemberBuff[] recArray;
if (dictByGroupIdx.containsKey(key)) {
Map<CFSecurityTSecGroupMemberPKey, CFSecurityTSecGroupMemberBuff> subdictGroupIdx =
dictByGroupIdx.get(key);
recArray = new CFSecurityTSecGroupMemberBuff[subdictGroupIdx.size()];
Iterator<CFSecurityTSecGroupMemberBuff> iter = subdictGroupIdx.values().iterator();
int idx = 0;
while (iter.hasNext()) {
recArray[idx++] = iter.next();
}
} else {
Map<CFSecurityTSecGroupMemberPKey, CFSecurityTSecGroupMemberBuff> subdictGroupIdx =
new HashMap<CFSecurityTSecGroupMemberPKey, CFSecurityTSecGroupMemberBuff>();
dictByGroupIdx.put(key, subdictGroupIdx);
recArray = new CFSecurityTSecGroupMemberBuff[0];
}
return (recArray);
}
public void deleteSecGroupIncludeByUIncludeIdx(
long ClusterId, int SecGroupId, int IncludeGroupId) {
if (indexByUIncludeIdx == null) {
indexByUIncludeIdx =
new HashMap<CFSecuritySecGroupIncludeByUIncludeIdxKey, ICFSecuritySecGroupIncludeObj>();
}
CFSecuritySecGroupIncludeByUIncludeIdxKey key =
((ICFInternetSchema) schema.getBackingStore())
.getFactorySecGroupInclude()
.newUIncludeIdxKey();
key.setRequiredClusterId(ClusterId);
key.setRequiredSecGroupId(SecGroupId);
key.setRequiredIncludeGroupId(IncludeGroupId);
ICFSecuritySecGroupIncludeObj obj = null;
if (indexByUIncludeIdx.containsKey(key)) {
obj = indexByUIncludeIdx.get(key);
((ICFInternetSchema) schema.getBackingStore())
.getTableSecGroupInclude()
.deleteSecGroupIncludeByUIncludeIdx(
schema.getAuthorization(), ClusterId, SecGroupId, IncludeGroupId);
obj.forget(true);
} else {
((ICFInternetSchema) schema.getBackingStore())
.getTableSecGroupInclude()
.deleteSecGroupIncludeByUIncludeIdx(
schema.getAuthorization(), ClusterId, SecGroupId, IncludeGroupId);
}
}
public List<ICFAccTaxObj> readAllTax(boolean forceRead) {
final String S_ProcName = "readAllTax";
if ((allTax == null) || forceRead) {
Map<CFAccTaxPKey, ICFAccTaxObj> map = new HashMap<CFAccTaxPKey, ICFAccTaxObj>();
allTax = map;
CFAccTaxBuff[] buffList =
((ICFAccSchema) schema.getBackingStore())
.getTableTax()
.readAllDerived(schema.getAuthorization());
CFAccTaxBuff buff;
ICFAccTaxObj obj;
for (int idx = 0; idx < buffList.length; idx++) {
buff = buffList[idx];
obj = newInstance();
obj.setPKey(((ICFAccSchema) schema.getBackingStore()).getFactoryTax().newPKey());
obj.setBuff(buff);
ICFAccTaxObj realized = (ICFAccTaxObj) obj.realize();
}
}
Comparator<ICFAccTaxObj> cmp =
new Comparator<ICFAccTaxObj>() {
public int compare(ICFAccTaxObj lhs, ICFAccTaxObj rhs) {
if (lhs == null) {
if (rhs == null) {
return (0);
} else {
return (-1);
}
} else if (rhs == null) {
return (1);
} else {
CFAccTaxPKey lhsPKey = lhs.getPKey();
CFAccTaxPKey rhsPKey = rhs.getPKey();
int ret = lhsPKey.compareTo(rhsPKey);
return (ret);
}
}
};
int len = allTax.size();
ICFAccTaxObj arr[] = new ICFAccTaxObj[len];
Iterator<ICFAccTaxObj> valIter = allTax.values().iterator();
int idx = 0;
while ((idx < len) && valIter.hasNext()) {
arr[idx++] = valIter.next();
}
if (idx < len) {
throw CFLib.getDefaultExceptionFactory()
.newArgumentUnderflowException(getClass(), S_ProcName, 0, "idx", idx, len);
} else if (valIter.hasNext()) {
throw CFLib.getDefaultExceptionFactory()
.newArgumentOverflowException(getClass(), S_ProcName, 0, "idx", idx, len);
}
Arrays.sort(arr, cmp);
ArrayList<ICFAccTaxObj> arrayList = new ArrayList<ICFAccTaxObj>(len);
for (idx = 0; idx < len; idx++) {
arrayList.add(arr[idx]);
}
List<ICFAccTaxObj> sortedList = arrayList;
return (sortedList);
}
public void forgetSecGroupIncludeByIncludeIdx(long ClusterId, int IncludeGroupId) {
if (indexByIncludeIdx == null) {
return;
}
CFSecuritySecGroupIncludeByIncludeIdxKey key =
((ICFInternetSchema) schema.getBackingStore())
.getFactorySecGroupInclude()
.newIncludeIdxKey();
key.setRequiredClusterId(ClusterId);
key.setRequiredIncludeGroupId(IncludeGroupId);
if (indexByIncludeIdx.containsKey(key)) {
Map<CFSecuritySecGroupIncludePKey, ICFSecuritySecGroupIncludeObj> mapIncludeIdx =
indexByIncludeIdx.get(key);
if (mapIncludeIdx != null) {
List<ICFSecuritySecGroupIncludeObj> toForget =
new LinkedList<ICFSecuritySecGroupIncludeObj>();
ICFSecuritySecGroupIncludeObj cur = null;
Iterator<ICFSecuritySecGroupIncludeObj> iter = mapIncludeIdx.values().iterator();
while (iter.hasNext()) {
cur = iter.next();
toForget.add(cur);
}
iter = toForget.iterator();
while (iter.hasNext()) {
cur = iter.next();
cur.forget(true);
}
}
indexByIncludeIdx.remove(key);
}
}
public void deleteTaxByTenantIdx(long TenantId) {
CFAccTaxByTenantIdxKey key =
((ICFAccSchema) schema.getBackingStore()).getFactoryTax().newTenantIdxKey();
key.setRequiredTenantId(TenantId);
if (indexByTenantIdx == null) {
indexByTenantIdx = new HashMap<CFAccTaxByTenantIdxKey, Map<CFAccTaxPKey, ICFAccTaxObj>>();
}
if (indexByTenantIdx.containsKey(key)) {
Map<CFAccTaxPKey, ICFAccTaxObj> dict = indexByTenantIdx.get(key);
((ICFAccSchema) schema.getBackingStore())
.getTableTax()
.deleteTaxByTenantIdx(schema.getAuthorization(), TenantId);
Iterator<ICFAccTaxObj> iter = dict.values().iterator();
ICFAccTaxObj obj;
List<ICFAccTaxObj> toForget = new LinkedList<ICFAccTaxObj>();
while (iter.hasNext()) {
obj = iter.next();
toForget.add(obj);
}
iter = toForget.iterator();
while (iter.hasNext()) {
obj = iter.next();
obj.forget(true);
}
indexByTenantIdx.remove(key);
} else {
((ICFAccSchema) schema.getBackingStore())
.getTableTax()
.deleteTaxByTenantIdx(schema.getAuthorization(), TenantId);
}
}
public void init(final Configuration config) throws PwmException {
final Map<FileValue.FileInformation, FileValue.FileContent> fileValue =
config.readSettingAsFile(PwmSetting.DATABASE_JDBC_DRIVER);
final byte[] jdbcDriverBytes;
if (fileValue != null && !fileValue.isEmpty()) {
final FileValue.FileInformation fileInformation1 = fileValue.keySet().iterator().next();
final FileValue.FileContent fileContent = fileValue.get(fileInformation1);
jdbcDriverBytes = fileContent.getContents();
} else {
jdbcDriverBytes = null;
}
this.dbConfiguration =
new DBConfiguration(
config.readSettingAsString(PwmSetting.DATABASE_CLASS),
config.readSettingAsString(PwmSetting.DATABASE_URL),
config.readSettingAsString(PwmSetting.DATABASE_USERNAME),
config.readSettingAsPassword(PwmSetting.DATABASE_PASSWORD),
config.readSettingAsString(PwmSetting.DATABASE_COLUMN_TYPE_KEY),
config.readSettingAsString(PwmSetting.DATABASE_COLUMN_TYPE_VALUE),
jdbcDriverBytes);
this.instanceID = pwmApplication == null ? null : pwmApplication.getInstanceID();
this.traceLogging = config.readSettingAsBoolean(PwmSetting.DATABASE_DEBUG_TRACE);
if (this.dbConfiguration.isEmpty()) {
status = PwmService.STATUS.CLOSED;
LOGGER.debug("skipping database connection open, no connection parameters configured");
}
}