You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@rocketmq.apache.org by zh...@apache.org on 2022/03/02 03:20:18 UTC

[rocketmq-connect] 10/43: Add SourceJdbcTask and Schema

This is an automated email from the ASF dual-hosted git repository.

zhoubo pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/rocketmq-connect.git

commit 9ea583f8516e23957b8650eb5eb9b97ae6857caf
Author: yuchenlichuck <yu...@126.com>
AuthorDate: Mon Jul 29 22:12:27 2019 +0800

    Add SourceJdbcTask and Schema
---
 README.md | 74 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 74 insertions(+)

diff --git a/README.md b/README.md
index a3ebb26..f02d838 100644
--- a/README.md
+++ b/README.md
@@ -1 +1,75 @@
 # RocketMQ-connect-jdbc
+
+### Directory Structure Description
+
+```web-idl
+│  pom.xml
+│  README.md
+└─src
+    ├─main
+    │  └─java
+    │      └─org
+    │          └─apache
+    │              └─rocketmq
+    │                  └─connect
+    │                      └─jdbc
+    │                          │  Config.java
+    │                          ├─connector
+    │                          │      JdbcSourceConnector.java
+    │                          │      JdbcSourceTask.java
+    │                          ├─dialect
+    │                          ├─schema
+    │                          │  │  Database.java
+    │                          │  │  Schema.java
+    │                          │  │  Table.java
+    │                          │  │
+    │                          │  └─column
+    │                          │          BigIntColumnParser.java
+    │                          │          ColumnParser.java
+    │                          │          DateTimeColumnParser.java
+    │                          │          DefaultColumnParser.java
+    │                          │          EnumColumnParser.java
+    │                          │          IntColumnParser.java
+    │                          │          SetColumnParser.java
+    │                          │          StringColumnParser.java
+    │                          │          TimeColumnParser.java
+    │                          │          YearColumnParser.java
+    │                          ├─sink
+    │                          └─source
+    │                                  Querier.java
+    └─test
+        └─java
+            └─org
+                └─apache
+                    └─rocketmq
+                        └─connect
+                            └─jdbc
+                                └─connector
+                                        JdbcSourceConnectorTest.java
+                                        JdbcSourceTaskTest.java
+```
+
+### Some Result of Testing JdbcSourceTask
+
+
+
+#### Data Type:SourceDataEntry
+
+{sourcePartition,sourcePosition,DataEntry{timestamp,entryType=CREATE,queueName,shardingKey,schema.schema=Schema{dataSource=DATABASE_NAME,name=TABLE_NAME,fields=[Field{index,name,type}]},payloading}}
+
+- For example
+
+```javascript
+SourceDataEntry{sourcePartition=java.nio.HeapByteBuffer[pos=0 lim=14 cap=14], sourcePosition=java.nio.HeapByteBuffer[pos=0 lim=44 cap=44]} DataEntry{timestamp=1564397062419, entryType=CREATE, queueName='student', shardingKey='null', 
+schema=Schema{dataSource='jdbc_db', name='student', fields=[Field{index=0, name='id', type=INT32}, Field{index=1, name='first', type=STRING}, 
+Field{index=2, name='last', type=STRING}, Field{index=3, name='age', type=INT32}]}, payload=[102121, "Python", "Py", 25]}
+```
+
+#### Mentioned DataBase Information and all SourceDataEntry
+
+- For example
+
+![database.png](https://github.com/yuchenlichuck/picture/blob/master/database.png?raw=true)
+
+![sourcedataentry.png](https://github.com/yuchenlichuck/picture/blob/master/sourcedataentry.png?raw=true)
+