AbstractDialect (PretronicDatabaseQuery 1.1.0.24 API)

java.lang.Object
- net.pretronic.databasequery.sql.dialect.defaults.AbstractDialect

All Implemented Interfaces:

ConnectionStringCreator, Dialect

Direct Known Subclasses:

H2PortableDialect, MariaDBDialect, MySQLDialect
```
public abstract class AbstractDialect
extends Object
implements Dialect
```

Nested Class Summary

Nested Classes
Modifier and Type	Class	Description
`private static class`	`AbstractDialect.FindQueryBuilderState`
`private static class`	`AbstractDialect.SearchQueryBuilderState`
`private static class`	`AbstractDialect.UpdateQueryBuilderState`

Field Summary

Fields
Modifier and Type	Field	Description
`private Class<? extends Driver>`	`driver`
`private String`	`driverName`
`private boolean`	`dynamicDependencies`
`private DatabaseDriverEnvironment`	`environment`
`private String`	`name`
`private String`	`protocol`

Fields inherited from interface net.pretronic.databasequery.sql.dialect.Dialect
DIALECTS, H2_PORTABLE, MARIADB, MYSQL

Constructor Summary

Constructors
Constructor Description

AbstractDialect(String name, String driverName, String protocol, DatabaseDriverEnvironment environment, boolean dynamicDependencies)

Constructors
Constructor	Description
`AbstractDialect(String name, String driverName, String protocol, DatabaseDriverEnvironment environment, boolean dynamicDependencies)`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`private Object`	`addAndGetEntry(Object value, AbstractDialect.SearchQueryBuilderState state)`
`private void`	`addEntry(Object value, AbstractDialect.SearchQueryBuilderState state)`
`private void`	`andOr(AbstractSearchQuery.OperationEntry entry, String symbol, AbstractDialect.SearchQueryBuilderState state)`
`private void`	`buildCreateQueryCreateEntry(SQLDatabase database, StringBuilder queryBuilder, List<Object> preparedValues, AbstractCreateQuery.CreateEntry entry)`
`private net.pretronic.libraries.utility.map.Pair<String,String>`	`buildCreateQueryFieldOptions(StringBuilder queryBuilder, AbstractCreateQuery.CreateEntry entry)`
`private String`	`buildField(String database, String databaseCollection, String field)`
`private String`	`buildField(AbstractChangeAndSearchQuery.ChangeAndSearchEntry entry)`
`private String`	`buildField(AbstractFindQuery.GetEntry entry)`
`private String`	`buildField(AbstractSearchQuery.ConditionEntry entry)`
`private String`	`buildField(AbstractSearchQuery.GroupByEntry entry)`
`private String`	`buildField(AbstractSearchQuery.OrderByEntry entry)`
`private void`	`buildFindQueryEntry(AbstractFindQuery.GetEntry entry, AbstractDialect.FindQueryBuilderState state)`
`private String`	`buildFindQueryGetBuilder(AbstractDialect.FindQueryBuilderState state)`
`private void`	`buildForeignKey(SQLDatabase database, StringBuilder queryBuilder, AbstractCreateQuery.ForeignKeyEntry entry)`
`private void`	`buildInsertQueryFieldsPart(List<AbstractInsertQuery.Entry> entries, StringBuilder queryBuilder, AtomicInteger preparedValuesCount, AtomicInteger valueCount, List<Object> preparedValues, Object[] values)`
`private void`	`buildSearchQueryConditionEntry(AbstractSearchQuery.ConditionEntry entry, AbstractDialect.SearchQueryBuilderState state, String entryConnector, boolean bracketFirst)`
`private void`	`buildSearchQueryConditionEntryType(AbstractSearchQuery.ConditionEntry entry, AbstractDialect.SearchQueryBuilderState state)`
`private void`	`buildSearchQueryEntry(AbstractSearchQuery.Entry entry, AbstractDialect.SearchQueryBuilderState state, String entryConnector, boolean bracketFirst)`
`private void`	`buildSearchQueryGroupByEntry(AbstractSearchQuery.GroupByEntry entry, AbstractDialect.SearchQueryBuilderState state)`
`private void`	`buildSearchQueryJoinEntry(AbstractSearchQuery.JoinEntry entry, AbstractDialect.SearchQueryBuilderState state)`
`private void`	`buildSearchQueryLimitEntry(AbstractSearchQuery.LimitEntry entry, AbstractDialect.SearchQueryBuilderState state)`
`private void`	`buildSearchQueryOperationEntry(AbstractSearchQuery.OperationEntry entry, AbstractDialect.SearchQueryBuilderState state)`
`private void`	`buildSearchQueryOrderByEntry(AbstractSearchQuery.OrderByEntry entry, AbstractDialect.SearchQueryBuilderState state)`
`private void`	`buildSearchQueryWhereBetweenConditionEntry(AbstractSearchQuery.ConditionEntry entry, AbstractDialect.SearchQueryBuilderState state)`
`private void`	`buildSearchQueryWhereConditionEntry(AbstractSearchQuery.ConditionEntry entry, AbstractDialect.SearchQueryBuilderState state)`
`private void`	`buildSearchQueryWhereInConditionEntry(AbstractSearchQuery.ConditionEntry entry, AbstractDialect.SearchQueryBuilderState state)`
`private void`	`buildSearchQueryWhereNullConditionEntry(AbstractSearchQuery.ConditionEntry entry, AbstractDialect.SearchQueryBuilderState state)`
`private void`	`buildUpdateQueryEntry(AbstractChangeAndSearchQuery.ChangeAndSearchEntry entry, AbstractDialect.UpdateQueryBuilderState state)`
`Class<? extends Driver>`	`getDriver()`
`String`	`getDriverName()`
`private Object`	`getEntry(Object value, AtomicInteger preparedValuesCount, Object[] values)`
`DatabaseDriverEnvironment`	`getEnvironment()`
`String`	`getName()`
`String`	`getProtocol()`
`private String`	`getWhereCompareSymbol(AbstractSearchQuery.ConditionEntry.Type type)`
`void`	`loadDriver()`
`net.pretronic.libraries.utility.map.Pair<String,List<Object>>`	`newCreateQuery(SQLDatabase database, List<AbstractCreateQuery.Entry> entries, String name, String engine, DatabaseCollectionType collectionType, FindQuery includingQuery, Object[] values)`
`net.pretronic.libraries.utility.map.Pair<String,List<Object>>`	`newDeleteQuery(SQLDatabaseCollection collection, List<AbstractSearchQuery.Entry> entries, Object[] values)`
`net.pretronic.libraries.utility.map.Pair<String,List<Object>>`	`newFindQuery(SQLDatabaseCollection collection, List<AbstractFindQuery.GetEntry> getEntries, List<AbstractSearchQuery.Entry> entries, Object[] values)`
`net.pretronic.libraries.utility.map.Pair<String,List<Object>>`	`newInsertQuery(SQLDatabaseCollection collection, List<AbstractInsertQuery.Entry> entries, Object[] values)`
`net.pretronic.libraries.utility.map.Pair<String,List<Object>>`	`newReplaceQuery(SQLDatabaseCollection collection, List<AbstractSearchQuery.Entry> entries, Object[] values)`
`net.pretronic.libraries.utility.map.Pair<String,List<Object>>`	`newUpdateQuery(SQLDatabaseCollection collection, List<AbstractSearchQuery.Entry> entries, Object[] values)`

