db_test.js 2.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566
  1. const router = require('koa-router')() //导入 koa-router
  2. const redis = require("../model/db/redis_db") //导入 db.js
  3. const mysql = require("../model/db/mysql_db") //导入 db.js
  4. // https://github.com/luin/ioredis#readme
  5. const logger = require('../model/logger')
  6. var remote_config_db = require("../model/db/remote_config_db");
  7. router.prefix('/test');
  8. router.post('/set', async (ctx) => {
  9. // const obj = ctx.request.body;
  10. // console.log("set:",obj)
  11. // redis.redis_set(obj.key, obj.value);
  12. // ctx.body = obj.key + " - "+ obj.value
  13. // var arrays = [1, 2, 3, 4, 5]
  14. for (let index = 0; index < 10; index++) {
  15. redis.redis_push('WITHDRAW_QUEUE_KEY', JSON.stringify({ code: index }))
  16. }
  17. while (true) {
  18. var item = await redis.redis_pop('WITHDRAW_QUEUE_KEY')
  19. logger.log('item', typeof item, JSON.parse(item));
  20. if (!item) {
  21. break
  22. }
  23. }
  24. logger.log('exit');
  25. })
  26. router.post('/get', async (ctx) => {
  27. const obj = ctx.request.body;
  28. console.log("get:", obj)
  29. await redis.redis_get(obj.key).then((result) => {
  30. // ctx.body = "key:" + obj.key + " \n" + "value:" + result
  31. console.error('>>>>>>>>>>>>redis_get' + "key:" + obj.key + "-" + "value:" + result)
  32. });
  33. await redis.readRedis(obj.key).then((result) => {
  34. ctx.body = "readRedis key:" + obj.key + " \n" + "value:" + result
  35. });
  36. })
  37. router.post('/queryUserPrivateKey', async (ctx) => {
  38. const obj = ctx.request.body;
  39. console.log("queryUserPrivateKey:", obj)
  40. // await mysql.queryUserPrivateKeyFromUserAddress(obj.userAddress).then(function (mysqlDbResp){
  41. // ctx.body = "results:" + JSON.stringify(mysqlDbResp)
  42. // console.log('mysqlDbResp=', JSON.stringify(mysqlDbResp));
  43. // })
  44. await mysql.queryCompanyInfoFromId(0).then(e => {
  45. ctx.body = "results:" + JSON.stringify(e)
  46. })
  47. })
  48. async function query() {
  49. console.log('collect_coins', await remote_config_db.isPause('collect_coins'))
  50. console.log('withdraw', await remote_config_db.isPause('withdraw'))
  51. }
  52. query()
  53. module.exports = router