zserio.runtime.validation

Class ValidationSqliteUtil

java.lang.Object

zserio.runtime.validation.ValidationSqliteUtil

public final class ValidationSqliteUtil
extends java.lang.Object

Contains SQL utilities need for validation code generated by Zserio.

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	ValidationSqliteUtil.ColumnDescription Describes the table column.

Constructor Summary

Constructors

Constructor and Description
ValidationSqliteUtil()

Method Summary

Modifier and Type	Method and Description
static java.util.Map<java.lang.String,ValidationSqliteUtil.ColumnDescription>	getTableSchema(java.sql.Connection connection, java.lang.String attachedDbName, java.lang.String tableName) Returns a map of column names to column description for given SQLite table.
static boolean	isHiddenColumnInTable(java.sql.Connection connection, java.lang.String attachedDbName, java.lang.String tableName, java.lang.String hiddenColumnName) Checks if hidden column exits in given SQLite table.
static java.lang.String	sqliteColumnTypeName(int columnType) Gets name of the given SQLite column type.
static int	sqlTypeToSqliteType(int columnType) Converts SQL type returned by ResultSetMetaData.getColumnType.

Methods inherited from class java.lang.Object

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

Constructor Detail

ValidationSqliteUtil

public ValidationSqliteUtil()

Method Detail

getTableSchema

public static java.util.Map<java.lang.String,ValidationSqliteUtil.ColumnDescription> getTableSchema(java.sql.Connection connection,
                                                                                                    java.lang.String attachedDbName,
                                                                                                    java.lang.String tableName)
                                                                                             throws java.sql.SQLException

Returns a map of column names to column description for given SQLite table.

Parameters:

connection - Database connection to use.

attachedDbName - Attached database name if table is relocated in different database or null.

tableName - Name of the table to get column types of.

Returns:

Map of column names to column description.

Throws:

java.sql.SQLException - Throws in case of any SQLite error.

isHiddenColumnInTable

public static boolean isHiddenColumnInTable(java.sql.Connection connection,
                                            java.lang.String attachedDbName,
                                            java.lang.String tableName,
                                            java.lang.String hiddenColumnName)

Checks if hidden column exits in given SQLite table.

Parameters:

connection - Database connection to use.

attachedDbName - Attached database name if table is relocated in different database or null.

tableName - Name of the table where to check hidden column.

hiddenColumnName - Name of hidden column to check.

Returns:

true if hidden column exists in given SQLite table.

sqlTypeToSqliteType

public static int sqlTypeToSqliteType(int columnType)

Converts SQL type returned by ResultSetMetaData.getColumnType. It converts only types which belongs to one of Types.INTEGER, Types.REAL, Types.VARCHAR, Types.BLOB or Types.NULL to SQLite type. All others types are left unchanged (possibly unknown for SQLite).

Parameters:

columnType - SQL column type returned by ResultSetMetaData.getColumnType().

Returns:

SQLite column type.

sqliteColumnTypeName

public static java.lang.String sqliteColumnTypeName(int columnType)

Gets name of the given SQLite column type. Note that Zserio supports only INTEGER, REAL, VARCHAR ("TEXT") and BLOB. Latest Xerial JDBC driver uses sqlite3_column_decltype in ResultSetMetaData.getColumnTypeName and thus doesn't reflect current dynamic type and therefore we cannon use it.

Parameters:

columnType - SQLite column type returned from sqlTypeToSqliteType.

Returns:

SQLite column type name.