Module org.yamcs.core

Package org.yamcs.yarch.query

Class Query

java.lang.Object

org.yamcs.yarch.query.Query

public class Query
extends Object

Helper class to programmatically build SQL queries.

Constructor Summary

Constructors

Constructor	Description
Query()

Method Summary

Modifier and Type	Method	Description
static CreateStreamQueryBuilder	createStream(String stream)
static CreateStreamQueryBuilder	createStream(String stream, TupleDefinition tdef)
static CreateTableQueryBuilder	createTable(String table)
static CreateTableQueryBuilder	createTable(String table, TupleDefinition tdef)
static DeleteFromTableQueryBuilder	deleteFromTable(String table)
static InsertIntoTableQueryBuilder	insertAppendIntoTable(String table, String... columns)
static InsertIntoTableQueryBuilder	insertAppendIntoTable(String table, Tuple tuple)
static InsertIntoTableQueryBuilder	insertIntoTable(String table, String... columns)
static InsertIntoTableQueryBuilder	insertIntoTable(String table, Tuple tuple)
static SelectStreamQueryBuilder	selectStream(String stream)
static SelectTableQueryBuilder	selectTable(String table)
static UpdateTableQueryBuilder	updateTable(String table)
static InsertIntoTableQueryBuilder	upsertAppendIntoTable(String table, String... columns)
static InsertIntoTableQueryBuilder	upsertAppendIntoTable(String table, Tuple tuple)
static InsertIntoTableQueryBuilder	upsertIntoTable(String table, String... columns)
static InsertIntoTableQueryBuilder	upsertIntoTable(String table, Tuple tuple)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

Query

public Query()

Method Details

createTable

public static CreateTableQueryBuilder createTable(String table)

createTable

public static CreateTableQueryBuilder createTable(String table,
 TupleDefinition tdef)

createStream

public static CreateStreamQueryBuilder createStream(String stream)

createStream

public static CreateStreamQueryBuilder createStream(String stream,
 TupleDefinition tdef)

selectTable

public static SelectTableQueryBuilder selectTable(String table)

selectStream

public static SelectStreamQueryBuilder selectStream(String stream)

insertIntoTable

public static InsertIntoTableQueryBuilder insertIntoTable(String table,
 String... columns)

insertIntoTable

public static InsertIntoTableQueryBuilder insertIntoTable(String table,
 Tuple tuple)

insertAppendIntoTable

public static InsertIntoTableQueryBuilder insertAppendIntoTable(String table,
 String... columns)

insertAppendIntoTable

public static InsertIntoTableQueryBuilder insertAppendIntoTable(String table,
 Tuple tuple)

upsertIntoTable

public static InsertIntoTableQueryBuilder upsertIntoTable(String table,
 String... columns)

upsertIntoTable

public static InsertIntoTableQueryBuilder upsertIntoTable(String table,
 Tuple tuple)

upsertAppendIntoTable

public static InsertIntoTableQueryBuilder upsertAppendIntoTable(String table,
 String... columns)

upsertAppendIntoTable

public static InsertIntoTableQueryBuilder upsertAppendIntoTable(String table,
 Tuple tuple)

updateTable

public static UpdateTableQueryBuilder updateTable(String table)

deleteFromTable

public static DeleteFromTableQueryBuilder deleteFromTable(String table)