search

trampgeek / jobe

jobe is a server that runs small programming jobs in a variety of programming languages
MIT License
111 stars 80 forks source link

How to support the SQL? #41

Closed sunyongke closed 3 years ago

sunyongke commented 4 years ago

This is a best sandbox server. I already used these application. and I want to know how to enable the SQL support?

trampgeek commented 3 years ago

The Jobe installer builds a system with sqlite3. The CodeRunner sql question type uses this via Python3. If you're using Jobe outside of CodeRunner you'll have to write your own glue code in Python (or other language of your choice) to set up an sqlite3 database file and run sql commands on it.

Here's the template for the CodeRunner question type as a text file: sqltemplate.txt. If you have further questions related to CodeRunner, please ask them on the CodeRunner question authors forum .

If you're looking for sql support beyond the level of sqlite3, I'm afraid you're out of luck.

sunyongke commented 1 year ago

Thanks for your template