JQL database manager for HBuilderX

In order to facilitate developers to debug query statements, HBuilderX 3.1.5 has built-in JQL query debugger. The usage is as follows

1. Right-click in the uniCloud/database directory and select New JQL Database Management (when HBuilderX creates a project, checking uniCloud will bring a jql file, you can directly use the built-in jql file)
2. Write your own statement in the jql file
3. Use the run button on the toolbar to run (shortcut key: Ctrl+R or F5)

Notice

• Write clientDB's js API (also supports regular js syntax, such as var), which can add, delete, modify, and query cloud databases. UniCloud-db component writing is not supported
• You can run all of them, or you can select part of the code to run. Click the Run button on the toolbar or press the [F5] key to run the code
• If there are multiple JQL statements in the document, only the last statement takes effect
• If you mix common js, the last statement must be a database operation statement
• The operation of the code here is not controlled by the permissions of the DB Schema. When porting the code to the actual business, pay attention to configuring the permissions in the schema.
• does not support clientDB actions
• Database query has a maximum number of returned items, see: limit
• For detailed JQL syntax, please refer to: JQL