nz.co.gregs.dbvolution.datatypes

Class DBStringTrimmed

java.lang.Object

nz.co.gregs.dbvolution.datatypes.QueryableDatatype<String>

nz.co.gregs.dbvolution.datatypes.DBString

nz.co.gregs.dbvolution.datatypes.DBStringTrimmed

All Implemented Interfaces:

Serializable, DBExpression, AnyResult<String>, EqualResult<String>, ExpressionCanHaveNullValues, ExpressionHasStandardStringResult, InResult<String>, RangeResult<String>, StringResult

public class DBStringTrimmed
extends DBString

Variant on DBString that automatically truncates the string value, useful when working with MS SQLServer CHAR columns.

Support DBvolution at Patreon

Author:

Gregory Graham

See Also:

Serialized Form

Field Summary

Fields inherited from class nz.co.gregs.dbvolution.datatypes.QueryableDatatype

SORT_ASCENDING, SORT_DESCENDING

Constructor Summary

Constructors

Constructor and Description
DBStringTrimmed() The default constructor for DBStringTrimmed.
DBStringTrimmed(String string) Creates a DBString with the value provided.
DBStringTrimmed(StringExpression stringExpression) Creates a column expression with a string result from the expression provided.

Method Summary

Methods

Modifier and Type	Method and Description
String	formatColumnForSQLStatement(DBDefinition db, String formattedColumnName) Returns the column of the object formatted for the database.
String	formatValueForSQLStatement(DBDefinition db) Returns the value of the object formatted for the database This should be overridden in each subclass This method is called by toSQLString after checking for NULLs and should return a string representation of the object formatted for use within a SQL select, insert, update, or delete statement.

Methods inherited from class nz.co.gregs.dbvolution.datatypes.DBString

copy, excludedPattern, excludedPattern, excludedRange, excludedRange, excludedRangeExclusive, excludedRangeExclusive, excludedRangeInclusive, excludedRangeInclusive, excludedValues, excludedValues, excludedValues, excludedValuesIgnoreCase, excludedValuesIgnoreCase, excludedValuesIgnoreCase, getColumn, getFromResultSet, getIncludesNull, getQueryableDatatypeForExpressionValue, getSQLDatatype, getTablesInvolved, getValue, isAggregator, isEmptyOrNullString, isEmptyString, permittedPattern, permittedPattern, permittedPatternIgnoreCase, permittedRange, permittedRange, permittedRangeExclusive, permittedRangeExclusive, permittedRangeInclusive, permittedRangeInclusive, permittedValues, permittedValues, permittedValues, permittedValues, permittedValuesIgnoreCase, permittedValuesIgnoreCase, permittedValuesIgnoreCase, permittedValuesIgnoreCase, setToNull, setValue, setValueFromStandardStringEncoding, stringResult, toStringList

Methods inherited from class nz.co.gregs.dbvolution.datatypes.QueryableDatatype

clear, createSQLForFromClause, equals, getColumnExpression, getLiteralValue, getOperator, getPreviousSQLValue, getPreviousValue, getPropertyWrapperDefinition, getQueryableDatatypeForObject, getQueryableDatatypeInstance, getSortOrder, hasBeenSet, hasChanged, hasColumnExpression, hashCode, includingNulls, isComplexExpression, isDefined, isNotNull, isNull, isPurelyFunctional, negateOperator, removeConstraints, setChanged, setColumnExpression, setDefined, setFromResultSet, setLiteralValue, setOperator, setPreviousValue, setSortOrderAscending, setSortOrderDescending, setToNull, setUnchanged, setValueToNull, stringValue, toSQLString, toString

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface nz.co.gregs.dbvolution.expressions.DBExpression

createSQLForFromClause, isComplexExpression, isPurelyFunctional, toSQLString

Constructor Detail

DBStringTrimmed

public DBStringTrimmed()

The default constructor for DBStringTrimmed.

Creates an unset undefined DBStringTrimmed object.

DBStringTrimmed

public DBStringTrimmed(String string)

Creates a DBString with the value provided.

The resulting DBString will be set as having the value provided but will not be defined in the database.

Parameters:

string - string

DBStringTrimmed

public DBStringTrimmed(StringExpression stringExpression)

Creates a column expression with a string result from the expression provided.

Used in DBReport, and some DBRow, sub-classes to derive data from the database prior to retrieval.

Parameters:

stringExpression - stringExpression

Method Detail

formatValueForSQLStatement

public String formatValueForSQLStatement(DBDefinition db)

Description copied from class: QueryableDatatype

Returns the value of the object formatted for the database This should be overridden in each subclass This method is called by toSQLString after checking for NULLs and should return a string representation of the object formatted for use within a SQL select, insert, update, or delete statement. For Example: DBString{yada} => 'yada' DBInteger{1234} => 123 DBDate{1/March/2013} => TO_DATE('20130301', 'YYYYMMDD')

Overrides:

formatValueForSQLStatement in class DBString

Parameters:

db - db

Support DBvolution at Patreon

Returns:

the literal value translated to a String ready to insert into an SQL statement

formatColumnForSQLStatement

public String formatColumnForSQLStatement(DBDefinition db,
                                 String formattedColumnName)

Description copied from class: QueryableDatatype

Returns the column of the object formatted for the database.

This method provides a route to transforming all calls to a column prior to use in SQL.

See the implementation in DBStringTrimmed for an example.

Overrides:

formatColumnForSQLStatement in class QueryableDatatype<String>

Parameters:

db - db

formattedColumnName - the name of the database column or similar expression ready to be used in an SQL excerpt

Support DBvolution at Patreon

Returns:

the formatted column ready to be used in an SQL statement