Skip to content
/ dogETL Public

A lib to transform data from jdbc,csv,json to ecah other.

Notifications You must be signed in to change notification settings

dogHere/dogETL

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

16 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Example

Start a job

Model model = new Model() 
        .setReader(reader)
        .setTransformer(transformer)
        .setWriter(writers) 

model.start(); 

Reader

//jdbc reader

Reader reader = new JDBCReader()
                .setConnection(connection) // jdbc connection
                .setSQL("select uid,count(*) as pv from logs group by uid"); // any sql

Support readers : jdbc,csv,json

Transformer

Transformer transformer = new Transformer<Row>() {
    @Override
    public void onEvent(Row event, long sequence, boolean endOfBatch) throws Exception {
        //deal each row here
    }
};

Writer

// jdbc multi-writer

Writer [] writers = new JDBCWriter()
        .setTarget("rpt_pv")
        .setPrimaryKeys("uid")
        .setWriterSize(POOL_SIZE)
        .setDataSource(dataSource)
        .create();

Support writers : jdbc,csv

License

Copyright 2016-2017 dogHere

Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at

    http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.

About

A lib to transform data from jdbc,csv,json to ecah other.

Topics

Resources

Stars

Watchers

Forks

Packages

No packages published

Languages