程序设计大赛前的准备+017版本接口迁移

本周概述

这两周要做的事情比较多,一是完成两个接口的迁移,二是完成程序设计大赛前老师布置的准备任务

接口迁移

本次接口迁移，难度还是比较大的，因为这个接口关联的表太多了，之前做单词接口的时候，一个表拖着三个表就已经快想破我的头皮了，这次更加复杂，一个表不光拖着三个表，这三个子表还有子表，甚至还有第三层，子表的子表中仍然由子表。

不过有了上一个接口的项目经验，也没花几天就完成的差不多了，虽然还没有接上微信进行调试，逻辑感觉最起码现在是通的。

先展示一下表，

在微信里面他是这样的 

{
  "_id": "b00064a760478a800930cd90071f17b6",
  "bookName": "四级词汇",
  "createTime": {
    "$date": "2021-03-09T14:47:28.187Z"
  },
  "isNPC": true,
  "left": {
    "grades": {
      "0": {
        "optIdx": 1.0,
        "score": 93.0
      },
      "1": {
        "optIdx": 3.0,
        "score": 88.0
      },
      "2": {
        "optIdx": 3.0,
        "score": 91.0
      },
      "3": {
        "optIdx": 0.0,
        "score": 89.0
      },
      "4": {
        "optIdx": 1.0,
        "score": -36.0
      }
    },
    "openid": "oYip95YZ-lgD7M8TZzDBRIBtpwKU",
    "avatar": "https://thirdwx.qlogo.cn/mmopen/vi_32/ChY18grtXma08fKhrDFxfcEe3BZybuyqEZCekxMaECiauRcHnVOWZfyo2icASduD8VZzfvTmeDw7cBicJia9QYtPzg/132",
    "gradeSum": 325.0
  },
  "bookId": "CET4Full",
  "isFriend": false,
  "nextRoomId": "",
  "questions": [
    {
      "options": [
        "n.准则；法典；代码",
        "n.投递；交付；分娩",
        "n.郊游，野餐",
        "v.装满，盛满；占满"
      ],
      "type": 1.0,
      "usphone": "dɪ'lɪvəri",
      "word": "delivery",
      "wordId": "CET4Full_2019",
      "answer": 1.0
    },
    {
      "wordId": "CET4Full_2001",
      "answer": 3.0,
      "options": [
        "n.消耗量；消耗",
        "n.柜台；计数器",
        "v.借，借用，借人",
        "v.说服"
      ],
      "type": 1.0,
      "usphone": "pɚ'swed",
      "word": "persuade"
    },
    {
      "usphone": "ə'sɪstənt",
      "word": "assistant",
      "wordId": "CET4Full_1991",
      "answer": 3.0,
      "options": [
        "adj.坚固的",
        "n.百分比，百分率",
        "n.调合，协调，和谐",
        "n.助手，助理；助教"
      ],
      "type": 1.0
    },
    {
      "usphone": "ɪn'tɛlɪdʒəns",
      "word": "intelligence",
      "wordId": "CET4Full_2022",
      "answer": 0.0,
      "options": [
        "n.智力；理解力；情报",
        "n.货币；金钱；财富",
        "adj.可溶的；可以解决的",
        "n.改进，改善；改进之处"
      ],
      "type": 1.0
    },
    {
      "wordId": "CET4Full_2005",
      "answer": 0.0,
      "options": [
        "v.拨",
        "v.指派〔任务〕；分配；分派",
        "v.使惊奇，使惊愕",
        "v.积累；堆积"
      ],
      "type": 1.0,
      "usphone": "'daɪəl",
      "word": "dial"
    }
  ],
  "right": {
    "openid": "npc_CET4Full_478",
    "gradeSum": 550.0,
    "grades": {
      "0": {
        "optIdx": 1.0,
        "score": 91.0
      },
      "1": {
        "optIdx": 3.0,
        "score": 74.0
      },
      "2": {
        "optIdx": 3.0,
        "score": 90.0
      },
      "3": {
        "optIdx": 0.0,
        "score": 95.0
      },
      "4": {
        "optIdx": 0.0,
        "score": 200.0
      }
    },
    "avatar": "https://ss2.bdstatic.com/70cFvnSh_Q1YnxGkpoWK1HF6hhy/it/u=2376119459,1068727113&fm=11&gp=0.jpg"
  },
  "state": 4.0,
  "_openid": "oYip95YZ-lgD7M8TZzDBRIBtpwKU"
}

在MySQL中  我给分为了5个表

其实也就是复杂一些的增删改查，只要能把逻辑理清楚其实并不难

 

程序设计大赛

然后就是这个比赛，本人也算一直在学习算法，虽然学的不咋地，但是还是在微微的努力，在学校里拿一等奖没问题，但心里明白，自己算法多么的不行，去年参加省赛的时候，才真正知道自己多么不行，我和三个大四同学组队，才拿了个省三，今年可能连省三也没有了，去年我在队伍里只是辅助，今年我得打C位了

先好好完成老师布置的算法题目吧，希望这次省赛能有个好成绩

劳动节快乐