Package org.craftercms.studio.api.v2.utils

Class SqlStatementGeneratorUtils

java.lang.Object

org.craftercms.studio.api.v2.utils.SqlStatementGeneratorUtils

public final class SqlStatementGeneratorUtils
extends Object

Field Summary

Fields

Modifier and Type	Field	Description
static final String	DEPENDENCIES_DELETE
static final String	DEPENDENCIES_DELETE_SOURCE
static final String	DEPENDENCIES_INSERT
static final String	ITEM_DELETE
static final String	ITEM_INSERT
static final String	ITEM_MOVE
static final String	ITEM_UPDATE
static final String	UPDATE_DELETED_PAGE_CHILDREN
static final String	UPDATE_NEW_PAGE_CHILDREN

Method Summary

Modifier and Type	Method	Description
static String	deleteDependencyRows(String siteId, String sourcePath)
static String	deleteDependencySourcePathRows(String siteId, String sourcePath)
static String	deleteItemRow(Long siteId, String path)
static String	insertDependencyRow(String siteId, String sourcePath, String targetPath, String type, boolean valid)
static String	insertItemRow(long siteId, String path, String previewUrl, long state, Long lockedBy, Long createdBy, ZonedDateTime createdOn, Long lastModifiedBy, ZonedDateTime lastModifiedOn, ZonedDateTime lastPublishedOn, String label, String contentTypeId, String systemType, String mimeType, String localeCode, Long translationSourceId, Long size, String previousPath)
static String	invalidateDependencies(String siteId, String targetPath)	Generate the necessary sql statements to invalidate dependencies for a given target path
static String	moveItemRow(String site, String oldPath, String newPath, long onStatesBitMap, long offStatesBitMap)
static String	updateDeletedPageChildren(long siteId, String folderPath)	Generates the sql statements to update a deleted page children.
static String	updateItemRow(long siteId, String path, String previewUrl, long onStatesBitMap, long offStatesBitMap, Long lastModifiedBy, ZonedDateTime lastModifiedOn, String label, String contentTypeId, String systemType, String mimeType, Long size)
static String	updateNewPageChildren(long siteId, String path)	Generates the sql statements to update a new page children.
static String	validateDependencies(String siteId, String targetPath)	Generate the necessary sql statements to validate dependencies for a given target path

Methods inherited from class java.lang.Object

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

Field Details

ITEM_INSERT

public static final String ITEM_INSERT

See Also:

• Constant Field Values

ITEM_UPDATE

public static final String ITEM_UPDATE

See Also:

• Constant Field Values

ITEM_DELETE

public static final String ITEM_DELETE

See Also:

• Constant Field Values

ITEM_MOVE

public static final String ITEM_MOVE

See Also:

• Constant Field Values

UPDATE_NEW_PAGE_CHILDREN

public static final String UPDATE_NEW_PAGE_CHILDREN

See Also:

• Constant Field Values

UPDATE_DELETED_PAGE_CHILDREN

public static final String UPDATE_DELETED_PAGE_CHILDREN

See Also:

• Constant Field Values

DEPENDENCIES_INSERT

public static final String DEPENDENCIES_INSERT

See Also:

• Constant Field Values

DEPENDENCIES_DELETE_SOURCE

public static final String DEPENDENCIES_DELETE_SOURCE

See Also:

• Constant Field Values

DEPENDENCIES_DELETE

public static final String DEPENDENCIES_DELETE

See Also:

• Constant Field Values

Method Details

insertItemRow

public static String insertItemRow(long siteId,
 String path,
 String previewUrl,
 long state,
 Long lockedBy,
 Long createdBy,
 ZonedDateTime createdOn,
 Long lastModifiedBy,
 ZonedDateTime lastModifiedOn,
 ZonedDateTime lastPublishedOn,
 String label,
 String contentTypeId,
 String systemType,
 String mimeType,
 String localeCode,
 Long translationSourceId,
 Long size,
 String previousPath)

updateItemRow

public static String updateItemRow(long siteId,
 String path,
 String previewUrl,
 long onStatesBitMap,
 long offStatesBitMap,
 Long lastModifiedBy,
 ZonedDateTime lastModifiedOn,
 String label,
 String contentTypeId,
 String systemType,
 String mimeType,
 Long size)

deleteItemRow

public static String deleteItemRow(Long siteId,
 String path)

moveItemRow

public static String moveItemRow(String site,
 String oldPath,
 String newPath,
 long onStatesBitMap,
 long offStatesBitMap)

updateNewPageChildren

public static String updateNewPageChildren(long siteId,
 String path)

Generates the sql statements to update a new page children. This should be called when a new page (index.xml) is created in an already existing folder

Parameters:

siteId - the site id

path - the page to the content (including index.xml)

Returns:

the sql statement

updateDeletedPageChildren

public static String updateDeletedPageChildren(long siteId,
 String folderPath)

Generates the sql statements to update a deleted page children. This should be called when a page (index.xml) is deleted via git but its children still exists

Parameters:

siteId - the site id

folderPath - the folder path to the deleted page

Returns:

the sql statement

insertDependencyRow

public static String insertDependencyRow(String siteId,
 String sourcePath,
 String targetPath,
 String type,
 boolean valid)

deleteDependencySourcePathRows

public static String deleteDependencySourcePathRows(String siteId,
 String sourcePath)

deleteDependencyRows

public static String deleteDependencyRows(String siteId,
 String sourcePath)

invalidateDependencies

public static String invalidateDependencies(String siteId,
 String targetPath)

Generate the necessary sql statements to invalidate dependencies for a given target path

Parameters:

siteId - the site id

targetPath - the target path of the dependency records to mark as invalid

Returns:

the sql statement

validateDependencies

public static String validateDependencies(String siteId,
 String targetPath)

Generate the necessary sql statements to validate dependencies for a given target path

Parameters:

siteId - the site id

targetPath - the target path of the dependency records to mark as valid

Returns:

the sql statement