动态的SQL语句在云函数中如何使用?
这是我的云数据库中一个集合的数据 [代码]{[代码][代码] [代码][代码]_id: [代码][代码]'west01'[代码][代码],[代码][代码] [代码][代码]name[代码][代码]: [代码][代码]'西学楼1号'[代码][代码],[代码][代码] [代码][代码]roomList: [[代码][代码] [代码][代码]{[代码][代码] [代码][代码]room:[代码][代码]'101'[代码][代码],[代码][代码] [代码][代码]bedList:[[代码][代码] [代码][代码]{bed:[代码][代码]'A'[代码][代码],isChoose:0},[代码][代码] [代码][代码]{bed:[代码][代码]'B'[代码][代码],isChoose:0},[代码][代码] [代码][代码]{bed:[代码][代码]'C'[代码][代码],isChoose:0},[代码][代码] [代码][代码]{bed:[代码][代码]'D'[代码][代码],isChoose:1},[代码][代码] [代码][代码]][代码][代码] [代码][代码]},[代码][代码] [代码][代码]{[代码][代码] [代码][代码]room:[代码][代码]'102'[代码][代码],[代码][代码] [代码][代码]bedList:[[代码][代码] [代码][代码]{bed:[代码][代码]'A'[代码][代码],isChoose:0},[代码][代码] [代码][代码]{bed:[代码][代码]'B'[代码][代码],isChoose:0},[代码][代码] [代码][代码]{bed:[代码][代码]'C'[代码][代码],isChoose:1},[代码][代码] [代码][代码]{bed:[代码][代码]'D'[代码][代码],isChoose:1},[代码][代码] [代码][代码]][代码][代码] [代码][代码]},[代码][代码] [代码][代码]{[代码][代码] [代码][代码]room:[代码][代码]'103'[代码][代码],[代码][代码] [代码][代码]bedList:[[代码][代码] [代码][代码]{bed:[代码][代码]'A'[代码][代码],isChoose:0},[代码][代码] [代码][代码]{bed:[代码][代码]'B'[代码][代码],isChoose:0},[代码][代码] [代码][代码]{bed:[代码][代码]'C'[代码][代码],isChoose:0},[代码][代码] [代码][代码]{bed:[代码][代码]'D'[代码][代码],isChoose:0},[代码][代码] [代码][代码]][代码][代码] [代码][代码]}[代码][代码] [代码][代码]],[代码][代码] [代码][代码]},[代码][代码] [代码][代码]{[代码][代码] [代码][代码]_id: [代码][代码]'west02'[代码][代码],[代码][代码] [代码][代码]name[代码][代码]: [代码][代码]'西学楼2号'[代码][代码],[代码][代码] [代码][代码]roomList: [[代码][代码] [代码][代码]{[代码][代码] [代码][代码]room:[代码][代码]'201'[代码][代码],[代码][代码] [代码][代码]bedList:[[代码][代码] [代码][代码]{bed:[代码][代码]'A'[代码][代码],isChoose:0},[代码][代码] [代码][代码]{bed:[代码][代码]'B'[代码][代码],isChoose:0},[代码][代码] [代码][代码]{bed:[代码][代码]'C'[代码][代码],isChoose:0},[代码][代码] [代码][代码]{bed:[代码][代码]'D'[代码][代码],isChoose:1},[代码][代码] [代码][代码]][代码][代码] [代码][代码]},[代码][代码] [代码][代码]{[代码][代码] [代码][代码]room:[代码][代码]'202'[代码][代码],[代码][代码] [代码][代码]bedList:[[代码][代码] [代码][代码]{bed:[代码][代码]'A'[代码][代码],isChoose:1},[代码][代码] [代码][代码]{bed:[代码][代码]'B'[代码][代码],isChoose:0},[代码][代码] [代码][代码]{bed:[代码][代码]'C'[代码][代码],isChoose:1},[代码][代码] [代码][代码]{bed:[代码][代码]'D'[代码][代码],isChoose:0},[代码][代码] [代码][代码]][代码][代码] [代码][代码]}[代码][代码] [代码][代码]],[代码][代码] [代码][代码]}[代码]想通过小程序来选择宿舍,通过云函数来将某个被选定的床位的“isChoose”字段设置为1。 例如,我选择了“西学楼1号-101房-A床”,那么我就需要把对应的床位的“isChoose”字段设置为1 我的json数据是多层的,于是我在云开发控制台的模板中尝试修改,我的方案是,通过下面的代码去修改“isChoose”字段的值 [代码]db.collection([代码][代码]'dormitories'[代码][代码])[代码][代码] [代码][代码].[代码][代码]where[代码][代码]({[代码][代码] [代码][代码]name[代码][代码]: [代码][代码]'西学楼1号'[代码][代码] [代码][代码]})[代码][代码] [代码][代码].[代码][代码]update[代码][代码]({[代码][代码] [代码][代码]data: {[代码][代码] [代码][代码]'roomList.0.bedList.0.isChoose'[代码][代码]: 1[代码][代码] [代码][代码]},[代码][代码] [代码][代码]})[代码]但是我也面临着一个问题,选择其他宿舍的话,那'roomList.0.bedList.0.isChoose'里的两个“0”(房间号的index和床号的index)就是动态的,而我也可以获得这两个index值,可是eval()在小程序中用不了,于是我也不能动态地改变这个SQL语句。 各位大佬有解决方案,或者其他的实现方案么?请不吝赐教,谢谢