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))