would it be possible to access network ressources (like a database server via pymssql) from inside the test (sandbox). Or are there any limitations in accessing ressources.
Thanks for your reply. I'm not that familiar with Jobe server, where do I find the firewall settings?
It sounds like you're not a sysadmin, so the short answer is probably that you won't be able to change the firewall settings. You'll probably need to put in a request to your institution's IT services group or whoever installed the CodeRunner plugin, requesting that the firewall for the Jobe server be set to allow outgoing access to whatever database server you want to access. But they (IT services) will quite likely be reluctant to weaken the security in that way.
If they say no, and you're really determined to access a remote DB server, you could set up your own Jobe server (e.g. using Docker + jobeinabox) and, using advanced configuration, set the question to use that custom Jobe server. But this option is not for the faint of heart and does still require sysadmin skills.
Are you sure you can't get away with using the supplied SQL question type, which uses sqlite3? It should be fine for teaching the basics of SQL. Then you don't need special firewall settings, access to remote servers, or per-student configuration of the database. Alternatively, if you wish to specifically teach python programming in conjunction with a database, you might be able to use an sqlite3 database file loaded into the question as a support file, appropriately configured for the question, and let the students access it with the sqlite3 module in Python.
Again, thank you very much!!
My plan is to set it up for MS SQL Server and Oracle. PL/SQL divers from SQLite. I've also concept in my head for allowing DML-Statements and creating DB-sandboxes on the fly.
Thanks, it helped me a lot. I will try to asking changing firewall settings...