ptyin/sqloj

集成SQL语句测评和学生管理的数据库系统实验平台，可用于毕设和大作业，欢迎提issue和pr。

Welcome to SQLOJ 👋

A lightweight database system experimental platform that integrates an OJ of SQL and a variety of practical functionalities.

✨ Demo

Install

docker pull ptyin/sqloj

Usage

docker run -d -p 80:80 -v <mongo-db-path>:/data/db -v <mongo-configdb-path>:/data/configdb -v <sqlite-path>:/var/lib/sqloj ptyin/sqloj:latest 

where <mongo-db-path><mongo-configdb-path><sqlite-path> denotes the data persistence directories path in your server. e.g.,

In Windows:

docker run -d -p 80:80 -v D:\SQLOJ\mongodb\data:/data/db -v D:\SQLOJ\mongodb\config:/data/configdb -v D:\SQLOJ\sqlite:/var/lib/sqloj --name test ptyin/sqloj:latest 

In Linux:

docker run -d -p 80:80 -v /opt/SQLOJ/mongodb/data:/data/db -v /opt/SQLOJ/mongodb/config:/data/configdb -v /opt/SQLOJ/sqlite:/var/lib/sqloj --name test ptyin/sqloj:latest 

Run tests

npm run test

Functionality

Module Design

User Management

User Role

• teacher
  • Default teacher username: admin
  • Default teacher password: tsxt-adm1n
• student

Login Panel

Teacher Example Page

Publish an assignment

Add questions in a certain assignment

Upload a database

Student Example Page

View question list

Review uploaded records

Status might be (RUNNING/AC/WA/RE/TLE)。

Check specific information in a record

Author

👤 Peter Yin

• Website: http://ptyin.asia/
• Github: @PTYin

Show your support

Give a ⭐️ if this project helped you!

📝 License

Copyright © 2021 Peter Yin.
This project is MIT licensed.

sqloj's Issues

问一下这个系统的sql是怎么判断对错的？没学过py不太看的懂。

第一次来GitHub评论。本科大创的题目也是这个方向
我只学了java和springboot和mysql。我个人的想法是将标准答案sql与学生提供的sql语句结果相比较，结果正确返回true，否则返回false。我的想法是每次判断sql都要在java上创建实体类，然后用jdbc去excute执行。但是这样只能用于指定的习题，不能像您这个系统自由添加习题与数据库。
恳请大佬解答。

docker build 报错

HTTP error 404 while getting https://mirrors.bfsu.edu.cn/pypi/web/packages/67/b8/0322016b9ce09a64fba9018211e7c35fd51380527ffd9ea248744f389239/Flask_PyMongo-2.3.0-py2.py3-none-any.whl#sha256=8a9577a2c6d00b49f21cb5a5a8d72561730364a2d745551a85349ab02f86fc73 (from https://mirrors.bfsu.edu.cn/pypi/web/simple/flask-pymongo/)
Could not install requirement Flask-PyMongo from https://mirrors.bfsu.edu.cn/pypi/web/packages/67/b8/0322016b9ce09a64fba9018211e7c35fd51380527ffd9ea248744f389239/Flask_PyMongo-2.3.0-py2.py3-none-any.whl#sha256=8a9577a2c6d00b49f21cb5a5a8d72561730364a2d745551a85349ab02f86fc73 (from -r /opt/sqloj/requirements.txt (line 5)) because of error 404 Client Error: Not Found for url: https://mirrors.bfsu.edu.cn/pypi/web/packages/67/b8/0322016b9ce09a64fba9018211e7c35fd51380527ffd9ea248744f389239/Flask_PyMongo-2.3.0-py2.py3-none-any.whl
Could not install requirement Flask-PyMongo from https://mirrors.bfsu.edu.cn/pypi/web/packages/67/b8/0322016b9ce09a64fba9018211e7c35fd51380527ffd9ea248744f389239/Flask_PyMongo-2.3.0-py2.py3-none-any.whl#sha256=8a9577a2c6d00b49f21cb5a5a8d72561730364a2d745551a85349ab02f86fc73 (from -r /opt/sqloj/requirements.txt (line 5)) because of HTTP error 404 Client Error: Not Found for url: https://mirrors.bfsu.edu.cn/pypi/web/packages/67/b8/0322016b9ce09a64fba9018211e7c35fd51380527ffd9ea248744f389239/Flask_PyMongo-2.3.0-py2.py3-none-any.whl for URL https://mirrors.bfsu.edu.cn/pypi/web/packages/67/b8/0322016b9ce09a64fba9018211e7c35fd51380527ffd9ea248744f389239/Flask_PyMongo-2.3.0-py2.py3-none-any.whl#sha256=8a9577a2c6d00b49f21cb5a5a8d72561730364a2d745551a85349ab02f86fc73 (from https://mirrors.bfsu.edu.cn/pypi/web/simple/flask-pymongo/)
好像是镜像站上的镜像已被删除或改变

sqloj可以参考算法OJ系统

可以在基础上增加OJ系统的一些功能，比如问题，比赛，排名，状态，后天可以查看所有学生等等，不知道是否还会继续更新