From ac8522fc973eaedee01d867b9886c807fdc5e945 Mon Sep 17 00:00:00 2001
From: zj <1772600164@qq.com>
Date: Fri, 30 Aug 2024 18:39:40 +0800
Subject: [PATCH] 1
---
websocketSerivce/src/main/java/org/example/task/MexcStock.java | 31 ++++++++++++++++++++++++++++---
1 files changed, 28 insertions(+), 3 deletions(-)
diff --git a/websocketSerivce/src/main/java/org/example/task/MexcStock.java b/websocketSerivce/src/main/java/org/example/task/MexcStock.java
index b03b5e6..d431451 100644
--- a/websocketSerivce/src/main/java/org/example/task/MexcStock.java
+++ b/websocketSerivce/src/main/java/org/example/task/MexcStock.java
@@ -11,9 +11,11 @@
import org.example.common.MexcMarketDataClient;
import org.example.pojo.Currency;
import org.example.pojo.ExchangeInfo;
+import org.example.pojo.bo.CurrencyKucoin;
import org.example.pojo.bo.CurrencyMexcBo;
import org.example.server.impl.CurrencySerivceImpl;
import org.example.util.ConverterUtil;
+import org.example.util.RedisUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.scheduling.annotation.Scheduled;
import org.springframework.stereotype.Component;
@@ -40,7 +42,7 @@
/**
* 同步mexc交易所交易对
*/
- @Scheduled(cron = "0 0/30 * * * ?")
+ @Scheduled(cron = "0 0/45 * * * ?")
// @Scheduled(cron = "0/10 * * * * ?")
public void syncCurrency() {
// 使用Lock来确保同步
@@ -75,8 +77,31 @@
List<CurrencyMexcBo> getList = gson.fromJson(symbolsJson, new TypeToken<List<CurrencyMexcBo>>() {
}.getType());
- currencyService.remove(new LambdaQueryWrapper<Currency>().eq(Currency::getSource,"mexc"));
- List<Currency> currencies = ConverterUtil.convertToList(getList, Currency.class);
+ // 获取数据库中已有的symbol列表
+ List<Currency> dbList = currencyService.list(new LambdaQueryWrapper<Currency>().eq(Currency::getSource, "mexc"));
+
+ // 删除已经下架的币种
+ Set<String> symbolSet = getList.stream().map(CurrencyMexcBo::getSymbol).collect(Collectors.toSet());
+ List<Currency> removeList = dbList.stream()
+ .filter(currency -> !symbolSet.contains(currency.getSymbol()))
+ .collect(Collectors.toList());
+
+ if(CollectionUtils.isNotEmpty(removeList)){
+ removeList.forEach(f->{
+ RedisUtil.delete("mexc"+f.getSymbol());
+ currencyService.remove(new LambdaQueryWrapper<Currency>().eq(Currency::getSymbol,f.getSymbol()));
+ });
+ }
+
+
+
+
+ // 比对接口返回的数据和数据库中已有的数据，找出新增的数据
+ Set<String> loclSymbolSet = dbList.stream().map(Currency::getSymbol).collect(Collectors.toSet());
+ List<CurrencyMexcBo> saveList = getList.stream()
+ .filter(CurrencyMexcBo -> !loclSymbolSet.contains(CurrencyMexcBo.getSymbol()))
+ .collect(Collectors.toList());
+ List<Currency> currencies = ConverterUtil.convertToList(saveList, Currency.class);
// 批量保存新增数据到数据库
if(CollectionUtils.isNotEmpty(currencies)){
currencyService.saveBatch(currencies);
--
Gitblit v1.9.3