Multiple sql resolution scopes within one file

Answered

I have a python project with, lets say, only one python source file.  My script (project) is to copy data from a source to a dest database.

I have 2 datasources setup in the ide, one for the source and the other for the dest (in this case, source is sqlserver, dest is snowflake)

I know I can set a project default datasouce. And I can set a datasource per file. But in my case, I have 1 file and code that looks like this

```
sql_src = "select firstname, lastname, address from mysrc"
sql_dest = "select fullname from mydest"
movedata(sql_src, sql_dest)
```

So I need to the IDE to resolve the first string against the src datasource and the 2nd against the dest datasource

In the olden days (when I used Eclipse), I seem to recall some way to add code comments as directives to the IDE to do things.  Using that, it might have been like

 

#--IDE-DIRECTIVE--: setdatasource(mysource) 
sql_src = "select firstname, lastname, address from mysrc"

 

Is there way to set the resolution scope per line/block in a file

thx

Alan

 

 

1
1 comment

It's not possible at the moment, feature request is welcome: https://youtrack.jetbrains.com/newIssue?project=DBE.

0

Please sign in to leave a comment.