APIdia Launch Partner

Top Fields Constructors Methods

net.ucanaccess.converters

public Class Pivot

Class Inheritance

extends Object

java.lang.Object
net.ucanaccess.converters.Pivot

Static Imports

net.ucanaccess.type.SqlConstants.PIVOT

Field Summary

Modifier and Type	Field and Description
private String	aggregateFun
private final Connection	conn
private String	expression
private String	from
private String	originalQuery
private static final Pattern	PAT_PIVOT
private static final Pattern	PAT_PIVOT_AGGR
private static final Pattern	PAT_PIVOT_CN
private static final Pattern	PAT_PIVOT_EXPR
private static final Pattern	PAT_PIVOT_GROUP_BY
private static final Map<String, String>	PIVOT_MAP
private List<String>	pivotIn
private boolean	pivotInCondition
private String	pivotStr
private static final Map<String, List<String>>	PREPARE_MAP
private String	select

Constructor Summary

Access	Constructor and Description
public	Pivot(Connection conn)

Method Summary

Modifier and Type	Method and Description
private void	appendCaseWhen(StringBuilder sb, String condition, String cn)
private void	cachePrepare(String name)
public static void	checkAndRefreshPivot(String currSql, UcanaccessConnection conn)
public static void	clearPrepared()
private String	format(Object cln)
public boolean	parsePivot(String query)
public boolean	prepare()
private void	prepareGetFromCache(String name)
public void	registerPivot(String name)
private String	replaceQuotation(String cn)
public String	toSQL(String name)
public String	verifySQL()

Inherited from java.lang.Object:: clone equals finalize getClass hashCode notify notifyAll toString wait wait wait

Field Detail

aggregateFun	back to summary
private String aggregateFun

conn	back to summary
private final Connection conn

expression	back to summary
private String expression

from	back to summary
private String from

originalQuery	back to summary
private String originalQuery

PAT_PIVOT	back to summary
private static final Pattern PAT_PIVOT Annotations @SuppressWarnings:java:S8786

PAT_PIVOT_AGGR	back to summary
private static final Pattern PAT_PIVOT_AGGR

PAT_PIVOT_CN	back to summary
private static final Pattern PAT_PIVOT_CN

PAT_PIVOT_EXPR	back to summary
private static final Pattern PAT_PIVOT_EXPR Annotations @SuppressWarnings:java:S8786

PAT_PIVOT_GROUP_BY	back to summary
private static final Pattern PAT_PIVOT_GROUP_BY Annotations @SuppressWarnings:java:S8786

PIVOT_MAP	back to summary
private static final Map<String, String> PIVOT_MAP

pivotIn	back to summary
private List<String> pivotIn

pivotInCondition	back to summary
private boolean pivotInCondition

pivotStr	back to summary
private String pivotStr

PREPARE_MAP	back to summary
private static final Map<String, List<String>> PREPARE_MAP

select	back to summary
private String select

Constructor Detail

Pivot	back to summary
public Pivot(Connection conn)

Method Detail

appendCaseWhen	back to summary
private void appendCaseWhen(StringBuilder sb, String condition, String cn)

cachePrepare	back to summary
private void cachePrepare(String name)

checkAndRefreshPivot	back to summary
public static void checkAndRefreshPivot(String currSql, UcanaccessConnection conn)

clearPrepared	back to summary
public static void clearPrepared()

format	back to summary
private String format(Object cln)

parsePivot	back to summary
public boolean parsePivot(String query)

prepare	back to summary
public boolean prepare()

prepareGetFromCache	back to summary
private void prepareGetFromCache(String name)

registerPivot	back to summary
public void registerPivot(String name)

replaceQuotation	back to summary
private String replaceQuotation(String cn)

toSQL	back to summary
public String toSQL(String name)

verifySQL	back to summary
public String verifySQL()