Package org.ametys.plugins.contentio.export.sql

Class FillSqlTableComponent

java.lang.Object

org.ametys.runtime.plugin.component.AbstractLogEnabled

org.ametys.plugins.contentio.export.sql.FillSqlTableComponent

All Implemented Interfaces:

LogEnabled, Component, Serviceable

public class FillSqlTableComponent
extends AbstractLogEnabled
implements Component, Serviceable

Fill sql table component

Field Summary

Fields

Modifier and Type	Field	Description
private Connection	_connection
protected ContentTypeExtensionPoint	_contentTypeExtensionPoint	Content type extension point.
protected Map<String,String>	_contentTypesToExport	The configured list of content types to export associated to the SQL table name to use
private static String	_EXCLUDE_XML_TAGS
private boolean	_exportNoMultiValuedTable
private boolean	_exportOnlyValidatedContent
protected I18nUtils	_i18nTranslator	The i18n translator.
protected LanguagesManager	_languageManager	The language manager
private String	_mappingPolicy
protected NormalizeNameComponent	_normalizeNameComponent	The normalise name component.
protected AmetysObjectResolver	_resolver	The ametys object resolver.
private String	_separator
private String	_sqlPrefixConf
private String	_sqlTablePrefix
private LinkedList<PreparedStatement>	_stmtList
private Map<String,ExportTableInfo>	_tablesInfos
protected UserManager	_userManager	The user manager
static String	ROLE	The component role

Constructor Summary

Constructors

Constructor	Description
FillSqlTableComponent()

Method Summary

Modifier and Type	Method	Description
private void	_fillContentTable(String idContent, String tableName)
private String	_getValueForNoMultiValuedTable(Object value, String type)
private int	_setNull(int position, PreparedStatement stmt, String type)
private int	_setValue(Object value, int position, PreparedStatement stmt, String type, String name, String contentId)
private void	executeInsert()
protected void	fillAdditionalData(ExportCounter fillIndex, Content content, PreparedStatement stmt)	Add additional values for content (Title, type, language, creator, creationDate, ...)
protected void	fillColumnForRichTextData(RichText richText, String attributeName, String contentId)	Fill column for data in rich text
void	fillTable(ExportConfiguration exportConfiguration, Map<String,ExportTableInfo> tableInfo)	Fill table with contents
protected void	fillTableForContentType(String contentTypeId)	Fill values from JCR request with specific content type
protected void	fillTableForMultipleAttribute(ElementDefinition definition, ModelAwareDataHolder dataHolder, String name, String tableName, String id)	Fill values from multiple attribute
protected void	fillTableForRepeater(RepeaterDefinition definition, ModelAwareRepeater repeater, String tableName, String id)	Fill values from a repeater
protected void	fillValue(ExportCounter fillIndex, ElementDefinition definition, ModelAwareDataHolder dataHolder, String name, String id, PreparedStatement stmt)	Fill values from an attribute
protected void	fillValues(ExportCounter fillIndex, ModelItemContainer modelItemContainer, ModelAwareDataHolder dataHolder, String tableName, String columnNamePrefix, String id, PreparedStatement stmt)	Fill values from a composite metadata
protected PreparedStatement	getInsertPreparedStatementFromTableName(String prefix, String tableName, String mappingPolicy)	Prepare INSERT statement
protected String	getTableName(String cTypeId)	Get the name of SQL table for given content type
protected void	insertValues()	Fill the SQL tables with values from JCR
void	service(ServiceManager manager)

Methods inherited from class org.ametys.runtime.plugin.component.AbstractLogEnabled

getLogger, setLogger

Methods inherited from class java.lang.Object

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

Field Detail

ROLE

public static final String ROLE

The component role

_EXCLUDE_XML_TAGS

private static final String _EXCLUDE_XML_TAGS

See Also:

Constant Field Values

_contentTypeExtensionPoint

protected ContentTypeExtensionPoint _contentTypeExtensionPoint

Content type extension point.

_resolver

protected AmetysObjectResolver _resolver

The ametys object resolver.

_normalizeNameComponent

protected NormalizeNameComponent _normalizeNameComponent

The normalise name component.

_contentTypesToExport

protected Map<String,String> _contentTypesToExport

The configured list of content types to export associated to the SQL table name to use

_i18nTranslator

protected I18nUtils _i18nTranslator

The i18n translator.

_languageManager

protected LanguagesManager _languageManager

The language manager

_userManager

protected UserManager _userManager

The user manager

_connection

private Connection _connection

_sqlTablePrefix

private String _sqlTablePrefix

_sqlPrefixConf

private String _sqlPrefixConf

_tablesInfos

private Map<String,ExportTableInfo> _tablesInfos

_mappingPolicy

private String _mappingPolicy

_stmtList

private LinkedList<PreparedStatement> _stmtList

_exportOnlyValidatedContent

private boolean _exportOnlyValidatedContent

_exportNoMultiValuedTable

private boolean _exportNoMultiValuedTable

_separator

private String _separator

Constructor Detail

FillSqlTableComponent

public FillSqlTableComponent()

Method Detail

service

public void service(ServiceManager manager)
             throws ServiceException

Specified by:

service in interface Serviceable

Throws:

ServiceException

fillTable

