com.fdflib.persistence.queries

Class CorePostgreSqlQueries

java.lang.Object

com.fdflib.persistence.queries.CorePostgreSqlQueries

All Implemented Interfaces:

CorePersistenceImpl

public class CorePostgreSqlQueries
extends java.lang.Object
implements CorePersistenceImpl

Created by brian.gormanly on 1/14/16.

Method Summary

Modifier and Type	Method and Description
void	checkDatabase()
void	checkDefaultEntries()
void	checkFields()
void	checkTables()
static CorePostgreSqlQueries	getInstance()
<S> java.lang.Long	insert(java.lang.Class<S> c, S state)
<S extends CommonState> java.util.List<S>	selectQuery(java.lang.Class c, java.util.List<java.lang.String> select, java.util.List<WhereClause> where) General select Query to retrieve all information for passed entity, can be used to return specified data from any table.
<S> void	update(java.lang.Class<S> c, S state)

Methods inherited from class java.lang.Object

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

Method Detail

getInstance

public static CorePostgreSqlQueries getInstance()

checkDatabase

public void checkDatabase()
                   throws java.sql.SQLException

Specified by:

checkDatabase in interface CorePersistenceImpl

Throws:

java.sql.SQLException

checkTables

public void checkTables()
                 throws java.sql.SQLException

Specified by:

checkTables in interface CorePersistenceImpl

Throws:

java.sql.SQLException

checkFields

public void checkFields()
                 throws java.sql.SQLException

Specified by:

checkFields in interface CorePersistenceImpl

Throws:

java.sql.SQLException

checkDefaultEntries

public void checkDefaultEntries()
                         throws java.sql.SQLException

Specified by:

checkDefaultEntries in interface CorePersistenceImpl

Throws:

java.sql.SQLException

update

public <S> void update(java.lang.Class<S> c,
                       S state)

Specified by:

update in interface CorePersistenceImpl

insert

public <S> java.lang.Long insert(java.lang.Class<S> c,
                                 S state)

Specified by:

insert in interface CorePersistenceImpl

selectQuery

public <S extends CommonState> java.util.List<S> selectQuery(java.lang.Class c,
                                                             java.util.List<java.lang.String> select,
                                                             java.util.List<WhereClause> where)

General select Query to retrieve all information for passed entity, can be used to return specified data from any table. It looks to the class for datatype information and matches each table field returned to the EntityState object by name. If specific select statements are made they only the corresponding object members will return with data. If the select parameter is null, all memebers will be returned. Table to query is determined by passing in the corresponding model class. (ex. MyObjectModel.class) Where clauses are passed as an List of Where objects which contain the key (or name), the value to check against, and the type of Conditional (applied between clauses if there is more then one, AND is the default). Example sql statement that would be generated for the following class: User.class and where: {[firstName, Larry], [lastName, Smith, AND]} would be: SELECT * FROM User where firstName = 'Larry' AND lastName = 'Smith';

Specified by:

selectQuery in interface CorePersistenceImpl

Type Parameters:

S - Type extending CommonState to query and return

Parameters:

c - Class of entity to select from

where - where clauses

Returns:

data queried