xml复制代码<dependency>
  <groupId>com.github.rrsunhome</groupId>
  <artifactId>excelsql-generate</artifactId>
  <version>2.0.2</version>
</dependency>

arduino复制代码implementation 'com.github.rrsunhome:excelsql-generate:2.0.2'

java复制代码    Resource resource = new ClassPathResource("order.txt");

        TextParserConfig parserConfig = new TextParserConfig("\t");
        parserConfig.setRowRange(0,20);
        SqlFormatConfig sqlFormatConfig = new SqlFormatConfig("insert into table(a,b,c) values({0},{1},{2});")
                .setString(0, 0)
                .setString(1, 1)
                .setInt(2, 2);
        SqlGenerator csvSqlGenerator = new DefaultSqlGenerator(resource,
                parserConfig, sqlFormatConfig);
        ResultSet resultSet = csvSqlGenerator.execute();
        resultSet.outputView();

java复制代码      Resource resource = new ClassPathResource("order-v1.xlsx");

        ExcelParserConfig parserConfig = new ExcelParserConfig();
        String sql = "insert into table(a,b,c) values({0},{1},{2});";
        SqlFormatConfig sqlFormatConfig = new SqlFormatConfig(sql)
                .setString(0, 1)
                .setString(1, 0)
                .setInt(2, 2);

        SqlGenerator csvSqlGenerator = new DefaultSqlGenerator(resource, parserConfig, sqlFormatConfig);
        ResultSet resultSet = csvSqlGenerator.execute();
        resultSet.outputView();

java复制代码        Resource resource = new ClassPathResource("order.csv");
        ExcelParserConfig parserConfig = new ExcelParserConfig();
        parserConfig.setSheetIndex(0);
        SqlFormatConfig sqlFormatConfig = new SqlFormatConfig("insert into table(a,b,c) values({0},{1},{2});")
                .setString(0, 1)
                .setString(1, 0)
                .setInt(2, 2);
        SqlGenerator csvSqlGenerator = new DefaultSqlGenerator(resource, parserConfig, sqlFormatConfig);
        ResultSet resultSet = csvSqlGenerator.execute();
        resultSet.outputView();

java复制代码        CsvParserConfig parserConfig = new CsvParserConfig();
        parserConfig.setTitleRowIndex(0);
        parserConfig.setRowRange(1, 30);
        parserConfig.addCellMapping(CellMapping.builder()
                .cellNum(1)
                .cellFilter(cellValue -> true)
                .cellConverter(Object::toString)
                .build());
        parserConfig.addCellMapping(CellMapping.builder()
                .cellNum(2)
                .cellFilter("21"::equals)
                .cellConverter(Object::toString)
                .build());
        parserConfig.addCellMapping(CellMapping.builder()
                .cellNum(0)
                .build());

java复制代码        SqlFormatConfig sqlFormatConfig = new SqlFormatConfig("insert into table(a,b,c) values({0},{1},{2});", new MessageFormatter())
                .setString(0, 1)
                .setString(1, 0)
                .setInt(2, 2);

go复制代码f:=createFile(path)
# 遍历 db
for db range redis.DB():
    # 遍历 key
    for key range db:
        # 跳过过期 key
        if key.isExpired():
            continue
        # 压缩 key
        f.write(compressCmd(key))
        # 设置超时时间
        if key.hasExpireTime():
            f.write(expiredCmd(key))
f.close()

java复制代码// K,V表示泛型,编译的时候不知道具体的类型,实例化的时候需要指定具体的类型
public genericClass<K,V> xxxx

java复制代码// K,V表示泛型,编译的时候不知道具体的类型,实现接口的时候需要指定
public interface genericInterface<K> xxx

java复制代码//  K,V表示泛型,编译的时候不知道具体的类型,调用方法的时候需要指定具体的类型
public <T> void genericMethod(T,V)

java复制代码List<Apple> list1 = new ArrayList<>();
List<Fruit> list2 = new ArrayList<>();
// 结果是true
System.out.println(list1.getClass() == list2.getClass());

java复制代码public class ArrayList<T> extends AbstractList<T>{}

java复制代码List<?> list = new ArrayList<Integer>();

js复制代码@Data
@ApiModel("商品信息")
public class Goods {

    private String skuCode;

    private BigDecimal price;

    private int num;

    private BigDecimal discount;

    private BigDecimal taxes;

