Mark Avreliy's questions

我有一个 JSON：

[
  {
    "datetime": "2025-04-07T18:03:50+03:00",
    "title": "Theme Drive",
    "content": {
      "adPlacement": {
        "id": 4289485,
        "name": "otclick_OLV_apart_jan_mar_In_stream",
        "banners": {
          "href": [
            "https://api.adriver.ru/banners/12037384",
            "https://api.adriver.ru/banners/12043208",
            "https://api.adriver.ru/banners/11887226",
            "https://api.adriver.ru/banners/12028437"
          ]
        }
      }
    }
  }
]

我想构建下面的 json：将数组中的元素分成具有属性的对象banner_id，然后将数字存储为值banners/

我期望这个输出：

[
  {
    "banner_id": 12037384
  },
  {
    "banner_id": 12043208
  },
  {
    "banner_id": 11887226
  },
  {
    "banner_id": 12028437
  }
]

我写：

[
  {
    "operation": "shift",
    "spec": {
      "*": {
        "content": {
          "adPlacement": {
            "banners": {
              "href": {
                "*": "[&]"
              }
            }
          }
        }
      }
    }
  }
]

我刚刚得到了一个数组（与预期不符），而且我在处理 Banner_id 时遇到了麻烦。对于拆分，我尝试了类似这样的方法："banner_id": "=split('banners/', @(1,&))"，但它抛出了错误。如何达到预期的输出？

更新

第二种情况，里面有一个对象href：

[
   {
      "datetime":"2025-04-07T18:03:50+03:00",
      "title":"Theme Drive",
      "content":{
         "adPlacement":{
            "id":4289485,
            "name":"otclick_OLV_apart_jan_mar_In_stream",
            "banners":{
               "href":"https://api.adriver.ru/banners/12037384"
            }
         }
      }
   }
]

预期的：

[
  {
    "banner_id": 12037384
  }
]

我的结果：

[
  {
    "operation": "shift",
    "spec": {
      "*": {
        "content": {
          "adPlacement": {
            "banners": {
              "href": {
                "*": {
                  "*banners/*": {
                    "$(0,2)": "[&2].banner_id"
                  }
                },
                "*banners/*": {
                  "$(0,2)": "[0].banner_id"
                }
              }
            }
          }
        }
      }
    }
  },
  {
    "operation": "modify-overwrite-beta",
    "spec": {
      "*": {
        "banner_id": "=toInteger"
      }
    }
  }
]

源 JSON：

[
  {
    "dimensions": [
      {
        "id": "1546382552",
        "name": "BLOOM FACE MASK DAY SPA AM APOTHEKA"
      },
      {
        "id": "2024-12-01",
        "name": ""
      }
    ],
    "metrics": [
      364,
      20
    ]
  },
  {
    "dimensions": [
      {
        "id": "857640546",
        "name": "Vitamin A"
      },
      {
        "id": "2024-12-02",
        "name": ""
      }
    ],
    "metrics": [
      310,
      22
    ]
  }
]

来自维度数组：

1. id从第一个对象开始应该写为字段sku，并name写为sku_name
2. id来自第二个对象应该写为字段date“

来自指标数组：

• 数组中第一个元素应写为session_view，第二个元素应写为session_view_search

我尝试过（但失败了）：

[
  {
    "operation": "shift",
    "spec": {
      "*": {
        "dimensions": {
          "*": {
            "0": {
              "id": "[&2].sku",
              "name": "[&2].sku_name"
            },
            "1": {
              "id": "[&2].date"
            }
          }
        },
        "metrics": {
          "0": "session_view",
          "1": "session_view_search"
        }
      }
    }
  }
]

最后我期望：

[
  {
    "sku": 1546382552,
    "sku_name": "BLOOM FACE MASK DAY SPA AM APOTHEKA",
    "date": "2024-12-01",
    "session_view": 364,
    "session_view_search": 20
  },
  {
    "sku": 857640546,
    "sku_name": "Vitamin A",
    "date": "2024-12-02",
    "session_view": 310,
    "session_view_search": 22
  }
]

我有一个抽象类：

