我正在尝试使用Java API在DynamoDB中创建表。
问题:它只在表中创建哈希键索引,而不创建其他属性。
private void createTable(DynamoDBMapper mapper, AmazonDynamoDBClient amazonDynamoDBClient) {
CreateTableRequest createTableRequest = mapper.generateCreateTableRequest(InsuranceData.class);
createTableRequest.setProvisionedThroughput(new ProvisionedThroughput(25L, 25L));
amazonDynamoDBClient.createTable(createTableRequest);
}
private void run(){
AmazonDynamoDBClient amazonDynamoDBClient = getDynamoDBLocalClient();
DynamoDBMapper mapper = new DynamoDBMapper(amazonDynamoDBClient);
InsuranceData insuranceData = new InsuranceData();
createTable(mapper,amazonDynamoDBClient);
}
POJO class
@DynamoDBTable(tableName = "InsuranceData")
public class InsuranceData {
private Integer siteId;
private String lob;
private InsuranceLobData multiItemLobData;
private InsuranceLobData standaloneLobData;
@DynamoDBHashKey(attributeName = "siteId")
public Integer getSiteId() {
return siteId;
}
public void setSiteId(Integer siteId) {
this.siteId = siteId;
}
@DynamoDBAttribute(attributeName = "F")
public String getLob() {
return lob;
}
public void setLob(String lob) {
this.lob = lob;
}
@DynamoDBTypeConverted(converter = InsuranceLobConverter.class)
public InsuranceLobData getMultiItemLobData() {
return multiItemLobData;
}
public void setMultiItemLobData(InsuranceLobData multiItemLobData) {
this.multiItemLobData = multiItemLobData;
}
@DynamoDBTypeConverted(converter = InsuranceLobConverter.class)
public InsuranceLobData getStandaloneLobData() {
return standaloneLobData;
}
public void setStandaloneLobData(InsuranceLobData standaloneLobData) {
this.standaloneLobData = standaloneLobData;
}
}
Converter
public class InsuranceLobConverter implements DynamoDBTypeConverter<String, InsuranceLobData> {
private final static Gson gson = new Gson();
@Override
public String convert(InsuranceLobData object) {
return gson.toJson(object);
}
@Override
public InsuranceLobData unconvert(String object) {
return gson.fromJson(object, InsuranceLobData.class);
}
}
有人能看到这里的问题吗?
此问题已解决
我存储复杂对象InsuranceLobData
的方式出现了问题。
@DynamoDBDocument
public class InsuranceLobData {
private boolean isActive;
private Set<String> locale;
private AbacusData abacusData;
private boolean isActiveForMobile;
private boolean isActiveForDesktop;
@Override
public String toString() {
return "InsuranceLobData{" +
"isActive=" + isActive +
", locale=" + locale +
", abacusData=" + abacusData +
", isActiveForMobile=" + isActiveForMobile +
", isActiveForDesktop=" + isActiveForDesktop +
'}';
}
public InsuranceLobData(){}
public InsuranceLobData(boolean isActive, Set<String> locale, AbacusData abacusData, boolean isActiveForMobile, boolean isActiveForDesktop) {
this.isActive = isActive;
this.locale = locale;
this.abacusData = abacusData;
this.isActiveForMobile = isActiveForMobile;
this.isActiveForDesktop = isActiveForDesktop;
}
@DynamoDBAttribute(attributeName = "isActive")
public boolean isActive() {
return isActive;
}
public void setActive(boolean active) {
isActive = active;
}
@DynamoDBAttribute(attributeName = "locale")
public Set<String> getLocale() {
return locale;
}
public void setLocale(Set<String> locale) {
this.locale = locale;
}
@DynamoDBTypeConvertedJson
public AbacusData getAbacusData() {
return abacusData;
}
public void setAbacusData(AbacusData abacusData) {
this.abacusData = abacusData;
}
@DynamoDBAttribute(attributeName = "mobile")
public boolean isActiveForMobile() {
return isActiveForMobile;
}
public void setActiveForMobile(boolean activeForMobile) {
isActiveForMobile = activeForMobile;
}
@DynamoDBAttribute(attributeName = "desktop")
public boolean isActiveForDesktop() {
return isActiveForDesktop;
}
public void setActiveForDesktop(boolean activeForDesktop) {
isActiveForDesktop = activeForDesktop;
}
}
不需要添加DynamoDBDocument注释@DynamoDBDocument
@DynamoDBTypeConverted(converter = InsuranceLobConverter.class)
足以让DynamoDB了解我想在数据库中存储什么样的数据。可能将注释@DynamoDBDocument
添加到InsuranceLobData
会让它难以理解存储数据的方式。
因此,删除注释@DynamoDBDocument
对我有效。
希望它也能帮助别人。
如果我理解正确,您的问题是-在创建表之后,为什么在表中只看到"siteId"属性而没有看到"F"?这是意料之中的事。由于DynamoDB是一个NoSQL数据库,所以空表将只显示分区键和排序键(如果存在(作为属性。
一旦表中至少有一个项,就可以看到"F"属性。