sqloj
sqloj copied to clipboard
集成SQL语句测评和学生管理的数据库系统实验平台,可用于毕设和大作业,欢迎提issue和pr。
Welcome to SQLOJ 👋
![SQLOJ](https://github.com/ptyin/sqloj/raw/main/doc/images/logo.png)
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!