插入数据到OrientDB嵌套列表中的Java代码部分。

huangapple
go评论112阅读模式
英文:

Inserting into embedded list of orient db through java

问题

以下是我用于创建所需类的 SQL 脚本：

  1. CREATE CLASS ProductSummary;
  2. CREATE PROPERTY ProductSummary.name STRING (NOTNULL, MANDATORY TRUE);
  3. CREATE PROPERTY ProductSummary.modelNumber LONG (NOTNULL, MANDATORY TRUE);
  4. ALTER CLASS ProductSummary STRICTMODE TRUE;
  6. CREATE CLASS PricingSummary;
  7. CREATE PROPERTY PricingSummary.price LONG (NOTNULL, MANDATORY TRUE);
  8. CREATE PROPERTY PricingSummary.discount LONG (NOTNULL, MANDATORY TRUE);
  9. ALTER CLASS PricingSummary STRICTMODE TRUE;
  11. CREATE CLASS TotalSummary EXTENDS V;
  12. CREATE PROPERTY TotalSummary.projectLink LINK Project (NOTNULL, MANDATORY TRUE);
  13. CREATE PROPERTY TotalSummary.productSummaries EMBEDDEDLIST ProductSummary;
  14. CREATE PROPERTY TotalSummary.pricingSummaries EMBEDDEDLIST PricingSummary;
  15. ALTER CLASS TotalSummary STRICTMODE TRUE;
  16. CREATE INDEX TotalSummary_projectLink_idx ON TotalSummary (projectLink) UNIQUE;

我正在尝试向 TotalSummary 类插入一些值，同时我还需要向 pricingSummaries 和 productSummaries 的嵌入式列表中插入一些值。

以下是用于构建插入查询的实用方法：

  1. protected String insert(final String vertex, final String fieldValuePairs, final PreparedStatementInitializer initializer) {
  2.     final String sql = "INSERT INTO " + vertex + " SET " + fieldValuePairs + " RETURN @rid";
  3.     return executeStatement(sql, initializer);
  4. }

将 List<ProductSummary> 转换为 List<Map<?, ?>> 的 toMap 方法：

  1. // ProductSummary	
  2. public Map<String, Object> toMap() {
  3.     final Map<String, Object> ret = new HashMap<>();
  4.     ret.put("name", name);
  5.     ret.put("model number", Long.valueOf(modelNumber));
  6.     return ret;
  7. }

将 List<PricingSummary> 转换为 List<Map<?, ?>> 的 toMap 方法：

  1. // PricingSummary
  2. public Map<String, Object> toMap() {
  3.     final Map<String, Object> ret = new HashMap<>();
  4.     ret.put("price", Long.valueOf(price));
  5.     ret.put("discount", Long.valueOf(discount));
  6.     return ret;
  7. }

当我执行代码时，我遇到了以下异常：

  1. Constraint violation for: TotalSummary@58f79eeb[recordId=<null>,customProperties=[]]. Reason: OValidationException: The field 'TotalSummary.productSummaries' has been declared as EMBEDDEDLIST but an incompatible type is used.

我已经尝试过以下方法：

  1. 我尝试在将其添加到构建器之前将列表转换为 JSON 格式，类似于 new Gson().toJson(pricingSummaries)。
  2. 将 pricingSummaries 和 productSummaries 转换为数组，使用 toArray() 方法。
英文:

This is the sql script that I have used to create the necessary classes :

  1. CREATE CLASS ProductSummary;
  2. CREATE PROPERTY ProductSummary.name STRING (NOTNULL, MANDATORY TRUE);
  3. CREATE PROPERTY ProductSummary.modelNumber LONG (NOTNULL, MANDATORY TRUE);
  4. ALTER CLASS ProductSummary STRICTMODE TRUE;
  5.  
  6. CREATE CLASS PricingSummary;
  7. CREATE PROPERTY PricingSummary.price LONG (NOTNULL, MANDATORY TRUE);
  8. CREATE PROPERTY PricingSummary.discount LONG (NOTNULL, MANDATORY TRUE);
  9. ALTER CLASS PricingSummary STRICTMODE TRUE;
  10.  
  11. CREATE CLASS TotalSummary EXTENDS V;
  12. CREATE PROPERTY TotalSummary.projectLink LINK Project (NOTNULL, MANDATORY TRUE);
  13. CREATE PROPERTY TotalSummary.productSummaries EMBEDDEDLIST ProductSummary;
  14. CREATE PROPERTY TotalSummary.pricingSummaries EMBEDDEDLIST PricingSummary;
  15. ALTER CLASS TotalSummary STRICTMODE TRUE;
  16. CREATE INDEX TotalSummary_projectLink_idx ON TotalSummary (projectLink) UNIQUE;

