多租戶3.3.1.tmp刪除數(shù)據(jù)沒有作用
代碼運(yùn)行的結(jié)果：
配置文件代碼：
@Bean
public?PaginationInterceptor?paginationInterceptor()?{
????PaginationInterceptor?paginationInterceptor?=?new?PaginationInterceptor();
????List<ISqlParser>?sqlParserList?=?new?ArrayList<>();
????TenantSqlParser?tenantSqlParser?=?new?TenantSqlParser();
????tenantSqlParser.setTenantHandler(new?TenantHandler()?{
????????@Override
????????public?Expression?getTenantId(boolean?where)?{
????????????return?new?LongValue(1088248166370832385L);
????????}
????????@Override
????????public?String?getTenantIdColumn()?{
????????????return?"manager_id";
????????}
????????@Override
????????public?boolean?doTableFilter(String?tableName)?{
????????????return?"user".equals(tableName);
????????}
????});
????sqlParserList.add(tenantSqlParser);
????paginationInterceptor.setSqlParserList(sqlParserList);
????return?paginationInterceptor;
}
2020-02-08
同學(xué)，這樣寫，不好使是必然的。
因?yàn)槟愕膁oTableFilter方法中，把user表給過濾掉了，你寫的邏輯是，如果表名等于user，則不增加租戶條件。
這個(gè)方法返回false的才會(huì)增加租戶條件。
????????@Override???????? ????????public?boolean?doTableFilter(String?tableName)?{??????????? ????????????return?"user".equals(tableName);???????? ????????}