Neo4J migration verification queries:
Run the below queries before and after the migration and verify the counts.
Migration | Type | Query | Before migration | Final migrationVersion |
|---|---|---|---|---|
All the nodes | Match(n:domain) return count(n); | |||
1 | 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.status, n.migrationVersion; | <null> | 1.2 - Live 1.0 - For other status |
1 | 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.status, n.migrationVersion; | <null> | 1.0 |
2 | 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.status, n.migrationVersion; | <null> | 1.2 - Live 1.0 - For other status |
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.status, n.migrationVersion; | <null> | 1.1 - Live 1.0 - For other status |
2 | 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.status, n.migrationVersion; | <null> | 1.0 |
2 | 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.status, n.migrationVersion; | <null> | 1.0 |
2 | 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 |
2 | 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.status, n.migrationVersion; | <null> | 1.1 - Live 1.0 - For other status |
2 | 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.status, n.migrationVersion; | <null> | 1.1 - Live 1.0 - For other status |
3 | 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.status, n.migrationVersion; | <null> | 1.1 - Live 1.0 - For other status |
3 | 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 |
4 | 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.status, n.migrationVersion; | <null> | 1.1 - Live 1.0 - For other status |
Migration version
Possible values for migrationVersion
Migration Version | Description |
|---|---|
<null> | Before migration |
0.1 | Node migration failed |
0.2 | Node migration successful but publishing ECAR failed |
0.5 | Node migration Skipped |
1.0 | Node migration successful |
1.1 | ECAR publishing successful |
1.2 | Video streaming successful |