Page Comparison

1

All the nodes

Match(n:domain) return count(n);

Video Asset

Match

2

All the node needs to migrate

MATCH (n:domain) where WHERE n.IL_FUNC_OBJECT_TYPE IN ["Asset"] and n.IL_SYS_NODE_TYPE="DATA_NODE" and AND n.mimeType IL_FUNC_OBJECT_TYPE IN ["video/mp4"Asset", "Content", "ContentImage", "Collection", "CollectionImage", "AssessmentItem", "video/webmItemSet"] return countAND NOT EXISTS(n.migrationVersion) , RETURN n.IL_FUNC_OBJECT_TYPE AS objectType, COUNT(n.mimeType, n.migrationVersion;Non ) AS count;

The count after migration should be 0.

3

Video Asset

Match (n:domain) where n.IL_FUNC_OBJECT_TYPE IN ["Asset"] and n.IL_SYS_NODE_TYPE="DATA_NODE" and NOT n.mimeType IN ["video/mp4", "video/webm"] return count(n), n.IL_FUNC_OBJECT_TYPE, n.mimeType, n.status, n.migrationVersion;

<null>

1.2 - Live

1.0 - For other status

4

Non Video ContentAsset

Match (n:domain) where n.IL_FUNC_OBJECT_TYPE IN ["Content", Asset"ContentImage"] and n.IL_SYS_NODE_TYPE="DATA_NODE" and NOT n.mimeType IN ["video/mp4", "video/webm"] return count(n), n.IL_FUNC_OBJECT_TYPE, n.mimeType, n.status, n.migrationVersion;

Plugin<null>

1.0

5

Video Content

Match (n:domain) where n.IL_FUNC_OBJECT_TYPE IN ["Content", "ContentImage"] and n.IL_SYS_NODE_TYPE="DATA_NODE" and n.mimeType IN ["application/vnd.ekstep.plugin-archive"video/mp4", "video/webm"] return count(n), n.IL_FUNC_OBJECT_TYPE, n.mimeType, n.migrationVersion;

AssessmentItem

Match (n:domain) where n.IL_FUNC_OBJECT_TYPE IN ["AssessmentItem"] and n.IL_SYS_NODE_TYPE="DATA_NODE" return count(n), n.IL_FUNC_OBJECT_TYPE, n.migrationVersion;

ItemSet

Match (n:domain) where n.IL_FUNC_OBJECT_TYPE IN ["ItemSet"] and n.IL_SYS_NODE_TYPE="DATA_NODE" return count(n), n.IL_FUNC_OBJECT_TYPE, n.migrationVersion;

Youtubestatus, n.migrationVersion;

<null>

1.2 - Live

1.0 - For other status

6

Plugin, Youtube, PDF, EPUB

Match (n:domain) where n.IL_FUNC_OBJECT_TYPE IN ["Content", "ContentImage"] and n.IL_SYS_NODE_TYPE="DATA_NODE" and n.mimeType IN ["application/vnd.ekstep.plugin-archive", "video/x-youtube", "application/pdf", "application/epub"] return count(n), n.IL_FUNC_OBJECT_TYPE, n.mimeType, n.status, n.migrationVersion;PDF

<null>

1.1 - Live

1.0 - For other status

7

AssessmentItem

Match (n:domain) where n.IL_FUNC_OBJECT_TYPE IN ["Content", "ContentImageAssessmentItem"] and n.IL_SYS_NODE_TYPE="DATA_NODE" and n.mimeType IN ["application/pdf" ] return count(n), n.IL_FUNC_OBJECT_TYPE, n.mimeTypestatus, n.migrationVersion;EPUB

<null>

1.0

8

ItemSet

Match (n:domain) where n.IL_FUNC_OBJECT_TYPE IN ["ContentItemSet", "ContentImage"] and n.IL_SYS_NODE_TYPE="DATA_NODE" and n.mimeType IN ["application/epub" ] return count(n), n.IL_FUNC_OBJECT_TYPE, n.mimeTypestatus, n.migrationVersion;

<null>

1.0

9

H5P

Match (n:domain) where n.IL_FUNC_OBJECT_TYPE IN ["Content", "ContentImage"] and n.IL_SYS_NODE_TYPE="DATA_NODE" and n.mimeType IN ["application/vnd.ekstep.h5p-archive"] return count(n), n.IL_FUNC_OBJECT_TYPE, n.mimeType, n.status, n.migrationVersion;

<null>

1.1 - Live

1.0 - For other status

10

HTML

Match (n:domain) where n.IL_FUNC_OBJECT_TYPE IN ["Content", "ContentImage"] and n.IL_SYS_NODE_TYPE="DATA_NODE" and n.mimeType IN ["application/vnd.ekstep.html-archive"] return count(n), n.IL_FUNC_OBJECT_TYPE, n.mimeType, n.migrationVersion;

Question

Match (n:domain) where n.IL_FUNC_OBJECT_TYPE IN ["Question"] and n.IL_SYS_NODE_TYPE="DATA_NODE" return count(n), n.IL_FUNC_OBJECT_TYPE, n.mimeType, n.migrationVersion;

QuestionSet

Match (n:domain) where n.IL_FUNC_OBJECT_TYPE IN ["QuestionSet", "QuestionSetImage"] and n.IL_SYS_NODE_TYPE="DATA_NODE" return count(n), n.IL_FUNC_OBJECT_TYPE, n.mimeType, n.migrationVersion;status, n.migrationVersion;

<null>

1.1 - Live

1.0 - For other status

11

ECML

Match (n:domain) where n.IL_FUNC_OBJECT_TYPE IN ["Content", "ContentImage"] and n.IL_SYS_NODE_TYPE="DATA_NODE" and n.mimeType IN ["application/vnd.ekstep.ecml-archive"] return count(n), n.IL_FUNC_OBJECT_TYPE, n.mimeType, n.status, n.migrationVersion;

<null>

1.1 - Live

1.0 - For other status

12

Collection

Match (n:domain) where n.IL_FUNC_OBJECT_TYPE IN ["Content", "ContentImage", "Collection", "CollectionImage"] and n.IL_SYS_NODE_TYPE="DATA_NODE" and n.mimeType IN ["application/vnd.ekstep.content-collection"] return count(n), n.IL_FUNC_OBJECT_TYPE, n.mimeType, n.status, n.migrationVersion;Match (n:domain) where n.IL_FUNC_OBJECT_TYPE IN ["Content", "ContentImage"] and n.IL_SYS_NODE_TYPE="DATA_NODE" return count(n), n.IL_FUNC_OBJECT_TYPE, n.mimeType, n.migrationVersion;

<null>

1.1 - Live

1.0 - For other status

<null>

Before migration

0.1

Node migration failed

0.2

Node migration failed while successful but publishing ECAR failed

0.5

Node migration Skipped node

1.0

Node migration successful

1.21

ECAR publishing successful

1.32

Video streaming successful