{"topic":{"id":4919,"title":"交大門评课社区上线网址 xjtu.app/course","slug":"topic","categoryId":2,"createdAt":"2023-12-11 16:00:00","bumpedAt":"2023-12-22 03:48:47.786704","views":1626,"postsCount":9,"highestPostNumber":11,"likeCount":11,"closed":false,"pinned":false,"pinnedGlobally":false,"pinnedAt":null,"pinnedUntil":null,"isBanner":false,"excerpt":"tl;dr 点击：https://xjtu.app/c/course/64 【以下信息已过时】请使用导航栏链接 -> 评课社区打开独立站点。基于 USTC 评课社区源码，汇集不同课程以及不同老师的教学班的信息。交大門评课社区上线，和主站的用户系统打通。欢迎提出建议，进行评价，以及改进/审计代码。网址：任意域名后加 /course（单复数都行）基本信息课程名录齐全，包含全校所有课程 ~200 选修课有成绩…","deletedAt":null,"isAnonymous":false,"category":{"id":2,"name":"网站","slug":"website","color":"986a44"},"author":{"id":1047,"username":"anonymous_coward_old","name":"Anonymous Coward Old","avatarUrl":"/uploads/image/43/32/4332638c11248b8ff07033c11de0759a55205facfbec85e14458245a91991faf.avif"},"tags":["dev","course"]},"posts":[{"id":9313,"postNumber":1,"raw":"## tl;dr\n\n点击：https://xjtu.app/c/course/64\n\n---\n【以下信息已过时】\n----\n\n请使用导航栏 链接 -> 评课社区 打开独立站点。\n\n基于 [USTC 评课社区](https://icourse.club/) 源码，汇集**不同课程**以及**不同老师的教学班**的信息。\n\n---\n\n交大門评课社区上线，和主站的用户系统打通。\n\n\n\n**欢迎提出建议，进行评价，以及改进/审计 [代码](https://github.com/xjtumen/course-review)**。\n\n网址：任意域名后加 `/course`（单复数都行）\n\n\n## 基本信息\n\n1. 课程名录齐全，包含全校 **所有** 课程\n2. ~200 选修课有**成绩分布、最高、最低、平均分**信息\n2. 250+ 选修课有评价信息\n2. 300+ 选修课有考核方式、授课模式、课程内容简介、使用教材及参考书信息\n\n\n## 特色功能：\n在 USTC 评课社区源码的基础上做了些许修改：\n* 支持 OAuth，也即只要你在 xjtu.app 登录，[进入评课社区后自动同步交大門登录身份](https://xjtu.app/t/topic/8246/11)。\n\n[details=\"Outdated info hided\"]\n-> 为什么多此一举非要点一下登录按键呢？\n-> 因为我本来是想开发 Discourse 插件，将本站的一个类别打造成评课社区。无奈 Ruby+Ember.js 的技术栈没有基于 USTC 评课社区代码 Python+Flask+Plotly 开发效率高。至于后面是否要切换成 Discourse 插件的方式还需要斟酌。\n[/details]\n\n\n* 区间分数可视化，以及显示均分、最高分、最低分。\n-> 当然，现在这个图表做得还是很粗糙的，后续需要改进配色、文字位置等等细节。欢迎 [PR](https://github.com/xjtumen/course-review/pulls)。\n![Screenshot_20230818_160701|690x472, 75%](/uploads/image/8f/3e/8f3ef52907c6fb96c83e219b18334bcedd596e5215bde4b22b6cc420097be4b3.avif)\n\n* (Idea) 使用 NLP 对现有评论数据进行情感分析和理解，以对“课程难度、作业多少、给分好坏、收获大小”等目前**空缺的**指标进行定性。\n-> 把 USTC 评课社区的数据爬下来，训练一个情感/语义分析模型\n\n更新：\n* 完善课程的自身属性：课程编号、开课单位、任课教师、学分（学时）、选修课板块类别、课程简介。去除了一些无用评价。（Idea）可以和现有的“导师信息”有机地结合起来，增加任课教师到交大門导师信息的链接。\n\n* (Ongoing) 调 `gpt-3.5-turbo-16k` 接口 summarize 某个课程/教学班的评论，类似本站总结话题的功能。\n\n* 可按选修课板块筛选\n\n* 完善在线编辑课程信息的功能，类似 https://course.sjtu.plus/ （上交评课网站，基于 Django）。\n\n### （Technical）运行方法\n\n\n```\ngit clone https://github.com/xjtumen/course-review\ncd course-review\n# 把 USTC 重命名为 USTC\nfor suffix in py html js\ndo\n list1=\"USTC 科大中国科学技术大学\"\n list2=\"XJTU 交大西安交通大学\"\n array1=($list1)\n array2=($list2)\n\n count=${#array1[@]}\n for i in `seq 1 $count`\n do\n echo replace all ${array1[$i-1]} to ${array2[$i-1]} in all suffix files\n find ./ -type f -name \"*.$suffix\" -exec sed -i \"s/${array1[$i-1]}/${array2[$i-1]}/g\" {} +\n \n done\n\ndone\n\n# 按照 README.md 进行数据库（MariaDB）的初始化作业\n$ mariadb -u root -p \nMariaDB [(none)]> CREATE USER 'dbuser'@'localhost' identified by 'MyPassword';\nMariaDB [(none)]> CREATE DATABASE icourse;\nMariaDB [(none)]> GRANT ALL ON icourse.* to 'dbuser'@'localhost';\nMariaDB [(none)]> \\q\nBye\n\n# 创建环境\npython -m venv ./venv\npip install -r requirements.txt\n\n# 按需修改 config/default.py 里面的变量如域名\n\n# 按照数据源修改数据导入脚本：tests/import_courses_jd.py\npython -m tests.import_courses_jd\n\n# 启动服务：\ngunicorn jcourse.wsgi --bind 0.0.0.0:8000 --workers=5 \n\n# 配置反向代理，可参考 `tests/conf/nginx-config`\n```\n\n~~由于是 $\\beta$ 测试，有可能由于功能更新/bug 修复造成短暂的服务中断，需要多刷新，敬请谅解。评价数据都能得到保留。~~\n\n~~域名暂定为 `c.xjtu.app`。~~ \n\n已经完成使用子目录反代，形式为 `xjtu.app/course` 或 `xjtu.app/courses`。\n\n---\n前情提要：\nhttps://xjtu.app/t/topic/4881/","cooked":"

tl;dr

点击：/c/course/64

【以下信息已过时】

请使用导航栏 链接 -> 评课社区 打开独立站点。

基于 USTC 评课社区源码，汇集不同课程以及不同老师的教学班的信息。

交大門评课社区上线，和主站的用户系统打通。

欢迎提出建议，进行评价，以及改进/审计代码。

网址：任意域名后加 /course（单复数都行）

基本信息

课程名录齐全，包含全校所有课程
~200 选修课有成绩分布、最高、最低、平均分信息
250+ 选修课有评价信息
300+ 选修课有考核方式、授课模式、课程内容简介、使用教材及参考书信息

特色功能：

在 USTC 评课社区源码的基础上做了些许修改：

支持 OAuth，也即只要你在 xjtu.app 登录，进入评课社区后自动同步交大門登录身份。

Outdated info hided

-> 为什么多此一举非要点一下登录按键呢？
\n-> 因为我本来是想开发 Discourse 插件，将本站的一个类别打造成评课社区。无奈 Ruby+Ember.js 的技术栈没有基于 USTC 评课社区代码 Python+Flask+Plotly 开发效率高。至于后面是否要切换成 Discourse 插件的方式还需要斟酌。

\n
区间分数可视化，以及显示均分、最高分、最低分。
\n-> 当然，现在这个图表做得还是很粗糙的，后续需要改进配色、文字位置等等细节。欢迎 PR。
\n $\"Screenshot_20230818_160701\"$
\n
\n
(Idea) 使用 NLP 对现有评论数据进行情感分析和理解，以对“课程难度、作业多少、给分好坏、收获大小”等目前空缺的指标进行定性。
\n-> 把 USTC 评课社区的数据爬下来，训练一个情感/语义分析模型
\n

更新：

\n
完善课程的自身属性：课程编号、开课单位、任课教师、学分（学时）、选修课板块类别、课程简介。去除了一些无用评价。（Idea）可以和现有的“导师信息”有机地结合起来，增加任课教师到交大門导师信息的链接。
\n
\n
(Ongoing) 调 gpt-3.5-turbo-16k 接口 summarize 某个课程/教学班的评论，类似本站总结话题的功能。
\n
\n
可按选修课板块筛选
\n
\n
完善在线编辑课程信息的功能，类似 https://course.sjtu.plus/ （上交评课网站，基于 Django）。
\n

（Technical）运行方法

git clone https://github.com/xjtumen/course-review\ncd course-review\n# 把 USTC 重命名为 USTC\nfor suffix in py html js\ndo\n    list1=\"USTC 科大 中国科学技术大学\"\n    list2=\"XJTU 交大 西安交通大学\"\n    array1=($list1)\n    array2=($list2)\n\n    count=${#array1[@]}\n    for i in `seq 1 $count`\n    do\n        echo replace all ${array1[$i-1]} to ${array2[$i-1]} in all suffix files\n        find ./ -type f -name \"*.$suffix\" -exec sed -i \"s/${array1[$i-1]}/${array2[$i-1]}/g\" {} +\n        \n    done\n\ndone\n\n# 按照 README.md 进行数据库（MariaDB）的初始化作业\n$ mariadb -u root -p \nMariaDB [(none)]>  CREATE USER 'dbuser'@'localhost' identified by 'MyPassword';\nMariaDB [(none)]>  CREATE DATABASE icourse;\nMariaDB [(none)]>  GRANT ALL ON icourse.* to 'dbuser'@'localhost';\nMariaDB [(none)]> \\q\nBye\n\n# 创建环境\npython -m venv ./venv\npip install -r requirements.txt\n\n# 按需修改 config/default.py 里面的变量如域名\n\n# 按照数据源修改数据导入脚本：tests/import_courses_jd.py\npython -m tests.import_courses_jd\n\n# 启动服务：\ngunicorn jcourse.wsgi --bind 0.0.0.0:8000 --workers=5   \n\n# 配置反向代理，可参考 `tests/conf/nginx-config`\n

~~由于是 $\\beta$ 测试，有可能由于功能更新/bug 修复造成短暂的服务中断，需要多刷新，敬请谅解。评价数据都能得到保留。~~

~~域名暂定为 c.xjtu.app。~~

已经完成使用子目录反代，形式为 xjtu.app/course 或 xjtu.app/courses。

前情提要：

\n","createdAt":"2023-12-11 16:00:00","updatedAt":"2024-07-24 12:51:16.174318","replyToPostNumber":null,"replyCount":2,"likeCount":6,"wordCount":1008,"liked":false,"bookmarked":false,"polls":[],"reactions":[{"reaction":"❤️","count":6,"users":[{"id":93,"username":"copi","name":null},{"id":172,"username":"HCCH","name":"HCCH"},{"id":307,"username":"Fast","name":null},{"id":426,"username":"Komeiji_Koishi","name":"Komeiji_Koishi"},{"id":1012,"username":"Ratled","name":"精神zjuer"},{"id":6205,"username":"uika_winwing","name":null}],"hasReacted":false}],"wiki":false,"version":20,"publicVersion":20,"deletedAt":null,"isAnonymous":false,"user":{"id":1047,"username":"anonymous_coward_old","name":"Anonymous Coward Old","avatarUrl":"/uploads/image/43/32/4332638c11248b8ff07033c11de0759a55205facfbec85e14458245a91991faf.avif","admin":false,"moderator":false,"signatureRaw":null,"signatureCooked":null}},{"id":9851,"postNumber":3,"raw":"好耶，之前看到过几个类似的网站，PKU(courses.pinzhixiaoyuan.com)，境外的一个 (www.ratemyprofessors.com)，CULPA([culpa.info](https://culpa.info))，可以供参考。\n\n另外 PKU 那边貌似出过一些问题，网站是匿名搭建的，但后来团委想抄（建一个受自己管理的），所以尝试了用爬虫爬下所有数据直接 copy，导致网站进行了一些访问限制，这个可能需要提前做下准备","cooked":"

好耶，之前看到过几个类似的网站，PKU(courses.pinzhixiaoyuan.com)，境外的一个 (www.ratemyprofessors.com)，CULPA(culpa.info)，可以供参考。

另外 PKU 那边貌似出过一些问题，网站是匿名搭建的，但后来团委想抄（建一个受自己管理的），所以尝试了用爬虫爬下所有数据直接 copy，导致网站进行了一些访问限制，这个可能需要提前做下准备

\n","createdAt":"2023-12-11 16:46:55.378704","updatedAt":"2023-12-11 16:46:55.378704","replyToPostNumber":null,"replyCount":1,"likeCount":2,"wordCount":112,"liked":false,"bookmarked":false,"polls":[],"reactions":[{"reaction":"❤️","count":2,"users":[{"id":93,"username":"copi","name":null},{"id":307,"username":"Fast","name":null}],"hasReacted":false}],"wiki":false,"version":1,"publicVersion":1,"deletedAt":null,"isAnonymous":false,"user":{"id":299,"username":"sola","name":null,"avatarUrl":null,"admin":false,"moderator":false,"signatureRaw":null,"signatureCooked":null}},{"id":9894,"postNumber":4,"raw":"感谢建议，rate limit 必须要有，再来点其他的反爬手段","cooked":"

感谢建议，rate limit 必须要有，再来点其他的反爬手段

\n","createdAt":"2023-12-11 16:46:55.378704","updatedAt":"2024-03-17 13:05:09.939797","replyToPostNumber":3,"replyCount":0,"likeCount":0,"wordCount":21,"liked":false,"bookmarked":false,"polls":[],"reactions":[],"wiki":false,"version":1,"publicVersion":1,"deletedAt":null,"isAnonymous":false,"user":{"id":1047,"username":"anonymous_coward_old","name":"Anonymous Coward Old","avatarUrl":"/uploads/image/43/32/4332638c11248b8ff07033c11de0759a55205facfbec85e14458245a91991faf.avif","admin":false,"moderator":false,"signatureRaw":null,"signatureCooked":null}},{"id":19549,"postNumber":6,"raw":"问问楼主不打算在表白墙和校园集市宣传宣传吗，好像现在用的人不多，课程信息也有限，是因为还在测试阶段吗","cooked":"

问问楼主不打算在表白墙和校园集市宣传宣传吗，好像现在用的人不多，课程信息也有限，是因为还在测试阶段吗

\n","createdAt":"2023-12-19 15:02:11.546328","updatedAt":"2023-12-19 15:02:11.546328","replyToPostNumber":null,"replyCount":1,"likeCount":0,"wordCount":50,"liked":false,"bookmarked":false,"polls":[],"reactions":[],"wiki":false,"version":1,"publicVersion":1,"deletedAt":null,"isAnonymous":false,"user":{"id":1372,"username":"onesparrow","name":"阿雀","avatarUrl":"/uploads/image/13/8c/138c8cfd0bd84ef8820f978e33e91f860514588e9ca489d6d9ad0dbee9cc770c.avif","admin":false,"moderator":false,"signatureRaw":null,"signatureCooked":null}},{"id":19560,"postNumber":7,"raw":"站长一己之力让你交网络设施超过无数高校，再建 lug,pt 站，iptv,ntp,dns，直播系统，wallessxjtu，代码托管，网络启动，ftp，聚合博客，wiki,freeshell 就是中国第一了","cooked":"

站长一己之力让你交网络设施超过无数高校，再建 lug,pt 站，iptv,ntp,dns，直播系统，wallessxjtu，代码托管，网络启动，ftp，聚合博客，wiki,freeshell 就是中国第一了

\n","createdAt":"2023-12-19 15:30:25.727588","updatedAt":"2023-12-19 15:30:25.727588","replyToPostNumber":1,"replyCount":1,"likeCount":1,"wordCount":52,"liked":false,"bookmarked":false,"polls":[],"reactions":[{"reaction":"❤️","count":1,"users":[{"id":307,"username":"Fast","name":null}],"hasReacted":false}],"wiki":false,"version":1,"publicVersion":1,"deletedAt":null,"isAnonymous":true,"user":{"id":2191,"username":"anonymous","name":null,"avatarUrl":null,"admin":false,"moderator":false}},{"id":19562,"postNumber":8,"raw":"可以看看 mit 的 IT 服务 https://ist.mit.edu/services","cooked":"

可以看看 mit 的 IT 服务 Our Services

\n","createdAt":"2023-12-19 15:33:28.735696","updatedAt":"2023-12-19 15:33:28.735696","replyToPostNumber":1,"replyCount":0,"likeCount":0,"wordCount":10,"liked":false,"bookmarked":false,"polls":[],"reactions":[],"wiki":false,"version":1,"publicVersion":1,"deletedAt":null,"isAnonymous":true,"user":{"id":2191,"username":"anonymous","name":null,"avatarUrl":null,"admin":false,"moderator":false}},{"id":19563,"postNumber":9,"raw":"@えしりなか强强 :herb:","cooked":"

@えしりなか强强 🌿

\n","createdAt":"2023-12-19 15:44:08.462308","updatedAt":"2023-12-19 15:44:08.462308","replyToPostNumber":null,"replyCount":0,"likeCount":0,"wordCount":9,"liked":false,"bookmarked":false,"polls":[],"reactions":[],"wiki":false,"version":1,"publicVersion":1,"deletedAt":null,"isAnonymous":false,"user":{"id":1941,"username":"john","name":"John","avatarUrl":"/uploads/image/5a/04/5a0499fe826e0ab0e29d97bc3d98bbc1dfebf81309f4b4426ae0c7b62bd908e8.avif","admin":false,"moderator":false,"signatureRaw":"自黄药师黄仁勋来，世人皆爱猫。余独爱老鼠之，可爱之态，活泼之动，实为人所难以抗拒。喵~\n\n:mouse_hole: :mouse: :mouse: :computer_mouse: :mouse_trap: :sob_mouse: :sweat_smile_mouse: :sleeping_mouse: :rolling_on_the_floor_laughing_mouse: :revolving_hearts_mouse: :pleading_face_mouse: :nerd_face_mouse: :mouse_hole: :melting_face_mouse: :mask_mouse: :innocent_mouse: :hugging_face_mouse: :frog_mouse: :face_with_cowboy_hat_mouse: :clown_face_mouse: :cherry_blossom_mouse: :cat_mouse:","signatureCooked":"

自黄药师黄仁勋来，世人皆爱猫。余独爱老鼠之，可爱之态，活泼之动，实为人所难以抗拒。喵~

$\":mouse_hole:\"$ 🐁 🐁 🖱️ 🪤 $\":sob_mouse:\"$ $\":sweat_smile_mouse:\"$ $\":sleeping_mouse:\"$ $\":rolling_on_the_floor_laughing_mouse:\"$ $\":revolving_hearts_mouse:\"$ $\":pleading_face_mouse:\"$ $\":nerd_face_mouse:\"$ $\":mouse_hole:\"$ $\":melting_face_mouse:\"$ $\":mask_mouse:\"$ $\":innocent_mouse:\"$ $\":hugging_face_mouse:\"$ $\":frog_mouse:\"$ $\":face_with_cowboy_hat_mouse:\"$ $\":clown_face_mouse:\"$ $\":cherry_blossom_mouse:\"$ $\":cat_mouse:\"$

\n"}},{"id":19579,"postNumber":10,"raw":"[quote=\"阿雀，post:6, topic:4919, username:onesparrow\"]\n楼主不打算在表白墙和校园集市宣传宣传吗\n[/quote]\n\n\n不是我想不想的问题。\n\n\n都 4 个多月了，现在是 $\\zeta$ 测试了我估计。\n\n根据后台日志，不少人是只看不发。","cooked":"

\n\t\t\t\t\t

\n\t\t\t\t\t\t

\n\t\t\t\t\t\t\t

\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t

\n\t\t\t\t\t\t\t阿雀，post:6, topic:4919, username:onesparrow:\n\t\t\t\t\t\t

\n\t\t\t\t\t

\n
楼主不打算在表白墙和校园集市宣传宣传吗
\n

\n\t\t\t\t

不是我想不想的问题。

都 4 个多月了，现在是 $\\zeta$ 测试了我估计。

根据后台日志，不少人是只看不发。

\n","createdAt":"2023-12-20 01:12:18.016456","updatedAt":"2024-03-17 13:05:10.017381","replyToPostNumber":6,"replyCount":0,"likeCount":2,"wordCount":70,"liked":false,"bookmarked":false,"polls":[],"reactions":[{"reaction":"❤️","count":2,"users":[{"id":307,"username":"Fast","name":null},{"id":2482,"username":"Boddy","name":"闆烽洺"}],"hasReacted":false}],"wiki":false,"version":2,"publicVersion":2,"deletedAt":null,"isAnonymous":false,"user":{"id":1047,"username":"anonymous_coward_old","name":"Anonymous Coward Old","avatarUrl":"/uploads/image/43/32/4332638c11248b8ff07033c11de0759a55205facfbec85e14458245a91991faf.avif","admin":false,"moderator":false,"signatureRaw":null,"signatureCooked":null}},{"id":19580,"postNumber":11,"raw":"小伙子，英文半角 `,` 后面记得加空格。另外，[专业的人干专业的事](https://lug.ustc.edu.cn/wiki/lug/services/#服务等级与服务标准)，像是 git 服务搭建门槛很低（gitlab, gitea），如果有人宣称可以提供免费的代码托管服务我是不敢用的（除了 github，gitlab）。","cooked":"

小伙子，英文半角 , 后面记得加空格。另外，专业的人干专业的事，像是 git 服务搭建门槛很低（gitlab, gitea），如果有人宣称可以提供免费的代码托管服务我是不敢用的（除了 github，gitlab）。

\n","createdAt":"2023-12-20 01:14:24.384934","updatedAt":"2023-12-22 03:48:47.75133","replyToPostNumber":7,"replyCount":0,"likeCount":0,"wordCount":82,"liked":false,"bookmarked":false,"polls":[],"reactions":[],"wiki":false,"version":5,"publicVersion":5,"deletedAt":null,"isAnonymous":true,"user":{"id":2191,"username":"anonymous","name":null,"avatarUrl":null,"admin":false,"moderator":false}}],"hasMore":false,"lastReadPostNumber":1,"hasUrlPostNumber":false}