Package org.yamcs.http.api
Class SqlBuilder
- java.lang.Object
-
- org.yamcs.http.api.SqlBuilder
-
public class SqlBuilder extends Object
-
-
Constructor Summary
Constructors Constructor Description SqlBuilder(String table)
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description SqlBuilder
descend(boolean descend)
List<Object>
getQueryArguments()
SqlBuilder
limit(long limit)
SqlBuilder
limit(long offset, long limit)
SqlBuilder
select(String... exprs)
Additive!String
toString()
SqlBuilder
where(String whereCondition, Object... args)
Additive!SqlBuilder
whereColAfter(String colName, com.google.protobuf.Timestamp timestamp)
SqlBuilder
whereColAfterOrEqual(String colName, com.google.protobuf.Timestamp timestamp)
SqlBuilder
whereColBefore(String colName, com.google.protobuf.Timestamp timestamp)
SqlBuilder
whereColBeforeOrEqual(String colName, com.google.protobuf.Timestamp timestamp)
SqlBuilder
whereColIn(String colName, Collection<?> values)
-
-
-
Constructor Detail
-
SqlBuilder
public SqlBuilder(String table)
-
-
Method Detail
-
select
public SqlBuilder select(String... exprs)
Additive! Calling multiple times will add extra select expressions to the already specified list.
-
where
public SqlBuilder where(String whereCondition, Object... args)
Additive! Calling multiple times will add extra conditions to the already specified list.
-
whereColAfter
public SqlBuilder whereColAfter(String colName, com.google.protobuf.Timestamp timestamp)
-
whereColAfterOrEqual
public SqlBuilder whereColAfterOrEqual(String colName, com.google.protobuf.Timestamp timestamp)
-
whereColBeforeOrEqual
public SqlBuilder whereColBeforeOrEqual(String colName, com.google.protobuf.Timestamp timestamp)
-
whereColBefore
public SqlBuilder whereColBefore(String colName, com.google.protobuf.Timestamp timestamp)
-
whereColIn
public SqlBuilder whereColIn(String colName, Collection<?> values)
-
descend
public SqlBuilder descend(boolean descend)
-
limit
public SqlBuilder limit(long limit)
-
limit
public SqlBuilder limit(long offset, long limit)
-
-