db_test.js 1.3 KB

1234567891011121314151617181920212223242526272829303132333435363738
  1. const router = require('koa-router')() //导入 koa-router
  2. const redis = require("../model/redis_db") //导入 db.js
  3. const mysql = require("../model/mysql_db") //导入 db.js
  4. // https://github.com/luin/ioredis#readme
  5. const console = require('../model/logger')
  6. router.prefix('/test');
  7. router.post('/set', async (ctx) => {
  8. const obj = ctx.request.body;
  9. console.log("set:",obj)
  10. redis.redis_set(obj.key, obj.value);
  11. ctx.body = obj.key + " - "+ obj.value
  12. })
  13. router.post('/get', async (ctx) => {
  14. const obj = ctx.request.body;
  15. console.log("get:",obj)
  16. await redis.redis_get(obj.key).then((result) => {
  17. // ctx.body = "key:" + obj.key + " \n" + "value:" + result
  18. console.error('>>>>>>>>>>>>redis_get'+"key:" + obj.key + "-" + "value:" + result)
  19. });
  20. await redis.readRedis(obj.key).then((result) => {
  21. ctx.body = "readRedis key:" + obj.key + " \n" + "value:" + result
  22. });
  23. })
  24. router.post('/queryUserPrivateKey', async (ctx) => {
  25. const obj = ctx.request.body;
  26. console.log("queryUserPrivateKey:",obj)
  27. await mysql.queryUserPrivateKeyFromUserAddress(obj.userAddress).then(function (mysqlDbResp){
  28. ctx.body = "results:" + JSON.stringify(mysqlDbResp)
  29. console.log('mysqlDbResp=', JSON.stringify(mysqlDbResp));
  30. })
  31. })
  32. module.exports = router