ccc.migration
Class LegacyDBQueries

java.lang.Object
  ccc.migration.LegacyDBQueries

public class LegacyDBQueries
extends java.lang.Object

Queries for data migration.

Author:

Civic Computing Ltd

Constructor Summary

LegacyDBQueries(DB db)
Constructor.

Method Summary

java.util.Map<java.lang.Integer,java.lang.Integer>	homepages() Return map containing legacy id and home page id of the folders.
java.util.Map<java.lang.String,LegacyFile>	selectFiles() Returns all files from the legacy database.
java.lang.String	selectFlagged(int contentId) Return the flagged value for a resource.
java.util.Map<java.lang.String,LegacyFile>	selectImages() Returns all images from the legacy database.
java.lang.Boolean	selectIsMajorEdit(int contentId, int version) Return value of the c3_content.is_major_edit.
java.util.Set<java.lang.Integer>	selectMenuItems() Retrieve a list of all legacy pages that are shown in a menu.
java.util.Map<java.lang.String,java.lang.String>	selectMetadataForUser(int userId) Sets metadata for the specified user.
java.util.List<ParagraphBean>	selectParagraphs(int pageId, int version) Returns list of all paragraphs with active version for specified page.
java.util.List<java.lang.Integer>	selectParagraphVersions(int pageId) Determine all the paragraph versions for a page.
java.util.List<ResourceBean>	selectResources(int i) Returns list of all resources with active version for specified parent.
java.util.Collection<java.lang.String>	selectRolesForResource(int resourceId) Returns the roles for a specified resource.
java.util.Set<java.lang.String>	selectRolesForUser(int userId) Sets roles for the specified user.
ResourceBean	selectSingleResource(int i) Returns a resource with legacy ID.
java.lang.String	selectStyleSheet(int contentId) Returns style sheet assigned to the resource.
java.util.Set<java.lang.String>	selectTemplateFields(java.lang.String templateName) Return a set of field names of the template.
java.lang.String	selectUserComment(int contentId, int version) Return user comment left at the page edit.
LogEntryBean	selectUserFromLog(int contentId, int legacyVersion, java.lang.String action) Returns the log entry for an action.
java.util.Map<java.lang.Integer,User>	selectUsers() Returns a list of users.
java.util.Collection<java.lang.Integer>	selectUsersForResource(int contentId) Returns the users allowed to access a resource.

Methods inherited from class java.lang.Object

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

Constructor Detail

LegacyDBQueries

public LegacyDBQueries(DB db)

Constructor.

Parameters:

db - The database to query.

Method Detail

selectResources

public java.util.List<ResourceBean> selectResources(int i)

Returns list of all resources with active version for specified parent.

Parameters:

i - folder parent id

Returns:

list of resources found with query

selectSingleResource

public ResourceBean selectSingleResource(int i)

Returns a resource with legacy ID.

Parameters:

i - The legacy ID.

Returns:

Resource found with query.

selectParagraphs

public java.util.List<ParagraphBean> selectParagraphs(int pageId,
                                                      int version)

Returns list of all paragraphs with active version for specified page. Sequences are not joined.

Parameters:

pageId - The page's id.

version - The page's version.

Returns:

A list of paragraph beans.

selectParagraphVersions

public java.util.List<java.lang.Integer> selectParagraphVersions(int pageId)

Determine all the paragraph versions for a page.

Parameters:

pageId - The page's id.

Returns:

The paragraph versions, as a list of integers.

selectUsers

public java.util.Map<java.lang.Integer,User> selectUsers()

Returns a list of users.

Parameters:

errors -

Returns:

The list of users.

selectMetadataForUser

public java.util.Map<java.lang.String,java.lang.String> selectMetadataForUser(int userId)

Sets metadata for the specified user.

Parameters:

userId - The user ID.

Returns:

The user's email address, as a string.

selectRolesForUser

public java.util.Set<java.lang.String> selectRolesForUser(int userId)

Sets roles for the specified user.

Parameters:

userId - The user ID.

Returns:

The user's roles, as a set of strings.

selectRolesForResource

public java.util.Collection<java.lang.String> selectRolesForResource(int resourceId)

Returns the roles for a specified resource.

Parameters:

resourceId - The resource ID.

Returns:

The resource's roles.

selectUserFromLog

public LogEntryBean selectUserFromLog(int contentId,
                                      int legacyVersion,
                                      java.lang.String action)

Returns the log entry for an action.

Parameters:

contentId - Content id

legacyVersion - Version id

action - Action

Returns:

A log entry bean representing the action.

selectFiles

public java.util.Map<java.lang.String,LegacyFile> selectFiles()

Returns all files from the legacy database.

Returns:

The files as FileDeltas.

selectImages

public java.util.Map<java.lang.String,LegacyFile> selectImages()

Returns all images from the legacy database.

Returns:

The images as FileDeltas.

selectStyleSheet

public java.lang.String selectStyleSheet(int contentId)

Returns style sheet assigned to the resource.

Parameters:

contentId - Content id

Returns:

The style sheet value stored in C3_SCRIPTS table

selectMenuItems

public java.util.Set<java.lang.Integer> selectMenuItems()

Retrieve a list of all legacy pages that are shown in a menu.

Returns:

The list of page IDs as a set.

selectFlagged

public java.lang.String selectFlagged(int contentId)

Return the flagged value for a resource.

Parameters:

contentId - The resource's id.

Returns:

"Y" if the resource is flagged, any other value indicates false.

homepages

public java.util.Map<java.lang.Integer,java.lang.Integer> homepages()

Return map containing legacy id and home page id of the folders.

Returns:

The map of IDs.

selectUserComment

public java.lang.String selectUserComment(int contentId,
                                          int version)

Return user comment left at the page edit.

Parameters:

contentId - The resource's id.

version - The page's version.

Returns:

The user comment.

selectIsMajorEdit

public java.lang.Boolean selectIsMajorEdit(int contentId,
                                           int version)

Return value of the c3_content.is_major_edit.

Parameters:

contentId - The resource's id.

version - The page's version.

Returns:

The boolean value of isMajorEdit.

selectTemplateFields

public java.util.Set<java.lang.String> selectTemplateFields(java.lang.String templateName)

Return a set of field names of the template.

Parameters:

templateName - The template name.

Returns:

Set of string containing field names.

selectUsersForResource

public java.util.Collection<java.lang.Integer> selectUsersForResource(int contentId)

Returns the users allowed to access a resource.

Parameters:

contentId - The resource ID.

Returns:

A collection of user IDs.