Function prepareTransformation

backend/plugin/parser/plsql/backup.go:185–227

(databaseName, statement string)

}

func prepareTransformation(databaseName, statement string) ([]statementInfo, error) {
	statements, err := SplitSQL(statement)
	if err != nil {
		return nil, errors.Wrap(err, "failed to split PLSQL")
	}

	var result []statementInfo
	positionMapper := base.NewByteOffsetPositionMapper(statement)
	for i, stmt := range statements {
		if stmt.Empty {
			continue
		}
		list, err := ParsePLSQLOmni(stmt.Text)
		if err != nil {
			return nil, errors.Wrap(err, "failed to parse PLSQL")
		}
		for _, item := range list.Items {
			raw, ok := item.(*oracleast.RawStmt)
			if !ok || raw.Stmt == nil {
				continue
			}
			info := extractOmniDML(databaseName, raw.Stmt, stmt.Text)
			if info == nil {
				continue
			}
			info.offset = i
			if stmt.Range != nil {
				info.startPosition = positionMapper.Position(int(stmt.Range.Start) + raw.Loc.Start)
				info.endPosition = positionMapper.Position(int(stmt.Range.Start) + max(raw.Loc.End-1, raw.Loc.Start))
			} else {
				info.startPosition = stmt.Start
				info.endPosition = stmt.End
			}
			info.fullSQL = stmt.Text
			result = append(result, *info)
		}
	}

	if len(result) == 0 {
		return nil, errNoBackupableDML
	}
	return result, nil
}

func extractOmniDML(databaseName string, node oracleast.StmtNode, fullSQL string) *statementInfo {
	switch n := node.(type) {