[PR] support connection config, and use conn_id to replace conn info in jo… [seatunnel]

[via GitHub]

thirsd opened a new pull request, #8945:
URL: https://github.com/apache/seatunnel/pull/8945

   this commit is for https://github.com/apache/seatunnel/issues/8941
   
   
   
   
   <!--
   
   Thank you for contributing to SeaTunnel! Please make sure that your code 
changes
   are covered with tests. And in case of new features or big changes
   remember to adjust the documentation.
   
   Feel free to ping committers for the review!
   
   ## Contribution Checklist
     - Make sure that the pull request corresponds to a [GITHUB 
issue](https://github.com/apache/seatunnel/issues).
     - Name the pull request in the form "[Feature] [component] Title of the 
pull request", where *Feature* can be replaced by `Hotfix`, `Bug`, etc.
     - Minor fixes should be named following this pattern: `[hotfix] [docs] Fix 
typo in README.md doc`.
   -->
   
   ### Purpose of this pull request
   
   <!-- Describe the purpose of this pull request. For example: This pull 
request adds checkstyle plugin.-->
   
   
   ### Does this PR introduce _any_ user-facing change?
   user can add -conn or --connect to set Connect Config file.
   
   connections.conf
   ```json
   connection {
     # 定义 MySQL 连接配置
     mysql_prod {
       url = "jdbc:mysql://192.168.1.19:3306/test"
       driver = "com.mysql.cj.jdbc.Driver"
       connection_check_timeout_sec = 100
       user = "root"
       password = "111111"
       fetch_size = 10000
     }
   
     # 定义 Kafka 连接配置
     kafka_test {
       bootstrap.servers = "kafka-test:9092"
       topic = "test_topic"
     }
     
     sqlite_test {
       url = 
"jdbc:sqlite:D:/MyWorld/05Projects/java/Seatunnel/SeaTunnel/db/test.db"
       driver = "org.sqlite.JDBC"
     }
   }
   ```
   
   sqlite_to_console.conf:
   ```json
   env {
     parallelism = 1
     job.mode = "BATCH"
   }
   
   source {
     # This is a example source plugin **only for test and demonstrate the 
feature source plugin**
     jdbc {
       url = 
"jdbc:sqlite:D:/MyWorld/05Projects/java/Seatunnel/SeaTunnel/db/test.db"
       driver = "org.sqlite.JDBC"
        table_path = "department"
     }
   }
   
   transform {
   }
   
   sink {
     console {
       plugin_input="fake"
     }
   }
   ```
   
   
   
   
   
   
   <!--
   Note that it means *any* user-facing change including all aspects such as 
the documentation fix.
   If yes, please clarify the previous behavior and the change this PR proposes 
- provide the console output, description and/or an example to show the 
behavior difference if possible.
   If possible, please also clarify if this is a user-facing change compared to 
the released SeaTunnel versions or within the unreleased branches such as dev.
   If no, write 'No'.
   If you are adding/modifying connector documents, please follow our new 
specifications: https://github.com/apache/seatunnel/issues/4544.
   -->
   
   
   ### How was this patch tested?
   no conn_id example
   ```json
   source {
     # This is a example source plugin **only for test and demonstrate the 
feature source plugin**
     jdbc {
       url = 
"jdbc:sqlite:D:/MyWorld/05Projects/java/Seatunnel/SeaTunnel/db/test.db"
       driver = "org.sqlite.JDBC"
        table_path = "department"
     }
   }
   ```
   
   sqlite example
   ```json
   source {
     Jdbc {
       conn_id = "sqlite_test"
       table_path = "department"
     }
   }
   ```
   
   mysql example
   ```json
   source {
     Jdbc {
       conn_id = "mysql_prod"
       query="select * from department"
     }
   }
   
   transform {
   }
   
   sink {
     console {
     }
   }
   ```
   
   
   
   
   
   ### Check list
   
   * [ ] If any new Jar binary package adding in your PR, please add License 
Notice according
     [New License 
Guide](https://github.com/apache/seatunnel/blob/dev/docs/en/contribution/new-license.md)
   * [ ] If necessary, please update the documentation to describe the new 
feature. https://github.com/apache/seatunnel/tree/dev/docs
   * [ ] If you are contributing the connector code, please check that the 
following files are updated:
     1. Update 
[plugin-mapping.properties](https://github.com/apache/seatunnel/blob/dev/plugin-mapping.properties)
 and add new connector information in it
     2. Update the pom file of 
[seatunnel-dist](https://github.com/apache/seatunnel/blob/dev/seatunnel-dist/pom.xml)
     3. Add ci label in 
[label-scope-conf](https://github.com/apache/seatunnel/blob/dev/.github/workflows/labeler/label-scope-conf.yml)
     4. Add e2e testcase in 
[seatunnel-e2e](https://github.com/apache/seatunnel/tree/dev/seatunnel-e2e/seatunnel-connector-v2-e2e/)
     5. Update connector 
[plugin_config](https://github.com/apache/seatunnel/blob/dev/config/plugin_config)
   * [ ] Update the 
[`release-note`](https://github.com/apache/seatunnel/blob/dev/release-note.md).


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@seatunnel.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org