org.labkey.remoteapi.query.BaseQueryCommand Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of labkey-client-api Show documentation
Show all versions of labkey-client-api Show documentation
The client-side library for Java developers is a separate JAR from the LabKey Server code base. It can be used by any Java program, including another Java web application.
The newest version!
/*
* Copyright (c) 2009-2018 LabKey Corporation
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package org.labkey.remoteapi.query;
import org.labkey.remoteapi.Command;
import org.labkey.remoteapi.CommandResponse;
import java.util.HashMap;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
/**
* User: brittp
* Date: Jun 24, 2009
* Time: 10:11:39 PM
*/
public abstract class BaseQueryCommand extends Command
{
protected int _maxRows = -1;
protected int _offset = 0;
protected List _sorts = new ArrayList();
protected List _filters = new ArrayList();
protected ContainerFilter _containerFilter;
private Map _queryParameters = new HashMap();
public BaseQueryCommand(BaseQueryCommand source)
{
super(source);
_containerFilter = source._containerFilter;
_offset = source._offset;
_maxRows = source._maxRows;
//deep copy sorts and filters lists
for (Sort sort : source._sorts)
{
_sorts.add(new Sort(sort));
}
for (Filter filter : source._filters)
{
_filters.add(new Filter(filter));
}
}
public BaseQueryCommand(String controllerName, String actionName)
{
super(controllerName, actionName);
}
/**
* Returns the current row limit value. Defaults to -1, meaning return all rows.
*
* @return The current row limit value.
*/
public int getMaxRows()
{
return _maxRows;
}
/**
* Sets the current row limit value. If this is set to a positive value, only
* the first maxRows rows will be returned from the server.
*
* @param maxRows The maximum number of rows to return, or -1 to get all rows (default)
*/
public void setMaxRows(int maxRows)
{
_maxRows = maxRows;
}
/**
* Returns the index of the first row in the resultset to return (defaults to 0).
*
* @return The current offset index.
*/
public int getOffset()
{
return _offset;
}
/**
* Sets the index of the first row in the resultset to return from the server.
* Use this in conjunction with {@link #setMaxRows(int)} to return pages of
* rows at a time from the server.
*
* @param offset The current offset index.
*/
public void setOffset(int offset)
{
_offset = offset;
}
/**
* Returns the current list of sort definitions.
*
* @return The current list of sort definitions, or null if none are defined.
*/
public List getSorts()
{
return _sorts;
}
/**
* Sets the current set of sort definitions.
*
* @param sorts The new list of sort definitions.
*/
public void setSorts(List sorts)
{
_sorts = sorts;
}
/**
* Adds a new sort definition to the current list.
*
* @param sort The new sort definition.
*/
public void addSort(Sort sort)
{
if (_sorts == null)
_sorts = new ArrayList();
_sorts.add(sort);
}
/**
* Constructs and adds a new sort definition to the current list.
* This is equivallent to calling addSort(new Sort(columnName, direction))
*
* @param columnName The column name.
* @param direction The sort direction.
* @see org.labkey.remoteapi.query.Sort
*/
public void addSort(String columnName, Sort.Direction direction)
{
addSort(new Sort(columnName, direction));
}
/**
* Returns the current list of filters, or null if none are defined.
*
* @return The current list of filters.
*/
public List getFilters()
{
return _filters;
}
/**
* Sets the current list of filters.
*
* @param filters The new list of filters.
*/
public void setFilters(List filters)
{
_filters = filters;
}
/**
* Adds a new filter to the list.
*
* @param filter The new filter definition.
*/
public void addFilter(Filter filter)
{
getFilters().add(filter);
}
/**
* Constructs and adds a new filter to the list. This is equivallent to
* addFilter(new Filter(columnName, value, operator))
*
* @param columnName The column name.
* @param value The filter value.
* @param operator The filter operator.
* @see org.labkey.remoteapi.query.Filter
*/
public void addFilter(String columnName, Object value, Filter.Operator operator)
{
addFilter(new Filter(columnName, value, operator));
}
/**
* Returns the container filter set for this command
*
* @return the container filter (may be null)
*/
public ContainerFilter getContainerFilter()
{
return _containerFilter;
}
/**
* Sets the container filter for the sql to be executed.
* This will cause the query to be executed over more than one container.
*
* @param containerFilter the filter to apply to the query (may be null)
*/
public void setContainerFilter(ContainerFilter containerFilter)
{
_containerFilter = containerFilter;
}
/**
@return Map of name (string)/value pairs for the values of parameters if the SQL references underlying queries
that are parameterized.
*/
public Map getQueryParameters()
{
return _queryParameters;
}
/**
Map of name (string)/value pairs for the values of parameters if the SQL references underlying queries
that are parameterized.
@param parameters the set of parameters
*/
public void setQueryParameters(Map parameters)
{
_queryParameters = parameters;
}
@Override
public Map getParameters()
{
Map params = super.getParameters();
if (getOffset() > 0)
params.put("offset", getOffset());
if (getMaxRows() >= 0)
params.put("maxRows", getMaxRows());
if(null != getSorts() && getSorts().size() > 0)
params.put("query.sort", Sort.getSortQueryStringParam(getSorts()));
if(null != getFilters())
{
for(Filter filter : getFilters())
params.put("query." + filter.getQueryStringParamName(), filter.getQueryStringParamValue());
}
if(getContainerFilter() != null)
params.put("containerFilter", getContainerFilter().name());
for (Map.Entry entry : getQueryParameters().entrySet())
{
params.put("query.param." + entry.getKey(), entry.getValue());
}
return params;
}
}