Connections iii. Running Queries iv. Database Transactions v. Accessing Connections vi. Query Logging ii. Query Builder i. Introduction ii. Selects iii. Joins iv. Advanced Wheres v. Aggregates vi. Raw Basic Usage iii. Mass Assignment iv. Insert, Update, Delete v. Soft Deleting vi. Timestamps vii. Query Scopes viii. Global Scopes ix. Relationships x. Querying Relations xi. Eager Loading xii. Inserting Attribute Casting xix. Model Events xx. Model Observers xxi. Converting To Arrays / JSON iv. Schema Builder i. Introduction ii. Creating & Dropping Tables iii. Adding Columns iv. Changing Columns v. Renaming

Chapter 7 - Query 111 About Query 111 RDBMS 112 Query Editor 112 Query Builder (Available only in Non-Essentials Edition) 116 Query Parameters 122 Debug Oracle Query (Available only Query Results 122 MongoDB 123 Query Editor 123 Find Builder (Available only in Non-Essentials Edition) 126 Aggregate Builder (Available only in Non-Essentials Edition) 127 Query Results Results 128 Redis 128 Query Editor 128 Query Results 132 Code Snippets (Available only in Non-Essentials Edition) 133 Chapter 8 - Model (Available only in Navicat Premium and Enterprise Edition)

Chapter 7 - Query 109 About Query 109 RDBMS 110 Query Editor 110 Query Builder (Available only in Non-Essentials Edition) 114 Query Parameters 120 Debug Oracle Query (Available only Query Results 120 MongoDB 121 Query Editor 121 Find Builder (Available only in Non-Essentials Edition) 125 Aggregate Builder (Available only in Non-Essentials Edition) 126 Query Results Results 126 Redis 127 Query Editor 127 Query Results 130 Code Snippets (Available only in Non-Essentials Edition) 131 Chapter 8 - Model (Available only in Navicat Premium and Enterprise Edition)

UndertowHttpHandlerAdapter adapter = new UndertowHttpHandlerAdapter(handler); Undertow server = Undertow.builder().addHttpListener(port, host).setHandler(adapter).build(); server.start(); 8 Kotlin val handler: handler: HttpHandler = ... val adapter = UndertowHttpHandlerAdapter(handler) val server = Undertow.builder().addHttpListener(port, host).setHandler(adapter).build() server.start() Tomcat Java HttpHandler ApplicationContext where components are auto-detected, and/or by registering components with the builder. While HttpHandler has a simple goal to abstract the use of different HTTP servers, the WebHandler

Chapter 7 - Query 108 About Query 108 RDBMS 109 Query Editor 109 Query Builder (Available only in Non-Essentials Edition) 113 Query Parameters 119 Debug Oracle Query (Available only Query Results 119 MongoDB 120 Query Editor 120 Find Builder (Available only in Non-Essentials Edition) 124 Aggregate Builder (Available only in Non-Essentials Edition) 125 Query Results Results 125 Redis 126 Query Editor 126 Query Results 129 Code Snippets (Available only in Non-Essentials Edition) 129 Chapter 8 - Model (Available only in Navicat Premium and Enterprise Edition)

..................................................................................... 78 Other Query Methods.......................................................................................... ................................................................................ 79 Fluent Query Builder ............................................................................................. ................................................................................... 99 Schema Builder ................................................................................................

Persistent URL Parameters Request & Response Objects Request ServerRequest Request Parameters Query String Parameters Request Body Data File Uploads PUT, PATCH or DELETE Data Environment Variables (from and XML views Helpers Database Access & ORM Quick Example More Information Database Basics Query Builder Table Objects Entities Retrieving Data & Results Sets Validating Data Saving Data Deleting Data Cache::clear Using Cache to Store Counters Cache::increment Cache::decrement Using Cache to Store Common Query Results Using Groups Cache::clearGroup() Cache::groupConfigs Globally Enable or Disable Cache Cache::disable

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55 7.1.5. Fluent Builder API . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Javadoc. 7.1.5. Fluent Builder API If you need to build an ApplicationContext hierarchy (multiple contexts with a parent/child relationship) or if you prefer using a “fluent” builder API, you can use the server but instead sets up a mock environment for testing web endpoints. With Spring MVC, we can query our web endpoints using MockMvc or WebTestClient, as shown in the following example: 142 Java

Server configuration Connection Management Users Authentication methods User credentials storage Query Manager Supported databases Features Database navigator DB Navigator folders Simple and Advanced Panel JSON and Document View Data export Entity Diagrams SQL Editor Query Execution Plan Visual Query Builder Log Viewer Query History Resource Manager Installation Running from Docker Build and results panel is opened Write SQL query and press or click the icon Ctrl-Enter Execute Query results will be shown in a tab on the SQL results panel Execute SQL query CloudBeaver User Guide 22.3. Page

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55 7.1.5. Fluent Builder API . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Javadoc. 7.1.5. Fluent Builder API If you need to build an ApplicationContext hierarchy (multiple contexts with a parent/child relationship) or if you prefer using a “fluent” builder API, you can use the server but instead sets up a mock environment for testing web endpoints. With Spring MVC, we can query our web endpoints using MockMvc or WebTestClient, as shown in the following example: 143 Java