OpenAPI 사양 다운로드: 다운로드
MongoDB Relational Migrator 도구에 대한 OpenAPI 사양
프로젝트의 매핑 규칙 및 스키마 변환을 기반으로 애플리케이션 코드를 생성합니다.
projectId 필수 | 문자열 (id) ^[A-Za-z0-9\-]+$ 프로젝트 ID |
collections 필수 | 의 배열 strings 생성된 코드에 포함할 MongoDB 컬렉션 |
includeSupportFiles 필수 | 부울 선택한 언어 및 프레임워크 에 해당하는 경우 지원 파일을 포함할지 여부입니다. |
언어 필수 | 문자열 (codegen-language-type) 열거형: "JAVA" "CSHARP" "자바 스크립트" "JSON" "PYTHON" |
프레임워크 필수 | 문자열 (codegen-framework-type) 열거형: "POJO" "POCO" "SPRING_DATA" "PERSISTence_LAYER" "MONGOOSE_SCHEMAS" "NODE" "MONGODB_JSON_SCHEMA" "STANDARD_JSON_SCHEMA" "JSON_EXAMPLE_SCHEMA" "PYTHON_TYPED_DICT_CLASSES" |
{- "collections": [
- "string"
], - "includeSupportFiles": true,
- "language": "JAVA",
- "framework": "POJO"
}
{- "language": "JAVA",
- "framework": "POJO",
- "files": [
- {
- "name": "string",
- "filetype": "ENTITY",
- "code": "string"
}
]
}
모든 마이그레이션 작업 가져오기
sort | 문자열^\w+,(DESC|ASC)$ 기본값입니다: "submittedAt,DESC" 예시: sort=submittedAt,DESC 결과를 조회하는 순서 |
limit | integer 예시: limit=20 결과 제한 |
유형 | 문자열 (migration-jobs-get-type) 값: "IN_PROGRESS" 예시: type=IN_PROGRESS 특정 작업 유형으로만 작업 필터링 |
projectId | 문자열 (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 필수 | 문자열 |
필수 | 객체 (jdbc-connection-details) |
필수 | 객체 (mongodb-connection-details) |
필수 | 객체 (migration-job-descriptor-options) |
필수 | 객체 (migration-verification) |
객체 (relational-table-filters) 스키마 |
{- "projectId": "string",
- "jdbcConnectionDetails": {
- "id": "string",
- "type": "string",
- "url": "string",
- "user": "string",
- "password": "string",
- "savePassword": false,
- "existingConnectionId": "string",
- "oraclePdbName": "string",
- "isManualUri": false
}, - "mongodbConnectionDetails": {
- "id": "string",
- "connectionString": "string",
- "projectId": "string",
- "savePassword": false,
- "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 필수 | 문자열 (id) ^[A-Za-z0-9\-]+$ 프로젝트 ID |
inputQuery | 문자열 |
{- "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",
- "attemptedTypedEntities": true,
- "usedTypedEntities": false,
- "errorMessage": "string",
- "modified": true,
- "runScriptTemplate": "string",
- "functionName": "string"
}
}
대량 쿼리 변환 작업 만들기
projectId 필수 | 문자열 (id) ^[A-Za-z0-9\-]+$ 프로젝트 ID |
언어 필수 | 문자열 (convert-query-language-type) 열거형: "JAVA" "CSHARP" "자바 스크립트" |
쿼리 필수 | 의 배열 strings |
tryTypedEntities | 부울 |
{- "language": "JAVA",
- "queries": [
- "string"
], - "attemptTypedEntities": true
}
{- "pendingQueries": [
- "string"
], - "runningQueries": [
- "string"
], - "completedQueries": [
- "string"
], - "failedQueries": [
- "string"
]
}
ID로 쿼리 가져오기
projectId 필수 | 문자열 (id) ^[A-Za-z0-9\-]+$ 프로젝트 ID |
queryId 필수 | 문자열 (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",
- "attemptedTypedEntities": true,
- "usedTypedEntities": false,
- "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 필수 | 문자열 (id) ^[A-Za-z0-9\-]+$ 프로젝트 ID |
queryId 필수 | 문자열 (id) ^[A-Za-z0-9\-]+$ 쿼리 ID |
언어 필수 | 문자열 (convert-query-language-type) 열거형: "JAVA" "CSHARP" "자바 스크립트" |
tryTypedEntities | 부울 기본값입니다: 거짓 |
{- "language": "JAVA",
- "attemptTypedEntities": false
}
{- "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",
- "attemptedTypedEntities": true,
- "usedTypedEntities": false,
- "errorMessage": "string",
- "modified": true,
- "runScriptTemplate": "string",
- "functionName": "string"
}
}