Methods inherited from interface net.pretronic.databasequery.sql.dialect.ConnectionStringCreator
createConnectionString

Methods inherited from interface net.pretronic.databasequery.sql.dialect.Dialect
byName, getDialects, registerDialect, unregisterDialect, unregisterDialect

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

name
```
private final String name
```

driverName
```
private final String driverName
```

driver
```
private Class<? extends Driver> driver
```

protocol
```
private final String protocol
```

environment

private final DatabaseDriverEnvironment environment

dynamicDependencies

private final boolean dynamicDependencies

Constructor Detail

AbstractDialect

public AbstractDialect(String name,
                       String driverName,
                       String protocol,
                       DatabaseDriverEnvironment environment,
                       boolean dynamicDependencies)

Method Detail

getName
```
public String getName()
```
Specified by:

getName in interface Dialect

getDriverName
```
public String getDriverName()
```
Specified by:

getDriverName in interface Dialect

getDriver

public Class<? extends Driver> getDriver()

Specified by:: getDriver in interface Dialect

loadDriver
```
public void loadDriver()
```
Specified by:

loadDriver in interface Dialect

getProtocol
```
public String getProtocol()
```
Specified by:

getProtocol in interface Dialect

getEnvironment
```
public DatabaseDriverEnvironment getEnvironment()
```
Specified by:

getEnvironment in interface Dialect

newCreateQuery

