Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQL action support #50

Closed
picimako opened this issue Aug 20, 2024 · 1 comment
Closed

SQL action support #50

picimako opened this issue Aug 20, 2024 · 1 comment
Assignees
Labels
feature A completely new feature Groovy DSL Related to the Citrus Groovy test DSL Spring XML DSL Related to the Citrus Spring XML test DSL XML DSL Related to the Citrus YAML test DSL YAML DSL Related to the Citrus YAML test DSL
Milestone

Comments

@picimako
Copy link
Owner

picimako commented Aug 20, 2024

Summary

Add SQL support for Citrus.

Tasks

* Some may not be doable.

Java/Groovy XML Spring XML YAML
SQL language injection [+] sql().statement() [+] test.actions.sql.statements.statement [+] testcase.actions.sql.statement [+] actions.sql/plsql.statements.statement
Code completion of column names in 'validate'/'extract' that are known in 'statement' [+] $(sql().dataSource(dataSource).query().statement("select NAME from CUSTOMERS where CUSTOMER_ID='${customerId}'").validate("[caret]", "")
At caret: NAME
Only for select statements. statement() call can be anywhere in the chain, even multiple ones.
[+] [+] [IP]
Bean completion (DataSource) [+] test.actions.sql@datasource [+] testcase.actions.sql@datasource [+] sql/plsql.dataSource/data-source
Bean completion (TransactionManager) [+] test.actions.sql.transaction@manager [+] testcase.actions.sql@transaction-manager [+] sql/plsql.transaction.manager
Groovy language injection [+] sql().validateScript() [+] sql.validate.script [+] sql.validate-script [+] sql.validate.script.value

Resources

@picimako picimako added feature A completely new feature YAML DSL Related to the Citrus YAML test DSL Groovy DSL Related to the Citrus Groovy test DSL XML DSL Related to the Citrus YAML test DSL Spring XML DSL Related to the Citrus Spring XML test DSL labels Aug 20, 2024
@picimako picimako added this to the v1.0.17 milestone Sep 3, 2024
@picimako picimako self-assigned this Sep 4, 2024
@picimako picimako removed this from the v1.0.17 milestone Sep 20, 2024
@picimako picimako added this to the v1.0.18 milestone Oct 16, 2024
@picimako
Copy link
Owner Author

Completed in v1.0.18.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature A completely new feature Groovy DSL Related to the Citrus Groovy test DSL Spring XML DSL Related to the Citrus Spring XML test DSL XML DSL Related to the Citrus YAML test DSL YAML DSL Related to the Citrus YAML test DSL
Projects
None yet
Development

No branches or pull requests

1 participant