OpenAPI 仕様をダウンロード: ダウンロード
MongoDB Relational Migrator ツールの OpenAPI 仕様
プロジェクトのマッピングルールとスキーマ変換に基づいてアプリケーション コードを生成します
projectId 必須 | string (id) ^[A-Za-z0-9\-]+$ プロジェクトID |
collections 必須 | の配列 string 生成されたコードに含める MongoDB コレクション |
includeSupportFiles 必須 | ブール値 サポート ファイルを含めるかどうか(選択した言語とフレームワークに該当する場合) |
言語 必須 | string (codegen-言語-type) 列挙: "Java" "CSMongoDB" "JavaSCRIPT" "JSON" "Python" |
フレームワーク 必須 | string (codegen-Framework-type) 列挙: "POJO" "POCO" "SPING_DATA" "PERSTENCY_LAYER" "MONGOSE_SCHEMAS" "NOde" "MONGODB_JSON_SCHEMA" "STANDARD_JSON_SCHEMA" "JSON_EXAMPLE_SCHEMA" "PYTH_TypeD_DECT_CLASSES" |
{- "collections": [
- "string"
], - "includeSupportFiles": true,
- "language": "JAVA",
- "framework": "POJO"
}
{- "language": "JAVA",
- "framework": "POJO",
- "files": [
- {
- "name": "string",
- "filetype": "ENTITY",
- "code": "string"
}
]
}
すべての移行ジョブを取得する
sort | string^\w+,(DESC|ASC)$ デフォルト: "submittedAt,DESC" 例: sort=submittedAt,DESC 結果を検索する順序 |
limit | integer 例: limit=20 結果を制限する |
タイプ | string (migration- jobs-get-type) 値: "IN_PROGESS" 例: type=IN_PROGESS 特定のジョブタイプのみにジョブをフィルタリング |
projectId | string (id) ^[A-Za-z0-9\-]+$ projectId でジョブをフィルタリング |
[- {
- "id": "string",
- "projectId": "string",
- "status": "RUNNING",
- "cdcStatus": "NOT_STARTED",
- "verificationJobId": "string",
- "options": {
- "dropCollections": false,
- "mode": "SNAPSHOT",
- "errorHandling": "FAIL",
- "errorTolerance": 0
}, - "jdbcConnectionString": "string",
- "mongoDbConnectionString": "string",
- "atlasMetadata": {
- "mongoDbProjectName": "string",
- "mongoDbProjectId": "string",
- "mongoDbClusterName": "string"
}, - "submittedAt": "2019-08-24T14:15:22Z",
- "statistics": {
- "startedAt": "2019-08-24T14:15:22Z",
- "elapsedSeconds": 0,
- "remainingTableCount": 0,
- "processingTables": [
- "string"
], - "totalEventsSeen": 0,
- "snapshotCompleted": false,
- "totalTableCount": 0,
- "totalEvents": 0,
- "totalEventSize": 0
}, - "cdcStatistics": {
- "startedAt": "2019-08-24T14:15:22Z",
- "lastEventTime": "2019-08-24T14:15:22Z",
- "eventsInLastHour": 0,
- "eventsInLastMinute": 0,
- "totalEventsSeen": 0
}, - "jobUpdates": [
- {
- "eventType": "DB_SETUP_ERROR",
- "stage": "SNAPSHOTTING",
- "message": "string",
- "details": "string",
- "timestamp": "2019-08-24T14:15:22Z",
- "count": 0,
- "location": {
- "table": "string"
}
}
], - "failureError": {
- "errorType": "string",
- "message": "string",
- "failureAt": "2019-08-24T14:15:22Z",
- "setupError": false
}, - "metadata": {
- "telemetryUserId": "string",
- "verificationRequested": false,
- "verificationStatus": "VERIFYING"
}, - "relationalTableFilters": {
- "property1": {
- "property1": {
- "whereClause": "string",
- "rowCount": 0
}, - "property2": {
- "whereClause": "string",
- "rowCount": 0
}
}, - "property2": {
- "property1": {
- "whereClause": "string",
- "rowCount": 0
}, - "property2": {
- "whereClause": "string",
- "rowCount": 0
}
}
}
}
]
新しい移行ジョブを送信する
projectId 必須 | string |
必須 | オブジェクト (jdBC-接続-詳細) |
必須 | オブジェクト (mongodb-接続-詳細) |
必須 | オブジェクト (移行ジョブ記述子オプション) |
必須 | オブジェクト (移行検証) |
オブジェクト (リレーショナルテーブル フィルター) スキーマ |
{- "projectId": "string",
- "jdbcConnectionDetails": {
- "id": "string",
- "type": "string",
- "url": "string",
- "user": "string",
- "password": "string",
- "savePassword": true,
- "existingConnectionId": "string"
}, - "mongodbConnectionDetails": {
- "id": "string",
- "connectionString": "string",
- "projectId": "string",
- "savePassword": true,
- "projectName": "string",
- "clusterName": "string",
- "hasTimeSeriesCollection": false,
- "existingConnectionId": "string"
}, - "options": {
- "dropCollections": false,
- "mode": "SNAPSHOT",
- "errorHandling": "FAIL",
- "errorTolerance": 0
}, - "verification": {
- "enabled": false
}, - "relationalTableFilters": {
- "property1": {
- "property1": {
- "whereClause": "string",
- "rowCount": 0
}, - "property2": {
- "whereClause": "string",
- "rowCount": 0
}
}, - "property2": {
- "property1": {
- "whereClause": "string",
- "rowCount": 0
}, - "property2": {
- "whereClause": "string",
- "rowCount": 0
}
}
}
}
{- "id": "string",
- "projectId": "string",
- "status": "RUNNING",
- "cdcStatus": "NOT_STARTED",
- "verificationJobId": "string",
- "options": {
- "dropCollections": false,
- "mode": "SNAPSHOT",
- "errorHandling": "FAIL",
- "errorTolerance": 0
}, - "jdbcConnectionString": "string",
- "mongoDbConnectionString": "string",
- "atlasMetadata": {
- "mongoDbProjectName": "string",
- "mongoDbProjectId": "string",
- "mongoDbClusterName": "string"
}, - "submittedAt": "2019-08-24T14:15:22Z",
- "statistics": {
- "startedAt": "2019-08-24T14:15:22Z",
- "elapsedSeconds": 0,
- "remainingTableCount": 0,
- "processingTables": [
- "string"
], - "totalEventsSeen": 0,
- "snapshotCompleted": false,
- "totalTableCount": 0,
- "totalEvents": 0,
- "totalEventSize": 0
}, - "cdcStatistics": {
- "startedAt": "2019-08-24T14:15:22Z",
- "lastEventTime": "2019-08-24T14:15:22Z",
- "eventsInLastHour": 0,
- "eventsInLastMinute": 0,
- "totalEventsSeen": 0
}, - "jobUpdates": [
- {
- "eventType": "DB_SETUP_ERROR",
- "stage": "SNAPSHOTTING",
- "message": "string",
- "details": "string",
- "timestamp": "2019-08-24T14:15:22Z",
- "count": 0,
- "location": {
- "table": "string"
}
}
], - "failureError": {
- "errorType": "string",
- "message": "string",
- "failureAt": "2019-08-24T14:15:22Z",
- "setupError": false
}, - "metadata": {
- "telemetryUserId": "string",
- "verificationRequested": false,
- "verificationStatus": "VERIFYING"
}, - "relationalTableFilters": {
- "property1": {
- "property1": {
- "whereClause": "string",
- "rowCount": 0
}, - "property2": {
- "whereClause": "string",
- "rowCount": 0
}
}, - "property2": {
- "property1": {
- "whereClause": "string",
- "rowCount": 0
}, - "property2": {
- "whereClause": "string",
- "rowCount": 0
}
}
}
}
{- "id": "string",
- "projectId": "string",
- "status": "RUNNING",
- "cdcStatus": "NOT_STARTED",
- "verificationJobId": "string",
- "options": {
- "dropCollections": false,
- "mode": "SNAPSHOT",
- "errorHandling": "FAIL",
- "errorTolerance": 0
}, - "jdbcConnectionString": "string",
- "mongoDbConnectionString": "string",
- "atlasMetadata": {
- "mongoDbProjectName": "string",
- "mongoDbProjectId": "string",
- "mongoDbClusterName": "string"
}, - "submittedAt": "2019-08-24T14:15:22Z",
- "statistics": {
- "startedAt": "2019-08-24T14:15:22Z",
- "elapsedSeconds": 0,
- "remainingTableCount": 0,
- "processingTables": [
- "string"
], - "totalEventsSeen": 0,
- "snapshotCompleted": false,
- "totalTableCount": 0,
- "totalEvents": 0,
- "totalEventSize": 0
}, - "cdcStatistics": {
- "startedAt": "2019-08-24T14:15:22Z",
- "lastEventTime": "2019-08-24T14:15:22Z",
- "eventsInLastHour": 0,
- "eventsInLastMinute": 0,
- "totalEventsSeen": 0
}, - "jobUpdates": [
- {
- "eventType": "DB_SETUP_ERROR",
- "stage": "SNAPSHOTTING",
- "message": "string",
- "details": "string",
- "timestamp": "2019-08-24T14:15:22Z",
- "count": 0,
- "location": {
- "table": "string"
}
}
], - "failureError": {
- "errorType": "string",
- "message": "string",
- "failureAt": "2019-08-24T14:15:22Z",
- "setupError": false
}, - "metadata": {
- "telemetryUserId": "string",
- "verificationRequested": false,
- "verificationStatus": "VERIFYING"
}, - "relationalTableFilters": {
- "property1": {
- "property1": {
- "whereClause": "string",
- "rowCount": 0
}, - "property2": {
- "whereClause": "string",
- "rowCount": 0
}
}, - "property2": {
- "property1": {
- "whereClause": "string",
- "rowCount": 0
}, - "property2": {
- "whereClause": "string",
- "rowCount": 0
}
}
}
}
{- "id": "string",
- "projectId": "string",
- "status": "RUNNING",
- "cdcStatus": "NOT_STARTED",
- "verificationJobId": "string",
- "options": {
- "dropCollections": false,
- "mode": "SNAPSHOT",
- "errorHandling": "FAIL",
- "errorTolerance": 0
}, - "jdbcConnectionString": "string",
- "mongoDbConnectionString": "string",
- "atlasMetadata": {
- "mongoDbProjectName": "string",
- "mongoDbProjectId": "string",
- "mongoDbClusterName": "string"
}, - "submittedAt": "2019-08-24T14:15:22Z",
- "statistics": {
- "startedAt": "2019-08-24T14:15:22Z",
- "elapsedSeconds": 0,
- "remainingTableCount": 0,
- "processingTables": [
- "string"
], - "totalEventsSeen": 0,
- "snapshotCompleted": false,
- "totalTableCount": 0,
- "totalEvents": 0,
- "totalEventSize": 0
}, - "cdcStatistics": {
- "startedAt": "2019-08-24T14:15:22Z",
- "lastEventTime": "2019-08-24T14:15:22Z",
- "eventsInLastHour": 0,
- "eventsInLastMinute": 0,
- "totalEventsSeen": 0
}, - "jobUpdates": [
- {
- "eventType": "DB_SETUP_ERROR",
- "stage": "SNAPSHOTTING",
- "message": "string",
- "details": "string",
- "timestamp": "2019-08-24T14:15:22Z",
- "count": 0,
- "location": {
- "table": "string"
}
}
], - "failureError": {
- "errorType": "string",
- "message": "string",
- "failureAt": "2019-08-24T14:15:22Z",
- "setupError": false
}, - "metadata": {
- "telemetryUserId": "string",
- "verificationRequested": false,
- "verificationStatus": "VERIFYING"
}, - "relationalTableFilters": {
- "property1": {
- "property1": {
- "whereClause": "string",
- "rowCount": 0
}, - "property2": {
- "whereClause": "string",
- "rowCount": 0
}
}, - "property2": {
- "property1": {
- "whereClause": "string",
- "rowCount": 0
}, - "property2": {
- "whereClause": "string",
- "rowCount": 0
}
}
}
}
{- "id": "string",
- "projectId": "string",
- "status": "RUNNING",
- "cdcStatus": "NOT_STARTED",
- "verificationJobId": "string",
- "options": {
- "dropCollections": false,
- "mode": "SNAPSHOT",
- "errorHandling": "FAIL",
- "errorTolerance": 0
}, - "jdbcConnectionString": "string",
- "mongoDbConnectionString": "string",
- "atlasMetadata": {
- "mongoDbProjectName": "string",
- "mongoDbProjectId": "string",
- "mongoDbClusterName": "string"
}, - "submittedAt": "2019-08-24T14:15:22Z",
- "statistics": {
- "startedAt": "2019-08-24T14:15:22Z",
- "elapsedSeconds": 0,
- "remainingTableCount": 0,
- "processingTables": [
- "string"
], - "totalEventsSeen": 0,
- "snapshotCompleted": false,
- "totalTableCount": 0,
- "totalEvents": 0,
- "totalEventSize": 0
}, - "cdcStatistics": {
- "startedAt": "2019-08-24T14:15:22Z",
- "lastEventTime": "2019-08-24T14:15:22Z",
- "eventsInLastHour": 0,
- "eventsInLastMinute": 0,
- "totalEventsSeen": 0
}, - "jobUpdates": [
- {
- "eventType": "DB_SETUP_ERROR",
- "stage": "SNAPSHOTTING",
- "message": "string",
- "details": "string",
- "timestamp": "2019-08-24T14:15:22Z",
- "count": 0,
- "location": {
- "table": "string"
}
}
], - "failureError": {
- "errorType": "string",
- "message": "string",
- "failureAt": "2019-08-24T14:15:22Z",
- "setupError": false
}, - "metadata": {
- "telemetryUserId": "string",
- "verificationRequested": false,
- "verificationStatus": "VERIFYING"
}, - "relationalTableFilters": {
- "property1": {
- "property1": {
- "whereClause": "string",
- "rowCount": 0
}, - "property2": {
- "whereClause": "string",
- "rowCount": 0
}
}, - "property2": {
- "property1": {
- "whereClause": "string",
- "rowCount": 0
}, - "property2": {
- "whereClause": "string",
- "rowCount": 0
}
}
}
}
{- "id": "string",
- "projectId": "string",
- "status": "RUNNING",
- "cdcStatus": "NOT_STARTED",
- "verificationJobId": "string",
- "options": {
- "dropCollections": false,
- "mode": "SNAPSHOT",
- "errorHandling": "FAIL",
- "errorTolerance": 0
}, - "jdbcConnectionString": "string",
- "mongoDbConnectionString": "string",
- "atlasMetadata": {
- "mongoDbProjectName": "string",
- "mongoDbProjectId": "string",
- "mongoDbClusterName": "string"
}, - "submittedAt": "2019-08-24T14:15:22Z",
- "statistics": {
- "startedAt": "2019-08-24T14:15:22Z",
- "elapsedSeconds": 0,
- "remainingTableCount": 0,
- "processingTables": [
- "string"
], - "totalEventsSeen": 0,
- "snapshotCompleted": false,
- "totalTableCount": 0,
- "totalEvents": 0,
- "totalEventSize": 0
}, - "cdcStatistics": {
- "startedAt": "2019-08-24T14:15:22Z",
- "lastEventTime": "2019-08-24T14:15:22Z",
- "eventsInLastHour": 0,
- "eventsInLastMinute": 0,
- "totalEventsSeen": 0
}, - "jobUpdates": [
- {
- "eventType": "DB_SETUP_ERROR",
- "stage": "SNAPSHOTTING",
- "message": "string",
- "details": "string",
- "timestamp": "2019-08-24T14:15:22Z",
- "count": 0,
- "location": {
- "table": "string"
}
}
], - "failureError": {
- "errorType": "string",
- "message": "string",
- "failureAt": "2019-08-24T14:15:22Z",
- "setupError": false
}, - "metadata": {
- "telemetryUserId": "string",
- "verificationRequested": false,
- "verificationStatus": "VERIFYING"
}, - "relationalTableFilters": {
- "property1": {
- "property1": {
- "whereClause": "string",
- "rowCount": 0
}, - "property2": {
- "whereClause": "string",
- "rowCount": 0
}
}, - "property2": {
- "property1": {
- "whereClause": "string",
- "rowCount": 0
}, - "property2": {
- "whereClause": "string",
- "rowCount": 0
}
}
}
}
[- {
- "id": "string",
- "projectId": "string",
- "name": "string",
- "inputQuery": "string",
- "lastModifiedAt": "2019-08-24T14:15:22Z",
- "queryType": "STORED_PROCEDURE",
- "queryStatus": "NOT_STARTED",
- "targetLanguage": "JAVA"
}
]
新しいアドホック クエリを作成する
projectId 必須 | string (id) ^[A-Za-z0-9\-]+$ プロジェクトID |
inputQuery | string |
{- "inputQuery": "string"
}
{- "id": "string",
- "projectId": "string",
- "input": {
- "database": "string",
- "schema": "string",
- "name": "string",
- "query": "string",
- "createdAt": "2019-08-24T14:15:22Z",
- "runScriptTemplate": "string",
- "queryType": "STORED_PROCEDURE"
}, - "output": {
- "query": "string",
- "status": "NOT_STARTED",
- "lastModifiedAt": "2019-08-24T14:15:22Z",
- "language": "JAVA",
- "errorMessage": "string",
- "modified": true,
- "runScriptTemplate": "string",
- "functionName": "string"
}
}
一括クエリ変換ジョブの作成
projectId 必須 | string (id) ^[A-Za-z0-9\-]+$ プロジェクトID |
言語 必須 | string (convert-query-言語タイプ) 列挙: "Java" "CSMongoDB" "JavaSCRIPT" |
クエリ 必須 | の配列 string |
{- "language": "JAVA",
- "queries": [
- "string"
]
}
{- "pendingQueries": [
- "string"
], - "runningQueries": [
- "string"
], - "completedQueries": [
- "string"
], - "failedQueries": [
- "string"
]
}
ID でクエリを取得する
projectId 必須 | string (id) ^[A-Za-z0-9\-]+$ プロジェクトID |
queryId 必須 | string (id) ^[A-Za-z0-9\-]+$ クエリ ID |
{- "query": {
- "id": "string",
- "projectId": "string",
- "input": {
- "database": "string",
- "schema": "string",
- "name": "string",
- "query": "string",
- "createdAt": "2019-08-24T14:15:22Z",
- "runScriptTemplate": "string",
- "queryType": "STORED_PROCEDURE"
}, - "output": {
- "query": "string",
- "status": "NOT_STARTED",
- "lastModifiedAt": "2019-08-24T14:15:22Z",
- "language": "JAVA",
- "errorMessage": "string",
- "modified": true,
- "runScriptTemplate": "string",
- "functionName": "string"
}
}, - "convertedRunResult": {
- "id": "string",
- "projectId": "string",
- "executionTimeMs": 0,
- "result": {
- "data": "string",
- "pageNumber": 0,
- "pageSize": 0,
- "total": 0,
- "hasMore": true
}, - "error": "string",
- "logs": {
- "stdout": "string",
- "stderr": "string"
}
}, - "sourceRunResult": {
- "id": "string",
- "projectId": "string",
- "executionTimeMs": 0,
- "result": {
- "data": "string",
- "pageNumber": 0,
- "pageSize": 0,
- "total": 0,
- "hasMore": true
}, - "error": "string",
- "logs": {
- "stdout": "string",
- "stderr": "string"
}, - "fieldMetadataMap": {
- "property1": {
- "columnType": "string",
- "columnIndex": 0
}, - "property2": {
- "columnType": "string",
- "columnIndex": 0
}
}
}
}
クエリを変換する
projectId 必須 | string (id) ^[A-Za-z0-9\-]+$ プロジェクトID |
queryId 必須 | string (id) ^[A-Za-z0-9\-]+$ クエリ ID |
言語 必須 | string (convert-query-言語タイプ) 列挙: "Java" "CSMongoDB" "JavaSCRIPT" |
{- "language": "JAVA"
}
{- "id": "string",
- "projectId": "string",
- "input": {
- "database": "string",
- "schema": "string",
- "name": "string",
- "query": "string",
- "createdAt": "2019-08-24T14:15:22Z",
- "runScriptTemplate": "string",
- "queryType": "STORED_PROCEDURE"
}, - "output": {
- "query": "string",
- "status": "NOT_STARTED",
- "lastModifiedAt": "2019-08-24T14:15:22Z",
- "language": "JAVA",
- "errorMessage": "string",
- "modified": true,
- "runScriptTemplate": "string",
- "functionName": "string"
}
}