public net.pretronic.libraries.utility.map.Pair<String,List<Object>> newCreateQuery(SQLDatabase database,
                                                                                    List<AbstractCreateQuery.Entry> entries,
                                                                                    String name,
                                                                                    String engine,
                                                                                    DatabaseCollectionType collectionType,
                                                                                    FindQuery includingQuery,
                                                                                    Object[] values)

Specified by:: newCreateQuery in interface Dialect

buildCreateQueryCreateEntry

private void buildCreateQueryCreateEntry(SQLDatabase database,
                                         StringBuilder queryBuilder,
                                         List<Object> preparedValues,
                                         AbstractCreateQuery.CreateEntry entry)

buildCreateQueryFieldOptions

private net.pretronic.libraries.utility.map.Pair<String,String> buildCreateQueryFieldOptions(StringBuilder queryBuilder,
                                                                                             AbstractCreateQuery.CreateEntry entry)

buildForeignKey

private void buildForeignKey(SQLDatabase database,
                             StringBuilder queryBuilder,
                             AbstractCreateQuery.ForeignKeyEntry entry)

newInsertQuery

public net.pretronic.libraries.utility.map.Pair<String,List<Object>> newInsertQuery(SQLDatabaseCollection collection,
                                                                                    List<AbstractInsertQuery.Entry> entries,
                                                                                    Object[] values)

Specified by:: newInsertQuery in interface Dialect

buildInsertQueryFieldsPart

private void buildInsertQueryFieldsPart(List<AbstractInsertQuery.Entry> entries,
                                        StringBuilder queryBuilder,
                                        AtomicInteger preparedValuesCount,
                                        AtomicInteger valueCount,
                                        List<Object> preparedValues,
                                        Object[] values)

newUpdateQuery

public net.pretronic.libraries.utility.map.Pair<String,List<Object>> newUpdateQuery(SQLDatabaseCollection collection,
                                                                                    List<AbstractSearchQuery.Entry> entries,
                                                                                    Object[] values)

Specified by:: newUpdateQuery in interface Dialect

buildUpdateQueryEntry

private void buildUpdateQueryEntry(AbstractChangeAndSearchQuery.ChangeAndSearchEntry entry,
                                   AbstractDialect.UpdateQueryBuilderState state)

newReplaceQuery

public net.pretronic.libraries.utility.map.Pair<String,List<Object>> newReplaceQuery(SQLDatabaseCollection collection,
                                                                                     List<AbstractSearchQuery.Entry> entries,
                                                                                     Object[] values)

Specified by:: newReplaceQuery in interface Dialect

newFindQuery

public net.pretronic.libraries.utility.map.Pair<String,List<Object>> newFindQuery(SQLDatabaseCollection collection,
                                                                                  List<AbstractFindQuery.GetEntry> getEntries,
                                                                                  List<AbstractSearchQuery.Entry> entries,
                                                                                  Object[] values)

Specified by:: newFindQuery in interface Dialect

buildFindQueryGetBuilder

private String buildFindQueryGetBuilder(AbstractDialect.FindQueryBuilderState state)

buildFindQueryEntry

private void buildFindQueryEntry(AbstractFindQuery.GetEntry entry,
                                 AbstractDialect.FindQueryBuilderState state)

newDeleteQuery

public net.pretronic.libraries.utility.map.Pair<String,List<Object>> newDeleteQuery(SQLDatabaseCollection collection,
                                                                                    List<AbstractSearchQuery.Entry> entries,
                                                                                    Object[] values)

Specified by:: newDeleteQuery in interface Dialect

buildSearchQueryEntry

private void buildSearchQueryEntry(AbstractSearchQuery.Entry entry,
                                   AbstractDialect.SearchQueryBuilderState state,
                                   String entryConnector,
                                   boolean bracketFirst)

buildSearchQueryConditionEntry

private void buildSearchQueryConditionEntry(AbstractSearchQuery.ConditionEntry entry,
                                            AbstractDialect.SearchQueryBuilderState state,
                                            String entryConnector,
                                            boolean bracketFirst)

buildSearchQueryConditionEntryType

private void buildSearchQueryConditionEntryType(AbstractSearchQuery.ConditionEntry entry,
                                                AbstractDialect.SearchQueryBuilderState state)

buildSearchQueryWhereConditionEntry

private void buildSearchQueryWhereConditionEntry(AbstractSearchQuery.ConditionEntry entry,
                                                 AbstractDialect.SearchQueryBuilderState state)

