GetRepos.js 1.3 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546
  1. const API = require("../../lib/API")
  2. const db = require("../../plugin/DataBase/db")
  3. const AccessControl = require("../../lib/AccessControl")
  4. const { BaseStdResponse } = require("../../BaseStdResponse")
  5. class GetRepos extends API {
  6. constructor() {
  7. super()
  8. this.setPath('/User/GetRepos')
  9. this.setMethod('GET')
  10. }
  11. async onRequest(req, res) {
  12. let {
  13. uuid,
  14. session
  15. } = req.query
  16. if ([uuid, session].some(value => value === '' || value === null || value === undefined))
  17. return res.json({
  18. ...BaseStdResponse.MISSING_PARAMETER
  19. })
  20. // 检查 session
  21. if (!await AccessControl.checkSession(uuid, session))
  22. return res.status(401).json({
  23. ...BaseStdResponse.ACCESS_DENIED
  24. })
  25. let sql = 'SELECT id, name, url, logo, create_time, update_time FROM repos WHERE create_user = ? AND state = 1 ORDER BY update_time DESC LIMIT 6'
  26. let rows = await db.query(sql, [uuid])
  27. if (!rows)
  28. return res.json({
  29. ...BaseStdResponse.ERR,
  30. msg: '数据库错误!'
  31. })
  32. res.json({
  33. ...BaseStdResponse.OK,
  34. data: rows
  35. })
  36. }
  37. }
  38. module.exports.GetRepos = GetRepos