@Entity
@Table(name = "cas_base_accounts", schema = "connectors_account_service")
@Inheritance(strategy = InheritanceType.JOINED)
@Data
@SuperBuilder
@NoArgsConstructor
public abstract class BaseAccount {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(unique = true)
    private Integer id;
//some fields here

还有两个子类：

@Entity
@Table(name = "cas_simple_auth_accounts", schema = "connectors_account_service")
@Inheritance(strategy = InheritanceType.JOINED)
@Data
@ToString(callSuper = true)
@EqualsAndHashCode(callSuper = true)
@NoArgsConstructor
@SuperBuilder
public class SimpleAuthAccount extends BaseAccount {


    @Id
    @GeneratedValue
    private Integer id;

    @NotNull
    @JsonIgnore
    private String clientId;

    @NotNull
    @JsonIgnore
    private String clientSecret;
//some other fields

和：

@Entity
@Table(name = "cas_oauth_accounts", schema = "connectors_account_service")
@Inheritance(strategy = InheritanceType.JOINED)
@Data
@ToString(callSuper = true)
@EqualsAndHashCode(callSuper = true)
@NoArgsConstructor
@SuperBuilder
public class OAuthAccount extends BaseAccount {

    @Id
    @GeneratedValue
    private Integer id;

    @JsonIgnore
    private String state;

    @JsonIgnore
    private LocalDateTime stateExpirationTime;

    @Transient
    private String tokenLink;
//some fields

当我运行简单的 GET 请求时http://localhost:8889/accountservice/accountIds?cabinetId=12收到错误：

threw exception [Request processing failed; nested exception is org.springframework.orm.jpa.JpaSystemException: Cannot instantiate abstract class or interface:  : 
test.connectorsaccountservice.accountservice.model.BaseAccount; nested exception is org.hibernate.InstantiationException: Cannot instantiate abstract class or interface:  : test.connectorsaccountservice.accountservice.model.BaseAccount] 

cabinetId = 12 的实体始终是 SimpleAuthAccount。例如，当我运行 cabinetId = 10 时，它返回正确的结果。在这种情况下，id != 12（和 21）的实体是 OauthAccount。

说明这个方法出错了：

    public Mono<List<Integer>> getAccountIds(Integer cabinetId) {
        return findServiceByCabinetId(cabinetId)
                .then(Mono.fromCallable(() -> baseAccountRepository.findByCabinetId(cabinetId)))
                .flatMapIterable(e -> e)
                .filter(oAuthAccount -> !oAuthAccount.getIsDeleted()
                        && UserStatus.ENABLED.equals(oAuthAccount.getUserStatus()))
                .map(BaseAccount::getId)
                .collectList();
    }

在这一行：

.then(Mono.fromCallable(() -> baseAccountRepository.findByCabinetId(cabinetId)))

存储库：

public interface BaseAccountRepository extends JpaRepository<BaseAccount, Integer> {

    Optional<BaseAccount> findByIdAndCabinetId(Integer accountId, Integer cabinetId);

    Optional<BaseAccount> findByCabinetIdAndAccountLogin(Integer cabinetId, String accountLogin);