I am trying to insert some values into my TotalSummary class, where I also need to insert some values into the EmbeddedList for pricingSummaries and productSummaries.

  1. public TotalSummary create(final TotalSummary totalSummary) {
  2. 		final Long projectId = 1;
  3. 		final StatementBuilder builder = new StatementBuilder();
  4. 		final StringBuilder query = new StringBuilder();
  5. 		
  6. 		final List&lt;Map&lt;?, ?&gt;&gt; productSummaries = totalSummary.getProductSummaries().stream()
  7. 				.map(ProductSummary::toMap)
  8. 				.collect(Collectors.toList());
  9. 		
  10. 		final List&lt;Map&lt;?, ?&gt;&gt; pricingSummaries = totalSummary.getPricingSummaries().stream()
  11. 				.map(PricingSummary::toMap)
  12. 				.collect(Collectors.toList());
  13. 		
  14. 		
  15. 		builder.addAttribute(&quot;projectLink = (SELECT FROM project WHERE id = ?)&quot;, projectId);
  16. 		if ( ! productSummaries.isEmpty()) {
  17. 			builder.addAttribute(&quot;productSummaries = ?&quot;, productSummaries);
  18. 		}
  19. 		if ( ! pricingSummaries.isEmpty()) {
  20. 			builder.addAttribute(&quot;pricingSummaries = ?&quot;, pricingSummaries);
  21. 		}
  22. 		
  23. 		try {
  24. 			insert(TotalSummary.class.getSimpleName(), builder.attributes(), statement -&gt; {
  25. 				builder.init(statement);
  26. 				return statement;
  27. 			});
  28. 		} catch (final UncategorizedSQLException e) {
  29. 			throw new ConstraintViolationException(totalSummary, ExceptionUtils.getRootCauseMessage(e), e);
  30. 		}
  32. 		return assertNotNull(findById(projectId));
  33. 	}
  35. This is the utility method that I am using to build the insert query : 
  36. protected String insert(final String vertex, final String fieldValuePairs, final PreparedStatementInitializer initializer) {
  37. 	final String sql = &quot;INSERT INTO &quot; + vertex + &quot; SET &quot; + fieldValuePairs + &quot; RETURN @rid&quot;;
  38. 	return executeStatement(sql, initializer);
  39. }
  41. The toMap methods to convert the List&lt;ProductSummary&gt; to List&lt;Map&lt;?,?&gt;&gt;
  43. **ProductSummary**	
  44. public Map&lt;String, Object&gt; toMap() {
  45. 	final Map&lt;String, Object&gt; ret = new HashMap&lt;&gt;();
  46. 	ret.put(&quot;name&quot;, name);
  47. 	ret.put(&quot;model number&quot;, Long.valueOf(modelNumber));
  48. 	return ret;
  49. }
  51. The toMap methods to convert the List&lt;PricingSummary&gt; to List&lt;Map&lt;?,?&gt;&gt;
  52. **PricingSummary**
  53. public Map&lt;String, Object&gt; toMap() {
  54. 	final Map&lt;String, Object&gt; ret = new HashMap&lt;&gt;();
  55. 	ret.put(&quot;price&quot;, Long.valueOf(price));
  56. 	ret.put(&quot;discount&quot;, Long.valueOf(discount));
  57. 	return ret;
  58. }

I am getting the following exception when I execute the code

  1. Constraint violation for: TotalSummary@58f79eeb[recordId=&lt;null&gt;,customProperties=[]]. Reason: OValidationException: The field &#39;TotalSummary.productSummaries&#39; has been declared as EMBEDDEDLIST but an incompatible type is used.

Things that I have already tried :

  1. I have tried to covert to list to json format before adding it to
    the builder like so new Gson().toJson(pricingSummaries);
  2. Converted the pricingSummaries and productSummaries toArray().

答案1

得分: 1

你将摘要定义为 EMBEDDEDLIST ProductSummary，但你正在传递映射列表作为值。

尝试创建真实的 ProductSummary 对象，例如：

  1. OElement ret = db.newEmbeddedElement("ProductSummary");
  2. ret.setProperty("price", Long.valueOf(price));
  3. ret.setProperty("discount", Long.valueOf(discount));
英文:

You defined the summaries as EMBEDDEDLIST ProductSummary but you are passing lists of maps as values.

Try to create real ProductSummary objects instead eg.

  1. OElement ret = db.newEmbeddedElement(&quot;ProductSummary&quot;);
  2. ret.setProperty(&quot;price&quot;, Long.valueOf(price));
  3. ret.setProperty(&quot;discount&quot;, Long.valueOf(discount));

huangapple
  • 本文由 发表于 2020年10月16日 20:37:38
  • 转载请务必保留本文链接：https://go.coder-hub.com/64389349.html
  • embeddedlist
  • java
  • java-8
  • orientdb
  • orientdb3.0
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定