com.github.pavinan.java.devextreme.helpers.datasource

Class DefaultSQLColumnProvider

java.lang.Object

com.github.pavinan.java.devextreme.helpers.datasource.DefaultSQLColumnProvider

All Implemented Interfaces:

SQLColumnProvider

public class DefaultSQLColumnProvider
extends java.lang.Object
implements SQLColumnProvider

Creates mapping for json names and database column names

Constructor Summary

Constructors

Constructor and Description
DefaultSQLColumnProvider()

Method Summary

Modifier and Type	Method and Description
java.lang.String	getDBColumnName(java.lang.String columnName) Default implementation
static java.lang.String	GetDBDateValueConversion(java.lang.String dateString) Some date conversions from iso formats to MSSQLServer dates
java.lang.String	getDBValueConversion(java.lang.String columnName, java.lang.String condition, java.lang.String value) Default implementation

Methods inherited from class java.lang.Object

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

Constructor Detail

DefaultSQLColumnProvider

public DefaultSQLColumnProvider()

Method Detail

GetDBDateValueConversion

public static java.lang.String GetDBDateValueConversion(java.lang.String dateString)
                                                 throws java.lang.Exception

Some date conversions from iso formats to MSSQLServer dates

Parameters:

dateString - json date

Returns:

converted date

Throws:

java.lang.Exception - For unknown date formats

getDBColumnName

public java.lang.String getDBColumnName(java.lang.String columnName)

Default implementation

Specified by:

getDBColumnName in interface SQLColumnProvider

Parameters:

columnName - json name

Returns:

dbname

getDBValueConversion

public java.lang.String getDBValueConversion(java.lang.String columnName,
                                             java.lang.String condition,
                                             java.lang.String value)

Default implementation

Specified by:

getDBValueConversion in interface SQLColumnProvider

Parameters:

columnName - json name

condition - =, <, "contains", "not contains" etc

value - json value

Returns:

converted value