blocks|key|48003|text|我想不出在Salesforce之外做这件事的方法(即使在Apex，我现在也只有一个想法可能行不通)，但我能想到两个可能会有帮助的建议：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|48004|48005|通过运行查询来验证查询，但使用自定义web服务分批执行查询。例如，在Apex中编写一个web服务，它可以一次接受多达100个查询字符串，让它运行它们并返回结果。这将极大地减少API调用的数量，但是如果您期望在UI中设置一个试错类型，那么它当然不会起作用。|ordered-list-item|48006|使用元数据API下拉所有对象及其字段的信息，并使用这些信息来验证至少查询中的字段是正确的。验证其他查询语法应该相对简单，尽管条件语句可能会变得有点棘手。|48007|48008|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|L|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|M|8|@]|9|@]|A|$]]|$1|F|3|G|5|E|7|N|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|P|8|@]|9|@]|A|$]]]|J|$]]

I can't think of a way to do this from outside of Salesforce (and even in Apex I've only got one idea right now that may not work), but I can think of two suggestions that may be of help:

<ol>
<li>Validate queries by running them, but do them in batches using a custom web service. i.e. write a web service in Apex that can accept up to 100 query strings at once, have it run them and return the results. This would drastically reduce the number of API calls but of course it won't work if you're expecting a trial-and-error type setup in the UI.</li>
<li>Use the metadata API to pull down information on all objects and their fields, and use those to validate that at least the fields in the query are correct. Validating other query syntax should be relatively straight forward, though conditionals may get a little tricky. </li>
</ol>

blocks|key|48716|text|您可以使用SoqlBuilder+library来解决您的问题。它为您生成SOQL，并且能够生成手动创建时非常容易出错的SOQL语句。它的语法很简单，我已经广泛地使用了它，几乎没有问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|48717|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/JitendraZaa/SOQLBuilder^0|5|J|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

You might solve your problem by using the <a href="https://github.com/JitendraZaa/SOQLBuilder" rel="nofollow noreferrer">SoqlBuilder library</a>. It generates SOQL for you and is capable of producing SOQL statements that would be quite error prone to create manually. The syntax is straight forward and I've used it extensively with very few issues.

blocks|key|2528462|text|我找到了另一种方法来做这件事。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2528463|Salesforce.com在这里用Backus-Noir+Form+(BNF)发布了他们的SOQL符号：http://www.salesforce.com/us/developer/docs/api90/Content/sforce_api_calls_soql_bnf_notation.htm|offset|length|2528464|这意味着您可以使用支持BNF的语言识别工具来解析SOQL。最常用的工具之一ANTLR可以做到这一点，而且是免费的。遵循ANTLR示例，将SOQL语法传递到它的语法编译器中，以获得所需语言(C#、Java、Python等)的词法分析器和解析器。然后，您可以将要验证的实际SOQL语句传递到词法分析器中，然后将词法分析器标记传递到解析器中，以拆分SOQL语句。如果你的词法分析器或解析器失败，你的SOQL是无效的。|2528465|entityMap|0|LINK|mutability|MUTABLE|url|http://en.wikipedia.org/wiki/Backus%25E2%2580%2593Naur_Form|1|http://www.salesforce.com/us/developer/docs/api90/Content/sforce_api_calls_soql_bnf_notation.htm|2|http://en.wikipedia.org/wiki/ANTLR^0|0|I|G|0|1H|2O|1|0|11|5|2|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|U|8|@]|9|@$D|V|E|W|1|X]|$D|Y|E|Z|1|10]]|A|$]]|$1|F|3|G|5|6|7|11|8|@]|9|@$D|12|E|13|1|14]]|A|$]]|$1|H|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]|P|$5|K|L|M|A|$N|Q]]|R|$5|K|L|M|A|$N|S]]]]

I found another way to do this. 

Salesforce.com posted their SOQL notation in <a href="http://en.wikipedia.org/wiki/Backus%E2%80%93Naur_Form" rel="nofollow">Backus-Noir Form</a> (BNF) here: 
<a href="http://www.salesforce.com/us/developer/docs/api90/Content/sforce_api_calls_soql_bnf_notation.htm" rel="nofollow">http://www.salesforce.com/us/developer/docs/api90/Content/sforce_api_calls_soql_bnf_notation.htm</a>

This means you can use a BNF-aware language recognition tool to parse the SOQL. One of the most common tools, <a href="http://en.wikipedia.org/wiki/ANTLR" rel="nofollow">ANTLR</a>, does this and is free. Following the ANTLR example, pass the SOQL grammar into its grammar compiler to get a Lexer and a Parser in your desired language (C#, Java, Python, etc.). Then you can pass the actual SOQL statements you want to validate into the Lexer, and then your Lexer tokens into your Parser, to break apart the SOQL statements. If your Lexer or Parser fails, you have invalid SOQL.

blocks|key|2738230|text|您可以使用salesforce+develop包，该包利用SOAP+API|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2738231|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

You can make use of the salesforce develop nuget packages that leverages SOAP API

I'm writing an API that converts actions performed by a non-technical user into Salesforce.com SOQL <code>'SELECT'</code>, <code>'UPSERT'</code>, and <code>'DELETE'</code> statements. Is there any resource, library, etc. out there that could validate the syntax of the generated SOQL? I'm the only one at my company with any experience with SOQL, so I'd love to place it into a set of automated tests so that other developers enhancing (or fixing) the SOQL generation algorithm know if it's still functioning properly.

I know one solution here is to just make these integration tests. However, I'd rather avoid that for three reasons:

<ol>
<li>I'd need to maintain another Salesforce.com account just for tests so we don't go over our API request cap.</li>
<li>We'll end up chasing false positives whenever there are connectivity issues with Salesforce.com.</li>
<li>Those other developers without experience will potentially need to figure out how to clean up the test Salesforce.com instance after DML operation test failures (which really means I'll need to clean up the instance whenever this occurs).</li>
</ol>

Is there a way to validate the syntax of a Salesforce.com's SOQL query without executing it?

集成测试

编译器

Python

Java

我正在编写一个API，将非技术用户执行的操作转换为Salesforce.com SOQL、'UPSERT'和'DELETE'语句。是否有任何资源、库等可以验证生成的SOQL的语法？在我的公司里，我是唯一一个有SOQL经验的人，所以我想把它放到一组自动化测试中，以便其他增强(或修复) SOQL生成算法的开发人员知道它是否...

问有没有一种方法可以验证Salesforce.com的SOQL查询的语法而不执行它？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问有没有一种方法可以验证Salesforce.com的SOQL查询的语法而不执行它？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问有没有一种方法可以验证Salesforce.com的SOQL查询的语法而不执行它？
EN