    List<BaseAccount> findByCabinetId(Integer cabinetId);

简单身份验证帐户存储库：

@Repository
public interface SimpleAuthAccountRepository extends
        JpaRepository<SimpleAuthAccount, Integer>,
        CustomAccountRepository<SimpleAuthAccount, Integer> {

    @Query("SELECT a FROM SimpleAuthAccount a " +
           "JOIN BaseCabinet c ON a.cabinetId = c.id " +
           "WHERE " +
           "(:realmId IS NULL OR a.realmId = :realmId) AND " +
           "(:accountLogin IS NULL OR a.accountLogin = :accountLogin) AND " +
           "(:accountId IS NULL OR a.id = :accountId) AND " +
           "(:cabinetId IS NULL OR a.cabinetId = :cabinetId) AND " +
           "(:isDeleted IS NULL OR a.isDeleted = :isDeleted) AND " +
           "((:advertiserIds) IS NULL OR a.advertiserId IN (:advertiserIds)) " +
           "ORDER BY c.description, a.accountLogin")
    List<SimpleAuthAccount> findAccounts(
            @Param("realmId") Integer realmId,
            @Param("accountLogin") String accountLogin,
            @Param("accountId") Integer accountId,
            @Param("cabinetId") Integer cabinetId,
            @Param("isDeleted") Boolean isDeleted,
            @Param("advertiserIds") Set<Integer> advertiserIds
    );

}

顺便说一句，之前好像可以，但我做了一些更改。发生此错误后，我恢复了所有更改，但错误仍然发生。在这些更改中，我没有触及本文中的任何类，只触及了其他类。

如何修复它？为什么会发生这种情况，为什么在恢复更改后仍然会发生这种情况？我想添加@DiscriminatorColumn和@DiscriminatorValue会有所帮助？对我来说，现有的列cabinetId就很好了@DiscriminatorColumn，但如果我有一个 SimpleAuthAccount 的 id 数组和 OAuthAccount 的 id 数组，我该如何为其设置值？我真的不想在这个表中添加另一列。但当然，如果这里没有更多的解决方案，我可以添加像auth_type和设置SIMPLE_AUTH这些OAUTH类的列。

源 JSON：

{
  "data": {
    "campaign": {
      "104": {
        "day": {
          "2024-07-01": {
            "metrics": {
              "reach_impression": "6.0000000",
              "unique_impression": 6,
              "impression": 9
            }
          },
          "2024-07-03": {
            "metrics": {
              "reach_impression": "19.0000000",
              "unique_click": 1,
              "reach_click": "2.0000000"
            }
          }
        }
      },
      "106": {
        "day": {
          "2024-07-01": {
            "metrics": {
              "unique_click": 29,
              "reach_click": "29.0000000",
              "click": 35
            }
          }
        }
      },
      "124": {
        "day": {
          "2024-07-01": {
            "metrics": {
              "unique_impression": 472,
              "event": 1,
              "unique_click": 25,
              "click": 49,
              "progress_100": 1,
              "impression": 690
            }
          },
          "2024-07-03": {
            "metrics": {
              "unique_click": 14,
              "reach_click": "52.0000000",
              "click": 33,
              "unique_impression": 28,
              "impression": 32
            }
          }
        }
      }
    },
    "metrics": {
      "click_average": 22107.6666666667
    }
  },
  "metadata": {
    "campaign": {
      "104": {
        "channel_id": 1,
        "real_end_date": null,
        "channel_label": "Display",
        "real_start_date": "2024-01-11 21:32:25",
        "label": "5ka_Promo_veer_2024"
      },
      "124": {
        "channel_id": 1,
        "real_end_date": null,
        "channel_label": "Display",
        "real_start_date": "2024-06-04 21:34:23",
        "label": " X5Club_Evergreen_June24"
      }
    }
  }
}

下面data.campaign有一些数字，如 124、104、106。这些数字是活动的 ID。我需要将这些值存储在字段中id，然后我们有字段day，并且在这个字段中2024-07-01，我想将这些值存储为report_date字段。在这个级别下，我们有metrics对象。在这个对象中，我想获取所有键值对。

对我来说主要的问题是如何以正确的方式将数字存储为键。

预期 JSON：

[
  {
    "id": 124,
    "report_date": "2024-07-01",
    "unique_impression": 472,
    "event": 1,
    "unique_click": 25,
    "click": 49,
    "progress_100": 1,
    "impression": 690
  },
  {
    "id": 124,
    "report_date": "2024-07-03",
    "unique_click": 14,
    "reach_click": "52.0000000",
    "click": 33,
    "unique_impression": 28,
    "impression": 32
  },
  {
    "id": 104,
    "report_date": "2024-07-01",
    "reach_impression": "6.0000000",
    "unique_impression": 6,
    "impression": 9
  },
  {
    "id": 104,
    "report_date": "2024-07-03",
    "reach_impression": "19.0000000",
    "unique_click": 1,
    "reach_click": "2.0000000"
  },
  {
    "id": 106,
    "report_date": "2024-07-01",
    "unique_click": 29,
    "reach_click": "29.0000000",
    "click": 35
  }
]

我有一张包含一些列的表。不幸的是，它不是以最佳方式设计的，写入此表的 REST API 也设计得不好，但我需要一些快速的解决方案。在列dimension_id（text数据类型）中，我有以下值：90％ 的行包含date类似2024-01-01，但其他行包含类似9391或 的字符串78417。我现在不想删除这些行（大量数据，大项目，理解和重写需要很长时间，也许它是一个有效值但需要其他列），但我需要过滤它们，因为当您尝试转换和过滤此列时，在此表上创建的视图会下降。

所以我需要抓住所有dimension_id包含date模式的行。

我尝试过

select * from table
where TO_DATE(dimension_id, 'YYYY-MM-DD') IS NOT NULL

但这没用。该怎么办？