Neo4J migration verification queries:
Run the below queries before and after the migration and verify the counts.
Type | Query |
|---|---|
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; |
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; |
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; |
Plugin | 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"] 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; |
Youtube | 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/x-youtube"] return count(n), n.IL_FUNC_OBJECT_TYPE, n.mimeType, n.migrationVersion; |
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/pdf"] return count(n), n.IL_FUNC_OBJECT_TYPE, n.mimeType, n.migrationVersion; | |
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/epub"] return count(n), n.IL_FUNC_OBJECT_TYPE, n.mimeType, n.migrationVersion; |
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; |
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; |
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; |
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; |
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; |
Migration version
migrationVersion’s possible values.
Migration Version | Description |
|---|---|
0.1 | Node migration failed |
0.2 | Node migration failed while publishing ECAR |
0.5 | Skipped node |
1.0 | Node migration successful |
1.2 | ECAR publishing successful |
1.3 | Video streaming successful |