buildSearchQueryWhereNullConditionEntry

private void buildSearchQueryWhereNullConditionEntry(AbstractSearchQuery.ConditionEntry entry,
                                                     AbstractDialect.SearchQueryBuilderState state)

buildSearchQueryWhereInConditionEntry

private void buildSearchQueryWhereInConditionEntry(AbstractSearchQuery.ConditionEntry entry,
                                                   AbstractDialect.SearchQueryBuilderState state)

buildSearchQueryWhereBetweenConditionEntry

private void buildSearchQueryWhereBetweenConditionEntry(AbstractSearchQuery.ConditionEntry entry,
                                                        AbstractDialect.SearchQueryBuilderState state)

getWhereCompareSymbol

private String getWhereCompareSymbol(AbstractSearchQuery.ConditionEntry.Type type)

buildSearchQueryOperationEntry

private void buildSearchQueryOperationEntry(AbstractSearchQuery.OperationEntry entry,
                                            AbstractDialect.SearchQueryBuilderState state)

andOr

private void andOr(AbstractSearchQuery.OperationEntry entry,
                   String symbol,
                   AbstractDialect.SearchQueryBuilderState state)

buildSearchQueryJoinEntry

private void buildSearchQueryJoinEntry(AbstractSearchQuery.JoinEntry entry,
                                       AbstractDialect.SearchQueryBuilderState state)

buildSearchQueryOrderByEntry

private void buildSearchQueryOrderByEntry(AbstractSearchQuery.OrderByEntry entry,
                                          AbstractDialect.SearchQueryBuilderState state)

buildSearchQueryGroupByEntry

private void buildSearchQueryGroupByEntry(AbstractSearchQuery.GroupByEntry entry,
                                          AbstractDialect.SearchQueryBuilderState state)

buildSearchQueryLimitEntry

private void buildSearchQueryLimitEntry(AbstractSearchQuery.LimitEntry entry,
                                        AbstractDialect.SearchQueryBuilderState state)

buildField

private String buildField(AbstractSearchQuery.GroupByEntry entry)

buildField

private String buildField(AbstractFindQuery.GetEntry entry)

buildField

private String buildField(AbstractChangeAndSearchQuery.ChangeAndSearchEntry entry)

buildField

private String buildField(AbstractSearchQuery.OrderByEntry entry)

buildField

private String buildField(AbstractSearchQuery.ConditionEntry entry)

buildField

private String buildField(String database,
                          String databaseCollection,
                          String field)

getEntry

private Object getEntry(Object value,
                        AtomicInteger preparedValuesCount,
                        Object[] values)

addAndGetEntry

private Object addAndGetEntry(Object value,
                              AbstractDialect.SearchQueryBuilderState state)

addEntry

private void addEntry(Object value,
                      AbstractDialect.SearchQueryBuilderState state)

Class AbstractDialect

Nested Class Summary

Field Summary

Fields inherited from interface net.pretronic.databasequery.sql.dialect.Dialect

Constructor Summary

Method Summary

Methods inherited from interface net.pretronic.databasequery.sql.dialect.ConnectionStringCreator

Methods inherited from interface net.pretronic.databasequery.sql.dialect.Dialect

Methods inherited from class java.lang.Object

Field Detail

name

driverName

driver

protocol

environment

dynamicDependencies

Constructor Detail

AbstractDialect

Method Detail

getName

getDriverName

getDriver

loadDriver

getProtocol

getEnvironment

newCreateQuery

buildCreateQueryCreateEntry

buildCreateQueryFieldOptions

buildForeignKey

newInsertQuery

buildInsertQueryFieldsPart

newUpdateQuery

buildUpdateQueryEntry

newReplaceQuery

newFindQuery

buildFindQueryGetBuilder

buildFindQueryEntry

newDeleteQuery

buildSearchQueryEntry

buildSearchQueryConditionEntry

buildSearchQueryConditionEntryType

buildSearchQueryWhereConditionEntry

buildSearchQueryWhereNullConditionEntry

buildSearchQueryWhereInConditionEntry

buildSearchQueryWhereBetweenConditionEntry

getWhereCompareSymbol

buildSearchQueryOperationEntry

andOr

buildSearchQueryJoinEntry

buildSearchQueryOrderByEntry

buildSearchQueryGroupByEntry

buildSearchQueryLimitEntry

buildField

buildField

buildField

buildField

buildField

buildField

getEntry

addAndGetEntry

addEntry