. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 341 9.1. SQL Databases. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 356 jOOQ SQL Dialect . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 683 18.9.3. Initialize a Database Using Basic SQL Scripts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 683 18.9.4. Initialize

specifying the type for bean references like ref("bazBean") • It is possible to use Kotlin top level functions to declare beans using callable references like bean(::myRouter) in this example • When specifying imperative way. On language side, suspending functions provides an abstraction for asynchronous operations while on library side kotlinx.coroutines provides functions like async { } and types like Flow. Spring laziness is not needed, fun handler(mono: Mono) becomes fun handler(value: T) since a suspending functions can be invoked to get the value parameter. • If laziness is needed, fun handler(mono: Mono)

specifying the type for bean references like ref("bazBean") • It is possible to use Kotlin top level functions to declare beans using callable references like bean(::myRouter) in this example 4 • When specifying imperative way. On language side, suspending functions provides an abstraction for asynchronous operations while on library side kotlinx.coroutines provides functions like async { } and types like Flow. Spring laziness is not needed, fun handler(mono: Mono) becomes fun handler(value: T) since a suspending functions can be invoked to get the value parameter. • If laziness is needed, fun handler(mono: Mono)

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 305 4.3.11. Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . er() .setType(EmbeddedDatabaseType.HSQL) .addScript("my-schema.sql") .addScript("my-test-data.sql") .build(); } Kotlin @Bean fun dataSource(): DataSource { return .setType(EmbeddedDatabaseType.HSQL) .addScript("my-schema.sql") .addScript("my-test-data.sql") .build() } Now consider how this application can be deployed into

Mathematical operators Assignment Types Constructors Variables The #this and #root variables Functions Bean references Ternary Operator (If-Then-Else) The Elvis Operator Safe Navigation operator Collection @TestPropertySource @DirtiesContext @TestExecutionListeners @Commit @Rollback @BeforeTransaction @AfterTransaction @Sql @SqlConfig @SqlGroup Standard Annotation Support Spring JUnit 4 Testing Annotations @IfProfileValue Demonstration of all transaction-related annotations Executing SQL scripts Executing SQL scripts programmatically Executing SQL scripts declaratively with @Sql TestContext Framework support classes Spring JUnit

#this and #root variables .................................................................. 201 Functions ............................................................................................... @AfterTransaction .................................................................................. 297 @Sql .................................................................................................. .......................... 332 Executing SQL scripts .................................................................................... 333 Executing SQL scripts programmatically .................

and Data Value Handling. . . . . . . . . . . . . . . . . . . . . . . . . . . 126 3.8.1. Providing SQL Type Information for Parameters. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . does what? Action Spring You Define connection parameters. X Open the connection. X Specify the SQL statement. X Declare parameters and provide parameter values X Prepare and run the statement. X This approach provides better documentation and ease of use when you have multiple parameters for an SQL statement. • SimpleJdbcInsert and SimpleJdbcCall optimize database metadata to limit the amount of

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 341 9.1. SQL Databases. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 356 jOOQ SQL Dialect . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 683 18.9.3. Initialize a Database Using Basic SQL Scripts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 683 18.9.4. Initialize

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 341 9.1. SQL Databases. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 356 jOOQ SQL Dialect . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 683 18.9.2. Initialize a Database Using Basic SQL Scripts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 683 18.9.3. Initialize

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 339 9.1. SQL Databases. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 354 jOOQ SQL Dialect . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 681 18.9.2. Initialize a Database Using Basic SQL Scripts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 681 18.9.3. Initialize