private void clearLockTimes() { if (logger.isDebugEnabled()) { for (final Pair<String, Long> time : _lockTimes) { logger.trace("SQL " + time.first() + " took " + (System.currentTimeMillis() - time.second())); } _lockTimes.clear(); } }
@DB() protected StringBuilder createPartialSelectSql(final SearchCriteria<?> sc, final boolean whereClause, final boolean enableQueryCache) { final StringBuilder sql = new StringBuilder(enableQueryCache ? _partialQueryCacheSelectSql.first() : _partialSelectSql.first()); if (sc != null && !sc.isSelectAll()) { sql.delete(7, sql.indexOf(" FROM")); sc.getSelect(sql, 7); } if (!whereClause) { sql.delete(sql.length() - (_discriminatorClause == null ? 6 : 4), sql.length()); } return sql; }
public String buildDistinctIdSql() { final StringBuilder sql = new StringBuilder(); return sql.append("SELECT DISTINCT id FROM ").append(buildTableReferences()).append(" WHERE ").append(buildDiscriminatorClause().first()).toString(); } }
public String buildCountSql() { final StringBuilder sql = new StringBuilder(); return sql.append("SELECT COUNT(*) FROM ").append(buildTableReferences()).append(" WHERE ").append(buildDiscriminatorClause().first()).toString(); }
public String toString(final String separator) { final StringBuilder buf = new StringBuilder(_name).append(": "); for (final Pair<String, Object[]> entry : _entries) { toString(buf, entry.first(), entry.second()); buf.append(separator); } return buf.toString(); }
public Pair<StringBuilder, Attribute[]> buildSelectSql(final Attribute[] attrs) { final StringBuilder sql = new StringBuilder("SELECT "); for (final Attribute attr : attrs) { sql.append(attr.table).append(".").append(attr.columnName).append(", "); } if (attrs.length > 0) { sql.delete(sql.length() - 2, sql.length()); } sql.append(" FROM ").append(buildTableReferences()); sql.append(" WHERE "); sql.append(buildDiscriminatorClause().first()); return new Pair<>(sql, attrs); }
@DB() protected StringBuilder createPartialSelectSql(final SearchCriteria<?> sc, final boolean whereClause) { final StringBuilder sql = new StringBuilder(_partialSelectSql.first()); if (sc != null && !sc.isSelectAll()) { sql.delete(7, sql.indexOf(" FROM")); sc.getSelect(sql, 7); } if (!whereClause) { sql.delete(sql.length() - (_discriminatorClause == null ? 6 : 4), sql.length()); } return sql; }
@Override @DB() public List<T> listAll(final Filter filter) { if (_removed == null) { return listAllIncludingRemoved(filter); } final StringBuilder sql = createPartialSelectSql(null, true); sql.append(_removed.first()); addFilter(sql, filter); return executeList(sql.toString()); }
public static SortedSet<Long> getAllIpsFromCidr(final String cidr, final Set<Long> usedIps) { final String cidrIp = getCidr(cidr).first(); final Integer cidrSize = getCidr(cidr).second(); return getAllIpsFromCidr(cidrIp, cidrSize, usedIps); }
@DB() protected List<Object> addGroupBy(final StringBuilder sql, final SearchCriteria<?> sc) { if (sc == null) { return null; } final Pair<GroupBy<?, ?, ?>, List<Object>> groupBys = sc.getGroupBy(); if (groupBys != null) { groupBys.first().toSql(sql); return groupBys.second(); } else { return null; } }
@Override public void execute() { final Pair<List<? extends VpnUser>, Integer> vpnUsers = _ravService.searchForVpnUsers(this); final ListResponse<VpnUsersResponse> response = new ListResponse<>(); final List<VpnUsersResponse> vpnResponses = new ArrayList<>(); for (final VpnUser vpnUser : vpnUsers.first()) { vpnResponses.add(_responseGenerator.createVpnUserResponse(vpnUser)); } response.setResponses(vpnResponses, vpnUsers.second()); response.setResponseName(getCommandName()); setResponseObject(response); }
@Override public void execute() { final Pair<List<? extends NetworkACL>, Integer> result = _networkACLService.listNetworkACLs(this); final ListResponse<NetworkACLResponse> response = new ListResponse<>(); final List<NetworkACLResponse> aclResponses = new ArrayList<>(); for (final NetworkACL acl : result.first()) { final NetworkACLResponse aclResponse = _responseGenerator.createNetworkACLResponse(acl); aclResponses.add(aclResponse); } response.setResponses(aclResponses, result.second()); response.setResponseName(getCommandName()); setResponseObject(response); }
@Override public void execute() { final Pair<List<? extends GuestOS>, Integer> result = _mgr.listGuestOSByCriteria(this); final ListResponse<GuestOSResponse> response = new ListResponse<>(); final List<GuestOSResponse> osResponses = new ArrayList<>(); for (final GuestOS guestOS : result.first()) { final GuestOSResponse guestOSResponse = _responseGenerator.createGuestOSResponse(guestOS); osResponses.add(guestOSResponse); } response.setResponses(osResponses, result.second()); response.setResponseName(getCommandName()); this.setResponseObject(response); }
@Override public void execute() { final Pair<List<? extends Network>, Integer> networks = _networkService.searchForNetworks(this); final ListResponse<NetworkResponse> response = new ListResponse<>(); final List<NetworkResponse> networkResponses = new ArrayList<>(); for (final Network network : networks.first()) { final NetworkResponse networkResponse = _responseGenerator.createNetworkResponse(ResponseView.Restricted, network); networkResponses.add(networkResponse); } response.setResponses(networkResponses, networks.second()); response.setResponseName(getCommandName()); setResponseObject(response); }
@Override public void execute() { final Pair<List<? extends NetworkOffering>, Integer> offerings = _configService.searchForNetworkOfferings(this); final ListResponse<NetworkOfferingResponse> response = new ListResponse<>(); final List<NetworkOfferingResponse> offeringResponses = new ArrayList<>(); for (final NetworkOffering offering : offerings.first()) { final NetworkOfferingResponse offeringResponse = _responseGenerator.createNetworkOfferingResponse(offering); offeringResponses.add(offeringResponse); } response.setResponses(offeringResponses, offerings.second()); response.setResponseName(getCommandName()); this.setResponseObject(response); }
@Override public void execute() { final Pair<List<PrivateGateway>, Integer> gateways = _vpcService.listPrivateGateway(this); final ListResponse<PrivateGatewayResponse> response = new ListResponse<>(); final List<PrivateGatewayResponse> projectResponses = new ArrayList<>(); for (final PrivateGateway gateway : gateways.first()) { final PrivateGatewayResponse gatewayResponse = _responseGenerator.createPrivateGatewayResponse(gateway); projectResponses.add(gatewayResponse); } response.setResponses(projectResponses, gateways.second()); response.setResponseName(getCommandName()); setResponseObject(response); }
@Override public void execute() { final Pair<List<? extends GuestOSHypervisor>, Integer> result = _mgr.listGuestOSMappingByCriteria(this); final ListResponse<GuestOsMappingResponse> response = new ListResponse<>(); final List<GuestOsMappingResponse> osMappingResponses = new ArrayList<>(); for (final GuestOSHypervisor guestOSHypervisor : result.first()) { final GuestOsMappingResponse guestOsMappingResponse = _responseGenerator.createGuestOSMappingResponse(guestOSHypervisor); osMappingResponses.add(guestOsMappingResponse); } response.setResponses(osMappingResponses, result.second()); response.setResponseName(getCommandName()); setResponseObject(response); }
@Override public void execute() { final Pair<List<? extends NetworkACLItem>, Integer> result = _networkACLService.listNetworkACLItems(this); final ListResponse<NetworkACLItemResponse> response = new ListResponse<>(); final List<NetworkACLItemResponse> aclResponses = new ArrayList<>(); for (final NetworkACLItem acl : result.first()) { final NetworkACLItemResponse ruleData = _responseGenerator.createNetworkACLItemResponse(acl); aclResponses.add(ruleData); } response.setResponses(aclResponses, result.second()); response.setResponseName(getCommandName()); setResponseObject(response); }
@Override public void execute() { final Pair<List<? extends Cluster>, Integer> result = _mgr.searchForClusters(this); final ListResponse<ClusterResponse> response = new ListResponse<>(); final List<ClusterResponse> clusterResponses = new ArrayList<>(); for (final Cluster cluster : result.first()) { final ClusterResponse clusterResponse = _responseGenerator.createClusterResponse(cluster, showCapacities); clusterResponse.setObjectName("cluster"); clusterResponses.add(clusterResponse); } response.setResponses(clusterResponses, result.second()); response.setResponseName(getCommandName()); this.setResponseObject(response); }
@Override public void execute() { final Pair<List<? extends GuestVlan>, Integer> vlans = _networkService.listDedicatedGuestVlanRanges(this); final ListResponse<GuestVlanRangeResponse> response = new ListResponse<>(); final List<GuestVlanRangeResponse> guestVlanResponses = new ArrayList<>(); for (final GuestVlan vlan : vlans.first()) { final GuestVlanRangeResponse guestVlanResponse = _responseGenerator.createDedicatedGuestVlanRangeResponse(vlan); guestVlanResponse.setObjectName("dedicatedguestvlanrange"); guestVlanResponses.add(guestVlanResponse); } response.setResponses(guestVlanResponses, vlans.second()); response.setResponseName(getCommandName()); this.setResponseObject(response); }