de.xima.fc.gui.bean.data

Class DBQueryBean

java.lang.Object

de.xima.fc.gui.common.utils.msg.I18nUtils

de.xima.fc.gui.common.utils.msg.MessageUtils

de.xima.fc.gui.common.utils.msg.AMessaging

de.xima.fc.gui.common.utils.msg.AJSFContext

de.xima.fc.gui.bean.ABackendJSFContext

de.xima.fc.gui.bean.FCContextBean

de.xima.fc.gui.bean.data.DBQueryBean

All Implemented Interfaces:

Serializable

public class DBQueryBean
extends FCContextBean

Bean for handling db queries

Author:

xima media GmbH, Dresden - Michael Kohlsche - 28.03.2014

See Also:

Serialized Form

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
class	DBQueryBean.EntityListModelImpl

Nested classes/interfaces inherited from class de.xima.fc.gui.common.utils.msg.AJSFContext

AJSFContext.RedirectOptions, AJSFContext.RedirectOptionsBuilder

Field Summary

Fields inherited from class de.xima.fc.gui.bean.FCContextBean

systemUC

Constructor Summary

Constructors

Constructor and Description
DBQueryBean()

Method Summary

Modifier and Type	Method and Description
List<DatenbankZugriff>	getDatenbankzugriffe()
String	getGeneratedSql()
String	getGeneratedUrl()
org.primefaces.model.StreamedContent	getMarkedQueries() Generates StreamedContent from the List of all the marked database queries contained within the model.
IEntityListModelSelectByView<Datenquelle>	getModel()
String	getParamSql()
org.primefaces.model.StreamedContent	getQuery(Datenquelle query) Generates StreamedContent for the given db query and returns it
List<IParameterModel>	getQueryParams()
String	getResourceName(Datenquelle datenquelle)
String	getResultString()
DataTable<String,String>	getResultTable()
EDataView	getResultView()
void	setModel(IEntityListModelSelectByView<Datenquelle> model)
void	setQueryParams(List<IParameterModel> queryParams)
void	setResultView(EDataView resultView)
void	updateModel()
void	upload(org.primefaces.event.FileUploadEvent event)

Methods inherited from class de.xima.fc.gui.bean.FCContextBean

getNavigationBean, getSessionBean, isSetupUser, redirectToDashboard, setNavigationBean, setSessionBean, switchMainView, switchMainView, switchSubView, switchSubView

Methods inherited from class de.xima.fc.gui.bean.ABackendJSFContext

ec, isDetached, isHasDB

Methods inherited from class de.xima.fc.gui.common.utils.msg.AJSFContext

destroySessionBean, encodeURL, findBean, findBean, findBean, findBean, findCurrentView, getBeanName, getBeanName, getContext, getCurrentViewBean, getLocaleBean, getRequest, getResponse, getSession, getSession, getSessionAttribute, isMasterServerContext, loadLazy, redirect, redirect, redirect, redirect, redirectToDashboard, redirectToDashboard, setLocaleBean, setSessionAttribute, uc

Methods inherited from class de.xima.fc.gui.common.utils.msg.MessageUtils

addErrorMsg, addErrorMsg, addErrorMsg, addErrorMsg, addErrorMsg, addErrorMsg, addErrorMsgFromString, addErrorMsgFromString, addErrorMsgToComponent, addErrorMsgToComponent, addErrorMsgToComponent, addErrorMsgToComponent, addErrorMsgToComponent, addErrorMsgToComponent, addInfoMsg, addInfoMsg, addInfoMsg, addInfoMsg, addInfoMsgFromString, addInfoMsgFromString, addInfoMsgToComponent, addInfoMsgToComponent, addInfoMsgToComponent, addInfoMsgToComponent, addMsg, addMsg, addMsg, addMsg, addMsgs, addMsgToComponent, addMsgToComponent, addWarnMsg, addWarnMsg, addWarnMsg, addWarnMsg, addWarnMsgFromString, addWarnMsgFromString, addWarnMsgToComponent, addWarnMsgToComponent, addWarnMsgToComponent, addWarnMsgToComponent, cleanErrorMsg, getErrorMessage

Methods inherited from class de.xima.fc.gui.common.utils.msg.I18nUtils

getFacesContext, getLocale, rbValue, rbValue, rbValue

Methods inherited from class java.lang.Object

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

Constructor Detail

DBQueryBean

public DBQueryBean()

Method Detail

updateModel

public void updateModel()

getResourceName

public String getResourceName(Datenquelle datenquelle)

getModel

public IEntityListModelSelectByView<Datenquelle> getModel()

Returns:

the model

setModel

public void setModel(IEntityListModelSelectByView<Datenquelle> model)

Parameters:

model - the model to set

getDatenbankzugriffe

public List<DatenbankZugriff> getDatenbankzugriffe()

getResultView

public EDataView getResultView()

setResultView

public void setResultView(EDataView resultView)

getQueryParams

public List<IParameterModel> getQueryParams()

setQueryParams

public void setQueryParams(List<IParameterModel> queryParams)

getResultString

public String getResultString()

getResultTable

public DataTable<String,String> getResultTable()

getParamSql

public String getParamSql()

getGeneratedSql

public String getGeneratedSql()

getGeneratedUrl

public String getGeneratedUrl()

getQuery

public org.primefaces.model.StreamedContent getQuery(Datenquelle query)

Generates StreamedContent for the given db query and returns it

Parameters:

query - Datenquelle for which the StreamedContent should be generated

Returns:

StreamedContent of the given db query

getMarkedQueries

public org.primefaces.model.StreamedContent getMarkedQueries()

Generates StreamedContent from the List of all the marked database queries contained within the model. If this list contains only a single entry the StreamedContent for this database query will be returned. If the list contains more than one entry the queries will be packed into a zip file and the generated StreamedContent of the zip file will be returned.

Returns:

the StreamedContent of all the marked model database queries

upload

public void upload(org.primefaces.event.FileUploadEvent event)