PlugIns JdbcSlim UserGuide 4TheMappingBetweenTestDataAndCommands ReadableLongCommands
When SQL gets more complex it can be easier to maintain in the wiki if it is literal instead of in a single line.
Inline
In Properties
We can use literal SQL in properties.| Define Properties | Preformatted |
| key | value |
| .include | TestDatabase |
| cmd | select ID from TestData where Name ='%Name%' and City ='%City%' |
| SQLCommand | Preformatted | |
| Name | City | ID? |
| James | London | 6 |
In SQLCommand
We can also use literal SQL in a SQLCommand table's constructor.| SQLCommand | Preformatted | select ID from TestData where Name ='%Name%' and City ='%City%' |
| Name | City | ID? |
| James | London | 6 |
Using a variable
But using literal SQL inside a table can make wiki pages hard to edit.So we can also use variables to contain the SQL statement.
Which will leave the wiki's source code much cleaner.
| Define Properties | Preformatted2 |
| key | value |
| .include | TestDatabase |
| cmd | select ID from TestData where Name ='%Name%' and City ='%City%' |
| SQLCommand | Preformatted2 | |
| Name | City | ID? |
| James | London | 6 |
| SQLCommand | Preformatted2 | select ID from TestData where Name ='%Name%' and City ='%City%' |
| Name | City | ID? |
| James | London | 6 |