def testFC(data): password = data['password'] if password == 123456: # 获取Token userId = data.get('id', 1) return ResponseEntity.ok('登录成功!').setToken({'user_id': userId}) else: return ResponseEntity.unauthorized('密码错误!')
def testFC(data): # 先获取配置中心url centerConfig = getConfByName(CONF_CENTER_NAME) # 获取配置 myConf = getConfigFromConfCenter(centerConfig['url'], ['mysql', 'postgresql'], centerConfig['pwd']) return ResponseEntity.ok(myConf.text)
def testFC(data): try: res = testFC1(data) _conn.commit() return res except Exception as e: _conn.rollback() _log.error(e) return ResponseEntity.badRequest(e)
def testFC(data): # 获取配置 mysqlConf = getConfByName('mysql') return ResponseEntity.ok(mysqlConf)
def testFC(data): return ResponseEntity.ok('Hello World!')
def testFC(data): print('前端传来的参数:') print(data) return ResponseEntity.ok(data)
def testPost(data): return ResponseEntity.ok('操作成功')
def testFC(data): orm = Orm(_conn, 'user') userId = orm.deleteByPrimaryKey(1) users = orm.selectAll() return ResponseEntity.ok(users)
def testFC(data): return ResponseEntity.ok(getUrl)
def testPost(data): token = getPayloadFromHeader() _log.info(token) return ResponseEntity.ok('操作成功')
def testFC1(data): # 关闭自动提交 userOrm = Orm(_conn, 'user', auto_commit=False) houseOrm = Orm(_conn, 'house', auto_commit=False) print('==============插入数据==============') userId = userOrm.insertData({'name':'张三', 'age':18}) houseOrm.insertData(['user_id', 'address', 'price'], [[userId, '成都市武侯区', 100], [userId, '成都市高新区', 200], [userId, '北京市东城区', 300], [userId, '北京市西城区', 400], [userId, '北京市朝阳区', 500]]) print('==============所有user数据==============') users = userOrm.selectAll() print(users) print('==============所有house数据==============') houses = houseOrm.selectAll() print(houses) print('==============所有位于成都的house数据==============') houses = houseOrm.selectByExample(Example().andLike('address', '成都%')) print(houses) print('==============所有不在成都的house数据==============') houses = houseOrm.selectByExample(Example().andNotLike('address', '成都%')) print(houses) print('==============所有user_id为1的house数据==============') houses = houseOrm.selectByExample(Example().andEqualTo({'user_id': 1})) print(houses) print('==============连接查询==============') userOrm.leftJoin('house', 'house.user_id=user.id') houses = userOrm.selectByExample(Example().andEqualTo({'price': 100})) print(houses) print('==============清除缓存==============') userOrm.clear() print('==============所有售价大于200小于400的house数据==============') houses = houseOrm.selectByExample(Example().andBetween('price', 200, 400)) print(houses) print('==============所有北京的房子涨价10==============') houseOrm.updateByExample({'price': '+10'}, Example().andLike('address', '北京%')) houses = houseOrm.selectAll() print(houses) print('==============分页查询==============') num, houses = houseOrm.selectPageByExample(Example().andEqualTo({'user_id': userId}), 2, 3) print('符合条件的总条数:{}'.format(num)) print('本页数据:') print(houses) print('==============多值查询==============') houses = houseOrm.selectByExample(Example().andInValues('price', [100, 200])) print(houses) return ResponseEntity.ok('请查看控制台日志')
def testFC(data): ''' ''' orm = Orm(_conn, 'user') userId = orm.insertData(data) return ResponseEntity.ok('新增用户成功,你的id:{}'.format(userId))