public void fillTable(ExportConfiguration exportConfiguration,
                      Map<String,ExportTableInfo> tableInfo)
               throws SQLException,
                      AmetysRepositoryException

Fill table with contents

Parameters:

exportConfiguration - the content export configuration

tableInfo - the map of table information

Throws:

SQLException - if a sql error occurred

AmetysRepositoryException - if an ametys repository error occurred

executeInsert

private void executeInsert()
                    throws SQLException

Throws:

SQLException

insertValues

protected void insertValues()
                     throws SQLException,
                            AmetysRepositoryException

Fill the SQL tables with values from JCR

Throws:

SQLException - if a sql error occurred

AmetysRepositoryException - if an ametys repository error occurred

fillTableForContentType

protected void fillTableForContentType(String contentTypeId)
                                throws SQLException,
                                       AmetysRepositoryException

Fill values from JCR request with specific content type

Parameters:

contentTypeId - the content type id

Throws:

SQLException - if a sql error occurred

AmetysRepositoryException - if an ametys repository error occurred

_fillContentTable

private void _fillContentTable(String idContent,
                               String tableName)
                        throws SQLException

Throws:

SQLException

fillValues

protected void fillValues(ExportCounter fillIndex,
                          ModelItemContainer modelItemContainer,
                          ModelAwareDataHolder dataHolder,
                          String tableName,
                          String columnNamePrefix,
                          String id,
                          PreparedStatement stmt)
                   throws SQLException,
                          AmetysRepositoryException

Fill values from a composite metadata

Parameters:

fillIndex - the position indicator in the insert statement

modelItemContainer - the attribute definitions

dataHolder - the ModelAwareDataHolder

tableName - the table name

columnNamePrefix - the column name prefix

id - the content id

stmt - the jdbc statement

Throws:

SQLException - if a sql error occurred

AmetysRepositoryException - if an ametys repository error occurred

fillTableForRepeater

protected void fillTableForRepeater(RepeaterDefinition definition,
                                    ModelAwareRepeater repeater,
                                    String tableName,
                                    String id)
                             throws SQLException,
                                    AmetysRepositoryException

Fill values from a repeater

Parameters:

definition - the repeater definition

repeater - the repeater

tableName - the table name

id - the content id

Throws:

SQLException - if a sql error occurred

AmetysRepositoryException - if an ametys repository error occurred

fillTableForMultipleAttribute

protected void fillTableForMultipleAttribute(ElementDefinition definition,
                                             ModelAwareDataHolder dataHolder,
                                             String name,
                                             String tableName,
                                             String id)
                                      throws SQLException

Fill values from multiple attribute

Parameters:

definition - the attribute definition

dataHolder - the ModelAwareDataHolder

name - the attribute name

tableName - the table name

id - the content id

Throws:

SQLException - if a sql error occurred

fillValue

protected void fillValue(ExportCounter fillIndex,
                         ElementDefinition definition,
                         ModelAwareDataHolder dataHolder,
                         String name,
                         String id,
                         PreparedStatement stmt)
                  throws SQLException,
                         AmetysRepositoryException

Fill values from an attribute

Parameters:

fillIndex - the position indicator in the insert statement

definition - the metadata definition model

dataHolder - the ModelAwareDataHolder

name - the attribute name

id - the content id

stmt - the jdbc statement

Throws:

SQLException - if a sql error occurred

AmetysRepositoryException - if an ametys repository error occurred

_setValue

private int _setValue(Object value,
                      int position,
                      PreparedStatement stmt,
                      String type,
                      String name,
                      String contentId)
               throws SQLException

Throws:

SQLException

_setNull

private int _setNull(int position,
                     PreparedStatement stmt,
                     String type)
              throws SQLException

Throws:

SQLException

_getValueForNoMultiValuedTable

private String _getValueForNoMultiValuedTable(Object value,
                                              String type)

fillAdditionalData

protected void fillAdditionalData(ExportCounter fillIndex,
                                  Content content,
                                  PreparedStatement stmt)
                           throws AmetysRepositoryException,
                                  SQLException

Add additional values for content (Title, type, language, creator, creationDate, ...)

Parameters:

fillIndex - the position indicator in the insert statement

content - the content

stmt - the jdbc statement

Throws:

SQLException - if a sql error occurred

AmetysRepositoryException - if an ametys repository error occurred

fillColumnForRichTextData

protected void fillColumnForRichTextData(RichText richText,
                                         String attributeName,
                                         String contentId)
                                  throws AmetysRepositoryException,
                                         SQLException

Fill column for data in rich text

Parameters:

richText - the rich text

attributeName - the metadata name

contentId - the content id

Throws:

AmetysRepositoryException - if an error occurred

SQLException - if a sql error occurred

getInsertPreparedStatementFromTableName

protected PreparedStatement getInsertPreparedStatementFromTableName(String prefix,
                                                                    String tableName,
                                                                    String mappingPolicy)
                                                             throws SQLException

Prepare INSERT statement

Parameters:

prefix - the table prefix

tableName - the table name

mappingPolicy - the mapping policy

Returns:

the INSERT preparedStatement

Throws:

SQLException - if a sql error occurred

getTableName

protected String getTableName(String cTypeId)

Get the name of SQL table for given content type

Parameters:

cTypeId - The id of content type

Returns:

the name of SQL table or null if not found