search

spring-attic / spring-cloud-task-app-starters-app-starters-release

Apache License 2.0
2 stars 5 forks source link

Add simple SQL executing task #52

Open djgeary opened 5 years ago

djgeary commented 5 years ago

I hope this is right place to add a request for a new task app starter.

I realise its difficult to come up with generic tasks and some of the previous tasks that were part of this project have been deprecated, however we use a very simple 'SQL executing task' that simply executes some configurable SQL against a target datasource (normally this is used as part of a larger composed job)

The configurable properties are just :

target data source (driver, url, username, password) specifically this can be different from the db used for the task execution repository

SQL (should support both a simple string property and a spring resource ie a script file)

This would also be useful for simple testing and examples like the timestamp task

sabbyanandan commented 5 years ago

Good observations. I could see it as a utility app, at least for testing. If you already have something like this, feel free to share the repo - we can attempt to port that as an application.

sabbyanandan commented 5 years ago

This could be similar to jdbc-sink, but it is run as a Task.

djgeary commented 5 years ago

I've shared our version of the task here https://github.com/djgeary/sql-executing-task. This one just supports an SQL resource (script file) but it could support direct configuration of an SQL string too.

sabbyanandan commented 5 years ago

Thanks, @djgeary. We will have a look.