    private BigDecimal firstFreight;

    private BigDecimal secondFreight;

}

js复制代码public interface TradeTypeStrategy {

    BigDecimal getGoodsTotalPrice(Goods goods);
}

js复制代码public class TradeType {

    private TradeTypeStrategy tradeTypeStrategy;

    public TradeType(TradeTypeStrategy tradeTypeStrategy){
        this.tradeTypeStrategy = tradeTypeStrategy;
    }

    public BigDecimal executeStrategy(Goods goods){
        return tradeTypeStrategy.getGoodsTotalPrice(goods);
    }
}

js复制代码public class TradeTypeStrategyA implements TradeTypeStrategy {

    /**
     *
     *
     * */
    @Override
    public BigDecimal getGoodsTotalPrice(Goods goods) {
        BigDecimal goodsTotalPrice = goods.getPrice().multiply(BigDecimal.valueOf(goods.getNum())).subtract(goods.getDiscount());
        return goodsTotalPrice;
    }
}

js复制代码public class TradeTypeStrategyB implements TradeTypeStrategy {

    @Override
    public BigDecimal getGoodsTotalPrice(Goods goods) {
        BigDecimal goodsTotalPrice = goods.getPrice().multiply(BigDecimal.valueOf(goods.getNum()))
                .subtract(goods.getDiscount()).add(goods.getFirstFreight());
        return goodsTotalPrice;
    }

js复制代码public class TradeTypeStrategyC implements TradeTypeStrategy {
   
    @Override
    public BigDecimal getGoodsTotalPrice(Goods goods) {
        BigDecimal goodsTotalPrice = goods.getPrice().multiply(BigDecimal.valueOf(goods.getNum()))
                .subtract(goods.getDiscount()).add(goods.getFirstFreight()).add(goods.getTaxes());
        return goodsTotalPrice;
    }
}

js复制代码public class TradeTypeStrategyD implements TradeTypeStrategy {

    @Override
    public BigDecimal getGoodsTotalPrice(Goods goods) {
        BigDecimal goodsTotalPrice = goods.getPrice().multiply(BigDecimal.valueOf(goods.getNum()))
                .subtract(goods.getDiscount()).add(goods.getFirstFreight()).add(goods.getSecondFreight()).add(goods.getTaxes());
        return goodsTotalPrice;
    }
}

js复制代码public class MainTrade {
    public static void main(String[] args) {
        Goods goods = new Goods();
        goods.setSkuCode("G888888");
        goods.setPrice(BigDecimal.valueOf(100));
        goods.setFirstFreight(BigDecimal.valueOf(20));
        goods.setNum(3);
        goods.setSecondFreight(BigDecimal.valueOf(8));
        goods.setDiscount(BigDecimal.TEN);
        goods.setTaxes(BigDecimal.valueOf(32));
        TradeType tradeTypeA = new TradeType(new TradeTypeStrategyA());
        System.out.println("贸易方式A的总价是 = " + tradeTypeA.executeStrategy(goods));
        TradeType tradeTypeB = new TradeType(new TradeTypeStrategyB());
        System.out.println("贸易方式B的总价是 = " + tradeTypeB.executeStrategy(goods));
        TradeType tradeTypeC = new TradeType(new TradeTypeStrategyC());
        System.out.println("贸易方式C的总价是 = " + tradeTypeC.executeStrategy(goods));
        TradeType tradeTypeD = new TradeType(new TradeTypeStrategyD());
        System.out.println("贸易方式D的总价是 = " + tradeTypeD.executeStrategy(goods));
    }
}

sql复制代码create table user (
id int primary key,
name varchar(20),
sex varchar(5),
index(name)
)engine=innodb;

sql复制代码select id,name from user where name='ls';

sql复制代码select id,name,sex from user where name='ls';

sql复制代码ALTER TABLE Testtable
ADD INDEX 
idx_func_register_date((DATE_FORMAT(register_date,'%Y-%m')));

sql复制代码CREATE TABLE User (
    userId BIGINT,
    userInfo JSON,
    mobile VARCHAR(255) AS (userInfo->>"$.mobile"),
    PRIMARY KEY(userId),
    UNIQUE KEY idx_mobile(mobile)
);

sql复制代码-- 不用虚拟列
SELECT  *  FROM User
WHERE userInfo->>"$.mobile" = '15088888888'

-- 使用虚拟列
SELECT  *  FROM User 
WHERE mobile = '15088888888'

sql复制代码WHERE a = ?
WHERE a = ? AND b = ?
WHERE b = ? AND a = ?
WHERE a = ? ORDER BY b DESC

sql复制代码WHERE b = ?
WHERE b = ？ ORDER BY a DESC

java复制代码@RestControllerAdvice
//@ControllerAdvice
@Slf4j
public class AllExceptionHandler{


    @ExceptionHandler(value =CustomException.class)
    public R customExceptionHandle(Exception e){
        //这个地方应该去创建多个Exception类然后分类去捕获
        log.error("自定义异常: {}",e);
        return R.fail(e.getMessage());
    }
    
    @ExceptionHandler(value = org.springframework.validation.BindException.class)
    public R bindExceptionHandle(BindException ex){
        StringBuffer defaultMessage = new StringBuffer();
        List<ObjectError> list = ex.getBindingResult().getAllErrors();
        if(list!=null && list.size()>0){
            try {
                int i=0;
                for (ObjectError error : list) {
                    if(i>0){
                        defaultMessage.append(",");
                    }
                    defaultMessage.append(error.getDefaultMessage());
                    i++;
                }
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
        String s = defaultMessage.toString();
        log.warn("用户数据参数异常: {}",s);
        return R.fail(s);

    }
    
    @ExceptionHandler(value = Exception.class)
    public R exceptionHandle(Exception e){
        log.error("未知的异常{},{}",e.getMessage(),e);
        return R.fail("系统异常",e.getMessage());
    }

    public AllExceptionHandler() {
        super();
    }

typescript复制代码@RestController
@Slf4j
public class OtherExceptionHandler implements ErrorController {
    @Override
    public String getErrorPath() {
        return "/error";
    }

    @RequestMapping("/error")
    public R otherError(HttpServletRequest request, HttpServletResponse response) {

        //将所有的错误请求都处理成200 具体根据实际项目配置
        response.setStatus(200);

        Integer statusCode = (Integer)request.getAttribute("javax.servlet.error.status_code");
        String errorMsg = "出现错误";

        if (statusCode == null) {
            errorMsg = "服务器内部错误";
        }
        
        //转发过来的自定义CustomException异常
        if(statusCode==5001 && request.getAttribute("javax.servlet.error.exception") instanceof CustomException){
            log.warn("Filter异常:{}",((Exception)request.getAttribute("javax.servlet.error.exception")));
            return R.fail(((Exception)request.getAttribute("javax.servlet.error.exception")).getMessage());
        }

        try {
            return R.fail(errorMsg, statusCode, HttpStatus.valueOf(statusCode));
        } catch (Exception ex) {
            errorMsg = "服务器内部错误:" + statusCode;
        }
        log.error("服务器错误,错误码:{}",statusCode);
        return R.fail(errorMsg);
    }
}

vbscript复制代码@Component
public class ZdcFilter implements Filter {

    @Override
    public void doFilter(ServletRequest request, ServletResponse response, FilterChain chain) throws IOException, ServletException {


    if(false){
    //中断 抛出异常
    
    //第一种  手动转发到/error接口
    request.setAttribute("javax.servlet.error.status_code",5001);
    request.setAttribute("javax.servlet.error.status_msg","通过转发/error设置返回数据");
    request.getRequestDispatcher("/error").forward(request, response);
    return;
         
    //第二种 抛出异常,自动转到/error接口,http状态码500
     throw new CustomException("通过MyFilter,抛异常返回值");
      
    //第三种 直接写到response中返回
    response.setContentType("application/json; charset=utf-8");
    response.getWriter().print("通过MyFilter直接接调用response返回数据");
    response.getWriter().flush();
    response.getWriter().close();
    return;
    
     }else{
      //正常通过
      chain.doFilter(request,response);
     }

    }
}

arduino复制代码    作者：ZOUZDC
    链接：https://juejin.cn/post/7028963866063306760
    来源：稀土掘金
    著作权归作者所有。商业转载请联系作者获得授权，非商业转载请注明出处。

kotlin复制代码//一定必须是实现ReactorServiceInstanceLoadBalancer
//而不是ReactorLoadBalancer<ServiceInstance>
//因为注册的时候是ReactorServiceInstanceLoadBalancer
@Log4j2
public class RoundRobinWithRequestSeparatedPositionLoadBalancer implements ReactorServiceInstanceLoadBalancer {
    private final ServiceInstanceListSupplier serviceInstanceListSupplier;
    //每次请求算上重试不会超过1分钟
    //对于超过1分钟的，这种请求肯定比较重，不应该重试
    private final LoadingCache<Long, AtomicInteger> positionCache = Caffeine.newBuilder().expireAfterWrite(1, TimeUnit.MINUTES)
            //随机初始值，防止每次都是从第一个开始调用
            .build(k -> new AtomicInteger(ThreadLocalRandom.current().nextInt(0, 1000)));
    private final String serviceId;
    private final Tracer tracer;


    public RoundRobinWithRequestSeparatedPositionLoadBalancer(ServiceInstanceListSupplier serviceInstanceListSupplier, String serviceId, Tracer tracer) {
        this.serviceInstanceListSupplier = serviceInstanceListSupplier;
        this.serviceId = serviceId;
        this.tracer = tracer;
    }
    
    //每次重试，其实都会调用这个 choose 方法重新获取一个实例
    @Override
    public Mono<Response<ServiceInstance>> choose(Request request) {
        return serviceInstanceListSupplier.get().next().map(serviceInstances -> getInstanceResponse(serviceInstances));
    }

    private Response<ServiceInstance> getInstanceResponse(List<ServiceInstance> serviceInstances) {
        if (serviceInstances.isEmpty()) {
            log.warn("No servers available for service: " + this.serviceId);
            return new EmptyResponse();
        }
        return getInstanceResponseByRoundRobin(serviceInstances);
    }

    private Response<ServiceInstance> getInstanceResponseByRoundRobin(List<ServiceInstance> serviceInstances) {
        if (serviceInstances.isEmpty()) {
            log.warn("No servers available for service: " + this.serviceId);
            return new EmptyResponse();
        }
        //为了解决原始算法不同调用并发可能导致一个请求重试相同的实例
        //从 sleuth 的 Tracer 中获取当前请求的上下文
        Span currentSpan = tracer.currentSpan();
        //如果上下文不存在，则可能不是前端用户请求，而是其他某些机制触发，我们就创建一个新的上下文
        if (currentSpan == null) {
            currentSpan = tracer.newTrace();
        }
        //从请求上下文中获取请求的 traceId，用来唯一标识一个请求
        long l = currentSpan.context().traceId();
        AtomicInteger seed = positionCache.get(l);
        int s = seed.getAndIncrement();
        int pos = s % serviceInstances.size();
        log.info("position {}, seed: {}, instances count: {}", pos, s, serviceInstances.size());
        return new DefaultResponse(serviceInstances.stream()
                //实例返回列表顺序可能不同，为了保持一致，先排序再取
                .sorted(Comparator.comparing(ServiceInstance::getInstanceId))
                .collect(Collectors.toList()).get(pos));
    }
}

xml复制代码<dependency>
    <groupId>io.dropwizard.metrics</groupId>
    <artifactId>metrics-core</artifactId>
</dependency>

java复制代码@Log4j2
public class ServiceInstanceMetrics {
	private static final String CALLING = "-Calling";
	private static final String FAILED = "-Failed";

	private MetricRegistry metricRegistry;

	ServiceInstanceMetrics() {
	}

	public ServiceInstanceMetrics(MetricRegistry metricRegistry) {
		this.metricRegistry = metricRegistry;
	}

	/**
	 * 记录调用实例
	 * @param serviceInstance
	 */
	public void recordServiceInstanceCall(ServiceInstance serviceInstance) {
		String key = serviceInstance.getHost() + ":" + serviceInstance.getPort();
		metricRegistry.counter(key + CALLING).inc();
	}
	/**
	 * 记录调用实例结束
	 * @param serviceInstance
	 * @param isSuccess 是否成功
	 */
	public void recordServiceInstanceCalled(ServiceInstance serviceInstance, boolean isSuccess) {
		String key = serviceInstance.getHost() + ":" + serviceInstance.getPort();
		metricRegistry.counter(key + CALLING).dec();
		if (!isSuccess) {
			//不成功则记录失败
			metricRegistry.meter(key + FAILED).mark();
		}
	}

	/**
	 * 获取正在运行的调用次数
	 * @param serviceInstance
	 * @return
	 */
	public long getCalling(ServiceInstance serviceInstance) {
		String key = serviceInstance.getHost() + ":" + serviceInstance.getPort();
		long count = metricRegistry.counter(key + CALLING).getCount();
		log.debug("ServiceInstanceMetrics-getCalling: {} -> {}", key, count);
		return count;
	}

	/**
	 * 获取最近一分钟调用失败次数分钟速率，其实是滑动平均数
	 * @param serviceInstance
	 * @return
	 */
	public double getFailedInRecentOneMin(ServiceInstance serviceInstance) {
		String key = serviceInstance.getHost() + ":" + serviceInstance.getPort();
		double rate = metricRegistry.meter(key + FAILED).getOneMinuteRate();
		log.debug("ServiceInstanceMetrics-getFailedInRecentOneMin: {} -> {}", key, rate);
		return rate;
	}
}

kotlin复制代码private final LoadingCache<Long, Set<String>> calledIpPrefixes = Caffeine.newBuilder()
        .expireAfterAccess(3, TimeUnit.MINUTES)
        .build(k -> Sets.newConcurrentHashSet());
private final String serviceId;
private final Tracer tracer;
private final ServiceInstanceMetrics serviceInstanceMetrics;

//每次重试，其实都会调用这个 choose 方法重新获取一个实例
@Override
public Mono<Response<ServiceInstance>> choose(Request request) {
    Span span = tracer.currentSpan();
    return serviceInstanceListSupplier.get().next()
            .map(serviceInstances -> {
                //保持 span 和调用 choose 的 span 一样
                try (Tracer.SpanInScope cleared = tracer.withSpanInScope(span)) {
                    return getInstanceResponse(serviceInstances);
                }
            });
}


private Response<ServiceInstance> getInstanceResponse(List<ServiceInstance> serviceInstances) {
    if (serviceInstances.isEmpty()) {
        log.warn("No servers available for service: " + this.serviceId);
        return new EmptyResponse();
    }
    //读取 spring-cloud-sleuth 的对于当前请求的链路追踪上下文，获取对应的 traceId
    Span currentSpan = tracer.currentSpan();
    if (currentSpan == null) {
        currentSpan = tracer.newTrace();
    }
    long l = currentSpan.context().traceId();
    return getInstanceResponseByRoundRobin(l, serviceInstances);
}

@VisibleForTesting
public Response<ServiceInstance> getInstanceResponseByRoundRobin(long traceId, List<ServiceInstance> serviceInstances) {
    //首先随机打乱列表中实例的顺序
    Collections.shuffle(serviceInstances);
    //需要先将所有参数缓存起来，否则 comparator 会调用多次，并且可能在排序过程中参数发生改变（针对实例的请求统计数据一直在并发改变）
    Map<ServiceInstance, Integer> used = Maps.newHashMap();
    Map<ServiceInstance, Long> callings = Maps.newHashMap();
    Map<ServiceInstance, Double> failedInRecentOneMin = Maps.newHashMap();
    serviceInstances = serviceInstances.stream().sorted(
            Comparator
                    //之前已经调用过的网段，这里排后面
                    .<ServiceInstance>comparingInt(serviceInstance -> {
                        return used.computeIfAbsent(serviceInstance, k -> {
                            return calledIpPrefixes.get(traceId).stream().anyMatch(prefix -> {
                                return serviceInstance.getHost().contains(prefix);
                            }) ? 1 : 0;
                        });
                    })
                    //当前错误率最少的
                    .thenComparingDouble(serviceInstance -> {
                        return failedInRecentOneMin.computeIfAbsent(serviceInstance, k -> {
                            double value = serviceInstanceMetrics.getFailedInRecentOneMin(serviceInstance);
                            //由于使用的是移动平均值（EMA），需要忽略过小的差异（保留两位小数，不是四舍五入，而是直接舍弃）
                            return ((int) (value * 100)) / 100.0;
                        });
                    })
                    //当前负载请求最少的
                    .thenComparingLong(serviceInstance -> {
                        return callings.computeIfAbsent(serviceInstance, k ->
                                serviceInstanceMetrics.getCalling(serviceInstance)
                        );
                    })
    ).collect(Collectors.toList());
    if (serviceInstances.isEmpty()) {
        log.warn("No servers available for service: " + this.serviceId);
        return new EmptyResponse();
    }
    ServiceInstance serviceInstance = serviceInstances.get(0);
    //记录本次返回的网段
    calledIpPrefixes.get(traceId).add(serviceInstance.getHost().substring(0, serviceInstance.getHost().lastIndexOf(".")));
    //目前记录这个只为了兼容之前的单元测试（调用次数测试）
    positionCache.get(traceId).getAndIncrement();
    return new DefaultResponse(serviceInstance);
}

php复制代码<?php

namespace App\Admin\Controllers;

.
.
.

class HobbyInfoController extends AdminController
{
    /**
     * Title for current resource.
     *
     * @var string
     */
    protected $title = '用户爱好-一级分类';

    /**
     * Make a grid builder.
     *
     * @return Grid
     */
    protected function grid()
    {
        $grid = new Grid(new HobbyInfo());

        $grid->sortable();
        .
        .
        .

        return $grid;
    }

    /**
     * Make a show builder.
     *
     * @param mixed $id
     * @return Show
     */
    protected function detail($id)
    {
        $show = new Show(HobbyInfo::findOrFail($id));
        return $show;
    }

    /**
     * Make a form builder.
     *
     * @return Form
     */
    protected function form()
    {
        $form = new Form(new HobbyInfo());
        
        .
        .
        .

        //清空缓存
        $form->saved(function () {
            HobbyInfo::flushCache();
        });
        return $form;
    }
}

php复制代码<?php

namespace Encore\Admin\GridSortable\Controllers;

use Exception;
use Illuminate\Http\Request;
use Illuminate\Routing\Controller;

class GridSortableController extends Controller
{
    public function sort(Request $request)
    {
        $sorts = $request->get('_sort');

        $sorts = collect($sorts)
            ->pluck('key')
            ->combine(
                collect($sorts)->pluck('sort')->sort()
            );

        $status = true;
        $message = trans('admin.save_succeeded');
        $modelClass = $request->get('_model');

        try {
            /** @var \Illuminate\Database\Eloquent\Collection $models */
            $models = $modelClass::find($sorts->keys());

            foreach ($models as $model) {

                $column = data_get($model->sortable, 'order_column_name', 'order_column');

                $model->{$column} = $sorts->get($model->getKey());
                $model->save();
            }
        } catch (Exception $exception) {
            $status = false;
            $message = $exception->getMessage();
        }

        return response()->json(compact('status', 'message'));
    }
}

php复制代码<?php

namespace Encore\Admin\GridSortable\Controllers;

use Exception;
use Illuminate\Http\Request;
use Illuminate\Routing\Controller;

class GridSortableController extends Controller
{
    public function sort(Request $request)
    {
        $sorts = $request->get('_sort');

        $sorts = collect($sorts)
            ->pluck('key')
            ->combine(
                collect($sorts)->pluck('sort')->sort()
            );

        $status = true;
        $message = trans('admin.save_succeeded');
        $modelClass = $request->get('_model');

        try {
            /** @var \Illuminate\Database\Eloquent\Collection $models */
            $models = $modelClass::find($sorts->keys());

            foreach ($models as $model) {

                $column = data_get($model->sortable, 'order_column_name', 'order_column');

                $model->{$column} = $sorts->get($model->getKey());
                $model->save();
            }
            //自定义回调
            if (method_exists($model, 'afterSort')) {
                $model->afterSort();
            }
        } catch (Exception $exception) {
            $status = false;
            $message = $exception->getMessage();
        }

        return response()->json(compact('status', 'message'));
    }
}

php复制代码<?php

namespace App\Model;

use App\Model\Cache\CacheKey;
use Illuminate\Support\Facades\Cache;
use Illuminate\Support\Facades\Log;
use Spatie\EloquentSortable\Sortable;
use Spatie\EloquentSortable\SortableTrait;

class HobbyInfo extends CustomModel implements Sortable
{
    protected $table = 'tbl_hobby_info';
    protected $connection = 'footprint';

    protected $primaryKey = 'id';
    public $incrementing = true;


    use SortableTrait;

    public $sortable = [
        'order_column_name' => 'sort',
        'sort_when_creating' => true,
    ];

    //改了源码 添加了自定义回调
    public static function afterSort()
    {
        self::flushCache();
    }

    //清空缓存
    public static function flushCache()
    {
        $cacheKey = CacheKey::getCacheKey(CacheKey::TYPE_USER_SETTING_HOBBY_ALL);
        Cache::forget($cacheKey);
        Log::info('清空Hobby缓存');
    }
}