Git Product home page Git Product logo

cusx-course-report-query's Introduction

CUSX course report query

这是一个自动查询山西传媒学院成绩的小工具

安装依赖

pip3 install dotenv bs4 requests sqlalchemy pandas
cp .env.template .env

修改 .env 的内容

使用

注意!本工具会自动把评教任务完成并且都选 A

单人查询

单人查询会先查询本地数据库,没有再去爬取,也可以指定强制

python single.py
  • 如果没有修改过密码输入学号即可回车
    请输入学号和密码:2020202020
    
  • 如果修改过密码,使用空格分割密码
    请输入学号和密码:2020202020 password
    
  • 后缀输入 --force 即可强制爬取并更新数据库
    请输入学号和密码:2020202020 password --force
    请输入学号和密码:2020202020 --force
    
    会自动复制到剪贴板,可以方便的粘贴给你的朋友们!

整班查询

整班查询会使用学号遍历查询,会先查询本地数据库,没有再去爬取

考虑到数据量,不支持强制爬取

python group.py
请输入学号前8位:20202020
请输入班级人数:38
# 直接回车 密码无误
请确认学号密码(('2020202001', '2020202001'))# 输入字符串 修改密码
请确认学号密码(('2020202002', '2020202002')):02020202
# 输入 -i 不再确认密码
请确认学号密码(('2020202003', '2020202003')):-i

QQ 机器人

需要安装 mcl

首先要安装额外依赖

pip install cairosvg graia-broadcast graia-application-mirai==0.19.2

.env 填入对应信息然后

python bot.py

赶鸭子上架写的,不是很好看、读

群里使用 /学号 的方式查询,具体规则和 single 一致,然后会发送一张还算美观的成绩单

统计分析

python ranking.py

将生成各个科目的成绩统计

Contributing

Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.

支持我

爱票

微信扫码支持我创业!

License

MIT

cusx-course-report-query's People

Contributors

kejunmao avatar

Stargazers

 avatar  avatar

Watchers

 avatar  avatar  avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.