arnaudroger / simpleflatmapper Goto Github PK

Fast and Easy mapping from database and csv to POJO. A java micro ORM, lightweight alternative to iBatis and Hibernate. Fast Csv Parser and Csv Mapper

Home Page: http://simpleflatmapper.org

License: MIT License

Java 99.55% Shell 0.20% PLpgSQL 0.11% Kotlin 0.12% XSLT 0.03%

java csv jdbc orm mapper spring sql2o jdbi

simpleflatmapper's Introduction

Simple Flat Mapper

Release Notes

Getting Started

Docs

Building it

The build is using Maven.

git clone https://github.com/arnaudroger/SimpleFlatMapper.git
cd SimpleFlatMapper
mvn install

simpleflatmapper's People

Contributors

Stargazers

Watchers

Forkers

shotishu a8t3r wgpshashank ranjeet-floyd umitgunduz cmayne-r7 aburke-r7 sripadapavan baosight-plat scottalbertine xl1991 anddegs publicforks raipc oeohomos optinf caskam cquliaoli nangal taurus227 marlboro029 ghacupha bharrisau gzheng kruskallin stenix71 peteadshead kanbal bobbyguo chezulkhairi mohanaraosv zenios valcodav amitgol btellstrom 64ashg pydawan simplechen orthoxerox lukashaken snafua jonathanmza mabing2018 sndyuk johnnyahlstedt hank-cp doniro17 jlleitschuh afrische sondrehav khauser fhyfhy17 coffeeandicecream massimiliano76 cn-src shankulk sharpex davidkarlsen jmluy ltkn cxwxz ajunlonglive bellmit tanbinh123 bulksecuritygeneratorprojectv2 murodin bluedskim iq-scm cnrainbing laurentperez jhreid jreid-r7 farmerswrap wlsdnjs829 sixdouglas

simpleflatmapper's Issues

Ability to specify custom mapping

I want to be able to specify some mapping for columns that will take precedence if column is in the query. That should also allow to be non mapped specific to manage constants.

dynamic noasm is faster than dynamic in java 8 benchmark

benchmark is vs reader

java array support as well as list

Ability to map object in object

MyObject {
private int id;
private MySubObject object;
}

MySubject {
String value;
}

table { id, object_value }

if MyObject contains a objectValue field that should take precedence.

add classifier to source and javadoc jar

csv mapper property not found should not impact the index of found property

csv parser handle \r \n \r\n

specify csv dateformat

fix coverall report

Better property name handling

need to have a smarter property name handling to handle prefix, suffix and have better information.

Csv Mapper more flexible mapping

I want to be able to specify the row range in the file.
also need to be able to specify which column on which index.

Use annotation processor to calculate meta of the class?

Check if can use fasttuple to retrieve multiple object from 1 query.

cayenne

look at adding https://cayenne.apache.org/ to benchmark

Measure jOOQ with plain SQL vs. with generated code

The jOOQ benchmarks show that plain SQL is being used:

        DSLContext dsl = DSL
                .using(new DefaultConfiguration()
                        .set(dataSource)
                        .set(new SfmRecordMapperProvider()));

        ...

        List<DbObject> list = dsl.select()
                .from("TEST_DB_OBJECT").fetchInto(DbObject.class);
// "plain SQL" here   ^^^^^^^^^^^^^^^^

There is actually a known issue (jOOQ/jOOQ#3225) that appears only when the projected columns are unknown, as in your example.

Most jOOQ users, however, use the jOOQ code generator, in case of which the benchmark would probably run much faster:

        import static com.example.jooq.generated.Tables.TEST_DB_OBJECT;

        List<TestDbObjectRecord> list = dsl.select()
                .from(TEST_DB_OBJECT);