| 23 | ) |
| 24 | |
| 25 | func GenerateRestoreSQL(ctx context.Context, rCtx base.RestoreContext, statement string, backupItem *storepb.PriorBackupDetail_Item) (string, error) { |
| 26 | originalSQL, err := extractSQL(statement, backupItem) |
| 27 | if err != nil { |
| 28 | return "", errors.Errorf("failed to extract single SQL: %v", err) |
| 29 | } |
| 30 | |
| 31 | node, err := findFirstOracleDML(originalSQL) |
| 32 | if err != nil { |
| 33 | return "", err |
| 34 | } |
| 35 | if node == nil { |
| 36 | return "", errors.New("no DML statement found in extracted SQL") |
| 37 | } |
| 38 | |
| 39 | sqlForComment, truncated := common.TruncateString(originalSQL, maxCommentLength) |
| 40 | if truncated { |
| 41 | sqlForComment += "..." |
| 42 | } |
| 43 | return doGenerate(ctx, rCtx, sqlForComment, node, backupItem) |
| 44 | } |
| 45 | |
| 46 | func findFirstOracleDML(statement string) (oracleast.StmtNode, error) { |
| 47 | node, err := findFirstOracleDMLOnce(statement) |