com.scooterframework.orm.sqldataexpress.util
Class SqlConstants

java.lang.Object
  extended by com.scooterframework.orm.sqldataexpress.util.SqlConstants

public class SqlConstants
extends java.lang.Object

SqlConstants class holds all constants used in SQL Data Express.


Field Summary
static java.lang.String key_database
          Key table key represents a database connection name.
static java.lang.String key_group_by
          Key group_by represents GROUP BY clause in sql.
static java.lang.String key_having
          Key having represents HAVING clause in sql.
static java.lang.String key_order
          Key order represents direction of sort.
static java.lang.String key_order_by
          Key order_by represents ORDER BY clause in sql.
static java.lang.String key_sort
          Key sort indicates column names to sort.
static java.lang.String key_table
          Key table key represents a table name.
static java.lang.String key_view
          Key table key represents a view name.
 
Constructor Summary
SqlConstants()
           
 
Method Summary
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

key_database

public static final java.lang.String key_database
Key table key represents a database connection name.

See Also:
Constant Field Values

key_table

public static final java.lang.String key_table
Key table key represents a table name.

See Also:
Constant Field Values

key_view

public static final java.lang.String key_view
Key table key represents a view name.

See Also:
Constant Field Values

key_group_by

public static final java.lang.String key_group_by

Key group_by represents GROUP BY clause in sql.

For example, "group_by=id, name" will be translated to SQL query as "GROUP BY id, name".

See Also:
Constant Field Values

key_having

public static final java.lang.String key_having

Key having represents HAVING clause in sql. This is usually used with group_by together.

The HAVING clause was added to SQL because the WHERE keyword could not be used with aggregate functions.

For example, "having=sum(price)<100" will be translated to SQL query as "HAVING sum(price)<100".

See Also:
Constant Field Values

key_order_by

public static final java.lang.String key_order_by

Key order_by represents ORDER BY clause in sql.

For example, "order_by=age desc" will be translated to SQL query as "ORDER BY age desc".

See Also:
Constant Field Values

key_sort

public static final java.lang.String key_sort

Key sort indicates column names to sort.

For example, "sort=first_name" will be translated to SQL query as "order by first_name".

See Also:
Constant Field Values

key_order

public static final java.lang.String key_order

Key order represents direction of sort. If the query result set is in descending order, use value "Down". Otherwise by default the query results are in ascending order.

See Also:
Constant Field Values
Constructor Detail

SqlConstants

public SqlConstants()