org.greenrobot.greendao.internal

Class SqlUtils

java.lang.Object

org.greenrobot.greendao.internal.SqlUtils

public class SqlUtils
extends java.lang.Object

Helper class to create SQL statements as used by greenDAO internally.

Constructor Summary

Constructors

Constructor and Description
SqlUtils()

Method Summary

Modifier and Type	Method and Description
static java.lang.StringBuilder	appendColumn(java.lang.StringBuilder builder, java.lang.String column)
static java.lang.StringBuilder	appendColumn(java.lang.StringBuilder builder, java.lang.String tableAlias, java.lang.String column)
static java.lang.StringBuilder	appendColumns(java.lang.StringBuilder builder, java.lang.String[] columns)
static java.lang.StringBuilder	appendColumns(java.lang.StringBuilder builder, java.lang.String tableAlias, java.lang.String[] columns)
static java.lang.StringBuilder	appendColumnsEqualPlaceholders(java.lang.StringBuilder builder, java.lang.String[] columns)
static java.lang.StringBuilder	appendColumnsEqValue(java.lang.StringBuilder builder, java.lang.String tableAlias, java.lang.String[] columns)
static java.lang.StringBuilder	appendPlaceholders(java.lang.StringBuilder builder, int count)
static java.lang.StringBuilder	appendProperty(java.lang.StringBuilder builder, java.lang.String tablePrefix, Property property)
static java.lang.String	createSqlCount(java.lang.String tablename)
static java.lang.String	createSqlDelete(java.lang.String tablename, java.lang.String[] columns) Remember: SQLite does not support joins nor table alias for DELETE.
static java.lang.String	createSqlInsert(java.lang.String insertInto, java.lang.String tablename, java.lang.String[] columns)
static java.lang.String	createSqlSelect(java.lang.String tablename, java.lang.String tableAlias, java.lang.String[] columns, boolean distinct) Creates an select for given columns with a trailing space
static java.lang.String	createSqlSelectCountStar(java.lang.String tablename, java.lang.String tableAliasOrNull) Creates SELECT COUNT(*) with a trailing space.
static java.lang.String	createSqlUpdate(java.lang.String tablename, java.lang.String[] updateColumns, java.lang.String[] whereColumns)
static java.lang.String	escapeBlobArgument(byte[] bytes)
static java.lang.String	toHex(byte[] bytes)

Methods inherited from class java.lang.Object

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

Constructor Detail

SqlUtils

public SqlUtils()

Method Detail

appendProperty

public static java.lang.StringBuilder appendProperty(java.lang.StringBuilder builder,
                                                     java.lang.String tablePrefix,
                                                     Property property)

appendColumn

public static java.lang.StringBuilder appendColumn(java.lang.StringBuilder builder,
                                                   java.lang.String column)

appendColumn

public static java.lang.StringBuilder appendColumn(java.lang.StringBuilder builder,
                                                   java.lang.String tableAlias,
                                                   java.lang.String column)

appendColumns

public static java.lang.StringBuilder appendColumns(java.lang.StringBuilder builder,
                                                    java.lang.String tableAlias,
                                                    java.lang.String[] columns)

appendColumns

public static java.lang.StringBuilder appendColumns(java.lang.StringBuilder builder,
                                                    java.lang.String[] columns)

appendPlaceholders

public static java.lang.StringBuilder appendPlaceholders(java.lang.StringBuilder builder,
                                                         int count)

appendColumnsEqualPlaceholders

public static java.lang.StringBuilder appendColumnsEqualPlaceholders(java.lang.StringBuilder builder,
                                                                     java.lang.String[] columns)

appendColumnsEqValue

public static java.lang.StringBuilder appendColumnsEqValue(java.lang.StringBuilder builder,
                                                           java.lang.String tableAlias,
                                                           java.lang.String[] columns)

createSqlInsert

public static java.lang.String createSqlInsert(java.lang.String insertInto,
                                               java.lang.String tablename,
                                               java.lang.String[] columns)

createSqlSelect

public static java.lang.String createSqlSelect(java.lang.String tablename,
                                               java.lang.String tableAlias,
                                               java.lang.String[] columns,
                                               boolean distinct)

Creates an select for given columns with a trailing space

createSqlSelectCountStar

public static java.lang.String createSqlSelectCountStar(java.lang.String tablename,
                                                        java.lang.String tableAliasOrNull)

Creates SELECT COUNT(*) with a trailing space.

createSqlDelete

public static java.lang.String createSqlDelete(java.lang.String tablename,
                                               java.lang.String[] columns)

Remember: SQLite does not support joins nor table alias for DELETE.

createSqlUpdate

public static java.lang.String createSqlUpdate(java.lang.String tablename,
                                               java.lang.String[] updateColumns,
                                               java.lang.String[] whereColumns)

createSqlCount

public static java.lang.String createSqlCount(java.lang.String tablename)

escapeBlobArgument

public static java.lang.String escapeBlobArgument(byte[] bytes)

toHex

public static java.lang.String toHex(byte[] bytes)