Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Run the below queries before and after the migration and verify the counts.

Type

Query

Final migration migrationVersion

All the nodes

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

Video Asset

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

1.2

Non 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.migrationVersion;

1.0

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 ["video/mp4", "video/webm"] return count(n), n.IL_FUNC_OBJECT_TYPE, n.mimeType, n.migrationVersion;

1.2

Plugin, Youtube, PDF, EPUB

Match (n:domain) where n.IL_FUNC_OBJECT_TYPE IN ["Content"] 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.migrationVersion;

1.1

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;

1.0

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;

1.0

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.migrationVersion;

1.1

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;

1.1

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;

1.1

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;

1.1

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.migrationVersion;

1.1

Collection

Match (n:domain) where n.IL_FUNC_OBJECT_TYPE IN ["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.migrationVersion;

1.1

...